...
Oracle BI WebCatalog objects are deployed in specified structure. Additionally, there are few different types of objects available in Oracle BI WebCatalog. When sourcing from source code repository, FlexDeploy Oracle BI plugin requires that developers download and commit files in matching folder structure and with appropriate extension.
Oracle BI (Oracle Business Intelligence in pre-5.5.0.1) project type:
Objects stored in source code repository should be named with the following extensions.:
| Object Type Code | Object Type Name | File Extension in Source Control |
|---|---|---|
| FOLDER | Folder | .fldr |
| ANALYSIS | Analysis | .anlys |
| DASHBOARD | Dashboard | .db |
| DASHBOARD_PROMPT | DashboardPrompt | .dbp |
| REPORT | Report | .rprt |
| DATAMODEL | Datamodel | .dm |
| STYLE_TEMPLATE | StyleTemplate | .st |
| METADATA | Metadata | .md |
| KPI | KPI | .kpi |
| FILTER | Filter | .flt |
Oracle BI 2.0 project type. @Since 5.5.0.1
Objects stored in source code repository should be named with the following extensions:
OBIEE Type Name | OBIEE Signature / Composite Signature* | Source Control Extension |
|---|---|---|
| Action | action | Action |
| Agent | coibot1 | Agent |
| Analysis | queryitem1 | Analysis |
| Column | cosavedcolumn1 | Column |
| Condition | condition1 | Condition |
| Dashboard | dashboardfolder1 | Dashboard |
| Dashboard Prompt | globalfilteritem1 | Dashboard Prompt |
| Data Model | .xdm * | Data Model |
| Filter | filteritem1 | Filter |
| Group | customgroup1 | Group |
| KPI | kpi1 | KPI |
| KPI Watchlist | scorecardkpiwatchlist1 | KPI Watchlist |
| Mobile App | .xma | Mobile App |
| Report | .xdo * | Report |
| Scorecard | scorecard1 | Scorecard |
| Shortcut | N/A | Shortcut |
| Style Template | .xss * | Style Template |
| Visual Analyzer Projects | projectfolder1 | Visual Analyzer Projects |
For example, let's see following Balance Letter report in /shared/Sample Lite/Published Reporting/Reports Location. Images below are shown for Oracle BI project type, but similar structure is required for Oracle BI 2.0 using the extensions from the table above.
If you Archive this report, it will be downloaded as Balance Letter.xdo.catalog, but in order to work with FlexDeploy you should rename it to Balance Letter.rprt and place it in /shared/Sample Lite/Published Reporting/Reports folder of your code repository.
This can be a bit cumbersome, but it can be further automated, . See Automate check-in of development catalog items to SCM.