Need Help in Creating Drill Down in Pie Chart in webi

[Former Member]

Hello Guru ,

I have a requirement  where i need  Drill down  create a pie chart . I have created a variable which will be on Higher granularity , as per my knowledge  we cannot drill on variable , so we need to create the object in Universe and set a custom Hierarchy for that  and then apply for Drill in Pie Chart .Please correct me if i am wrong .

1) Now My requirement is to drill the pie chart till two levels and then last level details should be opened in a  Report .

Is This achievable  please suggest me .

2) I have created a pie chart and when i put the variable object i can see the value  but i am unable to change the pie chary color  its coming in gray shade or it changing to black and white . i am unable to put color . please suggest how to put colors.

Thanks in advance

anurag

[mhmohammed · Accepted solution]

Hi Anurag,

First things first, please get the Objects and Hierarchy created in the Universe. Now, lets come to your requests:

Request 1:

What do you mean when you say, "last level details should open in a Report"? Do you mean a separate report altogether? Would just a new table work instead of a Report for last level?

If its just a table, then its easily possible, as long as the BO version you have is BO 4.0+ and you have the option to Hide blocks (tables or charts or cell) depending on a formula.

You'd be basically adding a condition on Table (that needs to be displayed when you're at the last level in hierarchy) How do you find out which level of hierarchy your're at? Try this blog:

or, you can even create variables to find out which value was selected at each level in the hierarchy. E.g =Drillfilters([Level 1 Object Name]) will give you value selected in Level 1, and so on. Instead of the formula in the blog, you can even use multiple variables to find out if a value was selected at every level, that way you know, if a value is selected, it means user must have drilled down to that level already.

Eventually, you'll use the variables until Last but one levels, in the condition for Hiding or displaying the table at the last level. Makes sense?

Your requirement is a nice inspiration to update that blog, I already said in that blog (in 2nd line), that using that current level we're at, users can do many other things, and your requirement of opening a report or displaying something is exactly what I meant when I wrote that blog. The idea for that blog came when a friend of mine had a similar requirement as your's, to show a custom header and table when they're at the 3rd level in hierarchy.

Request 2:

Go to the Format Chart -> General -> Palette and select a different colorful palette, Apply and OK and see what happens.

Please respond to my questions in 1st request, so we can you better.

Thanks,
Mahboob Mohammed

[Former Member · Accepted solution]

Thanks for prompt response Mahboob Mohammed

Request 1

The scenario here is

We have a report  in which we are determining os/browser by a variable(There are other objects too)

now user requirement to create a pie chart on this variable( os/browser)  and enable drill to next level as (business) and then to (employee) and then popup a sub report with selected  employee details as final output.

Hope this is not confusing .

request 2

I have already tried this option Format Chart -> General -> Palette and colors

but its taking only gray color or black and white i am unable to Apply colors. Strange but its happening

Thanks

[former_member199945 · Accepted solution]

Hi,

For scenario1 can you try element linking & input control  combination by using these 2 features we can drill down chart/table  according to user selected LOV. (we can use variables also here).

if you are not familiar with element linking search in Google/scn you will get good docs.

Thanks

[mhmohammed · Accepted solution]

Hi Anurag,

Last step in the Request 1 is an issue, clicking on an Employee Name will not open a subreport, it'll go back 1 level up, which is Business. Below are the steps though.

1. Create an Object in the Universe to concatenate OS and Browser with a slash in between, something like @Select(OS object name)+'/'+@Select(Browser object name)
2. Create a Custom Hierarchy (if you're using UDT, check this blogBusiness Objects Step by Step Tutorial: STEP 8: CEATING HIERARCHIES:) or a Custom Navigation Path (if you're using IDT, check this blog ), to drill down from OS/Browser -> Business -> Employee. Obviously Save and Export/Publish the Universe.
3. Create a Pie Chart with OS/Browser and the Measure object and enable drilling.
4. Now, when you drill on any of the Pies for OS/Browser, it will drill down to Business, on further drilling, it'll go to Employee. If you want to drill up, you'll have to right click on any of the Pies and click on Drill up to Business.
5. I checked, when clicking on an Employee name, it's going back 1 level up, to Business.

Request 2, may just be a bug, or make sure you're using a correct Pie Chart, just use the Pie, don't use Pie with Variable slice depth.

Thanks,

Mahboob Mohammed

[Former Member · Accepted solution]

Thanks  Mahboob  for the Solution  i will try above solutions .