TM1 Function for TI, CubeSetConnParams

Sets the connection parameters and encrypt the password for a virtual cube stored in }CubeProperties control cube.

What is the … function?

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

Where can the … function be used?

TurboIntegrator

What is the syntax for …?

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

A demonstration on how to use …

Use CubeSetConnParams to set up a connection to the Employee cube.