DBSS TM1 Excel Syntax and Use

The DBSS function sends a string value to any TM1 cube’s cell. DBSS Syntax The syntax for DBSS is: Where: Importance of Sequence It is important to note that the arguments (e1…en) follow a specific sequence in which e1 corresponds to an element from the first dimension of the cube, e2 corresponds to an element…

Read More

Create a TM1 Send Sheet in Excel

Excel based TM1 Send Sheets are a wonderful way of having data that is calculated in Excel loaded automatically into TM1 on demand. Here we show how to create a send sheet and automate it so that it only runs when required.

Read More