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.