Slice VBA Documentation

Arc & Slice
,
1

Hi!

i can’t find a documentation about the VBA functions in Slice, is there one existing?

I used a macro in some sheets thats triggers the login window from perspectives, is there a way to do similar (or do the whole login) with Slice?

Thanks

2

Hi @Olide02

We only have the following functions available in VBA in Slice:

  • TM1RECALC1 - Recalc active worksheet
  • TM1REFRESH - Rebuild active worksheet
  • TM1REBUILDALL - Rebuild all worksheet in a workbook
  • DBSSEND - Send DBS in active worksheet
  • DBSSENDALL - Send DBS in active workbook

All of them can be executed via Application.Run in VBA.

N_CONNECT function hasn’t been implemented yet.

1 Like
3

Hi,

i have seen the N_CONNECT got implemented, but I can’t find any example or documentation.

VBA functions in Slice - Cubewise CODE

Can you maybe share some insight on this?

Edit:

Found this page: Using N_CONNECT in Slice - Cubewise CODE

and tried to run the N_CONNECT Macro like:

Application.Run "N_CONNECT", "Planung", "", "", "cognosAnalyticsHost:80/ibmcognos/bi/v1/disp"

Which does nothing (no error but also no connection)

Thanks!

4

Hi @Olide02

You CAM namespace (last parameter) doesn’t look right. This can be looked up in your cognos configuration.

Thanks,
Andrey

1 Like
5

Ups, thank you i didn’t read correctly and put in the gateway url.

If i understand it correctly, this will not work with the SingleSignOn (CAM) right?

Thanks and BR

6

You are correct. SSO isn’t supported by N_CONNECT.

1 Like
7

Hi,

thanks for the info, i enabled my account for password Auth and tried it with the native arc Dialoge window (Namespace login) which worked fine. If i try the Macro in Slice its calculate some seconds then nothing happens, explorer window still shows not logged in and i can’t receive any values.

Application.Run "N_CONNECT", "Server", "Domain\UID", "Password", "ApacheDS"

Thanks for your help!

Edit: Is it also possible to use N_CONNECT without opening the Server Explorer window before?

Edit2: Also is there some plans on add “TM1RECALCALL” Which would caluclate all formulars in the book? (Analoge to TM1REBUILDALL)

Edit3: Ok got the login working, don’t know what was wrong, but i placed it in a seperate sub and now it works, just found following behavior: When i open the server explorer and run the “N_Connect” Macro i got connected to the TM1 Server and can recivie values, but the explorer still shows not logged in, when i click on the Tm1 Instance, it shows me the Login Popup, if i now just close it without logging in, i got logged out → “#Connection!” in Cells.

Is this a bug? I think the session should be shared with the actual GUI Session

8

Resurrecting this thread…

Does anyone know if this list on the Slice website is the current list of supported VBA Functions in Slice?

More specifically, does anyone know if QUEXPORT or something like it is possible in Slice at the moment? It is a big use case for a prospective Slice client in the UK, and something I don’t think is possible in PAfE based on the PAfE API documents, so could be a good differentiator for Slice.

Cheers!

9

Hi @saylett

The list of VBA functions on the website is up to date.

There is no QUEXPORT formula in Slice. Feel free to create a ticket for this. It doesn’t have to be a copy of Pafe formula and we can also make better and more customizable.

1 Like
10

Thanks - feature request ticket created!