I need to pass parameter to the cube before it can be processed. Is there
any way to do this? Can cubes execute stored procedures?


Thank you!

Not really. Could you explain why would you want to do that? Perhaps
partitions can help you. Or setting permissions?

MC
"she" <she (AT) discussions (DOT) microsoft.com> wrote

The cube will eventually be used to present a search result back to the user.
Since the current web page take a very long time to load the report back
after input parameters, I was thinking to rebuild the webpage by getting data
from a cube that will take search criteria such from '11/1/2000' to
'11/1/2004'. Ideally the cube take these parameter and then process the cube
and present the data that was dated from '11/1/2000' to '11/1/2004' with the
search result on the website.

Thnak you!

"MC" wrote:

As far as I can see, you're having performance problems . I dont however
understand whats wrong with MDX query that filters the results between those
two dates? Are you having problems with MDX query or something else?

MC
"she" <she (AT) discussions (DOT) microsoft.com> wrote

Thank you for your reply. The current situation is this:
The company website presents the result sets from more than 10 user input.
Users may or may not input parameters to get the results, such as date from
'anydate' to 'anydate'. The site has severe performance issues because we do
not know what parameter a user might input to get the result. If a user
input all the parameters, it took 1 minute to get the result page presented
to the user. I was requested to use data warehouse to improve the
preformance. However I do not know if a cube will take user's input or
parameter. And I do not know if MDX will take user input.
Dose a MDX query use the following sytax?
where date between @userinputdatefrom and @userinputdateto

Thank you very much!

"MC" wrote:

Well MDX doesnt really have parameters. But you can build a string using the
provided parameters and then execute it as an MDX.
For your example you could use WITH SET to make a set from startdate to end
date and then use that set in the select part of the query. Something like

WITH
SET [DateFilter]
AS
'{datestart: dateend}'--- here youn need to specify dates

SELECT
{[dateFilter]} on ROWS,
{[Measures].[Result]} on COLUMNS

FROM
CUBENAME


If you need more help, feel free to send me more details.


MC


"she" <she (AT) discussions (DOT) microsoft.com> wrote