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 by New Contributor III
  • 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
  • 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"...

bisenhart by New Contributor II
  • 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
  • 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
  • 2 replies
  • 0 kudos