Building An Unique Time Dimension.

Hyperion 6.5 User

Hello everyone,

I am facing a problem, I created a time dimension whose grain is month. most of my fact tables use this grain.

For a new fact requiring grain to day. I changed my dimension table. So I increased the number line by the number of days ...

All my data is multiplied by the number of days each month ...

I therefore humbly prostrate myself before you to find documentation on the creation of a time dimension.

I have to make 2 different Time Dimension ? It is the only solution that offers me my consultant...

In this case, users do not know what is the good dimension to use for an indicator...

Thanks,

[Deleted User]

Your dimension is fine. You just have to tie your facts to a different grain.

Hyperion 6.5 User

I can not have the data differently than so be either monthly or daily. It all depends on the indicator ...

how do you do to cohabit fact made with different grains with a single time dimension ?

technically possible? or I am wrong ??

[Deleted User]

Sure. Just look at SampleApp:

It's just a question of logical relation vs physical join. The relation between teh entities is there for both in one go in the logical layer but physically some facts join on the month level and some on the day.

Hyperion 6.5 User

Thanks for your help Christian !!