Publisher Description
Ranet.UILibrary.Olap is open source project hosted at
http://code.google.com/p/ranet-uilibrary-olap/
It provides parsing, generating and visualization of MDX language and MDX query results. Moreover it provides data input and Writeback to OLAP cube.
It works under .NET and Silverlight.
It includes:
* MDX Document Object Model (MDX DOM)
* MDX Parser
* MDX Generator
* Description of supported MDX Syntax
* Set of OLAP visual controls for MS Analysis Services
* Dynamic Pivot Grid - Pivot Table with WriteBack ability for arbitrary MDX text query
* MDX Query Designer - visual MDX query builder
* OLAP metadata explorer
* Choice controls: CubeChoice,KpiChoice, MeasureChoice, LevelChoice, MemberChoice, etc
* Samples of use
The MDX Visual Designer is a user control for building MDX queries. MDX Visual Designer provides browsing cube metadata. From the cube Metadata tab you can drag KPIs, Measures, hierarchies, dimensions onto the Filters, Columns, Rows and Data. The MDX Visual Designer automatically generates MDX query which can be edited manually. Design settings can be stored and restored. When you execute the query, the Query result pane displays the resu
PivotGrid is a user control for browsing result sets after executing MDX query. PivotGrid has a number of useful features, like:
* Format cells according to cube settings (BACKCOLOR, FORECOLOR, etc.)
* User settings for cell formatting using icons, indicators, font settings.
* Edit cube data
* Drilldown, collapse and expand data
* Navigation through the history of the queries
* Rotate axes
* Hide empty rows and columns
* Copy data between levels
* Allocation between selected cells
* Scaling table
* Hints for cells
* Export to MS Excel
* Accessing data according to the privileges in SQL Server Analysis Services
PivotGrid provides two modes of editing data:
* Direct editing
* Using cache