function to use for selecting element by attribute value

[vinnusea]

How can i select an element in a dimension with its numeic attribute value??? in Turbo Integrator Please help

[rkaif]

I am not really sure what you are trying to do (as you have not explained it here).

But you can get the Attribute value of an element by using the ATTRS() function in the TI process

[vinnusea]

Hi
Yes i just need the element which matches the numeric attibute value..and i need to use this in Turbo integrator .
Any MDX or regular scripts /functions can help me???

[rkaif]

Any MDX or regular scripts /functions can help me???

As mentioned earlier that ATTRS() function is the one which you need. Here is the syntax for it:

Code: Select all

ATTRS(dimension, element, attribute)
ATTRS('plan_business_unit', '10100', 'Currency')

[vinnusea]

So here the issue is
If i need a attribute value of period 01,2010 in period dimension
i would write as ATTRN(Period, !Period, Index Num) which give out some number example 117

But if i need something like this

Need Period Which matches the Index Num 117
then i must get 01-2010 out...

How can i get this???
Did i make my issue clear?

[tomok]

So here the issue is
If i need a attribute value of period 01,2010 in period dimension
i would write as ATTRN(Period, !Period, Index Num) which give out some number example 117

But if i need something like this

Need Period Which matches the Index Num 117
then i must get 01-2010 out...

How can i get this???
Did i make my issue clear?

The index number attribute you are referring to would have to be not just an attribute, but also an alias and it can't be a numeric attribute, it would have to be string. You can store digits in the attribute, it just has to be set up as a string attribute to qualify to be an alias.

[rkaif]

Need Period Which matches the Index Num 117
then i must get 01-2010 out...

Use DimensionElementPrincipalName() in a TI Process to get the Element name of the attribute.

[Alan Kirk]

Need Period Which matches the Index Num 117
then i must get 01-2010 out...

Use DimensionElementPrincipalName() in a TI Process to get the Element name of the attribute.

That only works with aliases. This has been stated to be a numeric attribute.

Vinnusea, two options are:
(a) Add the Index Number as an alias, as per Tomok's suggestion. This will only work if the index number attributes are unique; or
(b) Get the size of the dimension using DimSiz then search through it using DimNm until you find the one that you're looking for.

Option (a) would be the preferred one if you have a choice.

[lotsaram]

Use DimensionElementPrincipalName() in a TI Process to get the Element name of the attribute.

The OP is wanting to select elements by a numeric attribute value, this will not help.

vinnusea - you can do what you want and quite easily. Use SubsetCreateByMDX to create a filtered subset of your dimension based on the numeric attribute value you are seeking a match for. Do this on the prolog and then you can use this subset in the rest of your process. an alternative would be to simply process subset ALL for the dimension and do an initial test for the value and itemskip if you don't find a match.

[vinnusea]

yes this works... Really appreciate for your time guys..