Monday, May 30, 2011

BIWA Techcast related Q&A - OBIEE 11.1.1.5

Oracle BI 11.1.1.5 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 11.1.1.5 and BI Apps 7.9.6.3. 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 11.1.1.5. The next release 11.1.1.6 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 11.1.1.5?
  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 11.1.1.5
  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 11.1.1.5 and JDeveloper ADF
  Question to Bob Ertl: we noticed performance issue on 11.1.1.3 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 11.1.1.5.0?
  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 (http://www.rittmanmead.com/files/biforum2011/Varan_OBIA.pdf) 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 7.9.6.3 (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 7.9.6.3 (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 11.1.1.5 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 (http://www.rittmanmead.com/files/biforum2011/Bloom_Security.pdf)
and another by Suyog Rao in the Atlanta event
(http://www.rittmanmead.com/files/biforum2011/Rao_Security.pdf)

I found one additional security blog that looks useful:
http://blogs.oracle.com/robreynolds/entry/security_in_obiee_11g_part_1

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 11.1.1.5 (http://www.rittmanmead.com/files/biforum2011/Lions_11115_New_Features.pdf)

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. (http://www.rittmanmead.com/files/biforum2011/McGinley_Mobile.pdf)
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 11.1.1.5 Released – OBIEE 11g Changes and New Features, May 25, noon ET

"Oracle BI 11.1.1.5 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 11.1.1.5.0.  Arguably, the biggest news on this release is that it is the first patch release since 11g was launched with version 11.1.1.3 in August, 2010 (11.1.1.4 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 11.1.1.5.0 include:
•          Full support for the Apple iPad
•          Full support for OLAP sources including Essbase and Oracle OLAP
•          Support for Oracle BI Applications release 7.9.6.3
•          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 11.1.1.3, 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 https://www1.gotomeeting.com/register/212164985 to register. to register.


Slides are now posted at:
http://www.vlamis.com/storage/papers/biwa2011-presentation1.pdf
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 (http://bit.ly/iQN4fr).
We will use this blog to respond to the questions from the Q&A session.

Q 7.9.5.1 Application is supported by 11g or not?    Oracle certifies OBIEE 11.1.1.5 only with 7.9.6.3.  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 7.9.5.1 with OBIEE 11g. You are also on older Informatica with 7.9.5.1 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?   (http://download.oracle.com/docs/cd/E12852_01/v11113/mktgseg/mktgsegTOC.html)

Q Are all existing issues fixed?  A lot of issues are in OBIEE (fixes from 11.1.1.3) 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 7.9.6.3

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 11.1.1.5 this was supported in 10G and not in 11g release 1?  Scheduled for 11.1.1.6   (Yes Oracle says it will not skip to 11.1.1.7!)

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

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 7.9.6.3 and 11g for a new install at a client? The implementation resources may be experienced in 7.9.6.2 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 11.1.1.5 using 7.9.6.3 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 7.9.6.3 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 7.9.6.3

Come to my webcast on May 18, 2011, noon ET and find out what is new in the BI Apps 7.9.6.3 / OBIEE 11.1.15 - the dynamic duo!  
https://www1.gotomeeting.com/register/821849265

Topics include new features like:

  • Certification for OBIEE 11.1.1.5
  • 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 https://www1.gotomeeting.com/register/821849265
    You can dial in to listen or use web audio
    Recording posted here
    Abstract:
    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 7.9.6.3 and its certification with OBIEE 11g. Learn what is new in OBIEE 11.1.1.5 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 7.9.6.3 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.


    Thanks
    http://OracleBIWA.org

    Friday, May 6, 2011

    Installing 7.9.6.3 BI apps with OBIEE 11.1.1.5

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


    OBIEE 11.1.1.5 and OBIA 7.9.6.3

    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 11.1.1.5.0   


     Oracle EPM and BI 
     by shyamvaran


     Business Intelligence Applications, v. 7.9.6.3 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.1.1.5.0   (so if you have 11.1.1.3 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.1.3.4.1.


    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 7.9.6.3:


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

    Thursday, May 5, 2011

    Get your hands on OBIEE 11.1.1.5 and OBIA 7.9.6.3

    Finally OBIEE 11g (11.1.1.5) and BI apps 7.9.6.3 can be downloaded now!
    I created an easy to remember url http://bit.ly/OBIEE11115       ...just remember bit.ly 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 7.9.6.3 is certified with OBIEE 11g and looks for OBIEE 11g installation folders....as shown above... earlier in this step the BI apps installer would look for OBIE 10g folders.

    7.9.6.3 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 7.9.6.2 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 7.9.6.2 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 7.9.6.3 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 11.1.1.5 and BI Apps 7.9.6.3 is announced!

    Oracle announced the much awaited Oracle Business Intelligence Release 11.1.1.5 introduces support for the iPad and iPhone today along with the Certification of OBIEE 11g for Oracle BI apps 7.9.6.3.  The BI apps was a big pain point as since 7.9.6.2 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 11.1.1.5 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 11.1.1.5 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.