Drill within context 1

[dbomrrsm]

Hopefully one of you BO gurus will be able to answer this one.

We are using 6.5 webi and have a back end oracle DB with 6 levels of aggregate tables and we have aggregate awareness set for this.

We have scope of analysis set to the second to bottom level so when any of the reports are run they hit the 5th level and bring back all the required data down to that level.

My question is:

When further analysis is required at the lowest level the Database is re-queried - that much I know. However, when it is re-queried does Webi bring back all data at the sixth level then do a filter itself or does it create an extra where clause in the SQL to filter on the option selected at the sixth level.

Any help much appreciated.



[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[skrandel]

It depends. I believe the default behavior is to limit it with a Where clause. You should turn off the "tranparent drill" feature and see what it does. Then it will prompt you for what you want it to do. You'll have either option.

Steve Krandel
Symantec

 

[dbomrrsm]

Steve

Thanks for your reply - can you tell me where the transparent drill feature is enabled/disabled.

TIA

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[skrandel]

In Supervisor.

Steve Krandel
Symantec

 

[dbomrrsm]

Steve

Again - Thanks.

Dave

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[dbomrrsm]

Steve

Sorry to sound as though I havent got a clue but where in Supervisor is this setting.

Thanks

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[skrandel]

Look around. It's in the product settings on the configuration tab. Must be in the WebIntelligence area.

Steve Krandel
Symantec

 

[dbomrrsm]

Thanks Steve

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]