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.