If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Generated SQL/MDX: No SQL/MDX available

Started by churchy, 19 Feb 2008 11:58:02 AM

Previous topic - Next topic

churchy

Hi,
I get "Generated SQL/MDX: No SQL/MDX available" message when i try to view the SQL generate by report studio for my report... any idea why it's happening?

Thanks.

Suraj

you have too many errors in the query that the query engine can not resolve for generating a sql.
try removing one query item at a time and see where it breaks.

churchy

The point is that report studio is actually generating any SQL because return records...

goose

I have noticed that on query subjects with many members and filters sometimes generating SQL/MDX fails even if the report is running fine. Depending on what your trying to do delete all filters and then try, its not perfect but at least you get basic sql with joins