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
First things first, please get the Objects and Hierarchy created in the Universe. Now, lets come to your requests:
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.
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.