Friday 20 May 2016

ID column and Oracle BI for MS Office

ID column:
1.What is the use of ID column?
A) ID column is useful to improve the performance of report by passing description column corresponding ID to SQL query.
Oracle BI for MS Office:
1.What are the key features of  Oracle Business Intelligence for Microsoft power point and excel?
A) Key features of OBIEE for Microsoft powerpoint and excel
1.View live, refreshable data from the OBIS.
a. Insert BI tables,Pivot tables and graphs into powerpoint or excel as refreshable, editable objects.
b.Apply PowerPoint or excel formatting to BI data; formats are retained when you refresh.
2.Copy and paste BI analysis from OBI Answers or OBI interactive dashboards to powerpoint or excel. The data, metadata and view layout are copied.
3.Secure BI data from Oracle BI objects in power point or excel so that users must log in to view the data. Secured objects can be refreshed.

No comments:

Post a Comment