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.

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.

Can AS-Actions be used in RS 2005?

Hello,
we defined a drillthrough action in AS to display some detail-information:
If we browse a cube inside Management Studio and do a right click on a
corresponding value, the defined action shows up in the context menu, so we
can display a list with the details. Now we want to have the same thing
inside reporting services: Just click on a value and show the corresponding
details. Is it possible to use the "resultset" of the AS-Action inside a
report? Where can we find detailed information on how to do that?
Regards,
R. Watermannshort answer: no
in RS you have to create your own navigation which is independent from the
cube definition.
RS is a reporting tool not a data navigation tool (like OWC proclarity
etc...).
maybe using some code you can retrieve these actions, but by default RS
can't do this.
"Ralph Watermann" <We.Want@.NoSpam.de> wrote in message
news:OIaULjrGGHA.3624@.TK2MSFTNGP09.phx.gbl...
> Hello,
> we defined a drillthrough action in AS to display some detail-information:
> If we browse a cube inside Management Studio and do a right click on a
> corresponding value, the defined action shows up in the context menu, so
> we can display a list with the details. Now we want to have the same thing
> inside reporting services: Just click on a value and show the
> corresponding details. Is it possible to use the "resultset" of the
> AS-Action inside a report? Where can we find detailed information on how
> to do that?
> Regards,
> R. Watermann
>