Reporting

Hi all, I have created some calculated fields into BI-viewer. I need to use the dashboard parameters into those calculation expressions as I have some calculations according to that. Any idea on how we can do that.

Hi,I have a large Excel report built on XFGetCells. I am trying to understand the dimensions that each XFGetCell is grabbing, but it takes a long time to parse through an XFGetCell manually and make notes of each relevant dimension. Is there a method or tool to read XFGetCells and translate the dimensionality in a format that identifies which dimension each member is related to? An example of one of my XFGetCells is:=XFGetCell(TRUE, "Cube1", "Entity1", "", "USD", $G$4, H$18, $I$4, $C$24, "Top", "Top", "Top", $C$15, "Top", $C26, "Top", "Top", "None", "Top", "None")-XFGetCell(TRUE, "Cube1", "Entity1", "", "USD", $G$4, H$18, $I$4, $D$24, "Top", "Top", "Top", $C$15, "Top", $C26, "Top", "Top", "None", "Top", "None")-XFGetCell(TRUE, "Cube1", "Entity1", "", "USD", $G$4, H$18, $I$4, $E$24, "Top", "Top", "Top", $C$15, "Top", $C26, "Top", "Top", "None", "Top", "None") I would like to understand that Cube= Cube1 Entity= Entity1 Parent= Cons= USD Actual= $G$4 Etc. Thank you

Hi Everyone.  How can I make an element not open with just one click, but with two clicks or more?

Hey guys! I am working on an Dashboard to present workflow status.... i got this: The query is: {Total GolfStream}{|GlobalScenario|}{|GlobalTime|}{}{}{RowType <> 'A'}   How can i remove the ones that have Central in the name?   Thanks!  

Hi, All!  I am unable to submit (cubeview form) from an Excel workbook which contains many unrelated sheets.  Leaving the workbook as is, I enter a new number in the form and click submit, but nothing happens...No error message, but it doesn't overwrite the existing number., so it isn't working. However, when I randomly delete a few sheets from the workbook, eventually the cell will turn yellow when I change the number, but submitting the data still doesn't update the number.   But when I delete a few more sheets, the cell turns yellow and finally the data is submitted.  Since it is resolved by shrinking the size of the workbook (original size is 3.23 MB) it seems to be a memory issue.  Is there a fix for this or even a known root cause?  Not sure if the issue is Excel and/or OneStream or something else.  The user would like to keep all of the sheets in the file.  Thank you!   🙂   

Is there a way to exclude a tab in a book if that tab has no data? I have a cost center loop added to a book. The loop includes all cost centers, although I know some cost centers have no data. I want to make sure we aren't excluding any cost centers in the event an old cost center is used. I'm trying to ensure the report is complete. However, adding all cost centers to the loop results in many completely blank tabs. Is there a way to suppress these tabs or exclude them from the output?

If I have a dashboard gridview of Stage table data, is it possible to execute a drillback to a source system directly from the gridview?

Hi All,   I have a dimension hierarchy like Account1(parent) and Account2(parent) hierarchy members in Account Dimension and i need those base members in the same row/column. I tried adding those members and got below error, can anyone suggest how to resolve this. Thanks in Advance.

Hello, I am trying to insert an excel file (tab) into a book that will export to excel. The purpose of the file is to insert a tab as a separator between report tabs so that the name of this excel tab denotes the type of reports that come next. I am having trouble inserting an excel file so I have created a work around by creating a blank cube view and giving it the output name that I want it to have and then brining that "report" into the book, but I don't feel like I should have to do that. If anyone has any knowledge on adding an excel file to a book, that would be great. Thanks!

Our team uses cubes views for reporting.  Often times they will highlight a cell for analysis purposes in a separate color, however when they refresh the cube view the color reverts back to the original color.  Is there a way to keep color, upon refresh.    

Hi All, For a Bi Viewer Dashboard I use a Cube View which calculates values with a GetDataCell calculation. I display the values in a line chart. The values are displayed correctly, but the calculated variable name in the legend does not match the defined name in the Cube View calculation, instead the first used account name from the calculation is used. How can I use the name I defined in the cube view cell in BI Viewer, or if it is not possible, how can I rename the variable name manually in BI Viewer?

Hi everyone. I’m working on a cube view, and I have a variable that handles the scenario, and I want another column to have the PY of that selected scenario, so if you could help me know how this can be done. Example for the scenario to modify.  

Hey folks, We have a requirement to define range of rows in a GetDataCell. For example: GetDataCell(CVR(Row1) + CVR(Row2) + CVR(Row3)..... CVR(Row100))Instead of defining it manually till Row100, Is there any way to give a range like this GetDataCell(CVR(Row1):CVR(Row100)) ?Any solution to this will be helpful. Thanks. 

Hello Community I have data sorted in descending order in Data Adapter. But when that data is imported to BI Viewer I am not getting in descending order or any other sorting order. 

Dear all, I'd like to know whether you've been faced to this issue. When defining the CV there are several nested dimensions in the row definition and I'd like to show it so that the header is repeated to avoid empty headers on the rows (see image below). Do you know how it could be possible to edit it? Thank you    

Hi there, I have the same issue as that of the link below but I'm looking for a solution without using a DynamicCalc nor GetDataCell because the parameter "Allow sparse row suppression" is set to True. Does anyone have an idea about how to proceed? Regards How to bring attribute "Text" fields value into a Cube View - OneStream Community (onestreamsoftware.com)   Edit: When using a DynamicCalc member and "Allow sparse row suppression" = True, it entails an error (see following image)  

We have a combo-box for entity selection on a dashboard however, it only allows a user to select 1 entity at a time. How do I make that comb-box open to multi-select 2 or more entities? I do not see a multi-select true or false option on the combo box form. Parameter: Combo Box: In Dashboard:        

Hi, I am wanting to show the scale of dollars in a report, I have the parameter |!Divisor!| which has display items as Whole Numbers, Thousands, Millions, and Billions. When I use that parameter in a report instead of showing the display items it shows the value items which are 0, 3, 6, and 9.   Thank you, Jeremy Morgan    

When refreshing a quick view after having changed the PoV, any formula in the row that is refreshed will be cleared.Is it possible to retain the formula ? Example: A1 Formula B1 PoV C1 PoV When changing B1 and C1, and refreshing A1 will be cleared. Thanks!

Hi All, I am trying to add two UD2 dimension members in the Cube view member filter and obviously , its not allowing me to enter them. I went through the approach of creating a dimension in UD8 and then copying all the data from the UD2 dimension to UD8 dimension in order to show the two columns. However, it is not working for me. I used the following code in dynamic calc formula for UD8: B2C_PGC_Provider so that I can reference it to UD2 ( all member dimensions and included data):  Dim U2Filter As List(Of Member)=api.Members.GetBaseMembers(api.Pov.UD2Dim.DimPk, api.Members.GetMemberId(dimtype.UD2.Id, "Programs_Provider")) For Each memberObj In U2FilterBRApi.ErrorLog.LogMessage(si, memberObj.Name)Next. Please let me know what is wrong and how this can be resolved.

Hi, We have a user that is getting the error below while trying to refresh an excel file using Smartview.  I've had a look at the file, and it's nothing special. Just a few XFgetCell formulas, and it runs fine for me. Error: Index was out of range. Must be non-negative and less than the size of the collecion. Parameter name: index.   Any ideas folks?

Are there any steps that need to be taken for YE close in OneStream. Balances rollover P&L to R.E. and Opening balances for BS accounts. Do we just run a 2024 force consolidation? Any recommendations?

Hi all, I'm looking for a way to skip a dimension parent level in a Tree expansion while still maintaining a tree style view.  Does anyone know if this is possible? Alternatively, does anyone know of a way to declare an expansion MyHierarchy.Tree and include a .Where or .Remove clause?  I can't seem to get this to work for me so I wonder if it's just not possible using the "Tree" method. Example: Default Expansion based on .Tree expansion Parent 1     Child 2        Child 3            Base MemberDesired View (skip the Child3 parent):Parent 1      Child 2            Base Member

Hi, This is most likely basic but I cannot find a reference for this.  I want to show the time Quarter in a cube view, but the name should be the last month of the quarter instead of Q1. Should be March 2023. May I know how to do this? Thank you in advance.

Hi, I sent out an excel cube view report to My colleague. He filled in the numbers and sent it back to me to submit. However, when I click the submit button in excel, the cube view report number is overridden ( to existing system data) and the number my colleagues input is gone. Any way to submit his number before the cube view loads the previous number? Thank you.