No data available

[zaib]

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...

[Lynn]

Do you see any differences in the generated SQL?

[zaib]

Nope. Looks good

[MFGF]

Does the query subject have an embedded design-mode filter?

MF.

[zaib]

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

[zaib]

Lifting the filter let me expand the dimension.  MFGF thank you

[zaib]

Okie I put the filter back and issue turned out to be that parameter map did not had a default value.