Forum Discussion

Chandu509's avatar
Chandu509
New Contributor II
21 days 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
  • victortei's avatar
    victortei
    New Contributor III
    20 days ago

    Hi Chandu509, could you provide an example of what you're trying to achieve?

    For instance, if your source file has this record:
    Account123, Dept123, ProductABC, 1000

    What should the system do with it?
    a) Map Account123 to accounts 100001 and 100002?
    b) Map Account123 to specific accounts based on the department, for example?

    This will help us provide more accurate guidance.

    Thanks!

  • rhankey's avatar
    rhankey
    Contributor
    21 days 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
      21 days 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
        21 days 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.