comparing facts with different granularity

Hi,
I have a sale fact connected to a few dimensions like time(month),
product, customer, area.
I have also a budget fact connected to time(year), customer_group.
Customer_group is an itermediate level in customer hierarchy (Sector,
Segment, Customer_Group, Customer).
I was thinking of building a virtual cube, but I don't know how to
connect the two facts at differents level dimensions in dimensions
time and customer.
Can anybody help me?
Thank you
Roberto BottoYou can solve this through disabled property.
First of all, you normalize the time dimension table according to the sale
and budget fact tables.
In your budegt cube, set the disabled property of the levels, below year
level of time dimension, to Yes.
Do the same steps for customer dimension.
Create a virtual cube based on sale and budget cubes.
Ohjoo Kwon
"Roberto Botto" <orion48@.aruba.it> wrote in message
news:a6c31b2d.0503240516.2342ee7@.posting.google.com...
> Hi,
> I have a sale fact connected to a few dimensions like time(month),
> product, customer, area.
> I have also a budget fact connected to time(year), customer_group.
> Customer_group is an itermediate level in customer hierarchy (Sector,
> Segment, Customer_Group, Customer).
> I was thinking of building a virtual cube, but I don't know how to
> connect the two facts at differents level dimensions in dimensions
> time and customer.
> Can anybody help me?
> Thank you
> Roberto Botto|||Thank you for the suggestion, but I can't make it work.
The problem is in the join between the customer dimension and the budget
fact.
The budget fact foreign key is not the customer, which is primay key in
the customer dimension, but an higher level code (the customer group).
Hence the join between the fact budget and the customer dimension,
through the customer group, multiplies the the budget records. This is
my problem, not just hiding the lower dimension levels.
Thank you
Roberto Botto
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!|||Why don't you normalize the customer dimension table according to the sales
and budget fact tables.
For example, Customer_Group(Sector, Segment, Customer_Group) and
Customer(Customer).
Ohjoo
"Roberto Botto" <orion48@.aruba.it> wrote in message
news:O$XMioRMFHA.580@.TK2MSFTNGP15.phx.gbl...
> Thank you for the suggestion, but I can't make it work.
> The problem is in the join between the customer dimension and the budget
> fact.
> The budget fact foreign key is not the customer, which is primay key in
> the customer dimension, but an higher level code (the customer group).
> Hence the join between the fact budget and the customer dimension,
> through the customer group, multiplies the the budget records. This is
> my problem, not just hiding the lower dimension levels.
> Thank you
>
> Roberto Botto
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!sqlsql