After forcing an annotation update in OnCommand Insight, you need to select the annotations you want in Data Warehouse and initiate a Data Warehouse build. You can wait until the next scheduled build or initiate a build now.
Procedure
- Log in as an administrator to the Data Warehouse Portal
at https://hostname/dwh, where hostname is the name of the
system where OnCommand Insight Data Warehouse is
installed.
-
From the navigation pane on the left, click Annotations.
The list displays a row for every annotation type and a target object to which the annotation can be assigned. A check mark in the Published column indicates that the annotation was already selected for the particular target object and is already available through the
Data Warehouse data marts.
- Click Edit to edit how annotations will be imported from OnCommand Insight.
- To edit the annotation process, do the following:
For example, if a host is annotated with annotation type floor
and gets the value 1
, and there are 3 rows for that host in the host_dimension table, then selecting Init with Current associates the value 1
in the floor
column for all 3 rows in the host_dimension table. If Init with Current is not selected, then only the latest row for that host will have the value 1
in the floor column.
- Click Save.
A warning message appears indicating that this will cause changes to the structure of the data or data loss, if you are removing annotations.
- To continue, click Yes.
Data Warehouse initiates an asynchronous annotations job that applies the requested changes. You can see the job in the Jobs page. You can also see the changes in the Data Warehouse database schema.