![]() | |
![]() |
| | Thread Tools | Display Modes |
#1
| |||
| |||
|
#2
| |||
| |||
|
|
Somewhere in the depths of all the APIs is there an object model for building and parsing MDX queries in code? I'm probably looking for whatever Analysis Services uses to cache the MDX query behind the scenes while you're browsing a cube. For example, I'm looking to build up an MDX query in an object model, execute the MDX statement, cache the object model, and then later use it to easily modify the query and re-execute it. Anyone know if something like this exists? I've looked for it myself, but can't find it. I'm in the process of writing it myself. |
#3
| |||
| |||
|
|
There is an object model used by the management tools, but unfortunately it is undocumented. I'm not aware of any other 3rd party libraries for something like this... Thanks, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Terry Smith" <TerrySmith (AT) discussions (DOT) microsoft.com> wrote in message news:6A393C94-957F-425C-AB30-7131F3C0C7C3 (AT) microsoft (DOT) com... Somewhere in the depths of all the APIs is there an object model for building and parsing MDX queries in code? I'm probably looking for whatever Analysis Services uses to cache the MDX query behind the scenes while you're browsing a cube. For example, I'm looking to build up an MDX query in an object model, execute the MDX statement, cache the object model, and then later use it to easily modify the query and re-execute it. Anyone know if something like this exists? I've looked for it myself, but can't find it. I'm in the process of writing it myself. |
#4
| |||
| |||
|
|
Is it not confident? What for tool do you keep in view? |
|
Hi, Akshai Could you please tell a bit more it about? Is it not confident? What for tool do you keep in view? Thanks, Vladimir Chtepa "Akshai Mirchandani [MS]" <akshaim (AT) online (DOT) microsoft.com> schrieb im Newsbeitrag news:erLtYD9FGHA.3936 (AT) TK2MSFTNGP12 (DOT) phx.gbl... There is an object model used by the management tools, but unfortunately it is undocumented. I'm not aware of any other 3rd party libraries for something like this... Thanks, Akshai -- This posting is provided "AS IS" with no warranties, and confers no rights Please do not send email directly to this alias. This alias is for newsgroup purposes only. "Terry Smith" <TerrySmith (AT) discussions (DOT) microsoft.com> wrote in message news:6A393C94-957F-425C-AB30-7131F3C0C7C3 (AT) microsoft (DOT) com... Somewhere in the depths of all the APIs is there an object model for building and parsing MDX queries in code? I'm probably looking for whatever Analysis Services uses to cache the MDX query behind the scenes while you're browsing a cube. For example, I'm looking to build up an MDX query in an object model, execute the MDX statement, cache the object model, and then later use it to easily modify the query and re-execute it. Anyone know if something like this exists? I've looked for it myself, but can't find it. I'm in the process of writing it myself. |
![]() |
| Thread Tools | |
| Display Modes | |
| |