MDX 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 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 morePivot Grid. Show MDX
Show MDX The Show MDX command displays the MDX query generated as a result of design, or prepared manually by the user, in a special window. If the query contains more than two axes, then it can be converted into a typical query containing two axes (rows and columns). Often it is convenient for debugging the query. For example, Microsoft Management Studio does not show the MDX query result if the query has more than two axes. Then it is necessary to modify the query manually. The MDX query can be copied to the clipboard. Figure: MDX query view window In addition, it is possible to...
read moreRanet OLAP Visual Controls Overview
Visual elements that are included with the Ranet OLAP library offer strong functionality and excellent design. This intuitive and easy-to-master tool does not require technical knowledge or programming skills from the user. It can meet business analysis requirements of the most demanding users. Unlimited analytical possibilities offered by Ranet OLAP library components enable the user to view the data from various angles. They help reveal business development trends that could have gone unnoticed or seemed of no importance. The visual elements included with the Ranet OLAP library helps to...
read more