bi apps reports2- oracle obiee & sap business objects
DESCRIPTION
TRANSCRIPT
![Page 1: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/1.jpg)
BI APPS Reports2 SAP Business Objects & Oracle
OBIEEBY
Sunny OKoro
![Page 2: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/2.jpg)
1
Contents
Applications.................................................................................................................................................3
Database Systems........................................................................................................................................8
SAP Business Objects...................................................................................................................................9
Universe Creation Relational Database.................................................................................................26
Web Intelligence....................................................................................................................................77
Crystal Reports Enterprise and Business Objects...................................................................................80
SAP Business Objects Explorer.............................................................................................................102
SAP Business Objects Analysis OLAP....................................................................................................112
Universe Creation Microsoft SSAS.......................................................................................................121
Reports Processing and Scheduling.....................................................................................................136
Oracle OBIEE............................................................................................................................................152
Installation & Configuration.................................................................................................................154
OBIEE Administration..........................................................................................................................166
Sample Reports...................................................................................................................................169
![Page 3: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/3.jpg)
2
![Page 4: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/4.jpg)
3
Applications
Microsoft Visual Studio 2010 /2008
Oracle SQL Developer
Microsoft Visio Professional 2010
![Page 5: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/5.jpg)
4
Microsoft Excel 2010
SAP Information Design Tool
![Page 6: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/6.jpg)
5
SAP Web Intelligence Rich Client
![Page 7: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/7.jpg)
6
Business Intelligence Applications
Oracle Business Intelligence Enterprise Edition
SAP Crystal Reports For Enterprise
![Page 8: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/8.jpg)
7
SAP Business Objects BI Platform 4.0
Microsoft SSAS 2008
![Page 9: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/9.jpg)
8
Database Systems
Microsoft SQL Server 2012 /2008R2
Oracle 11GR2
![Page 10: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/10.jpg)
9
SAP Business Objects
![Page 11: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/11.jpg)
10
![Page 12: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/12.jpg)
11
![Page 13: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/13.jpg)
12
![Page 14: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/14.jpg)
13
![Page 15: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/15.jpg)
14
![Page 16: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/16.jpg)
15
![Page 17: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/17.jpg)
16
![Page 18: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/18.jpg)
17
Results Abbreviated
![Page 19: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/19.jpg)
18
![Page 20: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/20.jpg)
19
![Page 21: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/21.jpg)
20
![Page 22: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/22.jpg)
21
![Page 23: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/23.jpg)
22
Adding Subtotals
![Page 24: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/24.jpg)
23
![Page 25: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/25.jpg)
24
![Page 26: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/26.jpg)
25
![Page 27: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/27.jpg)
26
Universe Creation Relational Database
![Page 28: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/28.jpg)
27
![Page 29: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/29.jpg)
28
![Page 30: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/30.jpg)
29
![Page 31: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/31.jpg)
30
![Page 32: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/32.jpg)
31
![Page 33: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/33.jpg)
32
![Page 34: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/34.jpg)
33
![Page 35: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/35.jpg)
34
![Page 36: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/36.jpg)
35
![Page 37: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/37.jpg)
36
![Page 38: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/38.jpg)
37
![Page 39: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/39.jpg)
38
![Page 40: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/40.jpg)
39
![Page 41: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/41.jpg)
40
![Page 42: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/42.jpg)
41
![Page 43: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/43.jpg)
42
![Page 44: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/44.jpg)
43
![Page 45: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/45.jpg)
44
![Page 46: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/46.jpg)
45
Before the universe is published make sure that the connection is published to the repository and replaced the local connection with published connection.
![Page 47: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/47.jpg)
46
![Page 48: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/48.jpg)
47
![Page 49: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/49.jpg)
48
![Page 50: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/50.jpg)
49
![Page 51: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/51.jpg)
50
![Page 52: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/52.jpg)
51
Results Abbreviated
![Page 53: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/53.jpg)
52
![Page 54: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/54.jpg)
53
![Page 55: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/55.jpg)
54
![Page 56: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/56.jpg)
55
![Page 57: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/57.jpg)
56
![Page 58: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/58.jpg)
57
![Page 59: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/59.jpg)
58
![Page 60: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/60.jpg)
59
![Page 61: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/61.jpg)
60
![Page 62: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/62.jpg)
61
![Page 63: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/63.jpg)
62
![Page 64: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/64.jpg)
63
![Page 65: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/65.jpg)
64
REVISIONS
![Page 66: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/66.jpg)
65
![Page 67: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/67.jpg)
66
![Page 68: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/68.jpg)
67
![Page 69: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/69.jpg)
68
![Page 70: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/70.jpg)
69
I decided to include all the date attributes associated with Fact Sales table in the same Fact sales table to make it easier to process the data without getting error message whenever reports are executed. On the business layer, I deleted the Date Dim and recreated a new Date Dim not associated with Date Dim table. Then I add the dimensions of the Date Dim by dragging the attributes from Fact Sales table and deleted any other date dimensions on the Fact Sales table on the business layer.
![Page 71: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/71.jpg)
70
![Page 72: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/72.jpg)
71
Additional measures were included including Tax and Freight.
![Page 73: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/73.jpg)
72
![Page 74: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/74.jpg)
73
![Page 75: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/75.jpg)
74
![Page 76: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/76.jpg)
75
![Page 77: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/77.jpg)
76
![Page 78: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/78.jpg)
77
Web Intelligence
![Page 79: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/79.jpg)
78
![Page 80: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/80.jpg)
79
![Page 81: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/81.jpg)
80
Crystal Reports Enterprise and Business Objects
![Page 82: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/82.jpg)
81
![Page 83: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/83.jpg)
82
![Page 84: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/84.jpg)
83
![Page 85: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/85.jpg)
84
![Page 86: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/86.jpg)
85
![Page 87: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/87.jpg)
86
![Page 88: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/88.jpg)
87
![Page 89: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/89.jpg)
88
![Page 90: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/90.jpg)
89
![Page 91: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/91.jpg)
90
![Page 92: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/92.jpg)
91
![Page 93: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/93.jpg)
92
![Page 94: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/94.jpg)
93
![Page 95: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/95.jpg)
94
![Page 96: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/96.jpg)
95
![Page 97: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/97.jpg)
96
![Page 98: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/98.jpg)
97
![Page 99: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/99.jpg)
98
![Page 100: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/100.jpg)
99
![Page 101: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/101.jpg)
100
![Page 102: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/102.jpg)
101
![Page 103: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/103.jpg)
102
SAP Business Objects Explorer
![Page 104: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/104.jpg)
103
![Page 105: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/105.jpg)
104
![Page 106: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/106.jpg)
105
![Page 107: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/107.jpg)
106
![Page 108: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/108.jpg)
107
![Page 109: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/109.jpg)
108
![Page 110: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/110.jpg)
109
![Page 111: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/111.jpg)
110
![Page 112: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/112.jpg)
111
![Page 113: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/113.jpg)
112
SAP Business Objects Analysis OLAP
![Page 114: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/114.jpg)
113
The SSAS http site makes SSAS accessible via internet.
![Page 115: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/115.jpg)
114
![Page 116: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/116.jpg)
115
![Page 117: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/117.jpg)
116
![Page 118: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/118.jpg)
117
![Page 119: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/119.jpg)
118
![Page 120: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/120.jpg)
119
Exported to Excel
![Page 121: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/121.jpg)
120
![Page 122: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/122.jpg)
121
Universe Creation Microsoft SSAS
![Page 123: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/123.jpg)
122
![Page 124: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/124.jpg)
123
![Page 125: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/125.jpg)
124
![Page 126: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/126.jpg)
125
![Page 127: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/127.jpg)
126
![Page 128: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/128.jpg)
127
With MS SSAS Data Foundation is not needed.
![Page 129: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/129.jpg)
128
![Page 130: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/130.jpg)
129
![Page 131: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/131.jpg)
130
![Page 132: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/132.jpg)
131
![Page 133: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/133.jpg)
132
![Page 134: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/134.jpg)
133
![Page 135: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/135.jpg)
134
![Page 136: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/136.jpg)
135
![Page 137: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/137.jpg)
136
Reports Processing and Scheduling
![Page 138: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/138.jpg)
137
![Page 139: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/139.jpg)
138
![Page 140: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/140.jpg)
139
![Page 141: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/141.jpg)
140
Results Abbreviated
![Page 142: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/142.jpg)
141
Results Abbreviated
![Page 143: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/143.jpg)
142
![Page 144: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/144.jpg)
143
![Page 145: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/145.jpg)
144
![Page 146: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/146.jpg)
145
![Page 147: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/147.jpg)
146
![Page 148: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/148.jpg)
147
![Page 149: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/149.jpg)
148
![Page 150: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/150.jpg)
149
![Page 151: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/151.jpg)
150
![Page 152: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/152.jpg)
151
![Page 153: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/153.jpg)
152
Oracle OBIEE
![Page 154: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/154.jpg)
153
![Page 155: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/155.jpg)
154
Installation & Configuration
Java Home and the environment variable for java home have to be implemented for a successful deployment.
![Page 156: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/156.jpg)
155
Oracle Repository Creation Utility will be utilized to create the necessary tablespace and schema including the database objects for the Oracle OBIEE. The Microsoft loopback adapter is used to create the static IP address since OBIEE will throw an error during installation if a dynamic IP address is used for both the database and OBIEE installations. The loopback adapter is also utilized by other database like DB2, Sybase ASE and SQL Server depending on the configurations which makes it easier for applications like SQL Developer to connect too. Only the Metadata and Business intelligence platform are need for OBIEE. Windows server or any server OS is the best option for installing OBIEE due to performance related issues during installation and configuration.
Verification
![Page 157: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/157.jpg)
156
Installation
Enterprise install option will install both the Oracle
Weblogic and OBIEE application and the software only install option will install the OBIEE application which can be manually deploy the application. For that option an existing Oracle Weblogic needs to be preinstalled first for that option to work.
![Page 158: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/158.jpg)
157
Note: Oracle OBIEE has many installation options which depend on the Operating Systems configurations, Weblogic and java versions even for development based systems. Weblogic can be
installed first and later OBIEE in the same folder with web logic. Then OBIEE is manually deployed or set up to use the weblogic.
![Page 159: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/159.jpg)
158
![Page 160: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/160.jpg)
159
![Page 161: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/161.jpg)
160
![Page 162: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/162.jpg)
161
![Page 163: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/163.jpg)
162
![Page 164: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/164.jpg)
163
Oracle BI Publisher Desktop, Oracle Business Intelligence Enterprise Edition Client and Applications have to be installed following a successful installation.
![Page 165: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/165.jpg)
164
DBA Task
Due to high memory usage by business intelligence applications like OBIEE, the default memory size has to be increased to increase performance using Oracle Enterprise Manager 11g or SQL Developer as illustrated below for each tablespace including the temporary tablespace.
![Page 166: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/166.jpg)
165
![Page 167: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/167.jpg)
166
OBIEE Administration
In the following task, I would set up the JDBC connections for database systems for Oracle, Microsoft SQL Server 2008 and 2012 and IBM DB2.
![Page 168: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/168.jpg)
167
![Page 169: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/169.jpg)
168
Sample ReportsFor this demonstration, on the first part I would utilized the OBIEE sample provided to create simple reports and on the second part, SQL Server AdventureWorksDW 2008 would be utilized to create the repository which would be deployed into the server for reports development.
Sales Reports
![Page 170: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/170.jpg)
169
![Page 171: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/171.jpg)
170
![Page 172: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/172.jpg)
171
Results Abbreviated
Adding sections to the reports allowing end user to print sections of report relating to their interest
![Page 173: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/173.jpg)
172
Results Abbreviated
![Page 174: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/174.jpg)
173
Results Abbreviated
![Page 175: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/175.jpg)
174
Formatting the report
![Page 176: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/176.jpg)
175
![Page 177: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/177.jpg)
176
Results Abbreviated
![Page 178: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/178.jpg)
177
Results Abbreviated
![Page 179: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/179.jpg)
178
Results Abbreviated
![Page 180: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/180.jpg)
179
![Page 181: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/181.jpg)
180
Results Abbreviated
![Page 182: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/182.jpg)
181
![Page 183: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/183.jpg)
182
![Page 184: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/184.jpg)
183
![Page 185: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/185.jpg)
184
![Page 186: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/186.jpg)
185
![Page 187: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/187.jpg)
186
Results Abbreviated
![Page 188: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/188.jpg)
187
![Page 189: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/189.jpg)
188
![Page 190: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/190.jpg)
189
![Page 191: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/191.jpg)
190
![Page 192: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/192.jpg)
191
![Page 193: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/193.jpg)
192
![Page 194: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/194.jpg)
193
![Page 195: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/195.jpg)
194
![Page 196: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/196.jpg)
195
![Page 197: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/197.jpg)
196
![Page 198: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/198.jpg)
197
![Page 199: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/199.jpg)
198
![Page 200: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/200.jpg)
199
![Page 201: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/201.jpg)
200
![Page 202: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/202.jpg)
201
![Page 203: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/203.jpg)
202
![Page 204: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/204.jpg)
203
![Page 205: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/205.jpg)
204
![Page 206: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/206.jpg)
205
![Page 207: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/207.jpg)
206
![Page 208: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/208.jpg)
207
![Page 209: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/209.jpg)
208
![Page 210: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/210.jpg)
209
![Page 211: BI Apps Reports2- Oracle OBIEE & SAP Business Objects](https://reader037.vdocuments.us/reader037/viewer/2022103015/54c6d99d4a7959ef018b457f/html5/thumbnails/211.jpg)
210