Create SQL Views using DRDC via Export Cube

Prerequisite:

In order for DRDC to work properly, one must take note of the following:

• The PowerOLAP database must be opened or running on a PowerOLAP Server. DRDC feature will not work when using a database locally.
• You must begin by creating Export Cube tasks before you can create SQL views using the DRDC function from the Export Cube Tasks dialog
  
  
  

Create a new SQL View from saved PowerOLAP Slice via DRDC

This will demonstrate how you can create SQL directly from the Export Cubes Dialog using the DRDC feature.

This is similar to the DRDC option in the Slice tab or the PowerOLAP ribbon, where it will send the data into a SQL View. However, this differs in how data is sent to the SQL Server. Whereas the DRDC in Slice tab sends out the exact PowerOLAP Slice to SQL Server, the DRDC option in Export Cube Tasks dialog works just like an export factdata. But instead of the export cube task being sent to a text file, it is sent to a SQL View.

Using this process, you must ensure that there is an existing export cube task for the Cube you want to generate the SQL views from. Then you need to identify the source cube from which the SQL views will be generated from by selecting from the list of available Export Cube Tasks before clicking the DRDC button.

Assuming that there are existing Export Cubes tasks created, create an SQL view from the Current Year Model cube as follows:

1.  Launch PowerOLAP application and open the corresponding database. The database must be running in a PowerOLAP Server.

UsingPO database running in PowerOLAP Server

2.   From PowerOLAP, go to the Data tab and click the Export Factdata command icon.
This will bring up the Export Cube Tasks dialog.

3.   Select an export cube task from the list corresponding to the cube from which you wish to create an SQL view from.
As in the example, select Current Year Model data.

4.   Click the DRDC button.
The DRDC dialog appears.

You will need to enter the required information in this dialog.

5.   Select whether to connect to the SQL Server via Windows Authentication (by ticking the checkbox) or by providing a valid SQL user and password.

6.   Enter the <display name of the view> that you will create into the SQL Server.

7.   Click OK.

As a result, a new SQL view will be created in the specified SQL Server. When you expand the corresponding database, and expand the views, you will see the new view created in there.

Notes


It is recommended to use SA SQL credentials to connect to SQL Server using the DRDC feature as this has full permissions.