Hi, I am creating a variable , where i want to get the specific values of a dimension object, i do not want to apply filter.. how can i achieve this?

[Former Member]

Hi, I am creating a variable , where i want to get the specific  values of a dimension object, i do not want to apply filter.. how can i achieve this?

[Former Member]

Hi Reena,

Just from your question , If you would like to get some specific value from another dimension. you can create a variable with If..else to populate only required value and populate blank for rest.

Example: Create new variable and

=IF([status]='A';[status];" ")  : populate status value as 'A' and blank for rest

OR you can use where clause ( populate name where status is 'A')

=[Name] where ([status]='A') : populate values from name field(object) where status is 'A'

you can further play with filter options as Monish suggested above.

Hope this helps. if you are expecting something else please elaborate your requirement.

Thanks

Bob

[former_member205194]

Hi Reena,

Can you elaborate on your requirement ? Where are you trying to create the variable ?

Why you do not want to use a filter ?

If its a variable in the Webi report, below are the main options-

1) Query level filter (restricts the data at the query-level)

2) Report level filter (restricts the data displayed from the microcube)

3) Ranking (ONLY the top 'N' data will be displayed)

Regards,

Monish