Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Use custom mdx queries in Excel add in Reports

Status
Not open for further replies.
Injun

Injun

IS-IT--Management
Dec 17, 2002
30
US
I have been able to use the pivot table in Excel and read data from a cube.However I need to be able to create my own MDX queries and
fire them up thru excel or Vb.net and progarmatically populate the
pivot tables. How do I do this ? I know how to connect
to a cube and add to different axes, but I'd rather use a
MDX query. Can I do this programatically ?

any ideas appreciated
 
Status
Not open for further replies.

Similar threads

burakcan
  • Locked
  • Question
How to rounding up to next integer value In MDX
Replies
0
Views
180
burakcan
burakcan
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
149
juanvg1972
juanvg1972
Motlatjo
  • Locked
  • Question
All Dimensions showing on Excel, but only 3 showing on SSMS
Replies
0
Views
151
Motlatjo
Motlatjo
edvmat
  • Locked
  • Question
Error in the conversion sql query
Replies
2
Views
219
edvmat
edvmat
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
277
Motlatjo
Motlatjo

Part and Inventory Search

Sponsor

Back
Top