dbTalk Databases Forums  

passing parameters to an OLAP cube

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss passing parameters to an OLAP cube in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Elie Khammar
 
Posts: n/a

Default passing parameters to an OLAP cube - 12-03-2003 , 05:34 PM






Hi There,

I'm trying to pass parameters to an OLAP cube.
I have my cube in a pivottable displayed in a browser. And
I want to give the possibility for the user to enter two
dates and automatically the cube will change to display
data according to these two days.

What's the best way to do it ? IS it by using DSO or MDX ?
And if you have some samples or a good book I'll really
appreciate that.

Thanks

Reply With Quote
  #2  
Old   
Tom Chester
 
Posts: n/a

Default Re: passing parameters to an OLAP cube - 12-03-2003 , 07:36 PM






Via MDX, though it depends on your client if this is possible.

tom @ the domain below
www.tomchester.net


"Elie Khammar" <ekhammar (AT) positron (DOT) qc.ca> wrote

Quote:
Hi There,

I'm trying to pass parameters to an OLAP cube.
I have my cube in a pivottable displayed in a browser. And
I want to give the possibility for the user to enter two
dates and automatically the cube will change to display
data according to these two days.

What's the best way to do it ? IS it by using DSO or MDX ?
And if you have some samples or a good book I'll really
appreciate that.

Thanks



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.