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
Answer There is a setting under Column Header Format that allows you to hide specific columns. Source: Office Hours 2020-04-23 Partner Enablement
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...
Answer A literal Parameter is application wide and it will keep the selected value. Source: Office Hours 2020-04-23 Partner Enablement
Answer See examples in the attached slides: Source: Office Hours 2020-04-09 Partner Enablement
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
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
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...
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...
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
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 ...
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...
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: ...
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...
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
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...
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...
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...
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...
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...
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