Muthuselvi
Top achievements
Rank 1
Rank 1
Muthuselvi
asked on 20 Jan 2012, 01:45 PM
By using the Cube Data Source Component (SSAS) how to retrive the data in order to bind the Crosstab wizard in Telerik Reporting Q2 2011 using Vb code. I need the Explation in detail.
3 Answers, 1 is accepted
0
Hello,
We recommend utilizing the CubeDataSource Wizard for this purpose. Relevant information on using the CubeDataSource Component is available in the following articles:
Greetings,
Steve
the Telerik team
We recommend utilizing the CubeDataSource Wizard for this purpose. Relevant information on using the CubeDataSource Component is available in the following articles:
- Configuring your project for using Microsoft Analysis Services
- Connecting the CubeDataSource component to an OLAP database
- Selecting data from an OLAP cube with the CubeDataSource component
- Specifying query parameters with the CubeDataSource component
Greetings,
Steve
the Telerik team
Q3’11 of Telerik Reporting is available for download. Register for the What's New in Data Tools webinar to see what's new and get a chance to WIN A FREE LICENSE!
0
Prashant
Top achievements
Rank 1
Rank 1
answered on 21 Oct 2013, 05:42 PM
Hi,
Somebody told me that there is some kind of a data connector from Telerik, probably another installable package, which when used with Data Cubes removes the need for writing MDX queries to fetch data from the Cube. Instead, it enables using simple T SQL to fetch data.
Is this correct? I tried searching for such a data connector but have been unlucky so far.
Please let me know.
Thanks.
Prashant Sharma
Somebody told me that there is some kind of a data connector from Telerik, probably another installable package, which when used with Data Cubes removes the need for writing MDX queries to fetch data from the Cube. Instead, it enables using simple T SQL to fetch data.
Is this correct? I tried searching for such a data connector but have been unlucky so far.
Please let me know.
Thanks.
Prashant Sharma
0
KS
Top achievements
Rank 1
Rank 1
answered on 24 Oct 2013, 12:13 PM
Hi,
The CubeDataSource works with MDX queries. As an alternative the cube can be accessed within a stored procedure (http://stackoverflow.com/questions/504728/sql-query-cubes) and used with an SqlDataSource, or in code (http://www.c-sharpcorner.com/uploadfile/shinuraj587/querying-sql-cube-from-net-application-using-stored-procedure/) and used with ObjectDataSource. In all cases things pass through MDX.
-KS
The CubeDataSource works with MDX queries. As an alternative the cube can be accessed within a stored procedure (http://stackoverflow.com/questions/504728/sql-query-cubes) and used with an SqlDataSource, or in code (http://www.c-sharpcorner.com/uploadfile/shinuraj587/querying-sql-cube-from-net-application-using-stored-procedure/) and used with ObjectDataSource. In all cases things pass through MDX.
-KS