Drilldown Dimension

[#1]

Hi,

I am really confused with the drill down group behavior.

I have created a table with 3 columns.

UNIV:

Territory,

sum

Count

The above table is joined with rest of the data model based on the Territory. So, from another table

named KIT I pulled Area, Region and Territory and created a drill down group.

I created a bar chart with

dimension as a drill down group with Area, Region and Territory and

Expressions as Sum and Count from UNIV Table.

But Surprisingly the above drilldown group is not working (i.e., I cant see the area and region in Bar chart, But when I select Territory from list box its working)

Can Someone pls help me working this out!

Thanks in advance!

Rohini.M

[johnw]

This probably isn't it, but your drill down dimensions have to be listed in the right order, from broadest to narrowest. So for instance Year, Month, Day. I can't tell from the field names which order Area, Region, and Territory should be in, but perhaps they're not in the right order?

[MK9885]

It should work both way.

Selecting fields on Chart or Filters.

There is no reason for not working.

[#4]

Thank you for reply!

The order is Area->Region->Territory. I created drill down in same order John. That's why am surprised by the result.

Can you pls help me if I can find any other way to work this out.

[#5]

Yes Aravind. That is what I expected and I cross checked with order and dimensions too. Somehow its not working.

[vishsaggi]

Can you show us the data model or the script you used for joining tables?

[MK9885]

There can be issue with the script.

Can you post sample data or qvw?

[#8]

Hi,

Pls find Script below

KIt:

SQL Select Kit, Kitreceived, Area, Region, Territory from reporting.kits_received ;

Qualify*;

Unqualify Territory;

UNIV7_Req_Summary:

SQL select Territory, count(kit_ID);

[#9]

Sorry, I cannot share the data model. But, I posted the script. Pls go thr'. We are loading all the tables from SQL Queries.

[vishsaggi]

Qualify*;

Unqualify Territory;

UNIV7_Req_Summary:

SQL select Territory, count(kit_ID);

In the Above script are you using Group By clause because you are using Aggr function count().?

something like this may be?

SQL select Territory, count(kit_ID) AS KitCount

Group by Territory;

And were both the tables joined by Territory or some other field ?