Visit our new official web-site http://silverlight.galantis.com/

We have released a new version Ranet OLAP v2.4.4

It includes the following enhancements:

• Support Silverlight 5 platform
• Support Windows 7 (x86, x64)
• Support Microsoft Internet Information Server 7
• Supprt Microsoft SQL Server 2008 R2
• At installation Ranet.UILibrary.OLAP the installer automatically creates Web application in Default Web Site also adjusts it for correct work with an example entering into the delivery complete set
• Support of work with local cubes
• Local cube Finance.cub is included in installer
• Examples are established in the catalog: Documents and Settings\All Users\Documents\Ranet.UILibrary.Olap-2.2 Samples
• Example of use, adjustment of context menu
• Fix MDX syntax http://code.google.com/p/ranet-uilibrary-olap/issues/detail?id=17
• Some bugs and regressions fixed

You can download Ranet OLAP v2.4 from the official web-site!

Ranet.UILibrary.Olap is Silverlight UI component library for 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

Ranet.UILibrary.Olap is a component library for OLAP.

Welcome to Ranet.UILibrary.OLAP project

Ranet.UILibrary.OLAP provides user interface for building MDX queries, parsing and executing MDX queries, browsing result sets and even changing cube data. Ranet.UILibrary.OLAP works under Firefox, Chrome, IE, with SQL Server Analysis Services 2005/2008, uses .NET 3.5 and Silverlight 3.0.

MDX Visual Designer overview

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 results for the MDX query using PivotGrid user control.

PivotGrid overview

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

• Direct editing
• Using cache

Ranet.UILibrary.OLAP video tutorial: http://www.youtube.com/watch?v=dDNa3D8RO4Y

You can find more info about project owner at

• http://galaktika.ru/en/