Address Dimension mapping to fact with diffrent grain

View previous topic View next topic Go down

Address Dimension mapping to fact with diffrent grain

Post  gaurav.gsimr@gmail.com on Fri May 30, 2014 1:04 pm

Hi,

Good Morning!

I have Address Dimension with (AddressId, City, State, Zip)

I have two Fact table like
Fact_A with Zip,Measure1,Measeure2
Fact_B with State, Measure1, Measeure2

Can I use Address Dimension on Fact_B. I don't have zip code over there.

Thank You,
Gaurav

gaurav.gsimr@gmail.com

Posts : 2
Join date : 2014-05-30

View user profile

Back to top Go down

Re: Address Dimension mapping to fact with diffrent grain

Post  ngalemmo on Fri May 30, 2014 1:26 pm

No. You can't use address on either fact. Both fact tables are aggregates, if you use address it would no longer be an aggregate, it would need to hold measures by address. If some of those measures are not fully additive by address (such as population and income statistics), you cannot do it at all.

Just store ZIP and State as degenerate dimensions. If you want to store other attributes relating to ZIP and State you need to build ZIP and State level dimension tables.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Address Dimension mapping to fact with diffrent grain

Post  Jeff Smith on Fri May 30, 2014 11:13 pm

I don't like the idea of putting address and Zip/City/Country/State in the same dimension. Data is regularly filtered or aggragated by Zip/City/Country/State. And putting the Address with the Zip can make the dimension HUGE.

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Address Dimension mapping to fact with diffrent grain

Post  gaurav.gsimr@gmail.com on Mon Jun 02, 2014 1:47 am

ngalemmo, you are right, I was just thinking there might be some other method to handle this kind of scenario in SSAS. Might be I am expecting more from SSAS



Jeff Smith, You point is valid but I am having data only for one country and I also defining the attribution relationship in the SSAS which will help us to maintain aggregation.


gaurav.gsimr@gmail.com

Posts : 2
Join date : 2014-05-30

View user profile

Back to top Go down

Re: Address Dimension mapping to fact with diffrent grain

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


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