Skip to Content
0
Former Member
May 18, 2010 at 07:26 PM

Script Question

24 Views

Hello All,

Can I use the below statement in SQL Scripts?

*SELECT(%CATEGORY%,"[COMPARISON]",CATEGORY,ID='%CATEGORY_SET%')

When I execute the script in logic debugger, select statement gets executed successfully. But when I execute through a package, it could not determine the %CATEGORY%. In my package, I do receive the category, time and entity dimension. The package does not fail, but I can see that %CATEGORY% is not determined.

Any input is appreciated.