Issue: No Data loaded from Query - MDX, SQL issue

[Former Member]

Hello,

I'm having a problem with a report based on Query with a hierarchy (0GLACCEXT Hierarchie, Data in Cube 0FIGL_V10), first version of query had 3 filters, but I also tried to load the data without filters thinking it coused the problem - didn't help to fix the issue.

If I put some characteristics into the report - the fields are empty - i did "browse data" in the database and found out that only the data for the "year" was fetched by the SQL expression even though I have some similar reports with hierarchies based on 0GL_Account and data is fetched correctly in those ones.

I tried MDXTEST on SQL expression

"SELECT {[Measures].[D5LABJ7EYP982LUFOJAXZ3Z3E]} ON COLUMNS, NON EMPTY [0GLACCEXT CVIS].MEMBERS DIMENSION PROPERTIES [0GLACCEXT CVIS].[40GLACCEXT] ON ROWS FROM [0FIGL_V10/ZEN_FIGL_V10_Q0001]"

Data is being loaded.

What else can I try?

ps: just found out that data is not fetched when i assign a hierarchie no matter which one (could it be the issue due to the size of hierarchy?)

Edited by: Elizaveta Nikitina on May 5, 2009 3:33 PM

[former_member11696]

Please re-post if this is still an issue to the Data Connectivity - Crystal Reports Forum or purchase a case and have a dedicated support engineer work with you directly