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

You 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 (AT) aruba (DOT) it> wrote

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.developersdex.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 (AT) aruba (DOT) it> wrote