Forum Discussion

kasife's avatar
kasife
Helper V
2 years ago
Solved

Data modeling suggestion

Guys, good afternoon!
All good?
I would like your opinion for a modeling issue, as I did it in a way that is bringing the correct result, but when placing the values in a matrix, the matrix gives an error due to space problems, so I don't know if I did it in the best way. correct.
I have the following model

All dimension tables are related to fact tables. Each fact table represents a stage of my funnel.
I would like to obtain the following result:
- Number of broker per project
- Quantity of broker per period between the beginning and end of the project
I can have one or more brokers for each project and one project for or more for each broker (many to many).
So I combined all the brokers that are in the 4 fact tables and the corresponding projects, creating the _projetos_corretor table.
In a matrix I put the broker, the project and the amount of sales that come from my table fact _repasses (Vendas do Mês Colunm).
When I select the project, it correctly returns the values

But when I remove the filter and it tries to return all projects and brokers the following error occurs

There is not enough memory.
How could I improve my modeling? Is there a better way to do this?




2 Replies