Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Dimensional Model with different granularity to Cube

2 posters

Go down

Dimensional Model with different granularity to Cube Empty Dimensional Model with different granularity to Cube

Post  richardbadge Tue Feb 09, 2016 10:50 am

Apologies if I have the terminology wrong and don't explain things very well, as I am relatively new to this and am getting confused on a design decision and just wanted some advice.

I work in the business but am working with the IT department on a design of a dimensional model and cube for a Cost value system we have. The commercial team submit a single Cost value report each month per project and this is saved in an operational database, there are loads of fields stored for all the different costs, revenue, cash at levels like labour, plant, material. I was going to have a fact table with the granularity of a single row per form submitted per month with dimensions for the month and the project, the fact table would then have different columns for every single field on the CVR and to me this made sense.

However, when speaking to people in the business they have said that when presenting this in a cube, the user will have loads of measures to select and will get very confusing on what to use and they have suggested adding additional groupings in the cube to group certain costs and value together, which to be honest makes sense as well.

What I would like to know is can you still have a dimensional model with the single fact row per CVR with all the fields and then when creating the cube put in the additional logic to add the dimension in for the further analysis at the cube level?

The reason I want to keep the dimension model at the single row per CVR as there are metrics that do not easily fit into the additional dimensions in the cube and I want to keep all of the information.

I hope this is clear.

richardbadge

Posts : 2
Join date : 2016-02-09

Back to top Go down

Dimensional Model with different granularity to Cube Empty Re: Dimensional Model with different granularity to Cube

Post  ngalemmo Tue Feb 09, 2016 1:18 pm

Yes, you can aggregate data before loading into a cube. A view is probably the easiest way to handle it.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Dimensional Model with different granularity to Cube Empty Re: Dimensional Model with different granularity to Cube

Post  richardbadge Wed Feb 10, 2016 1:57 pm

Many thanks, I have a meeting with the designers on Friday, so will discuss this with them.

richardbadge

Posts : 2
Join date : 2016-02-09

Back to top Go down

Dimensional Model with different granularity to Cube Empty Re: Dimensional Model with different granularity to Cube

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum