9.4 - Drill in a slice

[homebunny]

When we drill in a excel slice, we end up in a new excel file and a active form, is there a setting to have a drill trough a new excel file in a slice (instead of a active form) ?

[ScottW]

When you drill from Excel you always end up in a new Excel workbook.
As of 9.4 TM1 now drills to an active form rather than a static slice (with no formatting). This is actually a huge improvement as there is (some) formatting and drill up/down ability on rows. Why would you want to drill to a static slice rather than active form?

[homebunny]

Hi Scott,
We have a Excel file with custom VBA code, when the users drill trough, he can run a macro for doing custom action into this dril trough view. So for migrating i would like to have the same behavior as before ...

Secondly i'm my enviroment, Windows 2003 -64 Bit , Office XP English.
The second excel file never opens, instead excel crashes
Drill works perfect in the TM1 architect.

Code: Select all

Event Type:	Error
Event Source:	Microsoft Office 10
Event Category:	None
Event ID:	1000
Date:		10/02/2009
Time:		14:26:28
User:		N/A
Computer:	BEGEFI02
Description:
Faulting application excel.exe, version 10.0.6850.0, faulting module tm1api.dll, version 9.4.0.568, fault address 0x00015294.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Data:
0000: 41 70 70 6c 69 63 61 74   Applicat
0008: 69 6f 6e 20 46 61 69 6c   ion Fail
0010: 75 72 65 20 20 65 78 63   ure  exc
0018: 65 6c 2e 65 78 65 20 31   el.exe 1
0020: 30 2e 30 2e 36 38 35 30   0.0.6850
0028: 2e 30 20 69 6e 20 74 6d   .0 in tm
0030: 31 61 70 69 2e 64 6c 6c   1api.dll
0038: 20 39 2e 34 2e 30 2e 35    9.4.0.5
0040: 36 38 20 61 74 20 6f 66   68 at of
0048: 66 73 65 74 20 30 30 30   fset 000
0050: 31 35 32 39 34 0d 0a      15294.. 

[andre lie]

Hi Scott,

I want to clarify what you mean by 'As of 9.4 TM1 now drills to an active form rather than a static slice (with no formatting)'. I slice a cube to an Excel, using 9.4. Then I choose drill but it opens a static sheet. So I wonder what do you mean '9.4 nows drills to an active form'

Thanks
Andre

[ScottW]

I mean exactly what I said. In 9.4 a drill through executed from within Excel drills to an active form worksheet not a slice worksheet.

Obviously this can only be true where the drill source is a TM1 cube view. If the drill source is relational then the excel output of the drill will be static. Also if the row set for a cube view that is drilled to contains only N elements then this will also be static.

[andre lie]

Ok, I get what you mean now. Thanks

[luca]

Hi all,

does anybody know how to format an active form generated from a drill process? Thanks