Drill down from a chart to table

building reports desktopintelligence
1

In DESKI report I have a chart where I enabled the drilling. When I drill down it creates another tab with details. Since I’m drilling from a chart the details tab also has the chart. If I want to see table in the detail tab, I have to manually change the chart to table.

Instead of doing this manually, is there any settings I can use to get a detail table when I drill down from a chart?

I’m using XI R2 Sp2.

Thanks,

Phil (BOB member since 2005-03-31)

2

Couple of thoughts.

  1. Create both a table and a chart. Display one or the other depending on the level of drill i.e. if you are at the top then show the chart, if you are drilling show a table
  2. Use and opendoc statement to jump from the summary chart report to a detailed table report.

Nick Daniels :uk: (BOB member since 2002-08-15)

3

Dear Phil,

Go to infoview preferences> Web Intelligence
go to General drill option:
Check the “Synchronize drill on report blocks” option

Now, When you create the table … copy and paste it adjacent to it in the same report.
Enable the drill mode.
Save this.
Now select the table you copied recently and turn this to chart.
Now when you drill this chart to a lower level … you’ll see that you table is also drilled to the same level.

This is possible in XI R2, now it depends on which version you are working.
I hope this helps.

Regards

shiva.tomar (BOB member since 2007-10-05)

4

Thanks for the quick response guys.

Hi Shiva,

Do we have “Synchronize drill on report blocks” option in DESKI also? I’m using XI R2 SP2.

Hi Nick,

Could you please give little bit more deatils about opendoc statement?

Thanks,

Phil (BOB member since 2005-03-31)

5

Opendoc allows you to create a link to a report. You have various parameters that can be passed to the ‘called’ report, for example do you want it to be refreshed, the values of any prompts etc. So the user will click on a link, which in the past might have been a drill operation. But you’ve used a variable in the report which contains an opendoc, so no drill takes place but another report is opened.

If you search the BusinessObjects Desktop for ‘opendoc’ you’ll find the syntax plus many, many examples!

Nick Daniels :uk: (BOB member since 2002-08-15)

6

Hey Phil,

Ammmmm No, i think you need to go by Nick’s suggestion… as DeskI doesn’t have that setting i guess… you can achieve this by opendoc…

Thanks Nick. You are a genius…

sorry for the confusion. :crazy_face:

Cheers,

shiva.tomar (BOB member since 2007-10-05)