Skip to Content
0
Former Member
Jan 19, 2009 at 05:07 PM

MDX Query not fetching any data

34 Views

Greetings Experts,

I am using Crystal 2008 with SAP Integration Kit 3.0 trial version. While all of the other features are working fine, the MDX query data source is not fetching any data. The steps followed are -

User MDX query data source - It connects to BW DB and shows the query

Select the Query - Query fields appear in Field Explorer.

Right Click and Browse Data - No Data

Add fields to report - No data

I checked the following -

The cube on which query is based actually has data

The trasports are loaded properly and there are no errors.

copy the DB query from crystal and past it to MDXTEST, retrives the data.

Kind request please help as I have no clue why mdx part is not working.

Regards,

Apoorv