function of drillthrough

Hi,

I can't visualize clearly what drillthrough is for. I dunno if this can cater what i'm looking for. basically, the client wants that from a default view to click on one of the dimensions and give him a more detailed view:

example:

GroupHeads Model No No.Of Units

A 1 10

B 2 14

C 2 20

Once the user clicks on the GroupHead A, he wants to see this detailed view:

Service Jobs Amount

1 10

2 20

3 50

4 11

....

10 9

Can this be done by drillthrough?

cherriesh

Hi,

The drillthrough functionality is used to drill into the a particular measure and produce a report based on the slice taken. So in your example above you might want to drill into the No.Of Units = 10, which is a slice of GroupHeads = A and Model No = 1

From that you can produce an output that makes up that value of 10 (you don't have to include the No.of Units) e.g. You might want to look at the service jobs, amount spent and the no units ordered:

Service Job Amount No.Of Units

2 12 5

8 36 2

10 1 3

If you slice it by something else e.g.

Year 2004 2005 2006

Service Job

A 12 10 11

B 22 20 21

C 32 30 31

If you drill through number 20, you will slice your drill through by year =2005 and service job = B e.g.

Service Job Amount No.Of Units

2 12 15

8 36 2

10 1 3

HTH

Matt

|||

Can drillthrough have more than 1 level? like after clicking on the first view, you click again on the 2nd view to show you another slice?

thanks a lot.

cherriesh

|||

Hi,

No you can only dril down once, unless you create an action to a report which in turn has the ability to drill down again in another report. But the standard drillthrough functionality I'm fairly sure you can't, as it takes you to the lowest level of granularity.

HTH

Matt