Reporting
Questions about Cube Views and Reports

Forum Posts

Resolved! dynamic time period member list

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

trunning by New Contributor
  • 419 Views
  • 3 replies
  • 0 kudos

Resolved! Excel File in Book

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

lp by New Contributor II
  • 547 Views
  • 3 replies
  • 1 kudos

Resolved! CubeView Row Collapse

I have a cubeview with 1 Row = A#NetIncome.TreedescendantsInclusiveR. I would like to have the accounts collapsed, so that the report doesn't have all the accounts/rows expanded.I have set RowExpansionMode = CollapseAll, but it did not change anythin...

bjornliow_0-1706203650596.png
bjornliow by New Contributor II
  • 220 Views
  • 1 replies
  • 0 kudos

Keep Excel Color Formatting upon refresh

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

tdugas by New Contributor III
  • 136 Views
  • 1 replies
  • 0 kudos

Resolved! CV Scenario PY dynamic

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.

Marco_0-1706117047009.png
Marco by Contributor
  • 242 Views
  • 1 replies
  • 0 kudos