Thursday Dec 19, 2013

How can we migrate the report jobs in BI Publisher from one system to other ?

Que ) On migrating from one system to other the user can be migrated and allocated to catalog groups but the report jobs won't show up. How can we migrate the report jobs?

Ans) There is no method available to move or migrate the existing reports jobs to another BI Publisher instance.The BI Publisher document doesn't provide any such option.We have a catalog utility that can be used to move the catalog objects like reports, data models etc but not jobs or job history.

Wednesday Nov 13, 2013

Can we install and run ODI where weblogic part is in separate domain on Exalytics?

Que ) Can we install and run ODI  where weblogic part is in separate domain on Exalytics?

Ans) ODI is only supported using the BI Applications(11.1.1.7) installed in the same MW home as OBIEE.

Wednesday Oct 30, 2013

OBIEE 11.1.1.7.131017 is Available for Oracle Business Intelligence Enterprise Edition and Exalytics

OBIEE 11.1.1.7.131017 is Available for Oracle Business Intelligence Enterprise Edition and Exalytics

You may refer Note 1595219.1 -OBIEE 11g 11.1.1.7.131017 is Available for Oracle Business Intelligence Enterprise Edition and Exalytics for more details.

Additional information:

  • You can directly apply OBIEE 11.1.1.7.131017  on the top of OBIEE 11.1.1.7.0 without applying the OBIEE 11.1.1.7.0 patch.
  • Oracle BI EE Suite Bundle Patch 11.1.1.7.131017 introduces support for Microsoft Internet Explorer 10
  • Oracle BI EE Suite Bundle Patch 11.1.1.7.131017 integrates support for Oracle BI Mobile App Designer into Oracle BI Presentation Services. The Home page displays a new Create Mobile App option and a link to the Mobile Apps Library; the New menu now also includes a Mobile App option. Note that to use these new options, you must also install the Oracle BI Mobile App Designer. Oracle BI Mobile App Designer is available in a separate patch (17220944) available from My Oracle Support. Apply the Mobile App Designer patch after installing Oracle BI EE Suite Bundle Patch 11.1.1.7.131017. Note that if you have previously installed Oracle BI Mobile App Designer on the BI system, then you do not have to re-apply Mobile App Designer patch 17220944. However, you will have to make a configuration change to re-enable the new Mobile App options.
  • Oracle BI EE Suite Bundle Patch 11.1.1.7.131017 improves functionality for exporting data from analyses, dashboards, and other Oracle BI Presentation Catalog objects into Microsoft Excel.

Thursday Oct 24, 2013

How to remove Analyze option from the report in OBI 11.1.1.7.0 ?

Que) How to remove Analyze option from the report in OBI 11.1.1.7.0 ?

Ans)

You can change the properties of a dashboard and its pages. Specifically, you can:

  • Change the style and description of the dashboard

  • Add hidden named prompts to the dashboard and to its pages

  • Specify which links (Analyze, Edit, Refresh, Print, Export, Add to Briefing Book, and Copy) are to be included with analyses at the dashboard level. Note that you can set these links at the dashboard page level and the analysis level, which override the links that you set at the dashboard level. 

  • Rename, hide, reorder, set permissions for, and delete pages.

  • Specify which accounts can save shared customizations and which accounts can assign default customizations for pages, and set account permissions.

  • Specify whether the Add to Briefing Book option is to be included in the Page Options menu for pages.

To change the properties of a dashboard and its pages:

  1. Edit the dashboard. 

  2. Click the Tools toolbar button and select Dashboard Properties.

    The "Dashboard Properties dialog" is displayed.

  3. Make the property changes that you want and click OK.

  4. Click the Save toolbar button.

Thursday Oct 17, 2013

OBI already has a caching mechanism in presentation layer and BI server layer. How is the new in-memory caching better for performance?

Question:

OBI already has a caching mechanism in presentation layer and BI server layer. How is the new in-memory caching better for performance?

Answer:

OBI Caching only speeds up what has been seen before. An In-memory data structure generated by the summary advisor is optimized to provide maximum value by accounting for the expected broad usage and drilldowns. It is possible to adapt the in-memory data to seasonality by running the summary advisor on specific workloads. Moreover, the in-memory data is created in an analytic database providing maximum performance for the large amount of memory available.

Friday Sep 13, 2013

OBIEE: How to deploy samplesales lite rpd?

We have seen lot of customers asking how to deploy samplesales rpd. Here are the steps to deploy samplesales rpd on your machine:

 A default OBIEE 11g installation includes the SampleAppLite RPD file and web catalog.

To deploy sample rpd, follow the steps below:

Step1:
Login into EM entering ->http://machinename:7001/em (e.g: http://localhost:7001/em)

Step2:
Once you logged into EM, Go to Business Intelligence from left side pane and select 'core application'. Select repository from right side pane.
Go to 'Deployment' tab -> select 'Repository' tab -> click on 'Lock and Edit' option.

Step3:
Once you click 'Lock and Edit Configuration' you will get the confirmation message . Click 'Close' with the screen.

Step4:
So In the next screen you are having the options to select repository and catalog which you want to deploy. After you selected the rpd and catalog click apply and click Activate Changes. (ingore catalog in this case)
ORACLE_INSTANCE/bifoundation/OracleBIServerComponent/coreapplication_obisn/repository

Step5:
Choose the repository from the location and enter the repository password and change the catalog name which you need to change.
Note: Do not forget to click 'Apply' button to save the changes .After the repository is uploaded, it is given a version number suffix (for example, SampleApp_bi001.rpd). After that Click 'Activate Changes'

Step6:
Once you click 'Activate Changes' , Activation process will be started
After this process is over, It will show the confirmation window. Just click 'Close'

Step7:
Once the changes has been activated, It will ask for the 'Restart to apply recent changes'. Click 'Restart to apply changes'

Step8:
Once you click 'Restart to apply recent changes' It will come to the below screen. Click 'Restart' to restart all the BI Services. Once the services is successfully restarted, The repository is updated.

See if you are able to login to Analytics now


Friday Aug 16, 2013

How To Create New Report From Scratch Within Excel Using Smart View?

This article describes the steps to create a new report from scratch within Excel using Smart View:
  1. Connect to OBIEE instance using Smart View as mentioned in https://blogs.oracle.com/ExalyticsOBIEE/entry/integrating_obiee_with_microsoft_office
  2. Click on Tab OBIEE ->View Designer Pane.
    The 'View Designer' pane will display a layout similar to the 'Criteria' Pager in Analytics.
    Here you can selecting from any subject area in the BI Catalog and drag and drop the dimensions and measures you want into respected rows,columns and Measures section.

    View Designer
  3. Add filters if required.

    Add Filters
  4. This report can then be manipulated either as an Excel pivot table or an OBIEE pivot table.

    Report
  5. Calculated Field can be added through 'Options->Fomulas'.

    Calculated Field

    Calc Field Report

  6. Now create Charts or Graph if required through 'Options->PivotCharts'.You can do any modification that you want using 'Options' tab.

    Pivot Chart

    Excel Chart

  7. Save the Excel document to your personal folder or you can upload to the BI Presentation Catalog using the Publish View button.

    Save

  8. Open the report in the Analysis Editor, just like any other analysis in the catalog.

    9
 NOTE:
Only SmartView 32-bit is supported with OBIEE 11.1.1.7.x.
SmartView 64-bit is not supported since it requires MS Office 2010, which is not certified with OBIEE 11.1.1.7.x

Sunday May 05, 2013

OBIEE 11.1.1.6.10 Patch released

11.1.1.6.10 bundle patch is now available for download from My Oracle Support for all platforms.

Bundled Patch Details:

  • Patch 11.1.1.6.10 (1 of 7) Oracle Business Intelligence Installer (BIINST):
    Patch 16504136
  • Patch 11.1.1.6.10 (2 of 7) Oracle Real Time Decisions (RTD):
    Patch 16504143
  • Patch 11.1.1.6.10 (3 of 7) Oracle Business Intelligence Publisher (BIP):
    Patch 16504148
  • Patch 11.1.1.6.10 (4 of 7) Oracle Business Intelligence ADF Components (BIADFCOMPS):
    Patch 16504154
  • Patch 11.1.1.6.10 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x (BIFNDNEPM):
    Patch 16504156
  • Patch 11.1.1.6.10 (6 of 7) Oracle Business Intelligence: (OBIEE):
    Patch 16427939
  • Patch 11.1.1.6.10 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer:
    Patch 16504161

Please refer to the readme file on the Installer download for important installation instructions.

 Thanks,

Sareesh

Tuesday Apr 09, 2013

Exalytics:Is Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7 certified with Exalytics PS2 (1.0.0.2), or any other Exalytics release?

Question:

Is Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7 certified with Exalytics PS2 (1.0.0.2), or any other Exalytics release?

Answer:

OBIEE 11.1.1.7.0 is a full product release and is not currently certified with Exalytics.  It includes many product enhancements and the installation/upgrade procedures are significantly different from the install method for a minor patchset, such as OBIEE 11.1.1.6.5.

The Oracle Exalytics Development team is actively working on certifying OBIEE 11.1.1.7.  An announcement will be made when the certification process is complete.  Certification details are available in the Exalytics Certification matrix posted here.

Thanks,

Sareesh

Oracle Exalytics/OBIEE Support


About

This Blog is for sharing the latest information regarding Exalytics and OBIEE

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today