Question

I m using Excel 2007 and this method to populate a querytable with and MDX query. When I run the MDX query in BIDS I get a normal result (7x2 result set). However, when I use it in the QueryTable, I only get two column headers (no results).
Can anyone tell me why the results aren t being returned to the QueryTable?

MDX Query:

SELECT
  NULL ON 0
 ,NonEmptyCROSSJOIN([Item].[Company].CHILDREN
 ,[Item].[Division].CHILDREN) ON ROWS
FROM
  [PETE];

Result in QueryTable:

Column Header 1: [Item].[Company].[Company].[MEMBER_CAPTION]
Column Header 2: [Item].[Division].[Division].[MEMBER_CAPTION]

Results in BIDS:

Company1 Division1
Company1 Division2
Company1 Division3
etc..

Answer 1

安排NCL ON 0 ->{} on 0 is a bit more MDX but I no consider it s problem. 我受过教育的猜测是你没有数据栏。

If you get rid of this or change with a dummy [Measures].defaultmember member, what do you get in Excel ?

MDX Query:

Result in QueryTable:

Results in BIDS:

友情链接