How to assign Adomd Datasource to RDLC??
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
April 14th, 2010 1:35am
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 tglich http://olafhelper.over-blog.de
April 14th, 2010 7:46am
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
April 14th, 2010 2:05pm
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 tglich http://olafhelper.over-blog.de
April 14th, 2010 2:30pm
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 one4: 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
April 14th, 2010 8:42pm
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).aspxIf there is anything unclear, please feel free to ask.Thanks,Jin ChenJin Chen - MSFT
April 15th, 2010 2:37pm
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.
June 22nd, 2011 7:33pm