Create Measure Dimension

[Rosanero4Ever]

Hi all,

I'm a newbie and, for exercise, I'd like create a simple cube based on only two dimension: time and measure.
I just created time dimension but I have some difficulties to create measure dimension as reguard as the contents of variables.
I import data from a SQL server database using ODBC connection.
Following data warehouse design guide lines, measure table have a FK to time dimesion so it is made up by a date column and other measure column (as suggested by a common star schema).
So, can you advice me any link that can help me to undestand how can implement what I wrote above?
Thank you very much for your help

ps
I'm waiting to receive the book "IBM Cognos TM1 Official Guide" and I hardly hope it will help me to undestand the TM1 phylosophy

[Wim Gielis]

Hi there

You need to think about what you want to store in the cube, by time element (the other dimension(s) in the cube).

For example, quantities sold on a day, then you need a measure 'Quantity sold'. You can define the name of that element in the Measures dimension the way you like.
Or if you want to trace Hours worked, then choose a measure like that. Or in a P&L cube with an account schedule, your measures might be called 'Value' and 'Value (000)' for simplicity. You have all freedom in principle.

No keys needed. Obviously, you will need to map your source data (SQL server table or view) towards your time elements and measures.

Wim

[Rosanero4Ever]

Hi Wim,

thanks for your reply.
So, If I well understand (I'm trying this solution in this moment), before I must create the measure dimension inserting elements that represent my measures.
After I create a process to mapping the data in the previous dimension in order to load data.
Is this correct?
I perform what I wrote, as you can see in the attached picture, but measure value are zeros.
I used the "recalculation" function but values are still zeros.
What's wrong?
Thanks!

8.jpg (102.29 KiB) Viewed 6318 times

[AmbPin]

Hello,
How have you created you time dimension? Your picture shows consolidated time elements, do you see values when you expand the time hierarchy? Did you give elements in the time hierarchy a weighting to make them consolidate?
Hopefully the scenario below might explain.

Capture.PNG (43.38 KiB) Viewed 6312 times

[Rosanero4Ever]

Hi,

Time dimension has a hierarchy structure and weigth are equal to 1 (if you want you can see my time dimesion here http://www.tm1forum.com/viewtopic.php?f=3&t=8123)
I'm thinking the cause of the problem is due to the cube action of the process. I must update the cube to load data, isn't it?
I will try and I'll write the result
Thanks!

[Rosanero4Ever]

Right! I must update or create a cube to see the measures values
Thanks for your help

[Wim Gielis]

I'm thinking the cause of the problem is due to the cube action of the process. I must update the cube to load data, isn't it?

Sure, you must execute your Turbo Integrator process to load the data into the cube.
If not, values in the cube will be 0.

[AmbPin]

Or you could expand all of the hierchies and type a value in to see if you then get a consolidated value when you refresh/recalc