User manual APPLIX TM1 CLIENT 2.6

[. . . ] prepared the information contained in this document for use by Applix personnel, customers, and prospects. Applix reserves the right to change the information in this document without prior notice. The contents herein should not be construed as a representation or warranty by Applix. Applix assumes no responsibility for any errors that may appear in this document. [. . . ] The strings in the various cells referred to can be changed, thus changing the intersection in the database to which the formula refers. Formulas written with cell references also have the advantage of being copyable. 1 DBGEN(Type, Value, Cube, K1, K2[, . . . K8]) DBGEN(Type, Value, Cube, K1, K2[, . . . K8]) DBGEN sends numeric or string values to cubes containing up to eight dimensions. This function restores cubes with the Transaction Log, and is a generic version of the DB Send functions (DBSn and DBSSn). Arguments Type Indicates whether the value being sent is numeric, string, or calculated. The names of elements defining the intersection in the cube to which the value is sent. K1 must be an element from the first dimension of the cube, K2 must be an element from the second dimension of the cube, and so on. Value Cube K1, . . . K8 Example DBGEN("N", 5342, "92act4d", "California", "3. 5 Diskettes", "Net Sales", "January") 2 Applix TM1 Client DBGEN16(Type, Value, Cube, K1, K2[, . . . K16]) This example sends the value numeric value 5342 to the cube 92act4d at the intersection of California, 3. 5 Diskettes, Net Sales, and January. DBGEN16(Type, Value, Cube, K1, K2[, . . . K16]) DBGEN sends numeric or string values to cubes containing more than eight dimensions. This function restores cubes with the Transaction Log, and is a generic version of the DB Send functions (DBSn and DBSSn). Arguments Type Indicates whether the value being sent is numeric, string, or calculated. The names of elements defining the intersection in the cube to which the value is sent. K1 must be an element from the first dimension of the cube, K2 must be an element from the second dimension of the cube, and so on. Value Cube K1, . . . K8 Worksheet Functions 3 DBRn(Cube, K1, K2[, . . . Kn]) Example DBGEN16(78365, "91accounting", "California", "Track1", "3. 5Dis kettes", "Wholesale", "Actual", "Net Sales", "External", "Code2", "January") This example sends the value 78365 to the cube 91accounting at the intersection of California, Track1, 3. 5 Diskettes, Wholesale, Actual, Net Sales, External, Code2, and January. DBRn(Cube, K1, K2[, . . . Kn]) This function retrieves a value from a cube of n dimensions. Arguments Cube K1, . . . Kn The name of the database cube from which to retrieve the value. Dimension element names that define the intersection of the cube containing the value to be retrieved. K1 must be an element from the first dimension of the cube, K2 must be an element from the second dimension, and so on. 4 Applix TM1 Client DBRn(Cube, K1, K2[, . . . Kn]) Example DBR4("92act4d", "California", "3. 5 Diskettes", "Net Sales", "January") In this case, 92act4d is the cube name, and the function returns the value at the intersection of California, 3. 5 Diskettes, Net Sales, and January. Worksheet Functions 5 DBRWn(Cube, K1, K2[, . . . Kn]) DBRWn(Cube, K1, K2[, . . . Kn]) This function works exactly the same as the DBRn function described above with one major difference; DBRWn reduces network traffic and may improve performance on wide area networks. In cubes with a large number of cube references, DBRWn forces TM1 Client to send references in "bundles" rather than individually. Normal TM1 Client DB references are updated individually during a recalculation. DBRW references force TM1 Client to execute two passes over the worksheet. In the first pass, the function reads all changes to values and sends them in a single bundle to the cube. In the second pass, the function reads the values in the cube and sends them in a single bundle back to the worksheet. As a result, the worksheet recalculates twice when the function is executed. Arguments Cube K1, . . . Kn The name of the database cube from which to retrieve the value. Dimension element names that define the intersection of the cube containing the value to be retrieved. K1 must be an element from the first dimension of the cube, K2 must be an element from the second dimension, and so on. Example DBRW4("92act4d", "California", "3. 5 Diskettes", "Net Sales", "January") 6 Applix TM1 Client DBRX(Handle, Cube, K1, K2[, . . . Kn]) In this example, the function returns the value at the intersection of California, 3. 5 Diskettes, Net Sales, and January in the 92act4d cube. DBRX(Handle, Cube, K1, K2[, . . . Kn]) The DBRX function retrieves a value from a places the value in a slice worksheet. It is optimized to work within the slice, and performs better than the standard DBRn function. In Lotus 1-2-3, this function requires that you specify the number of dimension in the cube. For example, use DBRX3 to retrieve a value from a cube containing 3 dimensions. Arguments Handle Cube K1, . . . Kn A reference to a cell containing a Slice function. Dimension element names that define the intersection of the cube containing the value to be retrieved. [. . . ] Client and TM1 Server are of different dates or versions. N55 Reloading Failed. Check files. Error Messages 15 N56 Not Connected to any Server. Client is not currently connected to a TM1 Server. N57 Can't Open More Connections. Client is connected to the Maximum number of TM1 Servers. N58 Invalid parameter XXXX. [. . . ]