Reporting
Questions about Cube Views and Reports

Forum Posts

Cube view - add more row members

I want to add more filters to my row, just as I have it in my Excel quickview, but from what I saw there is no visual way to add it, so I needed to know how to do this, whether it is through a business rule or another way.

Marco_0-1709138868186.png Marco_1-1709138881535.png
Marco by Contributor
  • 130 Views
  • 3 replies
  • 0 kudos

Cube View POV setting

I'd like assistance with utilizing a formula within the UD1 dimension section of the attached POV Cube view. Specifically, I am trying to subtract one cost center from another. So the formula I'm hoping for is something like "GPPPFI - GPPPAccounting"...

POV.PNG
bisenhart by New Contributor II
  • 128 Views
  • 2 replies
  • 0 kudos

Data flip sign when exporting to Excel

Dear community, We encountered a reporting issue: when exporting a cube view to Excel, one line of data will flip the signage. In cube view, we have the Budget amount of (10,763), and the delta is calculated with GetDataCell(CVC(Actual column) - CVC(...

LisaC_0-1708898772073.png LisaC_1-1708898981900.png
LisaC by New Contributor II
  • 174 Views
  • 3 replies
  • 0 kudos

Resolved! Cube View Cell Conditional Formatting - Large % result

I am trying to create a conditional formatting code to convert a large percentage result in a percent variance column to replace it with text ("nm"). Can anyone provide the conditional formatting text that would replace the actual % variance with tex...

kglen by New Contributor
  • 159 Views
  • 2 replies
  • 0 kudos

Resolved! cube view formatting

I want format the Cube view cell based on cell amountIf (CellAmount > GetDataCell(CVC(Col2)) )ThenBackgroundColor = Red, TextColor = WhiteEnd if This code is not working, Actually I am comparing actual amount with budget. how can we do this?