|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
March 31st, 2004, 08:15 AM
|
|||
|
|||
|
OLE DB Provider for OLAP Services
I need to be able to pass a parameter into a MDX query. Using the MDX utility I do not see a way. I was wondering if there was a way to modidy the OLAP driver to pass the parameter in on connection. Thanks
|
|
#2
April 1st, 2004, 04:15 AM
|
||||
|
||||
|
What are you trying to do?
Do you have a custom application or an Excel macro that needs to set a parameter and issue an MDX query against Ms Analysis Services?
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#4
April 2nd, 2004, 02:32 AM
|
||||
|
||||
|
As the MDX query is just a string you can put a parameter into it and set it's value, like a standard SQL query.
But I would check if this can't be solved through the standard user profile management of Ms AS where you can restrict access to data.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > OLE DB Provider for OLAP Services |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
