Tanks for tue answer. What i do not understand is how i should generate the foreign key in a fact table with quarterly grain. Could u help me there?
Thanks!
Olekova
Hello,
I have two fact tables with a different time granularity.
First fact table has the grain month, second has the grain quarterly. Should they use the same time dimension, or should I have a time dimension for each granularity?
If I have a time dimension like this
key year quarter month...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.