Recent Discussions
- pranav4610 months agoContributor II928Views2likes2Comments
What are Literal Value Parameters and how can they be helpful with Reports?
Literal Value Parameters allow the retention and storage of the formatting settings made for row and column headers, subtotal, grand total rows to ensure consistency and ease of maintenance across your report set. Update and get “perfect” the formatting for one report, save the formatting setting script into a literal value parameter and then you can reuse that parameter to drive formatting of all of your other reports! New executive arrives pushing a different color scheme? No problem! Just update the parameter for the new color once and ALL the reports that reference that parameter are automatically updated!TomABC2 years agoContributor II588Views1like0CommentsWhat formats are best for which reports?
Ad hoc spreadsheet reports for individual user analytical “slice and dicing”. Style sheets for Cube View connections into Spreadsheet can allow for expanded formatting options that can be retained for rows, columns or selections of reports and reused. Report View is best for those formal meeting “PDF” view reports.TomABC2 years agoContributor II429Views0likes0CommentsWhat’s best practice for keeping track of reports and underlying rows, columns, and visibility...
What’s best practice for keeping track of reports and underlying rows, columns, and visibility into your application? Using a report inventory (example shown) can be a great way to organize your reporting and also surface opportunities to share column, row templates.TomABC2 years agoContributor II434Views0likes0CommentsDid you know you can get the Excel look and feel out to your end users that LOVE excel?
By presenting Cube Views through Spreadsheet via Forms, you’re able to get that excel look and feel yet still provide security and control around the formatting and POV of your input forms!TomABC2 years agoContributor II516Views0likes0CommentsWhat are some MarketPlace solutions to help assist an Admin?
Please note: This is not a complete list! System Diagnostics (This is a marketplace solution) Administrator Solution Tools Home Page Manager Log Cleaner Business Rule Viewer Member Formula Builder Administrator Solution Tools: TDM Table Data Manager Parcel Service Guided Reporting Train Me Snippet Editor Application Control Manager Data Entry 123TomABC2 years agoContributor II573Views1like0CommentsCan I use different FX rates in my budget compared to actuals? Will I need to keep the data in...
Can I use different FX rates in my budget compared to actuals? Will I need to keep the data in different cubes? You will not need a separate cube just to have different FX rates for different scenarios. On any specific scenario, you can set up an FX rate type which is different from the one set on the cube. You will just need to set the “Use Cube FX rate settings” to False and then select the appropriate FX rate types.Noemi2 years agoNew Contributor III581Views0likes0CommentsHow can I update the relationship properties (such as e.g. percent consolidation) using grid view?
In the grid setting, check the “Display Parent Child Relationship” flag. You can select the relationship properties and set them for each parent-child relationship.Noemi2 years agoNew Contributor III1.1KViews1like2Comments