Question: How do you hide columns in a column view?
Answer There is a setting under Column Header Format that allows you to hide specific columns. Source: Office Hours 2020-04-23 Partner Enablement
Knowledge Base Articles
Question: When you have a data management job attached to the process button of a workflow, is there a way to have OS finish the data management job before returning control to the end user?
Answer The Data management jobs are kicked off by a DataQualityEventHandler. In the DataQualityEventHandler, there is a line that actually runs the DM job. ExecuteDataMgmtSequence - Runs the DM job and will not return control until it finishes. Sourc...
Is a literal Parameter local to a user or is it global and will it keep the selected value?
Answer A literal Parameter is application wide and it will keep the selected value. Source: Office Hours 2020-04-23 Partner Enablement
Question: Is there any more information on the Getdatabuffer Using Formulas filtered members?
Answer See examples in the attached slides: Source: Office Hours 2020-04-09 Partner Enablement
Question: Is there a way to have a cube view dynamically display only the valid constraint members of the account dimension? The accounts and the cube views are all in the rows.
Answer There is a setting in the cube view that can be turned on that will only display valid intersections. Source: Office Hours 2020-04-09 Partner Enablement
Is there a batch functionality for journals?
Answer There is currently no batch functionality for journals. A workaround is to run a BR that loops through all the journals for a specific time period and post each one. Source: Office Hours 2020-04-09 Partner Enablement
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...
Question: When using QuickViews in the Excel add-in, is it possible to do asynchronous reporting (as possible in the competitor tools)?
Example: Row Definition = A#Sales.Children – this produces 3 children rows Nested Row Member = U1#Product.Children – this produces 5 product rows for each of the 3 Account rows Desired is if for the 3rd account row, 3 products are removed from displa...
Question: When working with business rules, as the buttons of “Save” and “Undo” are placed next to each other, it sometimes happens that you hit “Undo” instead of “Save”. Is there an option (e.g. Shortcut) to “Redo” the action and get back the script deleted by “Undo”?
Answer No, not at this time. Enhancement Status: We have had requests for a “Redo” function to be added to CVs and in Excel, but do not see any such request for the BR editor. Source: Office Hours 2020-03-26 Partner Enablement
Question: Is there an option to clear non-calculated data in a “bulk” (as known from hs.clear) other than looping through the data buffer and use “SetDataCell” (which has a higher performance impact)? The “ClearCalculatedData“ is not impacting input/imported data – right?
Answer Non-calculated data can be cleared outside of rules From Workflow: From Data Management Jobs: However, there is no equivalent of hs.clear to clear non-calculated data within OneStream (by design…because it “breaks” the audit trail inherent in ...
Question: In Advanced Chart component of a Dashboard, can you show how to add a secondary axis?
Answer If you are using the Advanced Chart component, a Dashboard Data Set Business rule must be used (example rule below) Ensure the following settings on the Advanced Chart component are correct: Please note: This can be achieved in BI Viewer by ad...
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: ...
Can I set Application wide defaults for Formatting Cube Views in Excel?
Answer No, the Application Properties (found on the Applications Tab in OneStream), contain settings for 'Standard Reports' but these only apply to the Data Explorer and cannot be set for Excel or Report mode. It is recommended to created standard Ex...
Question: Is there a way to have multiple instances/installations of a single MarketPlace solution?
Answer Yes…you can use the “Solution Copy” feature within the “MarketPlace Solution Tools” solution, which is available for download on the MarketPlace: Source: Office Hours 2020-03-12 Partner Enablement
Question: With Analytic Blend, is there a way to get data into the cube?
Answer For loading Analytical Blend, this is purposely stored separately outside of the cube, as it is optimized for high-volume transactional data.Loading Analytic Blend data into the cube normally defeats the purpose.However… More specifically: Can...
Are there any security reports that show to auditors an overview what has changed, for example changes to rules?
Answer There is a Security Audit Report that covers most changes.Even if there is not a standard report that you need, everything is audited in the database. For other items, go to System/Database, all the tables beginning with “Audit” contains all t...
Question: Can you please provide guidance as to the best way to handle entities with different calendar and fiscal years? Main company is Aug fiscal year close. A few legal entities are March close. One is December close.
Answer Answer: Configuration touchpoints:EntityTime ProfilesScenariosFX RatesCubesData Integration – moving data between cubes Case Study A Two completely separate organizations: Retail/Commercial organization – “Business” FEBRUARY year-end Charitabl...
Question: Is it possible to run an automated consolidation task every hour using only the task manager to set everything up (i.e., without business rules/windows scheduler/PowerShell)? And, if it is possible, what are the steps to get there?
Answer No…Task Manager can be used to launch tasks, but is not there for automation of tasks. Automation, as posed in the question, would still need to be done using PowerShell, or other job automation mechanisms. Underlying purpose of Task Manager i...
Question: If actuals are included in People Planning, how do you limit the periods loaded into the cube when calculating forecasted amounts?
Answer Transformation rules can be set-up to map the time range period in order to load only applicable periods. Use a global variable in allocation methods to allow dynamic period selection for loading. Source: Office Hours 2020-02-13 Partner Enable...
Question: Is there a way to setup an account for DSO using the standard OS functionality and view the results using different trailing views?
Answer No, you would need to create a custom DSO calculation (example overleaf, based on Design & Reference Guide, pages 34-35). Source: Office Hours 2020-01-31 Partner Enablement
