Skip to main content
M
molly_lvc
Contributor
November 10, 2022
Solved

Pre-aggregated Origin Members on a Hybrid Scenario

  • November 10, 2022
  • 1 reply
  • 0 views

I set up a Hybrid Scenario with a Data Binding Type of "Copy Input Data from Source Scenario." I tried following the example in the Design and Reference Guide (below) for the Origin dimension, where the properties are as follows:

     - Member Filters to Exclude: O#Top.DescendantsInclusive

     - Pre-aggregated Members: O#Top=O#Import

 

molly_lvc_0-1668100101071.png

 

When force consolidating, I get data in both O#Import and O#Elimination, but O#Top for my source scenario and hybrid scenario agree. Is there any way to only copy data into O#Import?

As a side note, if I change Pre-aggregated Members to O#Top=O#Elimination, I only get data in O#Elimination.

Thanks!

Molly

 

Best answer by Henning

Hi Molly,

Can you use "Share Data from Source Scenario" instead? With the copy selection, you copy data from one scenario to another and then consolidate the new scenario, which then eliminates all IC data (and possibly custom rules) in the new scenario which is why you see data on O#Elimination I assume.

When you use "Share", the data will dynamically be displayed, without eliminating during a consolidation.

1 reply

H
OneStream Employee
HenningOneStream EmployeeAnswer
OneStream Employee
November 11, 2022

Hi Molly,

Can you use "Share Data from Source Scenario" instead? With the copy selection, you copy data from one scenario to another and then consolidate the new scenario, which then eliminates all IC data (and possibly custom rules) in the new scenario which is why you see data on O#Elimination I assume.

When you use "Share", the data will dynamically be displayed, without eliminating during a consolidation.

    M
    molly_lvcAuthor
    Contributor
    November 11, 2022

    Hi Henning,

    Unfortunately, I cannot use the "Share Data from Source Scenario" function because that is a read-only scenario and we plan to book entries in the new scenario. 

    Thanks for your explanation of the "Copy Input Data from Source Scenario." That makes sense to me and I think it's something we will be okay with.

    Thanks for your help!

    Molly

    Terms & ConditionsAccessibility statement