Optimize Deployment Usage Notes
The purpose of this topic is to help you understand various important points concerning the deployment of Optimize assets in Static DB Schema mode.
There are two prerequisites critical to the successful deployment of Optimize assets to a target Analytic Engine running in Static DB Schema mode:
1. For each deployment set you want to deploy, you must always execute the following operations in this order:
a. Execute the DDL recording stage.
b. Execute all generated SQL statements.
c. Execute the actual deployment stage.
2. Ensure that each asset included in the process is removed or deployed, instead of updated.
The Analytic Engine attempts to remove all assets within each deployment set in reverse order and then attempts to deploy them in the specified order. An asset cannot be removed if there are other assets depending on it.
Here is the Optimize assets dependency graph:
/ Hierarchy \
ILink - Dimension { } KPI - Rule
\ EventMap / / \ DataFilter /
If the Analytic Engine does not run in Static DB Schema mode and some assets cannot be removed, Deployer attempts to update these assets at deployment time. This is not supported by the Static DB Schema mode.