The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
Hybrid Source Scenarios - Additional Documentation / Details
One of the new features in the 6.6 release is the introduction of Hybrid Source Scenarios. I've watched the 6.6 release and read through the abbreviated examples in the admin guide. Both have good h...
Hello - I am going to ask that more documentation around the Options are added to the documentation. Below is more detail on the Options:
- ExecuteCopyDuringCalc - this is a True/False setting and by default it is set to True. This would only be used with the 2 Copy binding types and not the Share binding type. Having this setting as True indicates that the copy will execute during the Data Unit Calculation Sequence (DUCS). Or in other words, anytime you calculate a Data Unit the copy will execute. Making this setting False, you would need to use a Data Management Job to execute the Hybrid Source Data Copy. On a DM Step, there is a new setting called "Execute Scenario Hybrid Source Data Copy". You would make this True and then the Calculation defined on this step would use the settings from the Hybrid Source Data properties to run the Copy. This would NOT run during the DUCS and be a "point in time" calculation. Use cases for this may be versioning or seeding where constant copying of the same numbers would be unnecessary overhead on every calculation.
- CopyAsDurableData - this is a True/False setting and by default it is set to False. This would only be used with the 2 Copy binding types and not the Share binding type. By default, copied data is stored as calculated. Set this to true to flag this data as durable. Calculated data is cleared by OS at the beginning of the DUCS (if the scenario setting is set to True) and will re-calculate. Durable data is NOT cleared by OS at the beginning of the DUCS and must be cleared via a rule. These 2 settings go hand in hand. Likely, if you have ExecuteCopyDuringCalc as True, CopyAsDurableData would be False. And vice versa.
- RemoveZeros - this will remove zeros for the copied data. This is only if all periods of the intersection being copied are 0.
- SourceTimePeriodForYearlyResult - this is used when the Input Frequency of the target scenario is Yearly and the source scenario is an Input Frequency that is more granular. It is used for performance reasons to only share or copy one time period to the target scenario which limits the Data Unit size and will improve calculation and/or query performance.
- SourceViewForYearlyResult - use in conjunction with the setting above, this can either be Period/YTD. For the time period being copied/shared you can choose whether you want to copy/share the Periodic or YTD value.
- ExecuteCopyDuringCalc - this is a True/False setting and by default it is set to True. This would only be used with the 2 Copy binding types and not the Share binding type. Having this setting as True indicates that the copy will execute during the Data Unit Calculation Sequence (DUCS). Or in other words, anytime you calculate a Data Unit the copy will execute. Making this setting False, you would need to use a Data Management Job to execute the Hybrid Source Data Copy. On a DM Step, there is a new setting called "Execute Scenario Hybrid Source Data Copy". You would make this True and then the Calculation defined on this step would use the settings from the Hybrid Source Data properties to run the Copy. This would NOT run during the DUCS and be a "point in time" calculation. Use cases for this may be versioning or seeding where constant copying of the same numbers would be unnecessary overhead on every calculation.
EricOsmanski
OneStream Employee
OneStream EmployeeHello - I am going to ask that more documentation around the Options are added to the documentation. Below is more detail on the Options:
- ExecuteCopyDuringCalc - this is a True/False setting and by default it is set to True. This would only be used with the 2 Copy binding types and not the Share binding type. Having this setting as True indicates that the copy will execute during the Data Unit Calculation Sequence (DUCS). Or in other words, anytime you calculate a Data Unit the copy will execute. Making this setting False, you would need to use a Data Management Job to execute the Hybrid Source Data Copy. On a DM Step, there is a new setting called "Execute Scenario Hybrid Source Data Copy". You would make this True and then the Calculation defined on this step would use the settings from the Hybrid Source Data properties to run the Copy. This would NOT run during the DUCS and be a "point in time" calculation. Use cases for this may be versioning or seeding where constant copying of the same numbers would be unnecessary overhead on every calculation.
- CopyAsDurableData - this is a True/False setting and by default it is set to False. This would only be used with the 2 Copy binding types and not the Share binding type. By default, copied data is stored as calculated. Set this to true to flag this data as durable. Calculated data is cleared by OS at the beginning of the DUCS (if the scenario setting is set to True) and will re-calculate. Durable data is NOT cleared by OS at the beginning of the DUCS and must be cleared via a rule. These 2 settings go hand in hand. Likely, if you have ExecuteCopyDuringCalc as True, CopyAsDurableData would be False. And vice versa.
- RemoveZeros - this will remove zeros for the copied data. This is only if all periods of the intersection being copied are 0.
- SourceTimePeriodForYearlyResult - this is used when the Input Frequency of the target scenario is Yearly and the source scenario is an Input Frequency that is more granular. It is used for performance reasons to only share or copy one time period to the target scenario which limits the Data Unit size and will improve calculation and/or query performance.
- SourceViewForYearlyResult - use in conjunction with the setting above, this can either be Period/YTD. For the time period being copied/shared you can choose whether you want to copy/share the Periodic or YTD value.
Does the Copy Input Data from Source Scenario option copy all data cell storage types or just input?
- EricOsmanski
It will copy all storage types.
Hi Eric, when you say that it will copy all storage types, you mean that it will copy them all but when it pastes or writes to the target scenario as calculation or durable calculation right? There is not a way to have it copy the input data as input data, the calculated data as calculated and the durable calculated data as durable calculated to the target scenario right?
Thx,
Mike
- EricOsmanski
That's correct Mike.
