DBSW TM1 Excel Syntax and Use
The DBSW function in TM1 sends a numeric value to a TM1 cube. Syntax The syntax for using DBSW function is: Where: The arguments e1 through en are sequence sensitive, meaning the order of the elements is important. e1 corresponds to an element from the first dimension of the cube, e2 corresponds to an element […]
Dimensions in TM1
Dimensions are one of the fundamental building blocks in TM1. We put dimensions together to create cubes and then cubes to hold data. What are Dimensions? Dimensions in TM1 are just structured lists of elements (or sometimes known as members). So a list of product, months, customers, measures, years, accounts, cost centres, WBS codes, versions, […]
Slow MDX Subsets? Best Practice Guide to Maintain Sets in TM1
Do you have slow reports with large subsets using MDX? Here’s a best practice guide with screenshots to fix poor performing MDX based subsets.