Display dimension element based on attribute

[vins]

Hi Experts,

I want to display a dimension (lets say Currency dimension) element based on Market dimension attributes.

Explanation -- The attribute currency is defined for Market dimension . I want to display the elements in currency dimension according to selection of elements Market dimension.

Please HELP !!!!

Thanks in advance.

[EvgenyT]

Bit puzzled with what are you trying to do here...

I want to display the elements in currency dimension according to selection of elements Market dimension

... display where?

ET

[theblackdawn]

I want to display a dimension (lets say Currency dimension) element based on Market dimension attributes.

As far as I have understood, you are trying to display some elements in one dimension based on a selection of elements in another dimension.
And as far as I am aware, it is not possible to have a conditional drop-down of the dimensions inside a cube view. (Experts, please correct me if I'm wrong).
Possible workaround acc. to me - you can make the elements in Currency dimension display as Data values inside the cube, based on the selection of Market dimension elements. This is possible.
Would deftly say others' suggestions would be more helpful. This was just a thought from my end.

[EvgenyT]

As far as I have understood, you are trying to display some elements in one dimension based on a selection of elements in another dimension.
And as far as I am aware, it is not possible to have a conditional drop-down of the dimensions inside a cube view. (Experts, please correct me if I'm wrong).

Are you referring to conditional picklist? I havent extensively tested it, but I dont think you can...

[Darkhorse]

Could you not add the other dimensional data to your data you wish to "filter by" as attributes and then use the filter by option?

[vins]

Thanks for your precious answers!!!

@Darkhorse .. Do we have any option to use filter by attributes in TI process or any other work around to make it dynamic.

[declanr]

Do we have any option to use filter by attributes in TI process or any other work around to make it dynamic.

You can use SubsetCreateByMDX() in your prolog to create the data source or just do a while loop through the dimension elements with an IF statement inside; to assess if your ATTRS criteria is met, if so - use SubsetElementInsert.