Hi,
I am new to the TM1 environment and doing a prototype for the demo. I have created a few dimension including the measure dimension.
I am able to load from the .csv file into all the dimension, but my problem is how to load into the measure dimension. I have created the level as Balance, Net Margin etc.
These columns are present in the source file and when I am trying to import into the measure dimension these are automatically considered as dimension and there is no option of making them as measure.
Can anyone let me know the the steps to do that.
Thanks
Satya
Load into Measure Dimension using CSV
-
- Posts: 1
- Joined: Wed Nov 07, 2012 3:54 pm
- OLAP Product: TM1, PowerPlay
- Version: 10.1.1
- Excel Version: Excel 2010
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Load into Measure Dimension using CSV
Automatically???? I think not. You would have had to tell the TI they are dimensions. Go to the Variables tab and look at the Contents column. Does it say Dimension for the data file columns you are talking about? Change it to Data (using the drop-down) and that should do the trick.Satyabrata wrote:These columns are present in the source file and when I am trying to import into the measure dimension these are automatically considered as dimension and there is no option of making them as measure.