Discuss the features and functionality of OneStream.
Recently active
Hi, We have a cascade entity structure, where one of the sub-elements consolidates up to a certain period, and after that period the other begins to consolidate. Entity A1 has an investment in Entity B11. Consolidating 2019M12, the application calculates an elimination of consolidated reserves in both parents Entity B1 & Entity B2, regardless of the fact that Entity B2 does not consolidate until 2022M8. I would like to know if anyone else has had a similar problem and has been able to solve it. Thank you, Sara
In a Spreadsheet (TableView) business rule, I am trying to reference the view created during the load of a BiBlend Star Schema. In our case when I create the BiBlend Star Schema tables, I also see that a view is automatically created that links the dimension tables to the fact table. I would like to read this view as my datasource for my table view. I added the line the following line: sql.AppendLine("FROM vBIB_OneStreamDevelopment_COPA_AnalysisImport_COPA_BiBlend_2023M6") When I open the Table View in the OneStream spreadsheet I get the error message "Invalid object name 'vBIB_OneStreamDevelopment_COPA_AnalysisImport_COPA_BiBlend_2023M6'. I can read this view using a Data Adapter without issue, but when I embed in a Table View rule I get the above error.
Hey All. I have a cube view for a client that contains a decently sized row count. I don't really understand why Data Explorer will only format the cube view to have 4 rows per page. Does the red paging mean anything?
Hi Experts, i am trying to read the line items from celldetails. I think i get the sytax of BR functions it compiles fine but getting "Object reference not set to an instance of an object." error so something is wrong with script? I am able to read Cellamount just fine using the Member Script. Requirement is to get the cell detail in the report along with amount. Below is the line from the code: LineItem = BRapi.Finance.Data.GetDataCellUsingMemberScript(si,"AUM","Cb#AUM:E#RevAccComments:C#USD:S#RevAccRecon:T#"+ FYQ +": A#MGMTFEES:F#CQ_MGMT_FEE_REV:O#Top:I#None:U1#None:U2#None:U3#None:U4#"+ Product.Member.Name +":U5#None:U6#None:U7#None:U8#None").DataCellEx.DataCellDetail.LineItems.LineItems.Item(0).Classification any ideas on why this is not working?
I am working with a client the requires the first row of each section of their reports to have a dollar sign. No other rows in the section (outside of the total) need a dollar sign. The cube view also has row supression on which means the row can and will change depending on the account, time and entity. Has any one encountered this before?
Is anyone else seeing errors when compiling BRs that Imports the WinSCP assembly after the upgrades were applied today?Seeing this when compiling:1) Error at line 69: Reference required to assembly 'netstandard, Version=2.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' containing the type '[Object]'. Add one to your project.
Hello All, I am trying to create a cube view or report if necessary to list our active Entities. I've been able to filter by "In Use", but we also need to include the Member Property of "ReadWriteDataGroup" where its set to "Administrator". Is that even possible or would a Business Rule Member List contain the arguments necessary? Thanks for any suggestions!
The below finance rule will sort the members in my case it is entity and it will take the parameters in the Cube view. '*******************************************************************************************************************'Parameters in the Cube View'E#Root.CustomMemberList(BRName=MemberSort, MemberListName=AscEntSort, Memlist=E#[Legal].DescendantsInclusive)'******************************************************************************************************************** Dim Memberlistname As String = "AscEntSort" Dim MemberListstart As String = args.MemberListArgs.NameValuePairs.XFGetValue("Memlist",Nothing) Case Is = FinanceFunctionType.MemberList If args.MemberListArgs.MemberListName = Memberlistname Then Dim objMemberListHeader = New MemberListHeader(args.MemberListArgs.MemberListName) 'members into the list Dim objMemberInfos As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(
Hi All, We are trying to load more than 100 rows through a table view using the method NumberOfEmptyRowsToAdd in the Business Rule: tv is our table view object. However, when we add a value bigger than 100 in the code, no rows are available to load data in the Spreadsheet. We think is an internal limitation from Onestream to optimize performance. Is there any way to increase this limit? Maybe is only possible with some additional admin privileges in OS?
Is it possible to calculate slope, Correll and Intercept for a given factors vary by 12 periods using OS Finance Rules? If so, what are the libraries, I need to Import? Appreciate any suggestions how I can implement this in OS.
Hihi, I am using a variant of the GolfStream finance business rule "XFR_MemberListAlphabetical" and need to pass an additional variable into the rule. For a Finance rule, is it possible for a CV or QV to pass the MF variable to the rule? Currently, the rule is setup statically on a starting entity: Dim MemberListstart As String = "E#[Total GolfStream].base"" However, because our organization has thousands of entity, the finance rule passes all base entity into the QV. With suppression, I can arrive at the relevant members, however, it significantly slows down the rendering of the report. I've tried using the api.POV command, but it passes the user CV pov, which is not always relevant to the CV. Is there a way to pass a variable using something like an args.NameValuePairs()? I am having difficulty with the limitations of the finance rule VBA set. Essentially, I need the memberfilter builder of "E#[MyEntity].XFR_MemberListAlphabetical,Ent_Sort]" to use "E#[MyEntity] as
Hello, We are in the process of building workflows . During the demo of required workflow forms, there are some check reports built for users to verify their data and add comments. When the user switches between report tabs in the workflow, the refresh takes approximately 20 seconds to a full minute depending on the report. Our implementation partner suggested reducing the number of columns. We do have several columns of data, however this is needed for a proper review, and would like to review alternatives before reducing the reporting content. Is there anything else we can do to increase report refresh speed when there's multiple columns? Thanks, Will
Hi All, In OneStream there are many audit tables containing specific sections that can be audited. I'm looking for a detailed overall data audit showing which user changed which number at what time. Preferably combining loads with (Excel) input. Does anybody know which tables to join to get the good old HFM data audit table? Thanks in advance, Marc
Assuming data exists at every base account shown, the data will be accurate at the 69000 – Net Income level using the following account structure in a monolithic cube. Question Credit: Chul Smith Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
I don't know much about method queries, so I'm hoping to get some feedback on how to build off of or reference the data tables as well as where these tables are stored. The ICMatchingForWorkflowUnitMultiPlug method type used in the Intercompany Matching application reports returns the entities as "Name - Description," which causes a few problems for us considering our entity names' were created with an obscene number of characters and underscores. I've copied the reports and data adapters, but not sure how to write the script within the Report Designer or how to alter the data adapter... Any suggestions?
Hi All, Has anyone built a custom audit data report for their OneStream planning applications which shows which users changed which entities/accounts/scenarios, etc on specific days? Not sure if we have a marketplace solution for this. Any leads will be helpful. Thanks, Nidhi Mangtani
Workflow Profiles can only have dependencies through a Parent/Child hierarchy. Question Credit: Eric Osmanski Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
I have Import/validate/Load workflow.After the validation step , I want to run a business rule that can do the following -1. Sum up the amount for all records with the same Product code in the transformed table.2. Check if SUM = 0 for individual product code.3. If step2 is validated for all product code , then proceed for LOAD step, else error out.PS- I know this can be achieved via a confirmation rule but i want to validate before loading to the cube.One idea that i thought is to execute a validation in the transformation rule but that validation limits to record by record whereas I am looking for validation post all transformation.Thanks!
Hello, How can I call an account's assigned plug account via SQL? I able to get the PlugAcct DecimalValue, but need help with the syntax to return the account member name instead of the ID... SELECT (CASE WHEN D.DimTypeId = 0 THEN 'Entity' WHEN D.DimTypeId = 2 THEN 'Scenario' WHEN D.DimTypeId = 5 THEN 'Account' WHEN D.DimTypeId = 6 THEN 'Flow' WHEN D.DimTypeId = 9 THEN 'UD1' WHEN D.DimTypeId = 10 THEN 'UD2' WHEN D.DimTypeId = 11 THEN 'UD3' WHEN D.DimTypeId = 12 THEN 'UD4' WHEN D.DimTypeId = 13 THEN 'UD5' WHEN D.DimTypeId = 14 THEN 'UD6' WHEN D.DimTypeId = 15 THEN 'UD7' WHEN D.DimTypeId = 16 THEN 'UD8' ELSE 'Unknown' END)AS 'DimTypeName', M.NameAS 'MemberName', M.DescriptionAS 'MemberDesc', (SELECT TOP 1 MP.TextValue FROM MemberProperty MP &nb
Hi, AllWhat's the best way to ensure a specific tree within the account hierarchy has only one member within it. Would like to have a "count greater than one" alert or a report we can run, as inadvertent accounts affect data integrity.TIA!
Hi everyone, do you know if the report run time and page number that is in the cube view report footer can be moved into the report header? I was thinking perhaps via a cube view inline formula?
My requirement is to load 50 users in Onestream application, instead of manual updating , is it possible to load users in Onestream application ? and please let us know the steps. thank you
Is there a way to pull into XFGets a time stamp of the most recent GL import by entity? We have multiple GL imports and would like to add the import time stamp to Excel based reporting Example: Entity1 3/2/2023 9:05AM Entity2 3/1/2023 1:15PM Entity3 3/1/2023 10:00PM
hi , i am trying to add the users in OneStream planning application, how to add the bulk users in OneStream, tried with extract xml file and copied that in Excel but formatting is not supporting. Note: External authentication Provided is AzureSSO Thanks in Advance
When mapping an item from the "Validate" step in the workflow, it is possible to save the mapping to an "(unassigned)" item.Is it possible to restrict the storage of the mapping so that it cannot be mapped to "unassigned"? Thank you
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.