x

MDX query should behave like ADO query

I am trying to match existing reporting functionality while building up a new cube for a Proof of Concept.

Can I retrieve data from my cube using an MDX query and put it into a recordset so I can then populate an Excel Sheet with the data?

more ▼

asked Nov 12, 2009 at 07:26 PM in Default

avatar image

Raj More
1.8k 82 87 90

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You may be better getting Excel to connect to the cube directly.

But otherwise, sure... use ADOMD.Net.

more ▼

answered Nov 12, 2009 at 07:40 PM

avatar image

Rob Farley
5.8k 16 22 28

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x197
x140
x93

asked: Nov 12, 2009 at 07:26 PM

Seen: 2373 times

Last Updated: Nov 12, 2009 at 07:26 PM

Copyright 2016 Redgate Software. Privacy Policy