Function to retrieve a weight of an element

Post Reply
Rams
Posts: 21
Joined: Thu Mar 14, 2013 12:29 am
OLAP Product: TM1_Cognos
Version: 9.5.2_10.1_10.2
Excel Version: 2007
Location: Sydney, Australia

Function to retrieve a weight of an element

Post by Rams »

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.
Attachments
EleWeight.JPG
EleWeight.JPG (134.16 KiB) Viewed 2760 times
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Function to retrieve a weight of an element

Post by Alan Kirk »

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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Rams
Posts: 21
Joined: Thu Mar 14, 2013 12:29 am
OLAP Product: TM1_Cognos
Version: 9.5.2_10.1_10.2
Excel Version: 2007
Location: Sydney, Australia

Re: Function to retrieve a weight of an element

Post by Rams »

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