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 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 moreMDX Designer. Customer Calculation Editor
A built-in Customer Calculations Editor permits the user to create calculated elements and calculated sets on his own. When creating customer calculations elements, the user can use all capabilities offered by the MDX query language (for example, MDX language functions). Creating customer calculation sets can simplify the report design significantly, as customer calculation sets can take into account special features of the report (it can be complex filters or data selection algorithms). It is possible to save the settings and use them later when designing the report. One can use the...
read more