Where do I find a reference for the VBA functions that can be used in SSAS
2005?
The Microsoft reference is product specific (Access, Excel, 2003 version, XP
version, etc...) http://msdn.microsoft.com/office/dow...a/default.aspx

How do I find out which functions or which version of the functions SSAS
will be using?

Hello,

Since SSAS is server side, we could only use client side objects such as
pivottable in OWC to connect to SSAS.

Office 2003 Editions: Office Web Components Visual Basic Reference
http://www.microsoft.com/downloads/d...EA9-CF5C-4DD7-
8505-8074745A6D11&displaylang=en

Or you could use some components such as ADOMD/ADOMD.Net/XMLA to connect to
SSAS from client to get the data you want:

http://msdn2.microsoft.com/en-us/lib...7(SQL.90).aspx

Querying an OLAP-datasource using C#
http://devhood.com/tutorials/tutoria...=640&printer=t

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.

I fail to understand your reply. Did you mean to reply to another post?
What I'm looking for is the documentation of the VBA functions that can be
called from MDX code in SSAS.
If you follow the link in my original post, you will see that there are many
flavors of VBA, I need to find the documentation for the VBA functions that
apply to MDX for SSAS 2005.


""privatenews"" wrote:

Hello,

Sorry for that I didn't under this correctly. I'm still confused that MDX
can call VBA function directly. VBA is automation feature in Office
applciations such as Excel/Access and it is based on COM/ActiveX tech. We
could not use any VBA functions directly in MDX. You could refer to MDX
function in SQL 2000/2005 Books Online. These functions are built in
Analysis services.

I suspect you are reference some OWC component such as pivottable that you
could use in VBA. It includes MDX properites that can be used when
connecting to Analysis Services.

http://msdn.microsoft.com/library/de...us/vbaxl11/htm
l/xlproMDX_HV03081012.asp

If it is the case, I think there is no such centralized documents on SSAS
side and it is suggseted that you post in Office newsgroup to get more
qualified answers.

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.

Please refer to 2005 BOL: "Using Stored Procedures (MDX) ", or search for
"VBA".

You may also want to check the following article and look for "UDF":
http://msdn.microsoft.com/msdnmag/is...rvices2005/#S6

You can definitely call VBA functions from MDX, the syntax is
VBA!CDate(value) for instance. What I need is the proper documentation for
these functions.

Thanks for any help.

""privatenews"" wrote:

Hello,

Thank you for your clarification on this. I got the following feedback from
product team on this issue:

The VBA functions are documented in MSDN
(http://msdn.microsoft.com/library/de...-us/off2000/ht
ml/acidxFunctions.asp).

Analysis Services supports a subset of these functions, currently not
documented in SQL2005 docs. See SQL2000 docs¡*
http://msdn.microsoft.com/library/de...us/olapdmad/ag
mdxnonosfunct_2wab.asp

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.