Page 1 of 1
Display dimension element based on attribute
Posted: Fri Aug 09, 2013 4:54 am
by 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.
Re: Display dimension element based on attribute
Posted: Fri Aug 09, 2013 6:07 am
by 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
Re: Display dimension element based on attribute
Posted: Fri Aug 09, 2013 7:49 am
by theblackdawn
vins wrote: 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.
Re: Display dimension element based on attribute
Posted: Fri Aug 09, 2013 8:34 am
by 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...
Re: Display dimension element based on attribute
Posted: Sun Aug 11, 2013 12:27 am
by 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?
Re: Display dimension element based on attribute
Posted: Sun Aug 11, 2013 5:30 am
by 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.
Re: Display dimension element based on attribute
Posted: Sun Aug 11, 2013 8:16 am
by declanr
vins wrote: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.