It would be generous to characterize my feelings about the automatic tier annotation defaults in OCI as "doubtful". I suggest you carefully purge them.
First, go through the Annotation Rules and remove all of the rules that you or your customer did not create. Take note of what rules you've removed, and what objects they apply the tier annotation to.
Next, look at all of the objects to which unnecessary tier annotations may have been applied, find all of the unwanted tier annotations, and remove them. This will include, but may not be limited to:
- internal volumes
- storage pools
- storage arrays
- volumes
Now your OCI database should be free of unwanted tier annotations.
Once you do an ETL, the Inventory Mart of your DWH will be free of them as well.
Cleaning up the other data marts is a tougher question. For all time-series entries prior to this point, the old, unwanted tier annotations will be present. You have two options:
- Remember not to do reports using historical data that begins prior to this date
- Reset your Data Warehouse database and start fresh from this date
- Reset your Data Warehouse database and do a "build from history" and "init with current" to get your current annotations applied to some amount of history
When naming tiers, it may be a good idea to provide site-specific tier names. For instance, "Acme Tier 1" for customer Acme. This will make it easier to identify and destroy the default tier annotations.
As always, better ideas are welcome.