Query Selection Criteria

[Former Member]

Hi Gurus,

In the cube we have Valid from and Valid To date. in the Selection Criteria user needs to select Period (mm/yyyy) valid from and validto i e Start date and End date. If I am using intrvel in Valid from variable definition i .e selection criteria we are selecting the valid from start date and end date. We need to select valid from Start date and Valid to End date. how will we do this in the query.

proper response will be rewarded with points.

Thanks

RK

[Former Member]

Hi,

Create a variable and select the options as per your requirement wheather single value or multiple single values or interval range etc on the infoobject in the query which you want to see.

Cheers,

Malli.........