Office Hours
Questions and Answers from real consultants

Knowledge Base Articles

Question: Where and how can default formatting be set for reporting purposes, is there a way to format “Empty” to retrieve “0” instead?

Answer Yes, default report formatting for Cube Views, PDFs, and Excel can be set in a number of different places. Application Settings – Sets default formatting across the entire application Cube View Settings – Sets the formatting specific to the cu...

OSAdmin_0-1628874438298.png OSAdmin_0-1628874497413.png OSAdmin_1-1628874522274.png OSAdmin_2-1628874562429.png
OSAdmin by Valued Contributor
  • 733 Views
  • 0 comments
  • 0 kudos

For reporting, what is the best way to return a range?

Answer You can use an XFBR Rule to dynamically pull back a range. This can be useful when the workflow time is set to a range.If you have a set amount of months that need to be returned you can utilize the T#POV.Prior function. T#POV.Prior12 = Prior ...

QandA.png
OSAdmin by Valued Contributor
  • 241 Views
  • 0 comments
  • 0 kudos

Can you give an example of the best way to sum a row from a cube view? For example, if I add two rows to a cube view, one with a selection of members, how do I make the second row a custom sum of the first? I know one way to do it, but I don’t love it, I would love to see what else you guys recommend.

Clarification – this is referring to using Cube View Row/Column math when members expansions are in use. Answer No “elegant” ways to address this currently – options are: Avoid using member filters (i.e., break the source rows down to more detail) Re...

QandA.png
OSAdmin by Valued Contributor
  • 981 Views
  • 0 comments
  • 0 kudos
Top Contributors