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

Non additive and additive measures

3 posters

Go down

Non additive and additive measures Empty Non additive and additive measures

Post  avantika Sun Jul 19, 2015 10:06 pm

Hi,
I have a question, I designed a fact table which contains both additive and non additive measures in base table. Can we design a fact like that. I found that when we group the data from this fact the data is correct. However there is a requirement to summarize the data in a summary table, From this summary table data is again grouped. I found that the queries with different groupings on base table gives correct results.However grouping on already summarised data gives anomalies. The ETL team has told that the issue is with the design. I want to confirm that there is no issue with the design.

avantika

Posts : 1
Join date : 2015-07-19

Back to top Go down

Non additive and additive measures Empty Non additive and additive measures

Post  zoom Mon Jul 20, 2015 7:04 am

It sounds like dimensions in the Fact summary table are defined or loaded by ETL incorrectly. An easy way to find out to ask the question what is the grain of that summary fact table... in other words how does a single row represent in the Fact table. A Fact table with different grain would NOT produce correct result.
Try comparing base table's data to summary data to find out where are the differences.

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

Back to top Go down

Non additive and additive measures Empty Re: Non additive and additive measures

Post  ngalemmo Mon Jul 20, 2015 9:00 am

It would help if you explained the design.

Generally you want to avoid semi/non-additive measures. What are these measures? Can they be expressed in another way to make them more useable?
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Non additive and additive measures Empty Re: Non additive and additive measures

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