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

Address Dimension mapping to fact with diffrent grain

3 posters

Go down

Address Dimension mapping to fact with diffrent grain Empty Address Dimension mapping to fact with diffrent grain

Post  gaurav.gsimr@gmail.com 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

Back to top Go down

Address Dimension mapping to fact with diffrent grain Empty Re: Address Dimension mapping to fact with diffrent grain

Post  ngalemmo 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.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Address Dimension mapping to fact with diffrent grain Empty Re: Address Dimension mapping to fact with diffrent grain

Post  Jeff Smith 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

Back to top Go down

Address Dimension mapping to fact with diffrent grain Empty Re: Address Dimension mapping to fact with diffrent grain

Post  gaurav.gsimr@gmail.com 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

Back to top Go down

Address Dimension mapping to fact with diffrent grain Empty Re: Address Dimension mapping to fact with diffrent grain

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