OneStream Platform Forums

Hello Team,I am currently writing a connector business rule that connects an EDM system to retrieve a file, apply mapping logic, and process the resulting DataTable into ACM. I have successfully implemented the same integration code for several other connectors, all of which are functioning as intended. However, when I attempt to apply the same logic for the Account connector, I encounter the following error:"Index was out of range. Must be non-negative and less than the size of the collection. (Parameter 'index')" I have rewritten the rule twice but have not been able to resolve the issue. Do you have any insights into why this might be occurring?

When trying to connect to SAP from SIC, we are getting a tcp restart error   

HI,Modern browser could not be used.It has strange message "Skip to next section" for each dashboard component.

As the title suggests, I am trying to populate a dashboard list box that references the Workflow text property regardless of the dimension being used. I'm able to populate the list box using a single dimension, meaning a UD3 member is populated on the workflow's WFText4 property and a member list parameter uses |WFText4| to pull it in. How would I get this to work if the Workflow text value is not always UD3? For Example (both workflows will be using WFText4): Canada Workflow A needs a UD3 Member.Base to populate in the list box when they run the dashboard in their workflow but Canada Workflow B needs a UD6 Member.Base to populate the list box when they run the dashboard in their workflow. Please let me know if I can provide more context.

The title and image attached should provide enough context but please let me know if I can provide any additional information.

Hello,  When i am running Books from File Explorer -  Application Database, I am getting the below error, did any one come across this issue. requesting to help me how to handle this issue and get output.   

So we have a UD2 mapping set up in the List section. What I want is to be able to set up a Complex Expression in the UD2 Composite section so that for certain accounts it does nothing and so moves on to the List section, but for everything else we have a hard coded UD2 (e.g. None). I have no problem with setting the criteria in the Complex Expression, but I don't know if it is even possible to write some code that forces it to skip on out and look at the List mappings? I realise this is maybe a bit back to front compared to how the Composite mappings work, but we have a very tight list of accounts where we need to do the List UD2 mapping,  and everything else (which can be any other account) should just go to None.

Hello, We are trying to automate a simple allocation of specific corporate expense accounts.  The accounts allocate to different business based on their contribution to total GP.  I currently have two calculations: Account Dynamic Calc - BU GP / Total GP, giving the business GP% UD8 Dynamic Calc - GP% * Corporate Expense Account, giving the expense to be allocated to each BU I run into an issue when data is pulled as either QTD or YTD.  As an example, if someone is to pull the data at 2025M3/QTD, it will calculate calculate a separate GP% for the QTD information and complete the calculation.  This creates a discrepancy when looking at data monthly vs. quarterly.  Instead, I would need it to add together months 1-3 for consistency.  (See below table for reference) Is there a way to make a dynamic calculation calculate only at the monthly level and instead aggregate months for other view selections (QTD/YTD)?       What is happenin

Hello,We want to spread data acrross multiple periods in a cube view, so we select the parent member (Year) and we expect that automatically OS applies spreading to all its base time members (months).However, we are working on a forecast scenario with the setting "Number of No Input Periods Per WF Unit" set to 4. And we don't understand how the spreading works.It seems the system calculates the difference between the amount entered at the parent member (Year) and the total amount of the closed months (the no input periods), and this calculated amount is the one that is saved at the parent member (Year), instead of the amount enetered initially.Could someone help us to clarify this calculation?Thanks!   

Hi Team, In our system Narrative Reporting setup has done, but when we open Narrative Reporting. could not able Fetch and Load and anything. seems like everything is empty(below screenshot are for your reference). Can you please help us to setup the Narrative Reporting in the system.    

Hello, I have a table view where I also allow users to save changes. In my code I'm checking for the cells that have changed using "If tvr.Item("Bonus").IsDirty()". This seems to work fine for non-numeric columns, however, I find that for the numeric columns the cells are always marked as dirty even if they are not changed. I tried different things, e.g. marking the column as decimal data type "tv.Columns(7).DataType = XFDataType.Decimal" but so far no luck. Do you have any advise how this can be solved? Thanks, Volker

Hello,We are facing the following issue, we use the following xfbr to generate accounts in a cubeview rows and retrieve descriptions : XFBR(CCF_XFBR, GetCCFDrillDownWithDescription2,memberExp=[A#CashFlow_Gestion.TreeDescendantsInclusive], Time=|CVTime|).However, the Cube View where this XFBR is applied always displays the descriptions in the default format. The description does not adapt based on the user’s culture settings.How can we make the XFBR return descriptions that vary according to the user culture?For reference, here is the XFBR code :Public Function GetCCFDrillDownWithDescription2(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As String Try 'Get the Dim PK for Entity Dimension Dim accountDimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si,args.SubstVarSourceInfo.WFAccountDim) Dim flowDimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si,args.SubstVarSourceInfo.WFFlowDim) 'Dim memberListClass As New O

Hello everyone,I recently attempted to register for a OneStream certification exam and noticed that both the Lead Architect and Core Application Architect certifications are available. Could you please clarify which one is required for my consulting firm to qualify for a higher-level partnership with OneStream?Additionally, I would appreciate any insights into the main differences between these two certifications, as well as the passing score (percentage of correct answers) for each.Finally, if you have already taken one of these exams, I would be grateful if you could share your experience.Thank you in advance!

We are preparing to move the Transaction Matching (TM) module, an out-of-the-box marketplace solution, from the Development environment to the QAT environment.Could someone please guide me on the process for migrating the database tables, along with the match sets and matching rules created within the TM module?Specifically, is there a way to extract and load these artifacts directly, rather than recreating the entire solution from scratch in the new environment?

Hello, I have an automated report book and would like to expand the functionality to include charts (in addition to the existing cubeviews).  I was able to add the chart, but I'm struggling with trying to control the formatting.  I would like to modify the header and have the chart fill the page (too much white space). See below. Thanks! Is there a way to format the chart output, in particular I would like to enlarge the chart image and have it stretched across the page?

HI Team, We have created a stored calc and it is working fine at Base and parent entity level, but when we are running at Top entity level and my Time is 2028, at this i am getting below error. could not able to figure it. Can you please help us resolve the issue.  

  We have a recurring requirement to share the transformation rules/logic on a regular basis with downstream teams or auditors.   Currently, this is being done manually, which is time-consuming.   Is there a way to automate the extraction/export of transformation rules?  Some options I’m thinking of:  - Can this be done via Business Rules (BR) / Decision Model (DM) modules?  - Is it possible to extract or view all applied transformation rules directly through Cube Views?  - Has anyone built an automated solution (e.g., a dashboard, cube view, report, or extender rule) to export/list all transformation rules in a readable format?   Would really appreciate your thoughts or examples if you’ve implemented something similar.   Thanks!

Hi Team, I have created a dashboard with Vertical Stake Panel option and attached multiple Cube view components. when i scroll left to right in the dashboard my CV row headers are scrolling. how to freeze them in the dashboard.  

Hello!Has someone tried Narrative reporting in 9.1 version? I am currently experiencing issues: 1.- Inserting charts/Advanced Charts / Reports if someone could insert an exaple on how they have done it. 2.- I cannot vie the artifacts and acces them, this message keeps popping up (and the names are fine)Thank you so much for the help!!

  •You can set a text color on the Cubeview (i.e black) so all values show in a single colour, which would override the default grey/black. •You can also use a UD8 dynamic rule to hide derived values in future periods, if necessary.

In my cube view- I have some cells which are greyed out. What does that mean? I am admin.    

Hi,I am working on the cubeview below, where I have 2 dynamic calc accounts. On some of the cells their value is greyed out. The dimension on column is UD4. Can somebody help me understand why some of the values are greyed out? Thank you  

Hi,A user is facing two issues with Excel add-in.  XFGetCell and XFSetCell formulas with XFGetMemmber Property are used (XFGetMember function only at the top of the page). There are 15 sheets in the Workbook page.Has anyone experienced issues described below?  What is the likely solution?  Is it V8.4.1 specific issue? Thanks in advance for any help/pointers.Two issues:(1) Retrieval formula dont work and have to keep refreshing the whole workbook/worksheet. When refresh one worksheet, the rest will went error. When refresh another sheet, previous sheet went error.(2) When trying to save an offline version of retrieval file but error keeps pop up as attached.

Hi everyone,  Is there a possibility restrict the user only view the comment in specific CV and specific column cell.

Hi Everyone, I recently developed Flux reports for my organization, I'm encountering following issues. When I type comment on the 'Comment' column, if the comments is of say 100 words, the red line which I marked in the screenshot keeps moving to the right. refer screenshot below. How can I fix this issue? I use, V#Annotation for Comment column.2. When multiple users, try to update the comments, the comment from the last save is only visible. Could you please advise how can i overcome this? thanks in advance