Is there anybody can help me check the sqlquery to read the MDX query? It can't return any data

• lindsaywang

  SSCrazy

  Points: 2569

  More actions

  January 30, 2013 at 3:31 am

  #269620

  Hi

  who can help me check the openquery below? don't know why it can't return anything. but the MDX query can get all the members of the atttribut. don't know why.... Thanks a lot:)

  Thanks

  Lindsay

  SQL query to read the MDX Query with linked server

  select *

  from openquery(ADW,

  'Select [Product].[Product Key].[Product Key].ALLMEMBERS ON ROWS, {} on columns

  from ADW2')

  MDX query:

  Select [Product].[Product Key].[Product Key].ALLMEMBERS ON ROWS, {} on columns

  from ADW2