I think my case is very common so I'm hoping some experts out there
can help.

I have a big transaction table with among others "account",
"department" and "transaction description" columns. AccountID
and DepartmentID link to each their dimension but "description"
column does not.
All I want is to drill through to this "transaction description"
text. BUT HOW???
(This was easy in AS2000)



I have read about some alternatives but I'm not sure they are the
best for me.
1. create a new "description" dimension based on the same table as
fact data. Make this new dimension a "Fact dimension" and link it
to measure group. "Description" column then becomes key of this
dim. I suspect this dimension gets very big.

2. create a measure on this "description" column but as2005 will
not allow text/character measures.

3. create a new dim with ID and Description. Create an empty measure.
And then make a calculated measure pointing to description. Not sure on
this one, how it was.

Still, funny how this classic drill through case does not have an
abvious solution in AS2005. Or has it?