Drill Through access

[Catherine]

Hello,

I've built a drill through process that works fine. This drill through is available from an Excel sheet, more precisely from an active from.

But sometimes (I've not identified under which circumstances), the drill is no more available in the right clik menu.

Any idea of what I could do?

Thanks

[Andy Key]

Does the drill option re-appear if you hit the Rebuild Current Sheet or Rebuild Current Book buttons?

Alternatively does your drill assignment rule only apply the drill to part of the cube?

[LoadzaGrunt]

I have had problems with Excel being flakey around the drill-through option though. If an Excel restart solved the issue then you'd know it wasn't a specific TM1 problem.

[lotsaram]

The right-click drill menu in Excel works 99% of the time but can can be a bit quirky for the other 1%. Sometimes it's simply a matter of selecting a different range then reselecting the DBRW in question and right-clicking again. Other times a recalc fixes things, other times try slicing out a view out to reset TM1's monitoring of Excel events. Worst case run M_Clear or close and restart Excel.

Also as per Andy's post does the drill actually apply to all areas of the cube you are right-clicking from?

[Catherine]

The drill is assigned almost everywhere in the cube so this is not my problem.
I confirm that the only way I found to make the drill option re appear is to restart Excel. But this solution does not satisfy me. Or should I say it will not satisfy the users...

[Catherine]

By the way, lotsaram, what do you mean by "run M_Clear" ?
Thanks
Catherine

[paulsimon]

Catherine

M_Clear is a TM1 Macro

In VBA you put

Application.Run "M_CLEAR"

This tends to get the TM1-Excel Cache back in step with the TM1 Server.

You might want to look at my earlier post on Formatting in Relational Drill Thru in Excel for some ideas on how you could use this.

Regards


Paul Simon

[jstrygner]

I do not know if this is the case (to be honest I doubt it) but maybe somebody else will have "my issue".

I remember wondering why I do not have my TM1 options in right click menu on a DBRW cell in Excel avaliable.
It took some time till i discovered, that they were not available while I had "Page Break Preview" turned on (the one that shows how will the printout be divided to following pages).

I do not know if TM1_right_click_menu is never available in "Page Break Preview" mode, but at least few times in my case it was a solution to turn it off (set to "Normal View").