All geek questions in one place

Best option for retrieving Anaylysis Services Cube (SSAS) data dynamically in ASP.NET MVC

I need to dynamically add / remove dimensions and facts in a web application and get results from SSAS. The cube in SSAS is defined and ready to use. So far, the best idea I've found is to use MDX queries to retrieve metadata from an SSAS cube and display that data on a web page. Then the user can select the necessary measurements / facts, and I need to calculate the dynamic MDX query and get the results from SSAS. Communication with SSAS is done using AdomdDataReader. Are there any better options for solving this problem that requires less effect? It is possible to use Reporting Services (SSRS) in some way.

+4
source share
2 answers

Do you mean that you need to dynamically modify the structure of the cube? If so, this can be done using AMO: http://msdn.microsoft.com/en-us/library/ms345093.aspx

If you need to create a GUI for MDX queries, check the following: http://ranetuilibraryolap.codeplex.com/

This is not specific to ASP.NET (supported by Silverlight), perhaps you can reuse part of the code.

0
source

You have many options:

  • Use LINQ + ADO.NET Entity Framework + SSAS Entity Infrastructure Provider is the easiest way, especially if you need ASP. NET code depends on SSAS data. Some data grids, such as ASPxGridView, will allow users to reorder columns, filters, and row order and dynamically generate LINQ changes in response to user actions.

  • ADOMD.NET + MDX - you can do it this way if you know MDX very well, but there is a lot of work for the dynamic interface, and I do not recommend this option if # 1 can do work, especially if you need ASP.NET code that depends from SSAS / ADOMD.NET data (MDX + ADOMD.NET does not provide type security, does not support refactoring and unit testing).

  • (This is not MVC, but a regular ASP.NET parameter). For maximum user level flexibility, use Pivot Grids such as XtraPivotGrid - your users will be able to move rows to columns and back, change filters and order and the pivot grid will generate a modified MDX for you. Again, I do not recommend this option if you need ASP.NET code that depends on this data.

(I work for Agile Design LLC, the company that created the SSAS Entity Framework provider )

EDIT: in the comment below: -Yes, the SSAS Entity Framework provider works with ASP.NET MVC and WebForms. MSI includes a demo web application.

+5
source

Source: https://habr.com/ru/post/1344231/

More articles:


All Articles