Hello,

I understand it should be possible to define a Rowset Action that contains
an SQL query. Unfortunately I can't figure out what the syntax is of an SQL
statement within a Rowset Action.

Could anyone post an example of a SQL query that will function within a
Rowset Action (within the Foodmart 2000 Sales cube) ?

Thanks

Regards,

Mikey

Take a look at the drillthrough syntax in BOL

"DRILLTHROUGH
SELECT [Warehouse].[All Warehouses].[Canada].[BC] ON ROWS,
[Time].[1998].[Q1] ON COLUMNS,
[Product].[All Products].[Drink] ON PAGES,
[Measures].[Units Shipped] ON SECTIONS
FROM [My Cube]"

Note the presence of quotations, this is by design so you can build a
dynamic statement using the dimension member in your cube.

This applies to all action types.



"Mikey" <dekkerm (AT) yahoo (DOT) com> wrote

I've coded a little AS StoredProcedure that executes some SQL code on a server specified by an OLE DB connection string and returns the result as a DataTable. You can CALL it from a Rowset action your client application will be able to interpret it (at least Excel and OWC seem to do so). More information and the DLL here on my blog (sorry it's in french but you can Google-Translate it): http://fjehl.blogspot.com/2009/06/ss...procedure.html

Hope this helps

From http://www.developmentnow.com/g/112_...-statement.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/