Difference between Cyclic and DrillDown

[#1]

Hi All,

I am in a middle of designing a dashboard for our applicatoin in which I have different drill down charts. But that I want to see from different dimensions..Like I need so a list of dimensions and based on the selection it would show me the drill down chart.

Do you think I should use Cyclic Group for it? if yes then how would I use CYCLIC GROUP with the drill down chart. If any example file for my help is available I would be delighted.

Thanks

[amars]

Hi,

To create a cyclic group go in Properties -> Dimensions . click Edit Groups -> click new -> In Group Name give GroupName -> select required fields and add them -> Click on Cyclic Group and click ok.

You can refer Consulting Services example in the Getting Started tab of start page on the Invoiced tab there is a graph for Gross Profit with Cyclic group.

Regards,

Amar

[#3]

Hi,

if you are trying to navigate an hierarchy, use the DRILL DOWN GROUP. In case you want to show the same data from different perspectives ( by different dimensions), use the CYCLIC GROUP .

In case of CYCLIC GROUP, You could choose the field by right clicking on the Group icon and selecting.

In case of DRILL DOWN GROUP, as you make selections, you go to the next level. To traverse back to previous level, click on the arrow icon.

[#4]

Vidyut thank you for your reply. Well lah me explain you again. I am working for a telecom industry where I need to analyze the incoming traffic on our switches...the information is stored in Oracle database.

I have a selection criteria in following list boxes.

1. Years
2. Months
3. List of Countries
4. List of Phone Operators

Now to based on the criteria I have a chart on my screen which is showing the "Selected Operator" Data. Now the representation is like it is showing the SUM of total bandwidth consumed of the year for example year 2008. When I drill down it shows the total of Each months in seperate month bars ...now if I click on any month it drill downs further and shows me all 30 days data of that specific month..now on any selected day if i drill down further it shows the 24 hour's data of that selected day. Thats it.

What i did is I made a drill down group lets say "DrillDown_By_Operators" and assigned that group to that chart. But If I want to see that chart by "Total" not by operators for that I need to make a another group and offcourse another chart. If I am not mistaken this is what we call "Dimension" so for every dimension with the same theme will I create seperate charts.

What I want is that I should have a cyclic group and on click it shows me the list of different dimensions like "by_total", "by_operator", "by_country" and whatever I select the chart should populate based on that and I can drill down in the same way I've mentioned earlier.

Now please suggest.

Thanks

[#5]

Hmm, Mixing of Drill Down and Cyclic charts is not possible. Easier option would be to create 4 charts, with four different drill down groups, and make only one visible based on your selection in the cyclic group.

Instead of using the Cyclic group, You could create a new dimension with names of options in the Cyclic Group, and based on the selection, show one of the charts.

[ManuelRühl]

It is possible:

Create a drill-down-group f.ex. "DRILLDOWN"

Create a cyclic group. Edit the fields in the cyclic group by adding a field by formula.

Then type "=DRILLDOWN". So you can add several Drilldown-Groups in one Cyclic group.

It's not the finest way beacause you cant go up in the Drilldown group, but it works.

[#7]

Mruehl,

Can't you go back up in the Drilldown group with the Back button? (to step back a selection choice)

[ManuelRühl]

of course you can go up by hitting the step-back-button.

but if you've done some other selections after thrilling down, you first make the selections undone, not the thrill-down.

i've solved the problem by creating several hierarchiy levels:

Thrill Down 1: Company

Thrill Dwon 2: Company > Sales Man

Thrill Down 3: Company > Sales Man > Customer

So I can switch to upper levels by changing the cyclic-dimension

[#9]

Hi mruehl

I am having same requirment .

I have tried with the solution you have provided.It didnt work.

Please send a sample qvw file.

[ManuelRühl]

here you are