What is Ranet OLAP?
Ranet OLAP – Overview Ranet OLAP is an open source set of data visualization controls – powered by Microsoft Silverlight and was written specifically for SQL Server Analysis Services with support for SQL Server. Ranet OLAP is our advanced front-end solution for Microsoft SQL Server Analysis Services. This solution offers the developers of analytical applications unique capabilities for building modern and accomplished software. Using the Ranet OLAP library, you can build a powerful solution having unique features for fast and efficient work with multidimensional data supplied...
read moreMDX Query Builder
MDX Document Object Model (MDX DOM), MDX Parser, MDX Generator Ranet OLAP includes a query builder. We able to parse any MDX expression, including for dimensions hierarchy, formulas, crossjoin etc. MDX parser and generator build Document Object Model (DOM) for MDX expression, similar to Abstract Syntax Tree (AST). A Document Object Model (MDX DOM) is a model of how the various elements MDX expression are related to each other. A MDX query is built by constructing nodes of a tree. This MDX DOM approach for building a query is very effective. MDX Query Builder can do the following...
read morePivot grid. Commands
Pivot grid table commands The pivot grid toolbar includes the following commands: Command Description Refresh Runs the current MDX query and shows the result. Navigate To Begin Navigates to the beginning of the pivot grid query history. Navigate Backward Navigates one item back in the pivot grid query history. Navigate Forward Navigates one item forward in the pivot grid query history. Navigate To End Navigates to the last item in the pivot grid query history. On/Off Editing Mode Enables or disables editing of pivot grid cells. Copy selected sells to Clipboard Copies the...
read moreRanet OLAP Visual Controls
Ranet OLAP is a set of data visualization controls – powered by Microsoft Silverlight for the Microsoft SQL Server platform. Ranet OLAP includes Visual Controls: PIVOT GRID- control shows a summary table which is a result of running the MDX query Sorting – Ascending and Descending sorting can be applied to a row area, column area, or data area in the pivot grid table Members group – grouping data in the row area and column area are in the pivot grid table Show Properties – It can display the property of the dimension member in the table Properties, Custom...
read moreRanet OLAP Solution Overview
Why Use OLAP? OLAP (On Line Analytical Processing) is widely used in business intelligence, data mining and reporting applications that provide complex analysis of data in a short period of time. What makes OLAP such a powerful data analysis tool, and why would you want to use it are question that most people ponder when they are first introduced to this technology. Using OLAP lets you find out: Why one month’s sales were better than another month’s sales? Which product your Sales department selling the most of? The number of employees by department? Where your...
read more