| Author |
Does data warehouse take parameters?
|
|
|
| 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@discussions.microsoft.com> wrote in message
news:49850743-E919-4C3F-9FD6- 781677FEF8EA@microso
ft.com...
>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!
>
| |
|
| 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:
> Not really. Could you explain why would you want to do that? Perhaps
> partitions can help you. Or setting permissions?
>
> MC
> "she" <she@discussions.microsoft.com> wrote in message
> news:49850743-E919-4C3F-9FD6- 781677FEF8EA@microso
ft.com...
>
>
>
| |
|
| 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@discussions.microsoft.com> wrote in message
news:59B3B77F-F11B-419B-B491- 7A74BF8239A3@microso
ft.com...[color=darkred]
> 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:
>
| |
|
| 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:
> 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@discussions.microsoft.com> wrote in message
> news:59B3B77F-F11B-419B-B491- 7A74BF8239A3@microso
ft.com...
>
>
>
| |
|
| 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@discussions.microsoft.com> wrote in message
news:BF8E39F5-BA7A-4A34-900D- 7549C1A16DB9@microso
ft.com...[color=darkred]
> 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:
>
|
|
|
|