drill through

#1

I migrated AS2000 cube to SSAS 2005. In my 2000 version, Drill Through
option i enabled some of the columns in fact table (that is not part of
measure or dimension). When I try to todo same in 2005, it shows only
dimension and measures. Is there any way to display columns in fact table in
drill through.

thanks
kalyan

#2

add a new neasuregroup in your cube and use measures from this group for the
drill.

create no aggregations, setup this measuregroup to ROLAP and set the
measures with the "no aggregation" option (instead of sum of something else)
there is no local storage and no processing time required for this measure
group.

"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote

Quote:

I migrated AS2000 cube to SSAS 2005. In my 2000 version, Drill Through
option i enabled some of the columns in fact table (that is not part of
measure or dimension). When I try to todo same in 2005, it shows only
dimension and measures. Is there any way to display columns in fact table
in
drill through.

thanks
kalyan

#3

you MUST link your detailed fact table to your dimensions, like any other
fact table.

"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote

Quote:

Thanks JeJe,

I was little busy with otherstuff, as per your suggestion, here is what i
did,

I have 5 columns (that's not related with dimension or measure) i put it
one
table, i included that table in my dataview i have common column i related
this column to fact table then created measure group, it show error msg.
No
dimension relationship exisit, can you explain in more details

thanks
kalyan

"Jeje" wrote:

add a new neasuregroup in your cube and use measures from this group for
the
drill.

create no aggregations, setup this measuregroup to ROLAP and set the
measures with the "no aggregation" option (instead of sum of something
else)
there is no local storage and no processing time required for this
measure
group.

"Kalyan" <Kalyan (AT) discussions (DOT) microsoft.com> wrote in message
news:FF0A1308-79AB-46FD-AC3C-E30D092A479E (AT) microsoft (DOT) com...
I migrated AS2000 cube to SSAS 2005. In my 2000 version, Drill Through
option i enabled some of the columns in fact table (that is not part of
measure or dimension). When I try to todo same in 2005, it shows only
dimension and measures. Is there any way to display columns in fact
table
in
drill through.

thanks
kalyan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

drill through

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

drill through - 12-26-2006 , 07:03 PM

Re: drill through - 12-26-2006 , 07:45 PM

Re: drill through - 12-27-2006 , 05:19 PM