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

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 Valued Contributor
  • 472 Views
  • 0 comments
  • 0 kudos

Is there an equivalent to XFSetCell for member properties (i.e., XFSetMemberProperty)? I don’t see this as an option but there are a few XFSet formulas, but I am not sure if they would work for this.

Answer No, there is not Excel Add-In function for setting member properties. Metadata changes are captured (i.e., XML file loads, manual record updates, grid view bulk updates) so that audit trails can be maintained. Extracting the metadata XML and m...

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