by Galaktikasoft | Mar 18, 2011 | Ranet OLAP Blog |
If the cube supports editing (the dimension group has a ssas writeback partition) it is possible to use the Pivot Grid table in the editing mode to make changes to the cube data directly. The table section accessible for editing is highlighted with yellow background... 
by Galaktikasoft | Mar 18, 2011 | Ranet OLAP Blog
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 it can be converted into a typical query containing two axes (rows and columns). Often it is... 
by Galaktikasoft | Mar 18, 2011 | Ranet OLAP Blog
OLAP is great for aggregating data and hiding all of the database details. There are times when you want to know where values in some OLAP cells come from. Drill Through lets you retrieve the underlying rows in the database that give the cell its value. The OLAP... 
by Galaktikasoft | Mar 18, 2011 | Ranet OLAP Blog
Properties and Custom Properties commands show properties of a dimension member or cell, and their current values, in a special window. For a cell, it can display system properties and cortege structure (Tuple) with the current values. For a dimension member, both... 
by Galaktikasoft | Mar 18, 2011 | Ranet OLAP Blog
Ranet OLAP pivot table Show Properties command is called from the context menu in the row area. It can display properties of the dimension member in the table. With this command, it is possible to show or hide all dimension properties at once or show or hide... 
by Galaktikasoft | Mar 18, 2011 | Ranet OLAP Blog
Ranet OLAP pivot grid Members group mode includes commands that allow grouping data in the pivot grid table. Members in the row area and column area are grouped. The following grouping options are available: (None) - the data are not grouped, only the MDX query result... 
by Galaktikasoft | Mar 18, 2011 | Ranet OLAP Blog
Ranet OLAP pivot table sorting option includes commands for sorting data in ascending and/or descending order. Users can additionally configure sorting parameters. Sorting can be applied to a row area, column area, or data area in the pivot table. Sort Options allow... 
by Galaktikasoft | Mar 16, 2011 | Ranet OLAP Blog |
Ranet OLAP visual controls 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.... 
by Galaktikasoft | Mar 16, 2011 | Ranet OLAP Blog |
To use Ranet OLAP pivot table, you need to have: On the client: Microsoft® Silverlight™ 3.0 compatible browser (i.e. Mozilla Firefox, Google Chrome, Microsoft Internet Explorer etc.) On the server: Microsoft® Internet information server (IIS)... 
