Reporting
Questions about Cube Views and Reports

Forum Posts

Power point in Book not showing the full data of Cubeview

Hi, I created PowerPoint deck for reporting in the OS Book where I attached few cubeviews, But when i try to view the report it shows what ever fits in the one page but if the data is more to show extended rows that just cuts off and not even moving ...

nmubasc_0-1721681726560.png
nmubas-c by New Contributor
  • 32 Views
  • 0 replies
  • 0 kudos

CubeView Conditional Formatting based on cell value

Hi all, I am trying to use conditional formatting in a cubeview and color all of the columns but I want it based on the cell value in Col3, not its own cell value. I have If (CellAmount > 0) Then ReportBackgroundColor = Green --- but I want it to be ...

eeisenberg by New Contributor II
  • 52 Views
  • 1 replies
  • 0 kudos

Book: Footer using UTC time zone

When I run a OneStream book, the time zone in the footer is in UTC, which is 5 hours different from my time zone CST. However, if I run the individual cube views that are included in that book, the time zone is converted from UTC to CST. How do I get...

Cheryl_Lamkin_0-1721671724324.png Cheryl_Lamkin_1-1721671731334.png

CubeView dynamic Calc

Hello Experts i'm trying to create a report to calculate fcst numbers based on driver. for driver, i'm using dynamic calc where i'm taking 3 month moving avg as %. my user wants the ability to tweak %. how can i do that? if i add an additional column...

Screenshot_OS.png
prash4030 by New Contributor III
  • 62 Views
  • 0 replies
  • 0 kudos

Resolved! Combine application table and UD dimension information

Hi, I have an SQL data adapter that queries an application table, and one of the columns is the CostCenter. This CostCenter is also a dimension in our cube, where the table values correspond to the base-level members of that dimension. In the CostCen...

AndreaF by Contributor III
  • 108 Views
  • 2 replies
  • 0 kudos