Reporting

Hi all, I am working with navigation links in my cube view. However, when I open the 'linked cube view' through my 'main cube view,' I get the member filter to show in the title of the dialogue box that opened. These are the bound parameters that I used in the 'main cube view.' Is there a way to remove the member filter from the title bar in the dialogue box? I've included below what I mean with the title bar and my issue.  I appreciate any help you can provide. Kind regards, Floris van der Poel

When a translation or a consolidation is run, the AdjInput entries are rolled into the AdjConsolidated member. This rollup occurs as the data is moved along the Consolidation Dimension. Question Credit: Peter Fugere 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

Happy New Year Everyone! I am hoping someone has an example of how to use the formatting rule in OneStream Dashboard Reporting to change the style of any row in table oContent where label13 (field OFCvRAVAR in my dataset) is not zero. I think it's also possible via a script ... Have been looking in Golfstream for an example, but no luck. Thanks!

I can drill from the Journal report Question Credit: Peter Fugere 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

Is there an easy way to traverse with in a cube view like ctrl home, ctrl end, ctrl + up arrow, ctrl + down arrow in a Data explorer view. Need help.

Hi guys! I would like some guidance on how to pull all children at the same level in a Quickview. Thank you.  Oliveira, Vanessa

You cannot use OneStream to directly report on SAP data 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

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.

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

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 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>      

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 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

There are 2 Column Overrides that can be applied on a Row. Question Credit: Becca Speese 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

  The Member Filter Builder provides examples of calculations Question Credit: Becca Speese 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

The Workflow Status Reports show the status of the Import, Forms, and Adjustment items that are immediately under the Workflow slider. Is there a way to show the status of the individual Forms under the Required and Optional steps? Our Finance team wants to be able to run a report to see whether individual Forms are marked as Completed or not during the close process. Thank you for your help! Darrin

Hi, is it possible to use time functions other than "WF" in cube view point of view?   For example, I have the time function "T#WFYearM12" (it takes the current workflow year and add M12 at the end to get the December month). The function works as expected if used in cube view rows or columns. However, if I try using "WFYearM12" in the cube view POV, it does not work.   I can set the time to "T#WFYearM12" for each row of the cube view. However, I was wondering if it was possible to use the same or a similar function in the POV.   Thank you

Hi All, Do we have a function to get data from a row within CV? For e.g. GetDataCell(CVC(Rental Revenue) / CVC(Fleet Actual))   I tried using this method but keep getting a syntax error. Any suggestions in the right directions will be appreciated.  Thanks!   Best, Mustafa  

Navigation links provide the option to setup one Cube View to launch another Cube View or Dashboard. Question Credit: Becca Speese 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

Hello! I would like to create a table of contents for a book that lists the reports within the book dynamically (ie. if the book updates based on parameters set, then the ToC would update as well). Is a table of contents possible? If so, how would I go about creating this? Any guidance would be appreciated! Thank you!

Hello. I am trying to create a column set showing M1-M12 for the previous year based on Global Time. I can do this successfully using WFYear and POVYear as shown: T#YearPrior1(|WFYear|).BaseT#YearPrior1(|POVYear|).Base However, this syntax generates an error  =>   T#YearPrior1(|GlobalYear|).Base I can get close using  =>  T#GlobalYear.Prior1.BaseBut, it adds a column for the year which we do not want:   Thanks,Bil Brandon

Hi, is there a simple way to create a cube view with the member name and description in different columns?  Specifically, when there are nested members in the row.  I can pull in UD8, but they come in on two columns after the names which looks odd. thanks, Greg

Conditional Formatting determines if you want to display gridlines within Excel. Question Credit: Becca Speese 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

Hi,  In a forecast scenario I have placed some text in the "Custom settings" Text 1 What it the syntax to get this text1 into my header of the CV? T#Year(|WFYearNext1|)Q1:S#WF:name(|Text1|)

Hello, I am trying to write a rule where I get the base of Net Income where the Text 2 field is not blank. Does anyone know the syntax to indicate blank?  A#NET_INCOME.Base.Where(Text2 <> ????)   Thanks!