As part of the Cube module, we perform the following transformations to the templated Config and SQL Files:
| Tag | Replaced with |
| TEMPLATE_ENVNAME | The Target Environment Name |
| TEMPLATE_TO_SQLINSTANCE | The Database Server for the Cube Database |
| TEMPLATE_TO_CUBEDM_DATABASE_NAME | The Cube Datamart Database Name |
| TEMPLATE_TO_RCPORTAL_SERVER | The server name where the RC_PORTAL is runnig |
| TEMPLATE_TO_SSRS_URL | The URL to get to SSRS via Web Service |
| TEMPLATE_TO_SSRS_REPORTS_URL | The UR to get to SSRS Reports via a web page |
| TEMPLATE_TO_RCPORTAL_NAME | The name of the Portal (e.g. RCPORTAL_TEST1) |
| TEMPLATE_DB_SERVER | Database Server where the Cube Database resides |
| TEMPLATE_ENV_FOLDER | The Fileshare for the environment where config files are written |
| TEMPLATE_SSIS_LOG_FOLDER | The Log folder (on the enviornment's fileshare) |
| TEMPLATE_SVC_LOGIN | The Service Account used for Cube Services |
| TEMPLATE_EMAIL_SUBJECT | Email Subject for Cube SQL Agent Jobs |
| TEMPLATE_CUBEDM_DBNAME | Cube DataMart Database Name |
| TEMPLATE_CUBEDMSTAGING_DBNAME | Cube Staging Database Name |
| TEMPLATE_CREDITCUBE_DBNAME | Credit Cube Database Name |
| TEMPLATE_POSITIONCUBE_DBNAME | Position Cube Database Name |
| TEMPLATE_CREDITCUBEHISTORY_DBNAME | Credit Cube History Database Name |
| TEMPLATE_ENDUR_DBNAME | Endur / Findur Database Name |
| TEMPLATE_SSIS_SERVER | The server running SSIS |
| TEMPLATE_ENDUR_CREDIT_TRADE_TABLE | The Endur/Findur Credit Table |
| TEMPLATE_ENDUR_POSITION_TABLE | The Endur/Findur Position Table |
| TEMPLATE_CUBE_ACCESS_GROUP | The AD Group that has access to the Cube environment (e.g. CubeTEST1Access) |
In addition, all Environment Wide Setting Options / Environment Wide Settings are reviewed and transformed during these processes.
0 Comments