While browsing a cube in BI 2005, is it possible to review the MDX code
that is being generated in the cube editor (or somewhere else)? I am
still learing MDX and I think this would be a great learning tool. Can
anyone help?

Thanks,
Partha

You can use SQL Profiler to examine queries sent to the server...

HTH,
Akshai

--
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

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.

"Partha" <partha78 (AT) gmail (DOT) com> wrote

Akshai:

This thread interested me...

I have been trying to figure out how to trace the CREATE CUBE
statements AS2005 BI Studio must use when creating cubes, but was
unable to trace them in Profiler.

All the MDX I could get out of it was the calculated measures I wrote.
This came out in the when MDX scripts box was checked in the trace
template.

Is it possible to get the the MDX I assume MS uses through profiler?

Willy



Akshai Mirchandani [MS] wrote:

Thanks all. I'm not sure I know how to use the SQL profiler to view the
queries sent to the server. Can you kindly point me to some resources?

Thanks,
Partha

willy wrote:

Thanks all. Figured it out. For those interested, I did Start > Sql
Server 2005 > Performance Tools > Sql Server Profiler > File > New
Profile > (accepted the standard) > Run

I am able to view any query sent to the server, from BI cube browser or
Sql server Management studio. I think I had to have admin rights on AS.

Thanks,
Partha

Partha wrote:

Partha:

There seem to be three threads on this right now...

I hope you have your solution, but I cannot get the MDX Scripts
executed when the cube is rebuilt and a couple others are looking for
the MDX when browsing...

The topics are:
Substitute for Log File feature in AS 2005
View MDX used during browsing
How to review MDX code in BI Browser

Perhaps someone knows the answer to these threads...

Willy

BI Studio does not use "CREATE CUBE" MDX statements -- it uses DDL that is
in an XML format (also called Analysis Services Scripting Language or ASSL).

http://msdn2.microsoft.com/en-us/library/ms129318.aspx

The events you see in Profiler when cubes are being created will not be MDX
events but rather in the form of ASSL commands...

The MDX "CREATE CUBE" statements have limited use -- for session cubes and
local cubes.

Thanks,
Akshai
--
Try out the MSDN Forums for Analysis Services at:
http://forums.microsoft.com/MSDN/Sho...ID=83&SiteID=1

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.

"willy" <willrich33 (AT) yahoo (DOT) com> wrote

Thank You Akshai:

I realized I was on the wrong track earlier.

I arrived at the conclusion that I need "Microsoft SQL Server 2005
Management Objects Collection" and "Microsoft ADOMD.NET" installed if I
want to automate cube creation. Does this make any sense at all?

Somehow I couldn't find these references after install in my Office VB
Editor...

Perhaps I need a reboot.

Thanks Again, Willy



Akshai Mirchandani [MS] wrote:

You will not be able to find AMO or ADOMD.Net using the Office VBA
editor. Office VBA only allows you to access COM based libraries, both
AMO and ADOMD.NET are .Net libraries. You will have to use Visual Studio
..Net, if you don't have access to this you could try either the Express
Edition or you could have a look at PowerShell - the new scripting shell
that MS is developing.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1150502013.446196.276450 (AT) i40g2000cwc (DOT) googlegroups.com>,
willrich33 (AT) yahoo (DOT) com says...

Thanks for the heads up...

I am not sure where to go. The raw data for what I am doing comes in
via Office VB Editor. Will office 2007 support .net libraries? I have
yet to venture outside of office...I guess it's time...

Willy


Darren Gosbell wrote: