Re: Can I bind MDX queries

From: Milind (milind.bhabal_at_gmail.com)
Date: 02/09/05 

Date: 9 Feb 2005 10:40:06 -0800

You can write the MDX query in a Stored procedure and use Dynamic SQL
to build that query based on the parameters from your front end
application. Then you can execute this query by openrowset (in SQL
Server) with a linked analysis server. The stored procedure will return
a dataset and that you can bind it in your asp.net front end. Please
let me know if you have additional questions

HTH

Milind

Relevant Pages

  • Re: Database Engine Tuning Advisor suggestion to replace syntax.
    ... stored procedure, the user needs EXECUTE rights to the stored procedure. ... Query 1 requires the user to have SELECT rights on the Customers ... Also, FWIW, the dynamic SQL is only syntax checked at run time, not when the ...
    (microsoft.public.sqlserver.tools)
  • Re: order by problem with stored procedure
    ... :> I try to short dinamically the result my stored procedure. ... only values can be passed to a query via variables (whether the query is in ... DYNAMIC SQL means (see NATIVE DYNAMIC SQL in the PL/SQL Users Guide -- you ... if the host variable:ob_col contains the value 'ENAME' ...
    (comp.databases.oracle.misc)
  • Re: set a select statement stored in a table in a variable
    ... You do not require a dynamic sql statement to use a variable after = clause. ... > Inside a stored procedure I want to set ... > into a variable and then execute it using ... > the query I get the statement ...
    (microsoft.public.sqlserver.programming)
  • Re: Query question
    ... dynamic sql inside of a stored procedure. ... that allow any string as a substitute. ... The query execution plan can be reused. ...
    (microsoft.public.sqlserver.server)
  • Re: noise words, @@ERROR, and stop and resume indexing
    ... > Noiseword varcharNot Null ... > the data from the noise file to the noise_words table. ... >> A clause of the query contained only ignored words. ... >> into query analyzer before starting the stored procedure. ...
    (microsoft.public.sqlserver.fulltext)
Quantcast