You can also use xmla, but I don't think you will find it much better than MDX.
If you're stuck we MDX, I can recommend a good book for it. Erick Sent from my iPhone On Dec 29, 2010, at 12:18 PM, James Thigpen <[email protected]> wrote: > I sent this to the wrong group originally. Sorry for the duplication. > Looks like MDX and/or SSRS are the only means to get to this data. I > just thought someone might have something up their sleeve. > > Thanks, > > == original message == > Hey All, > > I have data in an SSAS cube. I'd like to get access to it > programmatically (DataSet, Json, etc). How does that work? > > -jt > > > ---------- Forwarded message ---------- > From: Scott Koon <[email protected]> > Date: Wed, Dec 29, 2010 at 12:15 PM > Subject: Re: SSAS Data Cubes > To: [email protected] > > Yeah, you have to use an MDX query to get stuff out of a cube I > believe. Last time I dealt with that was early 2000. The syntax is > pretty ugly and it was hard for me to wrap my head around. It might > have gotten better since then. > http://en.wikipedia.org/wiki/MultiDimensional_eXpressions > http://msdn.microsoft.com/en-us/library/ms145514(v=SQL.90).aspx > > On Wed, Dec 29, 2010 at 12:03 PM, James Thigpen > <[email protected]> wrote: >> >> Hey All, >> >> I have data in an SSAS cube. I'd like to get access to it >> programmatically (DataSet, Json, etc). How does that work? >> >> -jt > > -- > You received this message because you are subscribed to the Google Groups > "Seattle area Alt.Net" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/altnetseattle?hl=en. > -- You received this message because you are subscribed to the Google Groups "Seattle area Alt.Net" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/altnetseattle?hl=en.
