Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Distribution Percentage Calculated Measure....

0 views
Skip to first unread message

Henry

unread,
Oct 6, 2008, 4:49:16 PM10/6/08
to
Hello,

I have a Product and Customer dimension. They are linked to a Sales
fact table via a product key and a customer key.

I want to make a calculated measure that will find the distribution
percentage of a particular product in a particular store chain. For
example, if a store chain has 10 customers, and only 7 of them are
buying product X, then X has a distribution percentage of 70% in that
chain of stores. Please note that my Sales fact table contains data at
the invoice line level.

Any help would be greatly appreciated.

Thanks
H


Henry

unread,
Oct 9, 2008, 1:33:44 PM10/9/08
to
Any ideas anyone?

Ohjoo Kwon

unread,
Oct 10, 2008, 10:23:56 AM10/10/08
to
1. Create a new fact table for customers by store.
2. Define a measure with Count option using CustomerKey from the fact table.
If a customer can belong to multiple stores, use Distinct Count option.
3. Define a measure with Distinct count option using CustomerKey from your
sales fact table.
4. Define a calculated member using the two measures.

I wish I understood your problems.

Ohjoo

"Henry" <hank7...@yahoo.ca> 님이 다음 메시지를 작성했습니다.
news:6120ebcc-74ba-48d7...@d31g2000hsg.googlegroups.com...

0 new messages