Reporting
Questions about Cube Views and Reports

Forum Posts

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
  • 247 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
  • 152 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
  • 265 Views
  • 1 replies
  • 0 kudos

Resolved! Extract part of parameter string in cube view

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

fc_0-1706017459767.png fc_1-1706017852750.png
fc by New Contributor III
  • 611 Views
  • 4 replies
  • 1 kudos

Can we define a column/row range in a GetDataCell?

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