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.
Function to retrieve a weight of an element
-
- 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
- Attachments
-
- EleWeight.JPG (134.16 KiB) Viewed 2761 times
-
- 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
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.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.
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
Oops.....I've totally forget this function and over looked the problem... thanks a lot...I should have think twice before I post 
