Hi,
I am very new to TM1 and am not able to understand how measure is treated as a dimension.
Say for example i have product dimension , time dimension and the measures are Number of units sold,Amount in $ sold
How will the cube dimension be?
In case, I have got the basics wrong please correct me.
Thanks
Saj Suresh
_Internally_, TM1 has no concept of a measures dimension, however the Cognos reporting tools think of OLAP data in quasi-relational terms and require a dimension to be marked as the measures dimension (via Cube Properties). In the case you cite you have already specified units and $ sold - these would become the elements of your measure dimension.
You'd just have another dimension (probably called 'Measures') which contains these elements
Number of units sold
Amount
When you load the data into the cube, you specify every single dimension element (including the measure dimension element) and load it in.
So your source data would be something like this:
Product1,Time1,Number of Units,10
Product2,Time1,Number of Units,13
Product3,Time1,Number of Units,14
Product4,Time1,Number of Units,14
Product1,Time1,Amount,100
Product2,Time1,Amount,100
Product3,Time1,Amount,100