Recent Discussions
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 to Use this Training Course Forum
This is an online discussion forum for trainees completing the OneStream Essentials: Building Basic Reports to ask questions and engage with other trainees and OneStream instructors. Here are some guidelines and general information about the forum: The scope of this forum is questions on course content and labs (similar to questions you might ask in a classroom setting) For general OneStream product technical questions or product discussions, please post within our OneCommunity forums Please do not use this area to request answers to course assessment questions Share screenshots and provide detailed information to increase the odds of a helpful response If you posted here by accident and need to remove a post, use the post options and “report as inappropriate content”, provide a reason and our moderation team will handle this Note that this forum is monitored by OneStream instructors aiming to reply within 1-3 business days, but a specific response time is not guaranteed.agoralewski2 years agoCommunity Manager774Views0likes0CommentsWhat are the differences between the two bypass types?
What are the differences between the two bypass types? Contains at Position This switch will tell the Data Source to skip an entire line of a file if the Bypass Value is found at the specified location in the Position Settings section. Contains Within Line This switch will tell the Data Source to skip an entire line of a file if the Bypass Value is found anywhere on the line.plaabs252 years agoNew Contributor III869Views0likes0Comments