OneStream Platform Forums

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.   

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!!

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, 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  

OneStream Community, I am having difficulty applying visible parameters after embedding a Cube View in Excel. When I embed the Cube View and select "Use Display Value" the parameters appear but the parameter member list drop down is misaligned to the applicable parameter. Additionally, when the Cube View connection is removed and re-embedded without selecting "Use Display Value" on refresh the cube view shows an object reference error, but then after selecting ok the cube view will render with no issue. Has anyone come across this?    

I have created a quick view template file, but each time I launch it, the font gets changed to a light gray. This obviously makes it difficult to see and I need to reformat it afterwards. Here is a sample: My QV has "preserve excel formatting" enabled, so I am uncertain what is causing a formatting override. I have tried different primary styles, but it does not stop the format from overriding after closing and reloading the spreadsheet. Here are my options: Has anyone else experienced the same issue or have any insight into how I may fix it?

Hi All, I am trying to get a decimal value rounded up to integer for calculation (Not for display). The current cube view cell value is 0.75. I can make it displayed as 1. but, when I put it in GetDataCell function for division, it actually went back to use the value 0.75 to calculate the division. I tried using a dynamic calc with Math.ceiling function, not working. Please help. Thank you.

Hello, I recently recovered a scenario from a restored application copy from a point in time. I now would like to extract that scenario from the application copy and put that in our working application. Does anyone have any idea on how this would be done? Thank you, Jeremy Morgan

I need to get, from a Custom Dimension, the characters starting after "D." or "T." when it's possible. Normally it comes as D. or T. at the beginning, followed by XYZ. What I want to get, as a direct mapping, is XYZ (these are the members created in the Custom Dimension in OneStream).What type of mapping can I use for this? I don’t want to trim the source member in the Data Source because I need the full original source member to appear in Stage.