ACTION'S IN SSAS CUBE

  • WHAT ARE THE USES OF ACTION,DRILLTHROUGH ACTION,REPORT ACTION.....

    AND

    HOW TO USE THOSE ACTIONS EFFECIANTLY............

    [font="Verdana"]SRIHARI(:~[/font]

  • Hi,

    I suggest reading various articles, technet and MSDN, pressing F1 in BIDS helps too pointing you into the right direction.

    When to use is defined by requirement..

    Sometimes a user wants to see the underlying detail rows in cell crossing (axis) he can use the DRILLTHROUGH action the see all the rows that result in the value of this cell.

    URL action and member action see my other reply today on another question from you

    Regards Kees

  • Actions are "extended" functions added to cubes by cube designers. They can be attached to many aspects of a cube: members, levels, dimensions, cells and the cube itself. They are triggered when a user, in a client tool clicks on the relevant items and fires up the action. What makes them powerful is that they can be created formulaically - so they can be built using logic and parameters.

    Some pointers on the main actions:

    - DrillThrough Action- brings back the lowest level of detail WITHIN a cube underlying a cell's data

    - URL/Report Action - allows the user to fire up a URL that would take them to a web site. Report actions are more specific for launching a web page with an SSRS embedded in it. The Action builder in BIDS is designed to help you get the Report URL and paramters resolved.

    - Rowset Action - designed for the user to crank a SQL statement and return a flat rowset of data

    - Dataset Action - designed for the user to crank an MDX statement and return a multidimensional dataset

    Your problem is that very few tools provide you with access to these actions. Most tools expose the first 2 only. Excel 2010 and Pyramid Analytics support the top 3 (although rumour has it that Pyramid will suport all 4 in its next release). The Rowset action is particularly useful for returning fact detail behind a cube based on a user's interactive clicks.

    If you decide to build your own tools, accessing Actions can be extremely tough. Its buried deep in the APIs.

    Avi 😉

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply