Skip to Content
0
Former Member
Nov 21, 2011 at 07:06 AM

Help with SELECT Statement!!

25 Views

Hi Experts,

I am trying to fetch the YEAR property from Category dimension with Select instruction and using the fetched year to get the TimeIDs for that year from Time dimension via following syntax:

*SELECT(%VARYR%,"[YEAR]","CATEGORY","ID='%CATEGORY_SET%'")
*SELECT(%TIMEIDS%,"[ID]","TIME","CALC='N' AND PERIOD<>'INPUT' AND YEAR IN ('%VARYR%')")

The logic is validating fine but Problem is that 1statement is not working (means not fetching the Year), I have checked by putting "AOP" instead of %CATEGORY_SET% in 1st statement and then logic worked OK for the TimeIds fetched for the AOP category year.

Please let me know what can be the problem with first statement as it is not fetching the YEAR.

Thanks & Regards,

Rohit