by Galaktikasoft | Mar 15, 2017 | Ranet OLAP Blog
Ranet OLAP Pivot Table allows users to not only analyze actual data for reporting, planning, and budgeting but also perform what-if analysis for studying different scenarios by changing values in the pivot table and seeing how they influence the cube data. This...
by Galaktikasoft | Apr 3, 2013 | Ranet OLAP Blog
This article will tell you how to edit data in Ranet OLAP Pivot Grid. Part 1. Setting up the Writeback partition for the database Start SQL Server Business Intelligence Development Studio (BIDS) application from the Windows menu. In order to connect to the Adventure...
by Galaktikasoft | Sep 27, 2011 | Ranet OLAP Blog
Let's briefly overview features of the dynamic pivot grid included in the Ranet OLAP library. Ranet OLAP Pivot Grid is comprised of: Toolbar, Cube Metadata area, Report Structure area, MDX Query area Pivot Grid area showing the result of the query. We shall use...
by Galaktikasoft | Apr 21, 2011 | Ranet OLAP Blog
Ranet OLAP pivot grid without cell styles settings in the designer: Pivot grid cell styles designer window: Pivot grid with cell styles...
by Galaktikasoft | Apr 7, 2011 | Ranet OLAP Blog
Ranet OLAP pivot grid control presents multidimensional data in a two-dimensional table while providing a variety of features related to editing and sizing. How does the Pivot Grid behave when using different sizing and orientation options? Sizing and Scrolling When...
by Galaktikasoft | Mar 25, 2011 | Ranet OLAP Blog
When analyzing data, the MDX query from the pivot table designer is sent as a parameter used to initialize the whole pivot table. In the pivot table, the MDX query is parsed and modified when needed. For instance, the history of the user commands can be used to...
by Galaktikasoft | Mar 23, 2011 | Ranet OLAP Blog
Ranet OLAP pivot table 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...
by Galaktikasoft | Mar 18, 2011 | Ranet OLAP Blog
Change filter command in the MDX Designer calls a filters setup dialog allowing to modify the filter, where a list of elements included in the report is determined. Filter Type: Label Filter Value Filter Top N All three types of filters are shown in the figures...
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...