F
F
favbet2016-03-19 00:17:51
OLAP
favbet, 2016-03-19 00:17:51

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

1 answer(s)
F
favbet, 2016-03-19
@favbet

Isn't there an expert in the field here?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question