Does Drill Through work fine in AS2005?

Hi,

I had designed several cube in AS2005. And I counfused by some problem of drill through.

1. The large amount of dimensions makes drill through broken?

Drill Through works fine in the cube that includes 20 dimensions. But, In the same cube, the amount of dimensions is increase to 25. The drill through works no response...

2. In some case, the drill through do not response correct row data.

A MDX syntax that response measure is 8 (In my project, that means there would be 8 row data in the fact table.).
And I use the same mdx syntax to drill through, that only response 1 row data!

Any idea? or it's the bug?

thanks,

Drillthrough is certainly very different in AS 2005 compared to AS 2000.

It returns you the rows at the deepest granularity of the measure group. If the rows in the measure group are for the same cell coordinate, then they will aggregate up to a value of 8 in 1 row.

If you need to see all 8 rows, then you should define a degenerate dimension (could also be ROLAP) which is at that deepest granularity -- e.g. at TransactionID. You can hide this dimension so normal cube browsing operations will not see this deepest granularity.

When you define the default drillthrough action for the cube you can specify this granularity attribute in the RETURN clause and fetch the data for the 8 unique rows.

Its difficult to say what may cause the different behavior when you move from 20 dimensions to 25. Perhaps looking at profiler would help to see what is happening. Also, you need to make sure that drillthrough is being done on a reasonable size of dataset -- drilling through on a cell that has millions of fact rows will perform very badly.

HTH,

Akshai

Document Maps

What do I need to do to eliminate the document maps (Drill downs showing on
Left side of the report). I do not remember adding and have checked the
NAVIGATION properties of all the matrices in my report.
ThanksCheck the Label properties in your report. (They may be buried, so a search
through your code may be necessary.)
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Asim" <Asim@.discussions.microsoft.com> wrote in message
news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
> What do I need to do to eliminate the document maps (Drill downs showing
> on
> Left side of the report). I do not remember adding and have checked the
> NAVIGATION properties of all the matrices in my report.
> Thanks
>|||By searching through code, I mean using "View Code" in Visual Studio, or
opening the RDL file directly with a text editor.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
news:OnRZUGS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
> Check the Label properties in your report. (They may be buried, so a
> search through your code may be necessary.)
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Asim" <Asim@.discussions.microsoft.com> wrote in message
> news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
>> What do I need to do to eliminate the document maps (Drill downs showing
>> on
>> Left side of the report). I do not remember adding and have checked the
>> NAVIGATION properties of all the matrices in my report.
>> Thanks
>|||Thanks Jeff - I has a similar problem recently when I needed to add a group
to a table. Suddenly I had document maps and couldnt find anywhere that I had
entered labels for them. For clarification - there are many references in
these threads to viewing/editing code (the RDL). That cant be done directly
in reporting services so how do I do that? Being new to RS I guess I dont
quite understand how to use the RDL. If someone submits RDL there is
supposedly a way to "import" it to create a report?
"Jeff A. Stucker" wrote:
> By searching through code, I mean using "View Code" in Visual Studio, or
> opening the RDL file directly with a text editor.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> news:OnRZUGS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
> > Check the Label properties in your report. (They may be buried, so a
> > search through your code may be necessary.)
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "Asim" <Asim@.discussions.microsoft.com> wrote in message
> > news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
> >> What do I need to do to eliminate the document maps (Drill downs showing
> >> on
> >> Left side of the report). I do not remember adding and have checked the
> >> NAVIGATION properties of all the matrices in my report.
> >> Thanks
> >>
> >
> >
>
>|||In Visual Studio, you can right-click on a report and select "View Code".
When someone posts RDL, you can save it to a file with an RDL extension, and
open it directly or add it to your project.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:87CFC489-72ED-41CB-BD80-821D8D2065CB@.microsoft.com...
> Thanks Jeff - I has a similar problem recently when I needed to add a
> group
> to a table. Suddenly I had document maps and couldnt find anywhere that I
> had
> entered labels for them. For clarification - there are many references in
> these threads to viewing/editing code (the RDL). That cant be done
> directly
> in reporting services so how do I do that? Being new to RS I guess I dont
> quite understand how to use the RDL. If someone submits RDL there is
> supposedly a way to "import" it to create a report?
> "Jeff A. Stucker" wrote:
>> By searching through code, I mean using "View Code" in Visual Studio, or
>> opening the RDL file directly with a text editor.
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
>> news:OnRZUGS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
>> > Check the Label properties in your report. (They may be buried, so a
>> > search through your code may be necessary.)
>> >
>> > --
>> > Cheers,
>> >
>> > '(' Jeff A. Stucker
>> > \
>> >
>> > Business Intelligence
>> > www.criadvantage.com
>> > ---
>> > "Asim" <Asim@.discussions.microsoft.com> wrote in message
>> > news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
>> >> What do I need to do to eliminate the document maps (Drill downs
>> >> showing
>> >> on
>> >> Left side of the report). I do not remember adding and have checked
>> >> the
>> >> NAVIGATION properties of all the matrices in my report.
>> >> Thanks
>> >>
>> >
>> >
>>|||Got it ... thanks
"Jeff A. Stucker" wrote:
> In Visual Studio, you can right-click on a report and select "View Code".
> When someone posts RDL, you can save it to a file with an RDL extension, and
> open it directly or add it to your project.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
> news:87CFC489-72ED-41CB-BD80-821D8D2065CB@.microsoft.com...
> > Thanks Jeff - I has a similar problem recently when I needed to add a
> > group
> > to a table. Suddenly I had document maps and couldnt find anywhere that I
> > had
> > entered labels for them. For clarification - there are many references in
> > these threads to viewing/editing code (the RDL). That cant be done
> > directly
> > in reporting services so how do I do that? Being new to RS I guess I dont
> > quite understand how to use the RDL. If someone submits RDL there is
> > supposedly a way to "import" it to create a report?
> >
> > "Jeff A. Stucker" wrote:
> >
> >> By searching through code, I mean using "View Code" in Visual Studio, or
> >> opening the RDL file directly with a text editor.
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> >> news:OnRZUGS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
> >> > Check the Label properties in your report. (They may be buried, so a
> >> > search through your code may be necessary.)
> >> >
> >> > --
> >> > Cheers,
> >> >
> >> > '(' Jeff A. Stucker
> >> > \
> >> >
> >> > Business Intelligence
> >> > www.criadvantage.com
> >> > ---
> >> > "Asim" <Asim@.discussions.microsoft.com> wrote in message
> >> > news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
> >> >> What do I need to do to eliminate the document maps (Drill downs
> >> >> showing
> >> >> on
> >> >> Left side of the report). I do not remember adding and have checked
> >> >> the
> >> >> NAVIGATION properties of all the matrices in my report.
> >> >> Thanks
> >> >>
> >> >
> >> >
> >>
> >>
> >>
>
>|||Data regions (matrix, table, list, etc.), groupings (except chart groups
where Labels have a different meaning), and textboxes have a property called
Label. If the Label property is set on any of these and the expression
returns a value != null, the document map will show up.
Note: Make sure to *not* remove <Label> elements on report parameters or on
chart groupings (because these are the labels shown inside the chart).
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
news:95514D4D-A4FC-456C-BC7C-1E94182AEB5E@.microsoft.com...
> Got it ... thanks
> "Jeff A. Stucker" wrote:
> > In Visual Studio, you can right-click on a report and select "View
Code".
> > When someone posts RDL, you can save it to a file with an RDL extension,
and
> > open it directly or add it to your project.
> >
> > --
> > Cheers,
> >
> > '(' Jeff A. Stucker
> > \
> >
> > Business Intelligence
> > www.criadvantage.com
> > ---
> > "MJ Taft" <MJTaft@.discussions.microsoft.com> wrote in message
> > news:87CFC489-72ED-41CB-BD80-821D8D2065CB@.microsoft.com...
> > > Thanks Jeff - I has a similar problem recently when I needed to add a
> > > group
> > > to a table. Suddenly I had document maps and couldnt find anywhere
that I
> > > had
> > > entered labels for them. For clarification - there are many
references in
> > > these threads to viewing/editing code (the RDL). That cant be done
> > > directly
> > > in reporting services so how do I do that? Being new to RS I guess I
dont
> > > quite understand how to use the RDL. If someone submits RDL there is
> > > supposedly a way to "import" it to create a report?
> > >
> > > "Jeff A. Stucker" wrote:
> > >
> > >> By searching through code, I mean using "View Code" in Visual Studio,
or
> > >> opening the RDL file directly with a text editor.
> > >>
> > >> --
> > >> Cheers,
> > >>
> > >> '(' Jeff A. Stucker
> > >> \
> > >>
> > >> Business Intelligence
> > >> www.criadvantage.com
> > >> ---
> > >> "Jeff A. Stucker" <jeff@.mobilize.net> wrote in message
> > >> news:OnRZUGS%23EHA.3416@.TK2MSFTNGP09.phx.gbl...
> > >> > Check the Label properties in your report. (They may be buried, so
a
> > >> > search through your code may be necessary.)
> > >> >
> > >> > --
> > >> > Cheers,
> > >> >
> > >> > '(' Jeff A. Stucker
> > >> > \
> > >> >
> > >> > Business Intelligence
> > >> > www.criadvantage.com
> > >> > ---
> > >> > "Asim" <Asim@.discussions.microsoft.com> wrote in message
> > >> > news:ECFFFE76-E424-4A56-9F9C-569A59CDE6E1@.microsoft.com...
> > >> >> What do I need to do to eliminate the document maps (Drill downs
> > >> >> showing
> > >> >> on
> > >> >> Left side of the report). I do not remember adding and have
checked
> > >> >> the
> > >> >> NAVIGATION properties of all the matrices in my report.
> > >> >> Thanks
> > >> >>
> > >> >
> > >> >
> > >>
> > >>
> > >>
> >
> >
> >