Discuss the features and functionality of OneStream.
Recently active
Originally posted by Swadhin Patrrahi , i am getting security access error while uploading journal through excel template. i am having admin access. could anyone please help me on this and what could be possible reason to avoid this error. I've attached the pop up message Thanks in Advance
We are preparing for our UAT period and user access controls will be a part of the testing. I can see in the User Security reports that we have 2 native users. When click on Native Users to pull up the list, there is only one name listed. Why is there only 1 name listed? Also, I am looking for a description of what a Native User is - Design guide really does not explain it in a manner that I can provide that to the auditors and not get more questions back. I believe that the Installation guide may have some additional information but I cannot search that document online and it is not available for download (PDF file is not offered in the search result). System and Configuration as well as Academy has nothing on this topic. Thanks!
I've seen the 'Reset IIS' option as part of the Copy App process, and now again in the instructions for applying a new license key, but I have some questions: 1 - What does Reset IIS actually do? 2- What impact does selecting this have on our applications and users? 3 - How do I manually Reset IIS, so I can complete the Apply License Key instructions? Thanks.
Equity Accounting And Methods A consolidation method is just a way to treat an entity during consolidation based on how much of it you own or control. It makes sense, if you only own 10% of an entity, and another entity has an asset recorded for the value of that investment, you would be overstating your value if you let it add up at 100%. The following are the most common methods you might see. Subsidiary: Entity owned at >50% The Subsidiaries financial statements are consolidated and eliminated. The Equity associated with the subs financial statements are eliminated against the Holding companies Investment in the sub. If the Sub is not 100% owned, the owned portion of Equity is eliminated and the unowned portion is reclassed to Minority Interest. Equity: 50% >Entity owned >20% An Entity held, as Equity Method is NOT consolidated. The Net Income of the Entity is multiplied by the Equity holding and the result is booked to the
Equity pickup (EPU) is a method of reevaluating the investments owned by a holding company allowing the parent to realize changes in equity. This results in the holding company’s balance sheet showing the current value of the corresponding share in the equity of the subsidiary. Investments are normally shown at historical or acquisition cost. But an invested company has a value that can vary based on profit and loss they are incurring. The equity pickup adjustment offsets the historical cost in local currency, showing the actual value of the equity owned. Direct Ownership Percentage * Equity of Owned Entity = Current Equity Value - Investment = Equity Pickup Adjustment You can calculate the adjustment by simply taking the direct ownership percentage multiplied by the equity of the entity owned then subtract the investment in the parent. In OneStream the ownership percentage can be entered directly on the entity or by creating a Ownership cube. But once thi
Is there a formula (for use in Excel/Spreadsheet) to retrieve the Global Time setting from Application Properties?
Hi All, I'm trying to understand whether there is any way that within People Planning, a user would be able to initiate a transfer and the receiving entity would have the ability to accept or deny this transfer through an approval process. As an example, If I am transferring 3 employees from the insurance team to the finance team, would a member of the finance team be able to deny this change? Appreciate any insight you all may have on this. Thank you!
Happy Monday Y'all, How do I call a cube view extender BR in a cube view. I'm using it to increase the report sub-header font. I'm using a code that was described in OneStream XF manual. \ Here is the code: Select Case args.FunctionType Case Is = CVExtenderFunctionType.FormatReportUIItem Dim uiItem As CVExtenderReportUIItem = args.Report.CurrentUIItem If uiItem.UIItemType = XFReportUIItemType.PageHeaderLabelCenter1 Then uiItem.FontSize = 14 uiItem.Bold = True End If End Select Thank you, Mustafa A
Hello Everyone, Please help with your expertise on below one issue I am facing, Thanks in Advance !We are trying to use Workflow channel for independent locking for forms, however not activated for any Dimensions.Summary of current status/setup is as below:1) Each entity is assigned to it's own independent workflow profile2) In each workflow profile we have 3 forms - 2 for entities and 1 for Corporate3) Created 3 channels - 2 for Entity forms ('Flow_Load' and 'IC_load' and they need to be able to lock independently) and 1 for Corp forms4) Moved all accounts to 'NoDataLock'5) Now Entity users have access to 'view and write' only on the 2 forms with local channels6) I was expecting that when Local forms are completed and locked - Entity users should not be able to load any data via Forms - "HOWEVER they can still do this via Excel Grid and / or Setvalue" (((( Question is - Is there a way that as soon as they lock all the channels available to them Forms is 100% lock
OneStream Platform releases will periodically include an update to the Business Rules compiler, which is noted in each version’s Release Notes. The enhancements typically make the compiler stricter in detecting syntax or other conditions, which are surfaced through Error or Warning messages. Error messages must be resolved, as the Business Rules will not complete the compile process. Warning messages are exposed to provide guidance to the Administrator. The displayed line items will still function but should be updated to support the latest compiler’s requirements. The method to resolve the Warning will vary. In some cases, a replacement function may be available, or there may be a change to a function’s properties. Example The above error message informs the Administrator of a Warning on the LookupRowFieldValue function having a property change. By reviewing the current rule, and by looking at the current Function Definition, th
I have an user who is not an administrator but has manage cube view security role so he can create and manage cube views. However, he is also able to access cube view groups that are assigned to administrator only. Is there a way to restrict this user accessing these administrator-only cube view groups? Thanks!
Hi Team,We would like to understand how to copy data from some specific tables fromappsuite(appsuite-prd.onestreamcloud.com) to appsuite_dev(appsuite-dev.onestreamcloud.com)for some specific tables.
Hi All, Is there a way to visually see in a Cube View that a cell has a document attached to it? The purpose is to attached supporting documents to some Cube Views. Thanks
Hi All,I'm creating this report which uses a custom formula, that takes SUM/AVG of past six months, and calculates the Pct value. I tried using Rolling6MonthTotal and Rolling6MonthAvg view dimension in Denominator/Numerator, but it doesn't work as it should. Any ideas on how I can make SUM/AVG the prior 6 month, and run this calculation (highlighted). Thank you for your help.Best, Mustafa A
SOURCE: OneStream Champions I have a cubeview in onestream. If I launch one of them via the api it runs in 45 seconds. If I start two of them at the same time, they both finish in about 1:20 (a little over a minute, which is almost double the 45 seconds). https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/fdaa8e3ec877c251814ffe035f4895e65ba2dbc7.png image.png2140×180 24.7 KB What is the reason for the extra amount of time that is spent per report when two are running concurrently? IE. what internal resource is being protected against concurrency? From a technical standpoint, it seems very unexpected that two readers would block each other in this way. You can see in the screenshot that there is plenty of CPU available. I’m assuming this topic isn’t specific to our environment or to this cubeview. Nothing we are doing seems exceptional or unusual in any way.
Hello & Happy Friday.How do I over-ride a cube view cell amount? For example: IF an account (for e.g. Fleet Revenue %) is less than a certain number (for e.g. 45%), then run a custom calculation in all those cell. Else, show the original number. The excel-sheet uses an IF statement as shown below. I'm thinking that I have to write a BR (with nested IF) to run this. Will be great if there is a existing BR or method somewhere else, that I can reference. Any ideas/suggestions will be appreciated. Thank you!
I have created a DM sequence that calls multiple steps. One of the DM steps prompts the user to select a seed Scenario which I then pass to my Finance BR as a parameter value. The scenario options are presented to the user as a Member Dialogue Parameter object. This works perfectly when I run it directly through Data Management.Next, I create a Dashboard for all of this using Data Entry 123 for display. The user sees a button component that is configured as 'Execute Data Management Sequence' and I give it a Task Argument of {Phasing_BUD_Seq}{} which is my DM Seq.When I test this from my Workflow (uses DE123), it does not prompt the user to enter the Source Scenario from my Parameter, it just fires the DM Sequence. It seems like my member dialogue parameter is somehow being supressed or skipped.Does anyone know what I am missing here? Thanks
On a couple occasions the users of the OneStream Add-in have unintentionally reported partial results from a onestream cube. This has happened when data extends beyond the allowable page size ("Maximum Number of Rows"). It can sometimes come up by surprise. For example, a user may pull in all the YTD activity from a cube and it will fit within the page size for much of the year but towards the end of the year some of the data will go missing. If the Onestream data is retrieved on one of several sheets, and the data is used indirectly for calculations that are displayed elsewhere in the workbook, then the problem can be easy to miss. In fact, this type of a problem can even be overlooked when you are staring right at the add-in itself, since the only indication of a problem is way down at the bottom of the results. That is where you can see the "Page 1" annotation (see image below) This brings me to my question. Is there a
I'm having trouble figuring out how to organize the layout of my cubeview. I'd like a tabular layout where dimension levels will occupy their own columns. Below is an example where I am retrieving data from my cube by week. But I want to display the parent month and quarter in their own columns, next to the weeks. I am able to build the layout shown in the first image above. This is accomplished using TreeDescendants for the year. But I can't find a way to organize my quickview in a tabular layout (see the second image). Any help would be much appreciated! Sorry for the basic question. (I haven't yet found a good source of training material for Excel quickviews.)
Hi All, Happy Friday, I am building a form and in my cube view I am giving option of selecting Entity, Based on entity I need to show two Dimensions in the detail, we don't have any connection between these dimension. I can not update the Text field of entity because there are many to many relationship, One entity can have multiple project and ICP, so based on selected entity I need to show all related projects and ICPs so user can adjust the data. Selection - Entity Projects - ICP $$$$
SOURCE: ONESTREAM CHAMPIONS Hi All,We are at the point in our implementation where we are thinking about managing security and our userbase. We are going to have ~600 users as we are very decentralized with our financial management, and we currently have our SSO setup with SAML. We use ServiceNow internally for all things workflow/helpdesk related and were going to be building the workflow for user creation/modification and their roles. Knowing that OneStream also uses ServiceNow for their integration I am wondering if there’s any thing out there to automate certain things from ServiceNow, or if we can script a .xml file out of ServiceNow to our staging database and have that loaded to OneStream to make the changes. If anyone has any ideas or experience I’d love to hear, as we are going to be having our OneStream system as an “in-scope” software from an audit perspective and want to have some tight controls around user management. Thanks,Jeff
Dear OneStream community,I'm trying to save the data on this gridview on a shared folder, does anyone know how i can do it ? Once i will save it on a shared folder, i will put a business rule on the "initiate export" to tranform it and eport it in my computer this time.Please advice if you have any idea how i can do this,Thank you
New to OneStream but thought I would post an issue where we have an integration that runs a BR without any parameters and it will run successfully if we run it manually from theData Management menu. However this same integration will fail with the following error if we schedule/run it from the Task Scheduler. Here is the error we see in the Task Activity Log:Summary: Error processing Data Management Step 'Import DB2 Audit Checks'. Unable to execute Business Rule 'DB2_DataAudit'. Select a valid workflow profile... Any thoughts? Not understanding how it runs ok manually but has an issue if the Task Manager runs it. Thanks!
Do we have a way to transfer a file within OneStream (a pdf report), and automatically import into a public folders. What will be the file-path to that shared drive in OneStream. Any ideas will be appreciated. Thank you!
Hi is there a way i can load a on premise file to onestream file explorer automated.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.