Using Cube Action in Pivot Grid | Ranet OLAP

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

  1. Run Samlpe Web Application in Start menu (All programs - Ranet UILibrary.OLAP)
  2. Select tab item Confuguration
  3. Set the connection string in the cube that contains Action. For example:

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. 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.
ranet olap cube action

Figure 1. Configuring Cube Action in Ranet OLAP.

  1. In the Query result Area, select the Cel
  2. Call context menu Show list action.
cube action list

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.
cube action result map

Figure 3. Result of cube action execution.