Monday, May 30, 2011

BIWA Techcast related Q&A - OBIEE

Oracle BI Released – OBIEE 11g Changes and New Features (Webinar Questions)

We had two BIWA Techcasts on May 18 and May 25, 2011 with focus on OBIEE and BI Apps There were many questions on OBIEE and we decided to capture the questions and answer them over time here:

What about android or Blackberry support?
A   The Mobile BI support for iPhone and iPad were native in The next release is expected to have support for Andriod followed by support for Win OS. blackberry support will be in the future.

Q Does this still require database access during installation?
A The RCU part of installation requires a relational repository. This is the part common for Fusion Middleware (FMW) and not specifically the OBIEE part but is required. The OBIEE rpd will remain as a file
  Are connection methods same for all OLAPs from various technologies? What approach of connection to SSAS?
  Have support for multiple hierarchies been extended to include value-based hierarchies?
  How easy is the SAP BW Native connectivity, same as Oracle OLAP?  Any additional work to retain the hierarchal structures?
  Any comments/suggestions with respect to the skill sets required for establishing the business model and mapping layer in the CEIM, and the critical nature of this step?
  Has support for multiple RPDs been implemented?
  Can you selectively collapse tables on the Business Diagram?
  I have an issue with annoying "transactional update" been resolved in the Admin Tool?
  MS Office 2010 is certified for OBIEE
  Can you show the segmentation interface and features?
  Are there any enhancements to the Office Add-in.   In particular, ability to use hierarchical columns in pivottables inserted into Excel, or a workaround?  And ability to have attribute columns across the top of a pivottable as seen inserted in Excel?
  Adding to my last question, are there any good tutorials on the Office Add-in?
  Please share info on version management and MUDE in
  Has Discoverer metadata support changed a bit in the newest release?
  Would appreciated any comments regarding multi-user development and the configuration management of the RPD (CEIM metadata) – suggest any best practices.
  For map views on dashboards, do we need to download and configure NAVTEQ maps separately? Is this a separate license?
  Would you please provide details on What OOTB (Out of the box) Hierarchies available in this release? Where can I access the list of Hierarchies available? Can we still use DRM Hierarchy Manager to maintain those Hierarchies?
  Request method for SSAS access from BI Admin Tool.
  Question To Alan Lee: Where do we get the document that has the list of bugs fixed in .5
  Anything new on SAP BW connections
  I could not see link for SSAS in your demo amongst others.
  Can you talk a little bit about the integration points between and JDeveloper ADF
  Question to Bob Ertl: we noticed performance issue on in IE7. Was there any changes done to specifically address the performance in .5
  Could you please elaborate more on your slide 33 "oracle BI 10g upgrade" in terms of LOE to do an upgrade to
  Can you show the segmentation interface and features?
  Are there any improvements in OBIEE 11g with terms of managing Group Names while doing an Integration with LDAP / AD from 10g?

BI Forum at Atlanta, May 25-27, 2011 at Atlanta.

I was at the BI Forum last week, which is a niche OBIEE centric event. After holding 3 of these events in UK, Rittman brought is over to Atlanta. In a nutshell was it was 1 day of OBIEE 11g masterclass followed by 10 speakers in next two days. With only 55 attendees, it was limited to be a small event allowing attendees to interactive with each other. My talk's focus was on BI Applications ( and it was on Friday. The biggest concern raised during the Q&A was a lack of systematic way to port OBIEE side customizations as you migrates from one version of BI Apps to next. One of my suggestions was to look at reimplementation approach, such as a customer on EBS R 11.5.10 with OBIA 7.9.5 planning to go to R12.1.x and (with OBIEE 11g). When the migration is over such a large change, just like reimplementation approach to ERP, it may be worthwhile to look at OBIA for similar reimplementation approach, where you install (with OBIEE 11g, Informatica 9.0.x) and then decide which customizations needs rebuilt or porting.

The main focus was OBIEE 11g with good coverage of the release, that came out on May 6. I think the massive changes in the security framework was a big concern, specially by the end-users who are the prospective adopters of OBIEE 11g. Here are the two presentations on the OBIEE 11g security:
One is by Adam Bloom from the UK event (
and another by Suyog Rao in the Atlanta event

I found one additional security blog that looks useful:

It was my first chance to meet Philippe Lions the Product Manager for OBIEE from France. He gave an overview of the new features and the updated sample app for (

Mobile BI has taken a new stride with the out of box support for iPad and iPhone and Kevin McGinley did a great job in is talk. (
His talk was voted the top talk of the Atlanta event. His slides do not do justice to his actual presentation that he did from iPad!

Mark and Stewart did a great job overall in hosting this event as well as in their own talks. The event being in Atlanta, where I spent a good part of 2009 for my OBIEE related client project, allowed me to go and meet them as well.

Monday, May 23, 2011

BIWA Techcast: Oracle BI Released – OBIEE 11g Changes and New Features, May 25, noon ET

"Oracle BI Released – OBIEE 11g Changes and New Features"

Oracle Business Intelligence 11g was a huge release.  When OBIEE 11g was introduced, the font size had to be so small to fit all of the important new features on one PowerPoint slide, that it was unreadable.  Now, in May 2011, Oracle has issued the first patch release for OBIEE 11g, version  Arguably, the biggest news on this release is that it is the first patch release since 11g was launched with version in August, 2010 ( was skipped).  For those that were waiting for the first patch release, you no longer have that excuse for waiting to move to 11g of OBIEE.

Other notable features in version include:
•          Full support for the Apple iPad
•          Full support for OLAP sources including Essbase and Oracle OLAP
•          Support for Oracle BI Applications release
•          New support for Oracle TimesTen, MS SQL Server Analytic Services, and SAP BW
•          Reduced memory requirements for Weblogic and streamlined install process
•          64-bit BI Admin Tool
•          New visualizations in the BI Admin tool

In this BIWA TechCast, Dan Vlamis, President of Vlamis Software Solutions, Inc. and BIWA Board member will show off several of these and other new features in a live demonstration.  Dan will also briefly touch on features introduced in OBIEE, including new visualizations, Action Framework, map views, and OLAP-style interaction.  Dan will be joined by Oracle product management so they can answer questions you may have on these features and other topics related to Oracle Business Intelligence.
For more information on how to connect to this free TechCast to be held May 25, from 11:00am to 12:00pm, see to register. to register.

Slides are now posted at:
Presentation posted here

Wednesday, May 18, 2011

BIWA Techcast May 18, 2011 - Q&A

Thanks to 100+ attendees  and Robert Davis of Oracle for the Techcast today. Slides are now posted here (
We will use this blog to respond to the questions from the Q&A session.

Q Application is supported by 11g or not?    Oracle certifies OBIEE only with  It supports 7.9.6 and higher with OBIEE 11g but you will have to do the platform upgrade yourself.   I personally would not recommend using with OBIEE 11g. You are also on older Informatica with and will soon get out of support.

Q Would you please comment on how OBIEE 11g uses DRM to manage the Hierarchies?    DRM is a product to manage dimensional hierarchies.  I am not aware of a way to import hierarchies from DRM into OBIEE 11g.

Q What is the difference in Role and Group based Security?  Refer slide 39 and 40 of the slides

 Q What has changed in Marketing Segmentation?   (

Q Are all existing issues fixed?  A lot of issues are in OBIEE (fixes from e.g. BUG:12339862 - DESCRIPTOR ID ENABLED COLUMNS DOES NOT SUPPORT SEARCH ON TEXTUAL FILTER VALUES  Oracle will release a list of issues fixed in

Q Is the flash issue fixed in iPad. Apple does not support Flash
Also can we see dashboards and prompts in the native app   See slide 53, 54

Q Thanks a lot for the Presentation.I am interested about the quality of this new release, whether the issues/bugs from previous releases are fixed?  How stable is the .5 release? See last question

Q Any updates on Hyperion Workspace Integration with this was supported in 10G and not in 11g release 1?  Scheduled for   (Yes Oracle says it will not skip to!)

Q What new subject areas have been added?   No new subject areas in, same data model as

Q Are there any tools for Migrating our Discoverer Reporting System to OBIEE?   For EUL to RPD but not for Workbooks to Reports/Dashboards

Q What is your assessment from a skills perspective if we want to go with and 11g for a new install at a client? The implementation resources may be experienced in or before.
The implementer needs skills in OBIEE 11g and WLS, not much of difference in Informatica and DAC.

Q Do you recommend moving the OBIEE platform to using and load the data warehouse using INFA 8.6.1? Is this a recommended approach from Oracle?
Informatica 8.6.x will be de-supported soon, so use Informatica 9.0.x

...more to come

  How does cascading prompt differ from 10g linked prompts?
  Are both DAC patches 10052370 and 12381656 needed or the last one superseeds the former?
  Does the Real-time reporting in 11g is faster and reliable
  Do we have a DEMO / TRAINING Database out of the box for this version?
  Is it supported IBM COGNOS TM1 as a source for OBIEE 10g or 11g?
  We have been facing intermittent server crash
  What Oracle db versions are supported as OBIEE 11g on Oracle 11g gives message as db version not supported?

  Or only support essbasemulti-dimensionaldatabase?
  It was mentioned that Informatica would be continued to be supported (7.9.7.x). How do we see future releases post 7.9x wrt support for Informatica?
  Also, it is supported on Oracle Db 10g version?
  BIAPPS can only run on windows machine (obiee11gr5 installed) - any future plans on pointing the bia installer to an installation of obiee 1115 on a unix machine?
  What is the major advantage of informatica9.1?Compared the 8.6 version?
  Are SAML tokens supported in the OBIEE suite?
  Can we import cognos cubes to OBIEE?
  What are the differences between informatica 9 and 8.6 version. Could you please explain?
  If there are more than 6-7 reports in the dashboard, how does it display in the iPad?
  What tool(s) are used by designers for multidimensional modeling to build the CEIM?
  Do we need to be always connected in the iPad (or) will the dashboards work in Disconnected mode
  Any performance improvements in around better SDE queries etc, dac orchestration?
  Do drillups work in 11g?
       How is has the Version Control and Multiuser Development improved?

Monday, May 16, 2011

Sneak Peak to Oracle BI Apps

Come to my webcast on May 18, 2011, noon ET and find out what is new in the BI Apps / OBIEE 11.1.15 - the dynamic duo!

Topics include new features like:

  • Certification for OBIEE
  • iPad and iPhone support for out of box BI apps content
  • Informatica 9.0.1 support for ETL
  • Teradata 13.10 support
  • Oracle EBS 12.1.3 support

    Friday, May 13, 2011

    Webcast: Oracle BI Applications and OBIEE – New Developments - May 18, 2011, noon EST

    Please join us for a BIWA SIG Webcast on May 18, noon EST
    Here is the url to register
    You can dial in to listen or use web audio
    Recording posted here
    Are you able to unlock all the information that your users are looking for, from the ERP and other operational systems? This session will look at the Oracle Business Intelligence solutions with focus on OBIEE and Oracle BI Applications. We will cover the different scenarios for BI solutions and discuss custom development using OBIEE v/s using pre-packaged BI Applications as the framework. We will cover new developments such as Oracle BI Apps and its certification with OBIEE 11g. Learn what is new in OBIEE and how that impacts BI Application implementations. Taking a few case studies, we will look at feasible options whether you are on OBIEE 10 g or on OBIEE 11g to plan to migrate. Learn the tips and tricks from the field. Learn how mobile BI (support for iPhone and iPad from OBIEE) is adding new meaning to pervasive BI.

    Shyam V. Nath, OBIEE Architect at IBM, will cover the different scenarios for BI solutions and discuss custom development using OBIEE v/s using pre-packaged BI Applications as the framework. Drawing on his deep expertise in the industry, he will also cover new developments like Oracle BI Apps and its certification with OBIEE 11g. Learn tips and tricks from the field, and how mobile BI (support for iPhone and iPad from OBIEE) is adding new meaning to pervasive BI.


    Friday, May 6, 2011

    Installing BI apps with OBIEE

    In BI apps, Informatica gets a face list just the the BI platform are a few Informatica 9.0.1 installation screen shots...

    OBIEE and OBIA

    The formal announcements have started flowing in now...though the social media was active yesterday and I had downloaded parts of the software...I pasted some screenshots last evening...

     Oracle EPM and BI 

    Win x86 32/64-bit, Linux x86 32/64-bit, Sun Solaris SPARC (64-bit) available for  BI   

     Oracle EPM and BI 
     by shyamvaran

     Business Intelligence Applications, v. also available for download from OTN  

    The documentation is available now here

    Informatica 9.0.1 Hot fix 2 (OEM PowerCenter is listed as the ancillary supported program...nothing about the DAC 11g yet...

    • Oracle Business Intelligence Applications V7.9.6.3 requires Oracle BusinessIntelligence Enterprise Edition V11.   (so if you have or 10g you have to upgrade the BI platform)
    • Oracle Business Intelligence Applications V7.9.6.3 requires Informatica PowerCenter V9.0.1. Hotfix 2  (you cannot stay on 8.6.1 any more) 
    • Oracle Business Intelligence Applications V7.9.6.3 requires Oracle Data Warehouse Console V10.

    Due to OBIEE 11g infrastructure based on Web logic you need to be aware of the new security paradigm. Now to open the OracleBIAnalyticsApps.rpd file in Oracle BI Administration Tool, you must specify the Administrator\Admin123 credentials. The SADMIN is gone...

    The DAC requires a mandatory patchset for use with

    "Oracle Business Intelligence Applications V7.9.6.3 is supported on and requires Oracle Business Intelligence Data Warehouse Administration Console (DAC) platform
    Version with Patch 10052370."  If you feel like reading the full docs, they are here

    Thursday, May 5, 2011

    Get your hands on OBIEE and OBIA

    Finally OBIEE 11g ( and BI apps can be downloaded now!
    I created an easy to remember url       ...just remember and 11 1 1 5

    I noticed that this OBIEE 11g release is supported on Win 32/64, Linus 32/64 and Solaris 64... It will be supported on AIX soon. Have stopped speculating on HP's OS...

    The BI Apps is certified with OBIEE 11g and looks for OBIEE 11g installation shown above... earlier in this step the BI apps installer would look for OBIE 10g folders. now supports EBS R12.1.3   (7962 only supported R12.1.2 even though it came out just after the R12.1.3 release. However, I have not seen any issues of work with EBS R12.1.3. In my scenario it worked for HR, Fin, SCM and Procurement Analytics. I noted now Oracle has updated release notes to say that supports R12.1.3 now... in other words now they have completed their certification.

    It is good to see that 11.5.10 is still supported in this release and allows folks to stay on same ERP release while leveraging OBIEE 11g... some of the companies I know are awaiting to see the Fusion Apps catch on before they decide when to upgrade from EBS 11.5.10.

    OBIA supports Informatica 8.6.1 with Hot fix 11 and has Planned Certification for Informatica
    PowerCenter 9.0.1 HF2.

    Tuesday, May 3, 2011

    Oracle - OBIEE 11g and BI Apps is announced!

    Oracle announced the much awaited Oracle Business Intelligence Release introduces support for the iPad and iPhone today along with the Certification of OBIEE 11g for Oracle BI apps  The BI apps was a big pain point as since OBIEE 11g was supported but not certified. Now we are past that barrier and companies now using or planning BI apps for go-live over next few quarters should look at OBIEE 11g.  

    OBIEE Release content is now optimized for use with the iPad and iPhone, no third party drivers or software neded. Hence, no need for  any design changes to existing reports and dashboards.

    Now supports for additional data sources including Oracle TimesTen In-Memory Database, Oracle OLAP, Microsoft SQL Server Analysis Services and SAP Business Information Warehouse (BW). This is interesting move after the 7.9.7 that was ODI based release for SAP Finance Analytics only.

    The new software is not yet available for download, the announcement does not tell a date.