February 11, 2011 at 11:29 pm
I WANTED TO KNOW ABOUT STANDARD ACTIONS IN SSAS CUBE
ACTIONS LIKE..
DATASET
ROWSET
STATEMENT
PROPRIETARY
URL ACTIONS
CAN ANY ONE EXPALIAN THESE WITH ONE EXAMPLE(FOR EVERY ACTION).............
[font="Verdana"]SRIHARI(:~[/font]
February 13, 2011 at 9:18 am
Value Description
Dataset
Returns a Multidimensional Expressions (MDX) statement, representing a multidimensional dataset, to be run and displayed by the client application.
Proprietary
Returns a proprietary string that can be interpreted by client applications associated with the Application setting for this action.
Rowset
Returns a Multidimensional Expressions (MDX) statement, representing a tabular rowset, to be run and displayed by the client application.
Statement
Returns a command string to be run by the client application.
URL
Returns a Uniform Resource Location (URL) string to be opened by the client application, typically with an Internet browser.
A cube is accessed by a client application, for instance ProClarity, Excel, PerformancePoint Server. Some of these applications have the ability to show the results of dataset action by executing the MDX.
A statement and Rowset actions are valid OLE dB commands/statements. A statement should not return any results besides success or failure. Any OLE DB compliant data source can be used (including relational ones).
Proprietary string can be anything that is understood by the client-app.The client app is responsible interpreting the message and do the action.
Regards Kees
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply