Reporting

I would like the use one of the T#Global function and create a dynamic time list for the last 24 months.  For example, I had the time as 2023M12, the list would show me all the months of 2023 and 2022.  Anyone has any tips on how this can be acoomplished? Trung

Hello,    I have a dimension (UD5), the base embers of which I tag  with a certain text "TEST1". I am trying to create a dynamic hierarchy in UD8 by reading those texts as Text1.  I would like to use this dynamic hierarchy as  a report filter.  For some reason this is not working. I have no formula or BR to do any processing. Am I doing something wrong? Any help would be appreciated. Thank You, Indu

Dear Community, We have requirement to for reporting in which when we run the report its huge and we want to reduce the size of data and we want to apply sparse row suppression but since we have used dynamic calc in our column set which is throwing error when we apply sparse row setting.  Please let me know if you have any idea or solutions which would be very helpful. Thank You!

Hi everyone, I have the current Entity hierarchy: I created a cubeview that allows the user to initially select a base entity from a dropdown list to be used as Entity member within the cubeview. In some of the rows, though, I'd like to consider the Legal Entity code rather than the base member code (for example, assuming the user initially selects 1010TRW, I want two rows to use 1010 as Entity member whereas the rest of the rows will use 1010TRW). Is there a straightforward way to consider the first 4 characters of the parameter in one of the rows of the CV?  I tried to search for functions to be used in the Member filter builder window but I did not find any.Thanks in advance for any help!            

Is it possible to assign more than one security group to a Dashboard without having to create a new security group?  We have a Dashboard that our SuperUsers currently have access to, and they want the Supervisors to be able to see that Dashboard as well. We don't want to create a combined security group to include both SuperUsers and Supervisors to maintain separation of duties for auditing purposes and we don't want everyone in the application to have access to the dashboard.  Is this possible?   

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.