Adaptive Analytics supports the export of Business Intelligence cubes to Adaptive Analytics cubes. The following procedure for cube export assumes that you have already completed all of the configuration described in the previous section. This process does not in any way alter the source Business Intelligence cube.
-
Open a Terminal session on the InterSystems IRIS instance from which you wish to export a cube.
-
Ensure you are in the namespace of the cube you wish to export.
-
Execute the following commands:
set cube = "CUBENAME"
set caltab = "CALENDARTABLE"
set file = "PATH/EXPORTFILENAME"
Where CUBENAME is the InterSystems IRIS BI cube name, CALENDARTABLE is the name of your optional calendar table for managing dates, and PATH/EXPORTFILENAME is the target path of the cube export. The following example places an output file with the cubename and datetime stamp:
set cube = "HoleFoods"
set caltab = "MyCalendarTable"
set file = "/tmp/ cubeExport "_cube_" "_$TRANSLATE($ZDT($h,3)," :","--")_".json"
set sc=##class(%DeepSee.Utils).%AtScaleExportCube(cube,file,caltab)
If no calendar file is used, simply omit the caltab argument from the final command.
Execute the following command to verify that the cube was exported:
write sc
If the export was successful, this command will return the full file path of the resulting .json file. You will need this path for a later step. You may view this file in your text editor or IDE of choice.
-
Log in to your AtScale Design Center and, on the home page, select the Import from InterSystems IRIS Quick Start option.
-
In the modal window, click Browse, navigate to the .json cube file observed previously, and open it. Back in the primary modal window, click Next.
-
From the Data Warehouse and Schema dropdown menus, select the name of the data warehouse you have configured for this project and the appropriate schema respectively. Click Next to perform the import.
-
In the Review Import screen, click Download Report. This report provides details of import performance and recommendations for adjustments to models, if necessary.
-
You may receive warnings on this screen concerning incompatibilities between the structure of the export .json file and Adaptive Analytics's expected data model. These chiefly concern InterSystems IRIS BI calculated measures and drill-throughs due to use of proprietary MDX operations in InterSystems IRIS BI. InterSystems recommends manually reviewing all calculated measures and drill-throughs and adjust them as needed to ensure compliance with Adaptive Analytics's data model. This review process will be outlined in a later step. Click Next.
Additionally, cubes based on data connectors and cube relationships do not export in this process.
-
Set design-time and run-time permissions according to your needs and click Next to finalize the import process.
-
Review your calculated measures and drill-throughs as follows:
-
In the AtScale Design Center, navigate to your Adaptive Analytics project.
-
Click on your imported cube to open it in the Main Canvas.
-
Click on the Calculated Measures tool on the Main Canvas.
-
For each Calculated Measure, click Edit and, in the modal window, click Test MDX. Consult the displayed error messages to determine appropriate adjustments to each MDX definition.
You may now review your imported cube as you would review any other Adaptive Analytics model.