locked
How to assign Adomd Datasource to RDLC?? RRS feed

  • Question

  • Trying to create a RDLC based on cube data, however I cannot locate how to go about doing this. I can create a Datsaset when configuring things for the RDLC report and point that the an analysis services server, but the data that comes up is a list of the warehouse relational source tables for the cube and I'm not getting an interface to create an MDX query.

     

    If this has to be done programatically, are there any code samples out there, or is there a tutorial that i have just not been able to find?

     

    Thanks!!


    --ACG
    Tuesday, April 13, 2010 10:35 PM

Answers

  • Hi ACG,

    If I understand correctly, you have created dataset using Adomd object. Now, your question is how to assign this dataset to a local report.

    A local report does not contain a "query", because local report receive data from a dataset. If you have created the dataset, we can assign the dataset for the report directly.

    For more information about how to assign a dataset for a report, please see "How to Add Data Sources for ReportViewer Reports" in the following Microsoft Web site:
    http://msdn.microsoft.com/en-us/library/ms252094(VS.80).aspx

    If there is anything unclear, please feel free to ask.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Thursday, April 15, 2010 11:37 AM

All replies

  • Hello ACG,

    In your datasource, did you select "Microsoft SQL Server Analysis Services" as typ? If so, you can address a AS database + cube you like to run MDX queries.


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Wednesday, April 14, 2010 4:46 AM
  • Thanks for your reply! When I create a dataset I select datasource type as OLE DB Analysis Services. But like I say, it it seems all I get is tables prefixed with '$' and I don't get any fact tables.

     

    Again all I want to do is the setup of a RDLC as with SQL but instead use Analysis Services source. This should be easy, right?


    --ACG
    Wednesday, April 14, 2010 11:05 AM
  • Yes, it easy and of course it works.

    Even when I select "OleDB" => "Microsoft OLE DB Provider for Analysis Services 9.0" (Provider=MSOLAP.3;) I can onyl connect to SSAS and select SSAS databasese, not "tables". If you see tables with $ prefix it sounds more like Excel as datasource with datasheets as tables; they come along with $.


    Olaf Helper ----------- * cogito ergo sum * errare humanum est * quote erat demonstrandum * Wenn ich denke, ist das ein Fehler und das beweise ich täglich http://olafhelper.over-blog.de
    Wednesday, April 14, 2010 11:30 AM
  • OK, this is what i did.

     

    1: Create new Report Project with an RDLC report.

    2: In the wizard, I set DS type to OLE DB Analysis Services(MSOLAP.4)

    3: I can see the cubes there as expected, and I select one

    4: The objects I get are a set of Tables, $Product, $Site, $TableX (no Fact tables are listed)

    There is no excel connection or anything like that, just connection to a cube.

     

    Is this correct, is all I can get the Dimension tables in the cube? Also it seems that there's no MDX involved, it's all SQL style queries. Is there a good explanation for this?


    --ACG
    Wednesday, April 14, 2010 5:42 PM
  • Hi ACG,

    If I understand correctly, you have created dataset using Adomd object. Now, your question is how to assign this dataset to a local report.

    A local report does not contain a "query", because local report receive data from a dataset. If you have created the dataset, we can assign the dataset for the report directly.

    For more information about how to assign a dataset for a report, please see "How to Add Data Sources for ReportViewer Reports" in the following Microsoft Web site:
    http://msdn.microsoft.com/en-us/library/ms252094(VS.80).aspx

    If there is anything unclear, please feel free to ask.

    Thanks,
    Jin Chen


    Jin Chen - MSFT
    Thursday, April 15, 2010 11:37 AM
  • I too am mystified as to how to do this.  It's so easy in RDL.

    In 'Choose the Dataset' dialog box no SSAS data providers are listed when you click "New..." (Data source) .  Yet I've been busily creating BI projects and using ADOMD and other MOLAP providers for over a year now.

    I'm beginning to think that connecting to an OLAP cube from an RDLC file isn't possible.

    In this link I can't see the wood for the trees http://msdn.microsoft.com/en-us/library/ms252094(VS.80).aspx.  There is nothing relating to cubes.

    I can quite happily connect to SSAS from within Excel.

    Wednesday, June 22, 2011 4:33 PM