Skip to main content
C
Chandu509
Newcomer
February 17, 2025

Data source

  • February 17, 2025
  • 2 replies
  • 0 views

Hi,

Is it possible to map two account dimensions to two different columns in the fields in Datasource

Thanks,

Chandu

2 replies

R
rhankey
Newcomer
February 17, 2025

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.

C
Chandu509Author
Newcomer
February 17, 2025

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.

 

R
rhankey
Newcomer
February 17, 2025

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.

V
victortei
Newcomer
February 17, 2025

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!

    Terms & ConditionsAccessibility statement