Office Hours

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: With Specialty Planning, what is the general approach to build same-store sales analysis?

Answer We have customers who have such solutions in place, but the approach will vary on the specific requirements. Source: Office Hours 2020-01-31 Partner Enablement

Question: What is the best way to extract register data, specifically for Specialty Planning solutions? Users would like the option to press a button and download the register information and benefit from the formatting options that can be done with an Excel template.

Answer For the raw data, you can download as a CSV out-of-the box.However, the column order may not be the same as what was used in the Excel upload register template, and of course there is no formatting. Using an Extensibility rule, you could run a...

Question: When importing data into cube from a Specialty Planning solution…The user had to use the Replace (all time) option in order to see the impact of items removed from a register.

Question Answer •The Replace (All Time) option was newly introduced in v5 that was likely affecting the testing as a result of the upgrade. •When utilizing a workflow that imports data to multiple time periods (such as using a forecast scenario using...

OneStream Community

Knowledge Base Articles

Question: If actuals are included in People Planning, how do you limit the periods loaded into the cube when calculating forecasted amounts?

Question: With Specialty Planning, what is the general approach to build same-store sales analysis?

Question: What is the best way to extract register data, specifically for Specialty Planning solutions? Users would like the option to press a button and download the register information and benefit from the formatting options that can be done with an Excel template.

Question: When importing data into cube from a Specialty Planning solution…The user had to use the Replace (all time) option in order to see the impact of items removed from a register.