Drill Down Reports

[stuartgmilton]

Hey guys,

I'm back doing BO after 3 years and have forgotten just about everything.

I'm trying to create a drill down report based on the following;

1.Number of calls closed by department
2.Number of calls closed by employee
3.Priority of calls closed.

1 being the highest level and 3 being the most detailed.

Can someone give me a quick walkthrough of what I have to do, or point me in the right direction.

Cheers,

Stuart

 

[blom0344]

You would need the dimensions

department
employee
priority

and build a hierarchy with these 3 levels.
Then create a new table or crosstab with department/number of calls and start a drill-report.

Ties Blom

 

[stuartgmilton]

And the bit I got lost at was the heirarchy.

I have created the basic dimensions in the universe and the count measure.

I assume this is done in the universe?

 

[blom0344]

With the 'old' full client (now Desktop intelligence) you could create a hierarchy within the report. Solving this in the universe would be the best strategy..

Ties Blom

 

[stuartgmilton]

Ok Cheers.

 

[stuartgmilton]

Hey guys.

I've now been told that during the install of WebI. THe company decided to go for the IIS aproach as opposed to JSP. THis means I'm not able to use drill down in WebI.

Could anyone tell me how I could html link to another report tab within the same rpt file, for the required info.

Cheers,

Stuart

 

[skrandel]

I'm sorry, but that simply isn't true. You can drill using the ASP version as well. Drilling is NOT specific to the JSP version.

Steve Krandel
Intuit

 

[skrandel]

Further....In order to drill you have to build the reports in WebI. You cannot drill on a client-create report on the web.

Could that be your issue?

Steve Krandel
Intuit