Page 1 of 1

VUSLICE

Posted: Mon Oct 13, 2008 10:32 am
by Joffes
Hi guys,

I have created excel input templates referencing a vuslice to bring me the data.
It appears though that I can only use the code once.

The first time, my view is returned, but on any attempts thereafter I get a "FALSE" in the selected columns.

Does anyone have a solution to this.

Thanks

Re: VUSLICE

Posted: Mon Oct 13, 2008 9:28 pm
by Steve Rowe
I'm not sure why this should be...
Try adding Run("M_Clear") and or Run("T_Clear") to your code between calls. These clear all the internal variables of the client and might help you.

I'm assuming that you are sure that the view is still valid and that subsets have not been manipulated further so that the view is not returning any values?
How recent a version of TM1 are you running? I have a very vague recollection of a bug in this area.
HTH
Steve

Re: VUSLICE

Posted: Tue Oct 14, 2008 5:27 am
by Joffes
I'll give it a try thanks.

The views deifnately still exist and I'm running 9.1 SP3.

Re: VUSLICE

Posted: Tue Oct 14, 2008 8:32 am
by Joffes
Still no luck I'm afraid, anyone have any other ideas?
Can you actually use a vuslice command more than once in a workbook, or maybe its one of those macros that can only run once.

Re: VUSLICE

Posted: Mon Oct 20, 2008 10:56 pm
by paulsimon
Joffes

I'm running the same version as you, and I can run the following as many times as I want

Sub TestVUSlice()

Dim sResult As String

sResult = Application.Run("VUSLICE", "planning sample:PNLCube", "Default")

Debug.Print sResult

End Sub

I have used it to put Views on different sheets in the same workbook.

I was looking at it today to get over the problem of zero suppression with nested rows and various nasty format requirements. It is unfortunate that dynamic slices don't work, and we aren't going to upgrade to 9.4 anytime soon.

I was hoping that this would work with private views but it only seems to work with public views.

I was also hoping that it would put the view in to the active cell but it always seems to use Cell A1.

At present I am going back to the In-Spreadsheet Browser combined with DBRWs or the API or MDX. Does anyone else have some views on the best way to get dynamic slices in Excel, ie slices that allow for zero suppression and user's access rights?

Regards


Paul Simon