Re: How to review MDX code in BI Browser

Thank You Darren:

We crossed on another post this weekend...somehow I never thought of
"currentmember.parent." That should be helpful to me in the future.

I purchased "Visual Studio 2005 Standard Edition" and I am still having
problems getting the AMO reference. I can get DSO to work

ie. Dim svr as DSO.Server

but not AMO

ie. Dim svr as AMO.Server

Do I need the enterprise edition or something? Or maybe I am just lost.
I believe I have Analysis Management objects referenced.

Willy



Darren Gosbell wrote:
If you are accessing data using VBA, you are probably either doing
something like referencing Excel data directly or using a data access
library like ADO. .Net can pretty much access all the same data source
that VBA can, so that should not be an issue.

If you want to stay in Office - VSTO (Visual Studio Tools for Office)
might be an option. It lets you write .Net based logic for Office
applications. (but I think you need a full copy of Visual Studio.Net)

I don't know if Office 2007 will have native support for .Net based
libraries. I think I remember hearing that Office 2007 was still using
VBA, but I have not checked this out yet.

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

In article <1150509791.661810.154320@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
willrich33@xxxxxxxxx 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:
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@xxxxxxxxxxxxxxxxxxxxxxxxxxxx>,
willrich33@xxxxxxxxx says...
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:
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...


.

Relevant Pages

  • Re: How to review MDX code in BI Browser
    ... problems getting the AMO reference. ... Darren Gosbell wrote: ... If you want to stay in Office - VSTO (Visual Studio Tools for Office) ... Will office 2007 support .net libraries? ...
    (microsoft.public.sqlserver.olap)
  • Re: Bin directory
    ... librareis to the GAC we could not add them to our visual studio references, ... There is one downside to using the GAC however, ... one solution is to place the business libraries in the Global ... which allows you to reference them without having ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: importing a tlb in Visual Studio 2005
    ... automatically reference the correct library (there are actually 4 different ... libraries), so I'd lean towards the lib path being off. ... Searching libraries ...
    (microsoft.public.dotnet.languages.vc)
  • File/Project References within Solutions
    ... This is regarding Visual Studio 2003. ... many of these reference each other. ... we would simply add all of the libraries that we wish ... you may be asking why we would want two different developers working on ...
    (microsoft.public.dotnet.general)
  • error message trying the microsoft console application example
    ... namespace 'ConsoleSampleWebSearch' ... To set up the project in Microsoft Visual Studio .NET 2005 1.. ... menu, select Add Web Reference. ... In the Web reference name text box, ...
    (microsoft.public.dotnet.languages.csharp)
Loading