CODEWITHSUNDEEP
excelvbassasmdx
eAlchemist
eAlchemist

Reputation: 106

MDX driven QueryTable returns no rows

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..

Upvotes: 0

Views: 447

Answers (1)

ic3
ic3

Reputation: 7680

Strange the 'NULL ON 0' -> '{} on 0' is a bit more MDX but I don't think it's the problem. It's looks like a way to switch columns and rows, my educated guess is the issue is you've no data columns.

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

Upvotes: 1

Related Questions