CubeSetConnParams function for IBM Planning Analytics (TM1)

CubeSetConnParams sets the connection parameters and encrypts the password for a virtual cube stored in }CubeProperties control cube.

In this video, CubeSetConnParams is used to set up a connection to the Employee cube.

Where can the CubeSetConnParams function be used?

TurboIntegrator

Which TM1 Server version is the CubeSetConnParams function available for?

Version 11

What is the syntax for CubeSetConnParams?

CubeSetConnParams(CubeName, ProviderName, DataSourceLocation, DataSourceName, DataSourceCatalog, UserID, Password, SAPClientID, SAPClientLang, ProviderString)

CubeName = cube name
ProviderName = provider Name
DataSourceLocation = data source location
DataSourceName = data source name
DataSourceCatalog = data source catalog
UserID = user name for the database
Password = Password to be encrypted
SAPClientID = SAP client ID
SAPClientLang = SAP language setting
ProviderString = provider string

Relevant Functions

AddCubeDependency = Establish cube dependency manually
CellGetN = Retrieves a numeric value from a cube cell.
CellGetS = Retrieves a string value from a cube cell.
CellIncrementN = Increases a numeric value by a value.
CellIsUpdateable = Checks whether a cube cell can be written to. If the cell can be written to, the function returns 1, otherwise a 0 is returned.
CellPutProportionalSpread = Proportionally spreads a value to the children of a consolidation.
CellPutN = Writes a numeric value to a cube cell.
CellPutS = Writes a string value to a cube cell.
CubeClearData = clears the entire data for a Cube
CubeCreate = Creates a cube using the list of specified dimensions
CubeDestroy = Deletes a Cube from the TM1 Server
CubeDimensionCountGet = Returns the number of dimensions in a cube
CubeExists = Used check if a cube exists on the TM1 Server
CubeGetLogChanges = Determines whether the logging property of a cube is turned on or not
CubeSaveData = Serialises a cube to disk
CubeSetConnParams = Sets the connection parameters and encrypt the password for a virtual cube stored in }CubeProperties control cube
CubeSetLogChanges = Sets the logging property for a cube
CubeTimeLastUpdated = Returns a serial value which refers to the last time the cube was updated
CubeUnload = Unloads a cube and its view from the memory