locked
How to Query SSAS Data Source View Data Programmatically RRS feed

  • Question

  • I have created a SQL server DataSource and Data source View using AMO. Programmatically , But How to query the data which references in that Data source view?

    Simply I want to extract the data which refer in a particular datasource view and display them in a Grid View.

    Thanks , 

     
    Monday, February 18, 2013 6:35 AM

Answers

All replies

  • Hi Kalinga,

    I am trying to involve someone more familiar with this topic for a further look at this issue. Sometime delay might be expected from the job transferring. Your patience is greatly appreciated. 

    Thank you for your understanding and support.

    If you have any feedback on our support, please click here.

    Regards,


    Elvis Long
    TechNet Community Support

    Wednesday, February 20, 2013 6:04 AM
  • Hi there,

    The data source view is an abstraction used for generating SQL for processing the dimensions and measure groups in the cube, and when designing the cube.  It is not queryable as far as I know.  You may be able to reverse engineer the queries and then 

    To query the data, you would need to have the connection string for the data source and use programmatic access.  Otherwise you could expose the data using drillthrough or Analysis Services Stored Procedure Project (ASSP) add-in if it is contained in a cube.

    http://www.solidq.com/sqj/JournalDocuments/Business_Intelligence/SSAS-Cube-Exploration-Digging-Through-the-Details-with-Drillthrough.pdf

    http://asstoredprocedures.codeplex.com/releases/view/79180

    cheers,

    Andrew


    Andrew Sears, T4G Limited, http://www.performancepointing.com

    Wednesday, February 20, 2013 6:08 PM
  • Hi,

    You can use named query: http://msdn.microsoft.com/en-US/library/ms175683%28v=sql.90%29.aspx

    Some samples:

    - http://technet.microsoft.com/en-us/library/cc505861.aspx

    - http://www.sql-server-performance.com/2012/adhoc-reporting-using-ssrs-2008-r2/3/


    Regards,
    Christian HL
    Microsoft Online Community Support


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.


    Thursday, February 21, 2013 1:14 AM