Skip to Content
0
Former Member
May 05, 2009 at 01:10 PM

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

29 Views

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