drill down and column generation

[JonnyB]

Hello,

I'm working on a report that I'd like to be able to drill down on, and have the final detail include more columns than the original report. For example, I have the following report:

Region Total
1 100.00
2 -59.99
3 30.00

After drilling on region 2 I'd like to see:

Region Location Book Type Trade Number Volume Value
2
South
BB
phys
A3389AB 47 100.00
A3424BC 50 -159.99


How can I make this happen?

Thanks for the help.
Jon

 

[cabs]

I need to build the same thing...
Have you somo answer to this???

Some friend tells to me that you can do this with SDK module... Do you know??

 

[JonnyB]

I have been going through the documentation and have purchased David Jackson's BO Companion book. In there, he demonstrates drill-down to be exactly what I want. I have set up my universe, hierarchies and reports to exactly mimic his, but with no luck. Did they change the functionality of drilling between versions 4 and 5? Basically, according to Jackson, double clicking on a measure variable will then show the details throughout the hierarchy. This however, is not the case. Perhaps I'm doing something incorrectly.

 

[ShyamRewaskar]

Hi.

This requirement is not possible trough BO itself.
SDK is the tool you can use to custamize your report through VBA, but there is no event for drill in VBA till now, So I dont think so it is possible, you can contact business objects for the same.

Shyam Rewaskar