Hello everyone from Slovenia

I have one question for you guys. I relatively new in OLAP so i think my problem will be nothing for you
I have 2 different dimension TIME and DELIVERY DATE. Both dimensions share the same table TIME in staging database
When I edit the cube and add both dimension, I only see one box with the name of the table TIME. If I join this dimension(s) to fact table and process the cube, the result just isn't right. But if i make a copy of the table TIME in the staging database and then make these two dimensions TIME on the table TIME and DELIVERY DATE on the copy of the table TIME, I see both dimensions(boxes) in cube editor in result is correct.
But in this case I have duplicated tables and I don't like this
Is there any more practical solution

Uros

There are 2 other options - refer to this post from 2002:

http://groups.google.com/groups?q=al...roup:microsoft.
public.sqlserver.olap&hl=en&lr=&ie=UTF-8&oe=UTF-8&group=microsoft.public
..sqlserver.olap&selm=3CE01A42.65B70C03%40dsslab.c om&rnum=3
in SQL.

1) You can put a view on the dimension table (essentially, just a SELECT
* FROM Customer) and change the table for one of the dimensions to use
the view.

2) You can set a table alias for one or both of the dimensions in the
cube editor by right-clicking on the table header in the Schema view and
selecting Change Alias... from the context menu.

In my experience, using the view may sidestep some problems.

HTH

--
George Spofford
Microsoft MVP
Chief Architect / OLAP Solution Provider
DSS Lab

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!