Set Up and Configure BIA Project in IWE

Follow these steps to import the BI Project into IWE Design Studio:

1. Open IWE Design Studio
2. Set the Workspace as required
3. Select File - Import
4. Select General - Existing Projects into Workspace then select Next
5. Select Browse and navigate to ..\Reporting\components\core\etl\CuramBIWarehouse
6. Select OK and Finish - this will import the Data Warehouse Project into IWE

Follow these steps to import the Database Connection Profiles, which were created when running 'build configtest' above:

1. In IWE Design Studio open the Data Source Explorer
2. Select the Import Icon - this will open the Import Connection Profiles window
3. Select Browse and navigate to ..\Reporting\components\core\etl\CuramBIWarehouse\database-connections
4. Import each of the 5 Connection Profiles in turn:
   • curamdb.xml - this contains the connection details to connect to the Source Application Database
   • curamst.xml - this contains the connection details to connect to the Staging Objects on the Central Database
   • curamdw.xml - this contains the connection details to connect to the Central Database
   • curamdm.xml - this contains the connection details to connect to the Datamart Database
   • curamdmo.xml - this contains the connection details to connect to the Demo Data Database
5. After importing the Connection Profiles right click each of the Database Connections in IWE and select Properties to check that their properties are all correct
6. Enter the required password into each Database Connection
7. Right click on each of the Database Connections and select Connect - they should all successfully connect to each of their Databases

The Flat Files Path Variable should have been set when running 'build configtest' above. Follow these steps to check that the Flat Files Path Variable is correctly pointing to the Static Data Files:

1. In the IWE Design Studio Data Project Explorer open the CuramBIWarehouse folder
2. Right click on the Variables folder and select Manage Variables
3. In the Manage Variable window select the CuramBIWarehouse Project and click Next
4. Select the FLATFILES_PATH Variable Group
5. Select the PATH_V Variable and click Edit
6. Ensure that the path is pointing to point at this folder ..\Reporting\components\core\etl\CuramBIWarehouse\package-misc
7. Select OK and Finish