Reporting

When building a Cube View its helpful and best practice to build a report dynamically so that less maintenance is needed.  There is a Member Expansion Function "First" and "Last" but nothing in between (i.e., second, third etc.) For example, if you use X#MyMember.Children.First.Children it will display all the children of your member as well as the grandchildren of the first child.  Last will do the same but give you the grandchildren of the last child instead.  It would be helpful to be able to reference different positions other than first and last in a hierarchy so that the member that you need grandchildren of doesn't need to specifically be called out in the member filter. This would help my client tremendously with being able to have the most dynamic report possible in the event that members are added to the dimension hierarchy.

Ok, we have a cube view configured with a parameter for the following dimensions highlighted below in the POV tab of the CV   Now, I explained to our testers that we wouldn’t need to select the members under the CUBE POV because it is parameterized in the CV for selection. Three of the five users were able to see and select the view members.  I was able to replicate the issue with a test account. I created a test account to replicate the issue I selected the CUBE POV and asked why is it that I can select parameterized members for dimensions: Cons, Time, Scenario, Division, Entity, and not from the View dimension? Notice the only members that are populated in the Cube POV are Time, View, Flow, and origin (see below) Just for kicks, I select the view dimension,  select member SV (scenario view ), OK, and Close Can you believe the View members are now populating in the parameter?  Does anyone know why?     

Why is our UD8 Level1 formula called multiple times by cubeview- for over 25 mins? this member is the first column in our small report with other column being a month.We needed to display Level1 member to Level8 (our .base member) of our accounts dimension in a cubeview.It runs withing 1 min when there are only a few hundred rows of accounts to report.However, when we tried to change that report to include base members of our product dimension, it is taking over 25 mins to run –for  just for one entity.  The problem seems to be in our UD8 formula called level1.We logged the calls to UD8 member Level1. It seems to be looping through this level1 multiple times.We may expect less than 1,000 rows for one entity and for one account, using suppress zero.To limit the minutes it takes to run, we had to set “Max Unsuppressed Rows per page “ and Max Seconds to process” to 6 mins in our cubeview.

Is it possible to use conditional suppression in CubeViews? For example, I would like to suppress row/columns when a value is greater than zero.

Hi community, refering to the solved request in the link: Solved: Show 0.0 in Cube View Data Cell instead of blank cell - OneStream Community (onestreamsoftware.com) Is it also possible to get a drill down here? That doesn´t work with the described UD8 anymore. Thanks.

Hi Team i have created a Bi Viewer report by fetching the People Planning Plan Data tab using SQL Data Adaptor and getting this error while opening the report from Workflow. My assumption is this error is popping up because of large dataset in the people planning data tab, as this is opening with lesser amount of data records, is there any way to make it work or to increase the no of rows for a bi- Viewer report?

Hi All,For some reason, we are getting errors (#Error) when we use the XFMemberProperty function in Excel with Account for the following 3 Member Properties; Input View for Adjustments, No Data Zero View for Adjustments, and No Data Zero View for Non-Adjustments.  Every other property returns a value or a blank cell which is what we want.  Any idea why these properties cannot just return a blank cell as opposed to showing an error? Thx,Mike

Originally posted by Hubert Gao Hello, In CubeView, is there any setting to show Zero for No Data cell instead of showing empty cell? Thank you!

Data generated by dynamic CubeView calculations can be imported into other Cubes or Scenarios” Question Credit: Jack Lacava 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

I am using the below formulae to fetch members in a cube view. Account -> A#Root.CustomMemberList(BRName= abc,Param1=value1) The results from BR defaults the indentation to 0 instead of the indentation that is mentioned in the formatting tab.   Do you know how we can change the indent level to 3 after the members get returned from BR.     JackLacava 

Hello! Does anyone have experience reporting across two applications in the same environment? I've been in touch with OS support who's still working on it but wanted to pose this to the larger customer/consultant community to see if there were any options or solutions out there already being used. Thanks!

1.How can we use the below member filter in red colour inside XFCELL. How can we use it? XFCell(Cb#GolfStream:E#[NA Clubs]:C#USD:S#Actual:T#2022M1:V#YTD:A#69000:F#None:O#Top:I#Top:U1#Top.base.where(Text2 contains '|WFYear|'):U2#Top:U3#Top:U4#Top:U5#None:U6#None:U7#None:U8#None) 2. How can we use GetDataCell(A#A100+A#200) inside XFCELL to calculate some expression.   Thank you!!!

Hello all .    i am trying to display in a cubeview a list of accounts with specific constraints related to FLow , for example i want to display Only accounts with having Flow = EQU . any idea which function to use ? i tried the [Where] clause it didnt work out. would the [Option] be helpful ? which arguments should i pass 

In a cube view, how can I use a manual input value in the formula in another column? Col1 Col2 Col3 EndBal Input Value EndBal - InputValue Many thanks in advance. Winni

Hi, are there any capabilities to use visualizations like Matplotlib? If not, any plans for this?thanks,Greg

All calculations must be executed as part of consolidation activities (Calculate, Translate, Consolidate). Question Credit: Jack Lacava 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

I want to apply background color for each row of a grid view based on column value 

Hi all, We are trying to import an excel report into powerpoint. This works fine. However, there is an issue with the borders that are appearing in the picture, as the picture does not seem to fill out the picture that is inside the powerpoint. Is there anything we can do to remove these borders in the picture? Please see an example: Named range in Excel: How it appears in the powerpoint picture (I highlighted the red) Ideally we would not have the white spaces in the picture. Any idea on which options could be used to stear this? With kind regards, Tim

I am looking for a Business rule function to write "data unit statistics" filtering on Year,month &Scenario. (OR) Cube view which can display DUS on the report.   PS- I know we can right click on calcstatus to get the DUS but require something which can create a report/write to a table for DUS>      

I want to creat a report as below. The issue is with the Comments under column2 , I want to insert something lika a text box where i can write in a paragraph for summary. Thanks in advance !  

Do the OneStream Excel VBA functions return a value that can be used to determine success or failure?  For example, I am loading data to a cube using a sheet with a number of XFSetCell() formulas and then using the VBA function RefreshXFFunctionsForActiveWorksheet() in a module to load this data: Call ExecuteXFFunction("RefreshActiveSheetXF") ........ Public Sub ExecuteXFFunction(XFFunction As String) ' This executes whatever XF functions are defined on the active worksheet. The active worksheet needs to be set before calling this function Set xfAddIn = Application.COMAddIns("OneStreamExcelAddIn") If Not xfAddIn Is Nothing And Not xfAddIn.Object Is Nothing Then    Select Case XFFunction       Case "RefreshActiveSheetXF"                  Call xfAddIn.Object.RefreshXFFunctionsForActiveWorksheet      Case "RefreshActiveSheetQV"                Cal

Hello - we are running the intercompany matching report in the Application Reports dashboard and I see there is a setting which states "Suppress Matches" is set to false as a default. Please can anyone advise how to change this to true so we just see the mismatches?   Thank you!

Hi !I have a SQL table available where I wanted to show a radar graph based on its data.It turns out that BI Viewer is not providing radar or spider graphs, so I wanted to know how to have such graph based on a data table and not a cube view. BAsed on what I've seen, the Advanced Charts allows to work with cube views or business rules only. Does someone have a business rule in order to extract data from my SQL data table and have it as a source of the graph ? Regards,

Hi all, We have a question about invalid intersections in reports and whether it is just a presentation issue or if we need to be worried about calculations or transformation rules as well. We have Cost Centers in our UD1 dimension and we have some Accounts that require specific UD1s. For instance, Account 62000 Gross Sales has a constraint of UD1 65000_F Sales. The event handler ensures this combination is maintained when loading data using transformation rules. For reporting purposes, we have now created an alternate UD1 structure that does not include all UD1s for some very specific reasons. Now, when running reports such as the P&L, the row for Gross Sales shows pink when the alternate UD1 structure is used because that alternate structure does not include UD1 65000_F. The displayed data is still the correct Account 62000 and UD1 65000_F combination, but the cells are pink since that UD1 of 65000_F isn't in the alternate UD1 structure. This alternate UD1 structure is only used

Hello, I am building the Cube View.  As you can see below, I have Quarters in columns and now I want to add new rows for Qtr growth. How to achieve the formula for Quartly growth? I want to compare the current Qtr to the prior year's Qtr in New Row. Below is the formula.  Formula: (Current Year Qtr - Prior Year Qtr)/Current Year Qtr*100