Hello guys,
I am new to TM1 and am doing an Income Statement job.
In I'm stuck on a doubt, my dimension has values similar to SO_1478524789, GE_8524587482, however, my data source has the data 1478524789, 8524587482.
How do I import the data by matching the data of the variable containing the 1478524789 with the Leaf Level that contains SO_1478524789?
Dimension:
Data Source:
Instead SUBST
-
- Posts: 5
- Joined: Wed Jan 23, 2019 6:37 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Instead SUBST
Luc Batis
São Paulo, BR
São Paulo, BR
- PavoGa
- MVP
- Posts: 617
- Joined: Thu Apr 18, 2013 6:59 pm
- OLAP Product: TM1
- Version: 10.2.2 FP7, PA2.0.9.1
- Excel Version: 2013 PAW
- Location: Charleston, Tennessee
Re: Instead SUBST
It appears the leaf level "1478524789" is a unique identifier and assume the prefix is a categorization such as business unit/etc. If true, I would have actually used the "1478524789" as the primary element name with the prefix as an attribute and have a alias that combines the two into the desired display element. But instead you can just add the "1478524789" as an alias to the dimension and that should allow you to load the source file without a problem.
If that is not unique and it takes some other value in the source file to determine the final account, will need a slightly different solution using an alias or mapping cube.
If that is not unique and it takes some other value in the source file to determine the final account, will need a slightly different solution using an alias or mapping cube.
Ty
Cleveland, TN
Cleveland, TN