Making Focused Drills the "Default" drills

[mrees]

Hi,

I am using CA9 on CE9 and SQL2K.

Does anyone know if it is possible to make the default drill a focused drill. I do not like the way on charts where you have the parent member still on it when you drill down using the +or- buttons.

I know you can right click and select the focused drill down, but these cubes will eventually go to a lot of people, and I want it to be as simple as possible.

Thanks

Martin

 

[r1ch]

It's possible using the DHTML client, but not the ActiveX on AFAIK. For the DHTML client, search for common.js in your CA install and replace the line that says:-

var xml = ws.navigator.view.GetDrillDownCommand (member.dimensionName, member.uniqueName);

with:

var xml = ws.navigator.view.GetFocusDrillDownCommand (member.dimensionName, member.uniqueName);

It's completely unsupported of course, but it will do the trick.