AS serializes requests if MDX has VBA 
Author Message
 AS serializes requests if MDX has VBA
Hi,

I read somewhere (probably a newsgroup posting) that Analysis Services will
serialize requests if any MDX is sent which uses VBA functions.  I am
wondering if anyone (Microsoft?) can clarify this issue.  I use InStr in MDX
to perform searches.

Chris



Tue, 29 Nov 2005 12:08:44 GMT
 AS serializes requests if MDX has VBA

This is correct. Please keep in mind, that this will only affect you if the
queries are executed on the server. Clients, obviously, execute in parallel.

--
==================================================
Mosha Pasumansky  - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

Quote:
> Hi,

> I read somewhere (probably a newsgroup posting) that Analysis Services
will
> serialize requests if any MDX is sent which uses VBA functions.  I am
> wondering if anyone (Microsoft?) can clarify this issue.  I use InStr in
MDX
> to perform searches.

> Chris



Sat, 03 Dec 2005 14:17:35 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Serialize without using Serialized Isolation

2. MDX vs. Excel PivotTable API VBA

3. Retrieving Member Properties using MDX in VBA

4. MDX queries Excel and VBA

5. MDX vs. Excel PivotTable API VBA

6. MDX in Excel VBA

7. MDX in Excel VBA

8. Executing MDX with VBA function through VB

9. Request: example of an ODBC connection to btrieve data from Excel VBA

10. Functionality Request: Setting Default Directory (or DB) in MDX-Sample

11. Nationwide-239587--ORACLE-Developer 2000-VBA-Visual Basic-Java-Oracle, VB/VBA, Java Developer

12. Having "HAVING" problems with GROUP BY.


 
Powered by phpBB® Forum Software