Forum Discussion

Chandu509's avatar
Chandu509
New Contributor II
3 months ago

Data source

Hi, Is it possible to map two account dimensions to two different columns in the fields in Datasource Thanks, Chandu
Data Sources
rhankey's avatar
rhankey
Contributor II
3 months ago

You can map zero or more source columns to a given dimension of the Cube/ScenarioType.  A given Cube/ScenarioType cannot have more than one Dimension of any DimType.

  • Chandu509's avatar
    Chandu509
    New Contributor II
    3 months ago

    Thank you

    I created two OneStream account dimensions—one mapped to a static value and the other intended to be mapped to a different source account. However, the second mapping is not saving.

     

    • rhankey's avatar
      rhankey
      Contributor II
      3 months ago

      You might need to provide further details as to what is defined in each of the two Account_Base definitions.  There are instances where I add a Dimension 5 or 6 times to a Data Source to concatenate a combination of one or more source columns and StoredText values to ultimately contain what I want to transform.