Defining Action (rowset type) in SSAS | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Defining Action (rowset type) in SSAS

Hi
I need to build an Action on a measure that belongs to a cube that behaves like a DrillThrough Action that returns details related to a measure.
The problem is that the details data should come from a table that is not inside the cube but it is in an SQLServer relational DB.
So, it is possible to define an Action that could retrieve data from an external DB?
If so, For this action i chose target type as ‘cells’, target object as ‘all cells’ and action type as ‘rowset’ for returning tabular form. But I have to make this action to work on 3 dimension, how I’ll write the Action expression ?? this is where I am stuck at.
Really appreciate the help.
Thank you.

Have you created or defined a data source to this relational databsae?

Hello !
did you receive any answer to your post ?
i now have the same problem, I try to access details from my database (outside the cube), but I don’t know the syntaxis to full ‘Action expression’ !
I would really appreciate your help !
thank’s

Welcome to the forums.
http://msdn.microsoft.com/en-us/library/ms188935(SQL.90).aspx & http://msdn.microsoft.com/en-us/library/ms189378(SQL.90).aspx see any help, further reference is http://sqldb.wordpress.com/2006/06/26/enabling-drillthrough-in-analysis-services-2005-2/ here.

Thanks for your answer, but unfortunately I’ve allready read those documents and didn’t find the answer to my question.
Thanks again !
Fred

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |