Formatting columns at OBIEE is easy.
However, during the migration of catalog from one environment to other, these column formattings are lost as the conventional migration process only covers RPD and Catalog migration.
Mentioned below is set of small work around to achieve this:
1. Apply required formatting in any column and save it as ‘System Wide Default’
2. Once the column formats are saved as default, a entry is made in the system file. This system file is located in : Root Folder->System->Metadata. The name of the file will be same as Subject Area.
3. BI Coach Tip: This metadata folder is not easily editable. Thus, open the catalog of your target environment in offline mode.
4. Go to the same folder location in Target Environment as mentioned in Step 3
5. Paste the File (named as per your Subject Area) from Source to Target Catalog.
6. Restart the BI at target Location.
7. Your first race is won
Happy Learning!!
No comments:
Post a Comment