cancel
Showing results for 
Search instead for 
Did you mean: 
Office Hours
Questions and Answers from real consultants

Knowledge Base Articles

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
  • 111 Views
  • 0 comments
  • 0 kudos
OSAdmin by Community Manager
  • 321 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
  • 159 Views
  • 0 comments
  • 0 kudos

Question: What is the best way to extract register data, specifically for Specialty Planning solutions? Users would like the option to press a button and download the register information and benefit from the formatting options that can be done with an Excel template.

Answer For the raw data, you can download as a CSV out-of-the box.However, the column order may not be the same as what was used in the Excel upload register template, and of course there is no formatting. Using an Extensibility rule, you could run a...

QandA.png
OSAdmin by Community Manager
  • 57 Views
  • 0 comments
  • 0 kudos

Question: What’s the method to override the aggregation of a parent UD member when it is desired to have the UD parent be a calculation and not an aggregation.

Answer It is not possible to override the aggregation and store a different value in a parent because UD parents are not stored members. The only way to accomplish this is make the parent member a dynamic calculated member and define the calculation ...

QandA.png
OSAdmin by Community Manager
  • 58 Views
  • 0 comments
  • 0 kudos
Top Contributors