help.axcms.netAxinom Logo
Save Save Chapter Send Feedback

Configuration of Reporting Template Project

 

Configuring SQL connections


Please check the SQL connection strings and passwords in

C:\Projects\AxCMS_ReportingSample\Resources_ReportingSample\Configuration\SampleDEV\etl.config

and

C:\Projects\AxCMS_ReportingSample\Resources_ReportingSample\Configuration\SamplePROD\etl.config

make sure that any changes you make for Live System/Management System connections inside your MS.web.config and LS.web.config are also reflected in etl.config

  <SourceConnections>
   <Connection Name="LS" ConnectionString="Data Source=(local);Initial Catalog=AxCMS_Live_ReportingSample;UID=ReportingSample;PWD=AxinomCMS1;"/>
   <Connection Name="MS" ConnectionString="Data Source=(local);Initial Catalog=AxCMS_ReportingSample;UID=ReportingSample;PWD=AxinomCMS1;"/>
   <!--<Connection Name="MC" ConnectionString="Data Source=(local);Initial Catalog=AxCMS_MailCenter;UID=MailCenter;PWD=AxinomCMS1;"/>-->
  </SourceConnections>

  <DataWarehouseConnection ConnectionString="Data Source=(local);Initial Catalog=AxDWH_ReportingSample;Integrated Security=True;" />

  <OlapCubeConnection Server="(local)" Database="Cube_ReportingSample" />
  <!--<OlapCubeConnection Server="(local)" Database="Cube_ReportingSample_MC" />-->


After making changes to configurations, please run


C:\Projects\AxCMS_ReportingSample\Resources_ReportingSample\Deploy\PostBuild.bat


to copy them to appropriate folders.

 

Deploying Cube


NB! If you are running VISTA, please launch all programs listed in this document with:
Right click/Run as Administrator, this is nessesary for them to work normally.




First step is to create a Data Warehouse database based on ETL configuration. To create it, please run

C:\Projects\AxCMS_ReportingSample\AxDWH_Processor\CreateDatabase.bat

After the process completes, open your solution and right click on the cube project you want to use and select Deploy from the context menu.
( we will use Cube_ReportingSample for this solution, but the process is the same for Cube_ReportingSample_MC)

 

After the cube is succesfully deployed, we need to populate it with data from Data Warehouse.

To do this, run the file
C:\Projects\AxCMS_ReportingSample\AxDWH_Processor\RunIntegration.bat

 

Final step is to process the data within cube.

For this, right click Cube_ReportingSample project in your solution and select Process... from the context menu.