Hi,

I use this mdx to show how much each Advertiser earns on a monthly base, and
this for 5 years:

select
{[Broadcast Date].[Year].[2001],[2002],[2003],[2004],[2005]} ON COLUMNS,
Non Empty CrossJoin({[Advertiser Responsible].[All Advertiser
Responsible].[AnAdvertiser]},[Month].[All Month].CHILDREN) ON 1


I use this MDX in combination with openquery. The idea is to put the result
in a temp table, perform some actions on the data and then use it in a Stored
Procedure.

When the MDX has results, I can create a table that looks like this:

Advertiser | Month | 2001 | 2002 | 2003 | 2004 | 2005

But when the query has no results, it "drops" the first two columns.
Therefore, i can never use a self-created temp table.

Does anyone has any idea to make sure that the output result always has the
same number of columns ?

Thanks!
from [My Cube]

Hi all, i've solved it by useing exec and the query in varchar. That way, the
parser skips it because it sees it as text.

Regards,

"Koen" wrote: