Answer the question
In order to leave comments, you need to log in
How to properly organize the cube structure?
Help me understand how to properly organize the structure of the cube.
There is a fact table with daily data on orders and sales of dairy products (detailed to the level of packages). I fasten reference books to it (calendar, geographical location, clients, shops). But in my fact table I also need to put such indicators as the number of installed Refrigerators, shelves, extra places - here the lower level = this is a store, and there is packaging. Is it possible to combine these two measures into 1 cube?
I can't imagine how to do it...
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question