Search found 2 matches

by dk2316
Fri Aug 07, 2009 1:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA to insert dimension attributes
Replies: 2
Views: 2591

VBA to insert dimension attributes

Has anyone managed to manipulate dimension attributes via the API? I've managed to create a dimension and add elements to the dimension using the example provided, but am having trouble with adding attributes to dimension (aliases) and then updating these attributes at the child node level. I am gue...
by dk2316
Thu Jul 30, 2009 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Embedding MDX in TM1 Excel formulae (TM1RPTROW())
Replies: 1
Views: 2854

Embedding MDX in TM1 Excel formulae (TM1RPTROW())

I am trying to incorporate the TM1DRILLDOWNMEMBER( <set1>, <set2>|ALL [,RECURSIVE] ) MDX function into a TM1RPTROW, so that my active form appears fully expanded in one instance, and collapsed in another. This is so I can email hard-coded .xls files to offline users. The original excel formula looks...