TM1 Forum

Hi Experts,

Quick Question, is there a function or syntax to retrieve a weight of a consolidated element, little google gives me a "TM1DimensionElementComponentWeightGet" VB function and I'm not quite sure how to use this. In other word, can we retrieve the details in property pane of a consolidated element such as Type, Level, Weight and Index. Attached the screen.

Please help if you come across this situation. Any inputs are most welcome.

Rams wrote:Hi Experts,

Quick Question, is there a function or syntax to retrieve a weight of a consolidated element, little google gives me a "TM1DimensionElementComponentWeightGet" VB function and I'm not quite sure how to use this. In other word, can we retrieve the details in property pane of a consolidated element such as Type, Level, Weight and Index. Attached the screen.

Please help if you come across this situation. Any inputs are most welcome.

Sometimes a little Google is a dangerous thing. That's not strictly a VB function, it's an API function. It would be the last resort for obtaining this information.

The function that you want depends on the environment that you will be doing this in. (Something that the Request For Assistance Guidelines does mention that you should nominate.)

In Rules or TI, look here.

In Excel, look here.

Oops.....I've totally forget this function and over looked the problem... thanks a lot...I should have think twice before I post