I have a query subject which shows data in Framework Manager when I do a test, but when I use any query item of that query subject in a Report Studio report is blank. When I use it in Query Studio I get the message no data available. Any ideas...
Do you see any differences in the generated SQL?
Nope. Looks good
Does the query subject have an embedded design-mode filter?
MF.
You are right.
The query subject had a filter with always usage and following expression
[GOSALES].[PRODUCT_NAME_LOOKUP].[PRODUCT_LANGUAGE] = #sq($Language_Lookup{$runLocale})#
I am not sure why this filter will not let the dimension show up... I will remove this filter and see if I am able to expand the dimesnion
Lifting the filter let me expand the dimension. MFGF thank you
Okie I put the filter back and issue turned out to be that parameter map did not had a default value.