Reporting

Hi all, In a case we'd like to have a CV with 3 columns using different intercompany groups (group 1, group 2, group 3), for a particular account (1 row). Do you know how this can be done? I could do a member list but this would show the detail of every I#(partner x) for all the combinations but I'd like to show only the totals of each IC group. Thank you. Best regards, Carlos 

I have the following in Rows: Trying to exclude one account Goodwill from OI_EX_O. Member Expansion 1 - Primary Dimension Type UD1 / Member Filter / GetDataCell(A#FINS57:U1#OI_EX_O - CVR(GoodwillImp)):Name(OIE_Operating).   Columns are shared. The calculation for Variance$ and Variance% is not working for this particular row:   Shared Columns:        

Hi all  What would be the best way to create an intersection of two hierarchies within the same UD? For example, assume these are Profit Centres in UD1.    I would like to be able to create a cube view where by I could choose a node from hierarchy 2 and it will display the members (and the relevant subtotals) using hierarchy 1. i.e. if you choose 2022 you get the following: Thanks, Mark

Hi, this cube view report would run quickly without issue on Onestream application but when referring to it from the cube views in Excel plug in, I receive this error. Why could it be? Thanks for your inputs.   

Hello, I have a cube view connection in Excel that won't resize columns when I change my parameter selection. For example, here are what the columns look like with my initial parameter selection (2023M4) vs. a different time period (2023M5): As you can see, the columns aren't adjusting after I change the parameter. I have tested a number of settings such as defining the ExcelColumnWidth and some of the Cube View Connection settings but nothing seems to work. Are there any Excel specific settings or Cube View settings I need to check in order to resolve this issue?

Dear community, I am currently using the REST API (using the Personal Access Token that really works well !) in order to retrive a Cube View. It's very easy to use as it works just like a regular Data Adapter configuration. However, the cube view that I query is using 2 parameters. If I don't specific the parameters and a value in the REST API query, nothing is returned. I can specify the value manually, however I will lack the flexibility of the cube view to retrieve specific values. How can I change the REST API call for my cube view so that the parameters are indeed prompted ? {"BaseWebServerUrl": "XXXXXXX","ApplicationName": "Production","CubeViewName": "PVM_Graph2","DataTablePerCubeViewRow ": true,"ResultDataTableName": "ResultDataTableNames","CustomSubstVarsAsCommaSeparatedPairs": "P_POC_INP_UD7_Part1=D1,P_POC_INP_UD7_part2=D2","CubeViewDataTableOptions": {"IncludeTitle": false,"IncludeHeaderLeftLabel1": true,"IncludeHeaderLeftLabel2": true,"IncludeHeaderLeftLabel3": true,"Includ

Does anyone know of a way to handle this situation while using a Line Item dimension on a cube view input form? Let's say the Line Item dimension has 20 members.  Can you set a default number of Line Item rows to always show, say 10, but allow the users to add more as they wish?  I know the latter part is possible with the Allow Insert Suppressed Member property.  I don't know about the first part of the question.  I tried splitting it up into two rows, but the second row, which would be the one to insert Line Item rows when desired, doesn't display anything to click on and use the insert suppressed action. Thank you.

Trying to align the text in a button to the left. HorizontalAlignment = Left does nothing. I've also tried HorizontalContentAlignment under Image. It centers the interior text no matter what I do. Anyone have any thoughts? Is this possible at all? Kind of annoying if not.    

Hi!   I’m trying to create a cube view that can drill down to stage detail data. Is there any documentation on this?  Any input would be greatly appreciated!

Hello everyone, Is there a way to collapse/expend column via a native display configuration on Onestream (v8.1) ? Something same as the RowExpensionMode option in the Header Formatting but for the column. Thank you in advance.

We have users experiencing connection conflicts with the OneStream Excel Add-in. When they enable the OneStream add-in it disables the add-in they have for their ERP. They would like to be able to use both add-ins at the same time. How can we enable them to have both add-ins active? Have there been similar issues? What is causing their ERP add-in to be disabled? 

Hi OneStreamers, I am using the table vStageSourceAndTargetDataWithAttributes in a dashboard to display cost centers (Source Account) and Accounts (Target Accounts) per all other dimensions, for a selected entity and period. It's working fine but the amount from the table is always in the local currency of the entity, and I'd like to see all amounts in EUR. Is there an easy way to convert the figures in the table ? I saw there was a column named "Converted Amount", maybe it can be used somehow to show translated figures ? Appreciate your insights on this. Adam

Does anyone know what this message is talking about. Sorry...new. Users are trying to drilldown by 3 dimensions in the rows and are only getting approx. 6 rows of data and then the message under the output. Their row settings are at 10,000.   Any help would be appreciated.... James

Hi, I am building a BI Viewer chart and need my colors to be dynamic. I have three colors in my color palette for the BI Viewer component. I can manually set the color to match the option in the palette, but if I use the parameter changes my scenario or time, the palette color is reset and it selects a random color. If I use the automatic setting (which would make the most sense) it sets every color to black.  My ideal color settings are: First year actual: Blue Second/last year actual: Pink Second year plan: Green How can I set this up dynamically?

Hi I am trying to add conditional formatting to my CubeView to bold certain rows, so that it stands out for my users. I'm using treedescendants(i) to list out all the accounts to minimize any maintenance, so I can't bold the rows individually. Also, the accounts I want bolded are not in the same indentation level, so I can't use that expression. I tried using If (MemberDescription = 'Apple') Or (MemberDescription = 'Orange') Then Bold = True End If. This works, but if I tried adding another Or statement, it would not work:  Eg:  If (MemberDescription = 'Apple') Or (MemberDescription = 'Orange') Or (MemberDescription = 'Banana') Then Bold = True End If.  Is there another workaround for multiple Or statements/ how should I update my condition? 

Dear CommunityI am facing the fact that my XFBR(BR_XFBR_String, ParentBold, sEntity = |MFEntity|) does not passing the Entity Name to XFBR.CubeView is organized in the way that Rows contains just a part of Entity structure Entity.ChildrenInclusiveR (this two step structure has no Base Members) and i need to format only Top Parent of that. It works when Variable comes form POV or CV but not from the Rows/MF.Is there any way to use |MF...| for passing information to XFBR?Thanks

Hi everybody, I'm currently developing a dynamic CV that gives the chance to the user to select an account hierarchy of choice to show in the report  (P&L, BS etc.) through the parameter MainFormParentAcc_PL I'm having issues with indentation tho, because if I add .TreeDescendants the accounts are still shown on the same level in the report.  I tried to look if there is a format I can apply, but if I understand correctly the only format available for indentation is for the excel view (ExcelIndentLevel = xxx). Do you have any suggestion on how I could solve this?Thanks in advance!

Hello People, I built this CV and then I'm building this BI I used the same CV above in the BI dashboard, however, I couldn't move the periods in the columns like in the CV. I would like to have the periods in the columns like in the CV to get the same data.do you have guys any examples of this?    thank you

Hi all, I am trying to build out a CV for a report and I'm having trouble with the best way to build out the columns. My current approach is to just go at each column with differing member filters. For Example: 1st column - S#Actual:V#MTD:UD#Orders:...etc. Does anyone have a better approach that I could use? Or even just point me in the right direction in the documentation? Thanks in advance! Here is a screenshot of the report columns I need to build in OS:  

I have listed a parameter which has display items as Yes, No in one of cube view row override that displays in a Form. Along  with Yes, No items it is also showing "No Data" even if it is not listed down in Display items of the parameter. Could you suggest how to remove "No Data" item     

Hi, we have been working to build our Cash flow report and would need to include an account from the Balance sheet into the cube view report. We would need to include ''cash and cash equivalents at the beginning of the period'' and ''cash and cash equivalents at the period end''.Is this possible to include? When I tried to, I got no values from the BS account into the cube. If so, how would i proceed?Thank you! 

Hi All, I've got an annoying error message popping up on a dashboard I've built. To be clear it doesn't stop anything working, just wondering if I can get rid of it somehow... Basically in the content section there are 2 cube views. When the user clicks on something in the first one, it uses the normal navigation links (in the cube views) to pass an entity and UD4 across to the second one. It's all fine and works except for the first time the user opens the dashboard when cube view 2 doesn't load (and gives the error message) because nothing has been clicked on yet! Is there any way to pre-populate the |!ClickedEntity!| and |!ClickedUD4!| in cube view 2 before anything has actually been clicked? Thanks (screenshots below), Richard First time load before anything has been clicked:   After clicking on cube view 1, the navigation links kick in and populate cube view 2:  

Is there a way to create a dimension member drop down in Excel to use for the GetXFCell data selection listing?

We have built a set of dashboards for our client within OneStream and the requirement is to be able to export and distribute these dashboards outside of OneStream.  We have previously gone the route of exporting to PowerPoint, however, we are struggling with the cube views replacing the images, formatting, not bringing over any editable text, etc.. overall, a lot of work for a poor result.  Are there any other options to exporting dashboards? Ideal result is to get as close as we can to what we are seeing in the OneStream dashboards and just extract them.  Any advice is greatly appreciated!

i am pulling flow to cube view i want to round the number to two digit precision. i tied with number formatting N2 it didn't work. i can see the two digit in CV but real number still exist when i export to excel. How can i round the number?