Can fact table include fields that are neither dimension nor measurements?

I am new to Dimensional Modeling in SSAS!

Can fact table include fields that are neither dimension nor measurements?

I need this for a drillthrough Action that shows data other than the dimensions or the measurements!

Please help!

Aref

The answer is NO.

You cannot drill through into something that is not part of your model ( ether dimension or measure group measure)

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

So, there are something columns (like some detail information or description) in the fact table. And these columns must show in drill through action.

The fact table must become as a dimension?

|||

Take a look at the dimension with type Fact.

Looks like in your case you should be looking at creating new dimension with type Fact and adding the columns you would like to see in the drillthrough to this dimension as attributes.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.