Can anyone give an example about how to use VBA functions
in MDX queries with filters preferably.

Thanks in advance.

The only functions availables are listed in the help of AS. Most part of
these functions come from Excel.

If you search on the microsoft web site, there is some sample of how to use
the linreg function (and other linear regression functions), and this can
help you to used the other functions.
But I've never see any VBA function used in a filter (except the Now()
function to filter the actuel day or actual month).
Describe what you want to do.

"jagan_sv" <jagan_sv (AT) yahoo (DOT) com> a écrit dans le message de
news:100901c39182$e205c1f0$a101280a (AT) phx (DOT) gbl...

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.522 / Virus Database: 320 - Release Date: 2003-09-29

There's actually a substantial list of VBA functions. Many of these overlap
with similar Excel functions. Here's an exampe that uses the VBA INSTR
function to find members which contain "a" in thier name.

SELECT FILTER( [Customer].[Country - State Province -
City].[Country].ALLMEMBERS, ( INSTR( [Customer].[Country - State Province -
City].CurrentMember.Name, "a") > 0 ) ) ON 0 FROM [Food Mart 2000]

(If you want to explicilty call out what libarary the function comes from,
you can prefix it with VBA! or Excel!.)

- Matt Carroll

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

"Jéjé" <willgart (AT) hotmail (DOT) com> wrote