Elaborating on Olap Grid
View PDF | Print View | Html View
Written by: famous16
Total views: 1 |
Word Count: 609 |
Date: Tue, 23 Feb 2010 |
0 comments
Olap Grid on ASP.net is a control that renders the OLAP data which use DHTML tags. It may run on HTML version but it can be used perfectly nonetheless. It must be used alongside the RIA Olap Grid so that the data set objects, as well as the rows and columns, can easily be interpreted. There is a lot of interaction going on for the end user. Along with the specific features of the Olap Grid, you can set up the visuals in order to make the presentation more engaging.
The software lets you control the Grid cell contents along with the web style. There is a possibility to replace the cell’s content with an HTML code of your choice. You can test the flexibility of the following formats on your OLAP grid: BMP, CSV, GIF, HTML, JPEG, PDF, PNG, TIFF, TXT, XLS, and XML.
If you look closely into the program, you would see that all the Grid operations, such as sorting, filtering, grouping, drilling, and pivoting are performed in the AJAX mode. You don’t need any special AJAX library. You can turn to Silverlight technology for the controls that you could use. This will make it flexible for you. The Grid has different pop up menus that let you view the data set objects and rows and columns. The menus are context-dependent and there are special options for the Olap Grid. It depends on the content and the cell type. Either way, you can set these up so that you can make it appropriate for the event that you are preparing for.
A feature that is made available for the Olap Grid is the Time Intelligence. If the current Cellset has one or more than one dimensions, then there is an additional option that is available for you. The pop up menus then allow you to compare the values for each time period. It will also let you use the cumulative sum that is specified in the given data. The rows and columns make it easy to figure out the figures.
Another feature of the Olap Grid that is quite effective for the users is the RadarCube. The core has the detailed and well documented API that is needed in the program. This allows you to perform any OLAP-slice modification within your application. You can also get information about the Cube or the Grid Cell. Just create your own aggregation functions. Define your own rules by calculating the dimension members. You can also sort and filter the content. The Olap Grid separates the set objects that you need for the report that you are creating.
The other features that you can take advantage of with the Olap Grid are the 100% managed code, all ASP.net advantages, fixed columns and rows, web browsers, the Client side operating systems, and the three types of hierarchies. You should know as much as you can on these hierarchies. There are differences among the attribute, parent-child, and multi-level. The Olap Grid gives you the ability to make additional calculated measures on the client and the server side by using the information from the fact table and aggregated cube cells.
About the Author
Here you will learn more about Olap grid and data set objects
Source: Elaborating on Olap Grid
http://www.financebusinessarticles.com Rating: Not yet rated
