Page 1 of 1
9.4 - Drill in a slice
Posted: Wed Feb 11, 2009 9:16 am
by 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) ?
Re: 9.4 - Drill in a slice
Posted: Wed Feb 11, 2009 9:27 am
by 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?
Re: 9.4 - Drill in a slice
Posted: Wed Feb 11, 2009 9:41 am
by 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..
Re: 9.4 - Drill in a slice
Posted: Sun Feb 15, 2009 1:52 pm
by 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
Re: 9.4 - Drill in a slice
Posted: Sun Feb 15, 2009 2:36 pm
by 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.
Re: 9.4 - Drill in a slice
Posted: Mon Feb 16, 2009 1:37 am
by andre lie
Ok, I get what you mean now. Thanks
Re: 9.4 - Drill in a slice
Posted: Wed Mar 11, 2009 11:59 am
by luca
Hi all,
does anybody know how to format an active form generated from a drill process? Thanks