none
OPENQUERY a MDX return nothing

    Question

  • Could somebody help on this simple query and see why there is nothing returned (0 rows) please?

    select * from openquery(LINKED_AS,'select {} on columns,{[Company].[Company Descr].[Company Descr].allmembers} on rows from MyCube')

    if I ran same MDX :

    select {} on columns,{[Company].[Company Descr].[Company Descr].allmembers} on rows from MyCube

    by management studio it returns 4 rows.

    the Linked server (provider=MSOLAP) seems like working because I can expand/browse to database level.

    Thanks.

    Tuesday, July 30, 2013 5:59 PM

All replies