cancel
Showing results for 
Search instead for 
Did you mean: 
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 Community Manager
  • 229 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 Community Manager
  • 258 Views
  • 0 comments
  • 0 kudos

How can you adjust the column width on cube views?

Answer For the Row Header width: This can be found under General Settings > Header Size, and can be either set to a specific width, or –1 for default sizing. Needs to be set independently for Data Explorer, Excel & Report modes.For the Column width: ...

OSAdmin_0-1629130139004.png QandA.png
OSAdmin by Community Manager
  • 115 Views
  • 0 comments
  • 0 kudos

Question: In a Cube View heading, how can I include the last day of the month as the time description in a page caption (e.g., display "as at 30 September 2020" instead of "September 2020“)?

Answer Assuming that the date being shown is always the last day of the month and the client is using calendar months, it is possible to use XFBR string rule to call a function to get the number of days in the month. Source: Office Hours 2020-01-17 P...

OSAdmin_0-1629225419470.png QandA.png
OSAdmin by Community Manager
  • 124 Views
  • 0 comments
  • 0 kudos

Question: How do I extract register data to Excel? The register has a lot of text fields and unstructured data that is not suitable for storage in a cube. How can I extract the register data for analysis in Excel, without the data going through a financial cube?

Answer Option 1 – Instead of using the register in specialty solutions, a ‘lighter’ option would be to use the data import staging area, where you can use attribute columns for text. This is set on the cube settings, where you can enable additional a...

OSAdmin_0-1629225944245.png OSAdmin_1-1629225990745.png OSAdmin_2-1629226050246.png QandA.png
OSAdmin by Community Manager
  • 196 Views
  • 0 comments
  • 0 kudos
Top Contributors