team;

how do you have multiple dimensions based off of the same data without
having seperate dimension tables?

i have 2 date fields on my fact table, and i can't figure out how to let
them work seperately from one another.

aaron

You can create two dimensions based on the same table.
You can then add the two dimensions to the Cube in Cube Editor.
You will probably have to create the fact table - dimensions joins manually.
In the cube schema you will notice that the base table appers once with its
physical name and a second time with an alias.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html


"aaron_kempf (AT) hotmail (DOT) com" wrote:

FYI: an issue that I encountered recently, when using a single table for
2 dimensions of a cube - the Analysis Server incorrectly interpreted the
alias as the same table instance, when generating the drill-through SQL
query. Thus the cube aggregated correctly, but drill-through returned no
rows when specific members of either dimension were selected. The
work-around was to use a view for the second dimension, returning data
identical to the original table.


- Deepak

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

You can use properties to create different levels and
then create virtual dimensions based on those properties.

Abhinav kumar
akumar (AT) itmag (DOT) com.au
www.itmag.com.au

I dont understand how I am supposed to join the same table to the fact table
twice.

I dont see the table aliased twice.

here is a lil more info
So I have a fact table:

FACT

it has 2 fields

DateStarted
and
DateModified.

So i can make one date dimension-- but then I need to make 2 joins in this
schema-- one from Date.Date to Fact.DateStarted and one from Date.Date to
Fact.DateModified.

I previously had 2 views for this, one view called DateStarted and one
called DateModified

And I had 2 seperate joins referencing both views.

It just seems like I should be able to do this more efficiently.


Thanks SOOOOOOO much for your help guys

aaron





"Brian Altmann" <findme@thesignaturewebsite> wrote