New attributes cubes and functions

Post Reply
Wim Gielis
MVP
Posts: 3098
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

New attributes cubes and functions

Post by Wim Gielis »

Hello all,

I'm a bit puzzled. Looking at the control objects in a recent Planning Analytics Local installation, I see cubes like }CubeAttributes, }DimensionAttributes, }ProcessAttributes, }ChoreAttributes, }ViewAttributes_[CUBE], }SubsetAttributes_[DIM], ... coupled with the use of functions that you we can find here:
https://www.ibm.com/support/knowledgece ... 71004.html

Specifically, the ...AttrInsert functions.

Questions:
- for attributes on the cubes or on the dimensions, why not just using an attribute on the dimensions }Cubes or }Dimensions ? The cube }DimensionAttributes is similar to }ElementAttributes_}Dimensions, no, and isn't it overkill ? If we want to loop over the attributes of a dimensions, should we loop over the contents of 2 cubes (if they exist) ?
- we can insert an attribute of type Alias. How can we use it ? Can we somewhere toggle between element name (say, a view) and its alias ?
- I can see potential to use these cubes, like for example, storing information by Process in }ProcessAttributes, but this could already be done in a 2D cube with dimensions }Processes and an own dimension, right ? In fact, I could already have such a cube and named it }ProcessAttributes :D Way before IBM did it :o

Thanks,

Wim
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply