Cubewise
SolutionsEducationSoftwareResourcesSupportCompany
Contact us
EN

    CubeSetConnParams function for IBM Planning Analytics (TM1)

      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