Query Data Source in Cube Action


  • Hi,

    I'm trying to create a Statement or Rowset Action in a ssas cube to query the data source. The cube has only the sumarization to encrease performance, but our clients need to see those records that originated the aggregation. My data source is Oracle 11g.

    Can anyone post a example of a action code to do this?

    Thank you very much.

    Marcus Rehm

    Actually I found this project that do what I need.

    Analysis Services Stored Procedure Project:

    • Edited by Marcus Rehm Wednesday, August 28, 2013 2:27 PM
    Wednesday, August 28, 2013 12:46 AM


  • Hi Marcus,

    Based on the description, you have solved this issue. Thanks for sharing this, it will benefit for other community members who have similar issue.

    I will close this thread, please feel free re-open it if you have any question.

    Best Regards,

    Elvis Long
    TechNet Community Support

    Monday, September 02, 2013 1:17 PM