Reporting

We have a user who's add in files are adding a prefix to all the formulas of:=@onestreamexceladdin.xfgetfunctions.For all other users this does not show up.  I tried looking at the settings and searching several Excel forums to see what the issue might be.  I am thinking this is an Excel option that may not be set correctly. Has anyone seen this before and do you know what the issue may be?Thank you!  

Hello, I am attempting to build a simple line chart through BI Viewer with Cashflow amounts in Y axis and Time (month-year) in X axis. I cannot get it to sort properly so it display data to flow through time. In the X axis, I choose Time for Arguments and sort in ascending. But it sorted as 2021M1, 2021M11, 2021M12, then 2021M2. When I change Time display from Name to Description, it goes by April-2021, April 2021 etc. How do I set this up so Time dimension flow through chronologically?

Hi Folks, I have created a dashboard for Flash reporting, and I’m trying to add a section for commentary. I’ve used the View member “Annotation” in the cube view. This works fine for short comments or comments the length of column, anything beyond that is not visible. Anyone have an suggestion on how to get around this, eg wrap text or maybe another option to add comments to a dashboard. As an FYI, the comments are linked to the parameter on the dashboard. Thanks in advance.

Is there a functionality to populate headers when we open a cube view from Excel.  Currently when I open Excel, connect to OneStream and open a cube view, the headers that we set in OS does not populate.  Is there a fix to this? 

Hi everyone,   I am having some issues with the report dashboard component. I have created a report that consists of a graph linked to a specific data adapter. This data adapter is connected to a cube view. Everything is working fine, I am getting data in the graph, and it's doing the correct thing. However, the graph is printed 72 times on the report. These graphs are all identical, so it prints the same graph 72 times on the report.  Is it a coincidence that when I test the data adapter, the 'total number of rows' is also 72? In addition, is there a setting where I can specify that the report should only be printed once? I hope someone can help me find a solution. I really appreciate any help you can provide. Floris van der Poel

T#PeriodPrior1(|!DRU_Year!|):Name(April 30, 2021)   The member filter above is not dynamic since I am hard-coding 2021 in the second column. How can I make the second column be a prior period based on the first column?

Team Can you please help where will the Books be saved to export as .xml/zip file. Am trying to check that under "Application Load/Extract" RegardsVarun

I can can create reports showing descriptions (for accounts or other dimensions) in each users’ own language. Question Credit: Noemi Nagy   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

In my screenshot above, I would like to add a $ sign. I know this is done under Number Format. However I would like the $ sign to be aligned to the left-hand side. Would adding a narrow column allow me to do that? Not every line will have a $ sign attached to it. 

Hi everyone, I am looking for a solution to insert dashboards in extensible PowerPoints. I know how to put cube views, reports, etc., into PowerPoint. However, in the object lookup, there is no option for embedded dashboards or other dashboard components. Some background about the dashboard. It is set up using the same way dashboards are set up in Golfstream. It uses some state indicators and labels. The headers and state indicators are set up in separate dashboards and are merged into one dashboard using 2 rows and 1 column.  I have looked at workarounds on how to get the dashboard into a PDF or report. However, I did not find a working solution yet. Therefore I am reaching out to the community. Any help would be very much appreciated.  Thanks Floris van der Poel cpmview E: Fvanderpoel@cpmview.com

Hi all is there a way to get rid of the + on a nested dimension? In the example below The + on EQUITY accounts indicates that EQUITY is a real parent of the accounts below the +. But for the nested dimension Onestream displays always a + and it "seems" that the element "sys_CLO" is a parent of the element below. But in this case it is not true. "sys_CLO" is only the last element of the subset in the nested dimension.     My goal is to display a list of elements in the nested dimension suppressing 0 values on the rows.   Do you think this is possible not to show the +? Thanks in advance for the help. Marcello    

Hi All, We have some cube views which dynamically pull columns as per the cycle being planned.  Cycle1 : 4 quarters Cycle2: 3 quarters Cycle3: 6 quarters Cycle4: 5 quarters  These cube views have column separators, highlighted rows and columns. Cube views are included inside spreadsheet component which are then embedded inside the dashboards. ISSUE: Formatting is different for every cycle due to varying number of quarters. We have had to manually update the spreadsheet components for every cycle due to formatting going off. Would anyone have a dynamic solution for this?  

Hi All,   I am wondering if there is a way to display a text value in a cube view cell directly from a cubeview member filter?  In other words, in the same way that you can use a member filter with GetDataCell to force a number to be displayed (ie. A#Net_income:GetDataCell(100) will display 100), can you do something similar for text values like A#Net_Income:GetDataCell(Hello) to display Hello in the cell?  It doesn't work for me and I have also tried using A#Net_Income:V#Annotation:GetDataCell(Hello) and that doesn't work either.   Any thoughts?   Thx, Mike

Hi Community ! I am building an application where there is a need to have different "culture" on the accounts. In my cube view, I have a column where the "cell type" is defined as a combo box based on a parameter where the user can enter Yes or No. This parameter is of type "member list" with "Yes" and "No" being actual member of a dimension, and those are translated. However, when I change the language, or when a user with another language open the cube view, the parameter displayed value remain the same (Yes and No, insteas or "Oui" ou "Non" for French).   Is it normal? Or is there a workaround or specific config that should be done in order to achieve that ?   Regards,  

Hello,   I have a requirement to display an error message in a cube view if the value of a cell is greater than the absolute value of 1000. Under the Cell Format I have "If (CellAmount >= 1000) Or (CellAmount <= -1000) Then " Is this approach correct? Is there an absolute value synthax that I could use? Also what is the syntax that I can use to display an error message after the conditions are met?   Thank you for your time and best regards.

Is there an addin whereby I can retrieve data from OneStream into a Word document?

The image above shows the Subtitle 4: Right (For the Year Ended April), border and the columns for the report. Is it possible to have that subtitle be centered above the three columns? 

  I am trying to change the zeroes in my report to become '-'. Can I accomplish the above with an If Statement?  

I get this error when try run dashboard. Any suggestion what is happening here?  

Hi ! I came accross the "State Indicator" dashboard component, but I can't seem to find any information about how it's used and how to configure it, either in the online help and on the community. Could you please let me know if someone has already used it and what's the purpose of it ?   Many thanks ! Regads,

Hello everyone,  Hopefully someone might help . i am trying to create a cube view that will display GL Accounts having specific FLOW criteria . on the rows the i have GL and the columns contain the FLOWS. i have multiple flows configured but each GL has one FLOW. how can i display the Flow constraint that is configured on the GL account ? 

Happy Labor Day for USA. Happy gas shortages, high electric bills and soon coming freezing winters for many of us around the world.I renamed my Cubeview from CV1  to CV2_deleteVersion08302022. Why did my workflows  automatically change its configuration to use new name CV2_deleteVersion08302022? Should it not remain as CV1 ?  I'll try to give a screen shot

Hi All, I'm in this sort of dilemma, where my book prints the report over 2 pages, while my CV pdf print on one page.I'm wondering if there is a way to fit all on one page.  Thanks   

Hello,   I have a Cube View that prompts the user to select the month for the report when it is run.It would be great if it could select the current year's first month by default. I have tried some different things in the Default Value such as WFYear, T#WFyear, |T#WFyear| and others but cannot get the default I need. Does anyone know what the syntax that I am looking for is? Thank you very much for your time and involvement!      

I can use Table Views in the Excel Add-In. Question Credit: Noemi Nagy   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