Drill on Organization

building reports webintelligence
1

Folks,
We have Organization table, which is pretty much flatned. It have 7 levels like – level 1 – company name and company code, level 2 – Group name and group code, level 3 – division name and division code…etc…up to 7 levels. The least level is CO_ID
As it is very flat table so I have a join to fact table on company code(which is top level in the organization) and CO_ID with one to many relation.
Which creating the objects I have just pointed those to the columns – like Company Name object, Group Name object…and so on…

My question is when I pull these hierarchy objects in to the web intelligence drill- expecting to see “All company names” – when I select one value from the company names list- in the next level object, which is Group level it should show only prior selected company related groups and when we select one group then it should show that group related divisions……and so on …
But it is showing all the values in the next levels of the hierarchy. I had created Custom Hierarchy…but still not working…
Please help…

Thank You
Kiran

Nikki (BOB member since 2010-04-20)

2

You should be seeing different values in the drill filter drop-down along with ALL values for country, and on selecting individual or all values the groups should accordingly display data in the block
If its not happening this way then there is something else to it
.

haider :es: (BOB member since 2005-07-18)