In order to use Cube Action in Ranet OLAP Pivot Grid:

  1. Run Sample Web Application in Start menu (All programs - Ranet UILibrary.OLAP)
  2. Select tab item Configuration
  3. Set the connection string in the cube that contains Action. For example:
1
2
3
4
5
OLAPConnectionString Provider=MSOLAP.4;
Integrated Security=SSPI;
Persist Security Info=True;
Initial Catalog=Adventure Works DW;
Data Source=.SQL2008R2;
  1. Apply the changes by clicking Set OLAPConnectionString and check.
  2. The example uses action type URL for Cell. If such action is not in the cube, then run SQL Server Business Intelligence Development Studio (BIDS) and override Target type. Save the changes.
  3. Select Channel Sales cube. Configure the report by choosing hierarchy [Geography] etc.[City]. Execute MDX query.
Figure 1. Configuring Cube Action in Ranet OLAP.

Figure 1. Configuring Cube Action in Ranet OLAP.

  1. In the Query result Area, select the cell
  2. Call context menu Show list action.
Figure 2. Action List Control.

Figure 2. Action List Control.

  1. This opens a window with a list of actions. Select action and click Start URL.
  2. The link with the city on the map will open.
Figure 3. The result of cube action execution.

Figure 3. The result of cube action execution.

Write US