Announce: New release Ranet.UILibrary.Olap-1.0.118.0.msi

[Galaktika OpenSource]

Whats new:
October 20, 2009
- Samples: Added UI controls samples
- PivotGrid: fixed bug in Rotate axes. [http://
ranetuilibraryolap.codeplex.com/WorkItem/View.aspx?WorkItemId=5239]
- MdxDesigner: Added designer for calculated members (WITH MEMBER
clause) [http://ranetuilibraryolap.codeplex.com/WorkItem/View.aspx?
WorkItemId=5237]
- MdxDesigner: Added designer for named sets (WITH SET clause)
- DataService: Fully reimplemented. Added exceptions handling.
- MDX: fixed bug in quoted and double quoted strings
- MDX: fixed bug for NON EMPTY keyword in axes clause
- MDX: fixed bug for &key1&key2... unique name parsing
- Installer: English localization

Downloads are available at:
[http://code.google.com/p/ranet-uilibrary-olap/downloads/list]
[http://ranetuilibraryolap.codeplex.com/Release/ProjectReleases.aspx?
ReleaseId=34713]

It is Open Source project which is hosted at
[http://code.google.com/p/ranet-uilibrary-olap/]
[http://ranetuilibraryolap.codeplex.com/]
where you can find all source code.

You are welcome to report bugs and propositions at
[http://code.google.com/p/ranet-uilibrary-olap/issues/list]
[http://groups.google.com/group/ranet-uilibrary-olap]
[http://ranetuilibraryolap.codeplex.com/WorkItem/AdvancedList.aspx]
[http://ranetuilibraryolap.codeplex.com/Thread/List.aspx]


To use libraries you need to have:

On client:
* Silverlight 3.0 compatible browser (i.e. Mozilla Firefox, Google
Chrome, Microsoft Internet Explorer etc.)

On server:
* Microsoft Internet information server (IIS)
* Microsoft SQL Server 2005/2008 with Analysis services
* .NET 3.5

On development computer:
* .NET 3.5 (with MS Build)
* Silverlight SDK 3.0 (more info at [http://silverlight.net/learn/
quickstarts/])
* Adomd client (Microsoft.AnalysisServices.AdomdClient.dll)
* (optionally) WiX - for installer packages build ([http://
wix.sourceforge.net/])
* (optionally) Microsoft Visual studio 2008 SP1 with Silverlight tools
3.0 installed
* (optionally) SharpDevelop 3.1 [http://www.icsharpcode.net/OpenSource/
SD/Download/]
* (optionally) Ranet.BuildTools-1.0 (TFS build integration)

You need to build the sample application before run it.
You can use Visual Studio development webserver or can deploy it to
IIS.
Set "Startup project" to %InstallDir%\Samples\UITest.Web
\UITest.Web.csproj.

Please set correct ConnectionString and Web Services virtual paths on
"Config" tab.

The sample application supposes that you have installed Microsoft
sample datawarehouse database
AdventureWorksDW, you can find it at [http://
msftdbprodsamples.codeplex.com/].
Of course, you can use any other OLAP database.

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.

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

PivotGrid provides two modes of editing data:
* 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/]
* [http://galaktika.ru/en/solutions/galaktika-business-suite/
galaktika-bi/]
* [http://galaktika.ru/en/solutions/galaktika-business-suite/
galaktika-ranet/]

There is another Galaktika Open Source project :
* [http://code.google.com/p/galaktika-spo/]

[jamesT77]

Excellent Work. Can't wait to start using these controls.