Non additive and additive measures

View previous topic View next topic Go down

Non additive and additive measures

Post  avantika on 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

View user profile

Back to top Go down

Non additive and additive measures

Post  zoom on 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

View user profile

Back to top Go down

Re: Non additive and additive measures

Post  ngalemmo on 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?
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Non additive and additive measures

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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