Reporting
Questions about Cube Views and Reports

Forum Posts

Resolved! Export a report to Excel Error - Unable to open file

Hi all, I'm encountering an error with one user who is attempting to export a report to Excel. The download process is functioning correctly, and the file is being saved in the OnStream temporary folder. However, the issue arises as OneStream is unab...

GParreiras_0-1709148187372.png
GParreiras by New Contributor III
  • 374 Views
  • 4 replies
  • 0 kudos

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
  • 202 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
  • 176 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
  • 240 Views
  • 3 replies
  • 1 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
  • 295 Views
  • 2 replies
  • 0 kudos