December 2, 2002 at 5:00 am
Hello,
I have 2 dimensions from the same dimension table but with different levels. I have a filter in one of the dimensions. But this filter filters the data in the fact table when processing. How can I override this? I want to get all the data based on the other dimension. At the same time I need the dimension with filter as well. Any ideas, please reply ASAP.
Thanks in Advance,
Anbu
December 3, 2002 at 10:15 pm
Create 2 seprate Cubes with 2 dimensions and then Create Virtual Cube to Combined the result.
I think it should work.
December 5, 2002 at 11:06 am
Anbu -
A couple of potential solutions come to mind:
First, are these dimensions really alternate hierarchies? IE: are they essentially the same with some lower levels of detail not contained in one of the dims? If so, load all the data (to the lowest level of granularity) then create an alternate hierarchy dim with the lowest levels disabled.
Alternatively, use two views of the data to support the seperate dims. Process dims using these views. You'll need to accomodate this in the fact table (a view might work well here also) so that a column exists for each dim join.
I hope this helps.
Scot J Reagin
Scot J Reagin
sreagin@hitachiconsulting.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply