Oracle BIWA User Community

Hadoop is a fault-tolerant distributed system for data storage. It is highly scalable and useful for data (often unstructured data) beyond that are best stored in RDBMS . The scalability is the result of a Self-Healing High Bandwith Clustered Storage , known by the acronym of HDFS (Hadoop Distributed File System) and a specific fault-tolerant Distributed Processing, known as MapReduce. Recently, Director of IT at JP Morgan Chase (JPMC) said, Hadoop allows them to store data that they never stored before. It can include Web logs, TX data  and social media related data. While enterprise wide security concerns still prevail for Hadoop, it is slowly growing its footprint.  As in case of JPMC, it is being used for fraud detection and IT risk management. Aggregated forms of such data also feeds data mining and other advanced analytics tools.  eBay uses Hbase database for Hadoop.   HBase is an open source, non-relational, distributed database modeled after Google's BigTable. It i

Subject:  Webinar: Using Oracle R Enterprise -- Nov 30, noon EST Date:  November 22, 2011 11:55:15 AM EST Analytic friends: Happy Thanksgiving!! Oracle BIWA SIG is hosting a webinar next week that I think might interest many of you.  Here's the info about it. ============================== ============ Webinar: Using R within Oracle -- Nov 30, noon EST ============================== ============ Oracle now supports the R open source statistical programming language. Come to this webinar to learn more about using R within an Oracle environment. -- URL for TechCast:  https://stbeehive. oracle.com/bconf/confDetails? confID=334B:3BF0:owch: 38893C00F42F38A1E0404498C8A661 2B0004075AECF7&guest=true& confKey=608880 -- Web Conference ID: 303397 -- Web Conference Key: 608880 -- Dialup:  1-866-682-4770 , ID 5548204, passcode 1234 After a steady rise in the past few years, in 2010 the open source data mining software R overtook other tools to b

Once I was at Oracle Openworld 2011, it became so engaging between my speaking sessions, Customer Panel, Keynote sessions, IBM (GBS) booth duty, customer meetings and all the "appreciation" events, that I could not find time to update the blog sooner. I was able to Tweet regularly as it is so much easier to do that from a Smartphone as against need for portable PC or Tablet for blogging. So I decided to summarize my impressions of OOW 2011 here. While Oracle Exadata and Exalogic have been around for some time, it is now clear that Oracle is focusing on an appliance or "engineered" system like approach. While industry cynics say it is Oracle's approach to "lock" the customer into single vendor, really speaking the trend was started by likes of Teradata and Netezza who build machines for specific purposes be it data warehousing or something similar. Greenplum, Vertica, Aster Data, PacAccel are some of the ones to follow and their subsequent acquisition

The OOW 11 has 45,000 attendees from 117 countries as per Judy Sims at the 5:30 PM keynote. It has 380,000 customers. The Sunday is marked by User Group and SIG event from 9am to 5 PM. The BIWA SIG had 6 sessions in Moscone West 2003 all day long. The key announcement expected in the keynote from Larry is Exalytics or the BI appliance on the lines of Exadata family. This "appliance" is likely to empower OBIEE for "visualization at speed of thought."  Oracle set the stage for this when OBIEE 11.1.1.5 had support for Times Ten the in-memory engine. Besides, SAP with HANA has set the tome for the need of dedicated hardware for BI at the speeds users "desire." Chairmen of the Board Jeff Henley is now awarding the Oracle Excellence Awards for 2011. The winners are on the stage now. Deloitte got the middleware partner of the year CapGemini got the applications partner and Accenture the Industry partner. These are the Specialized Partners of the Year 2011.

BIWA SIG at Oracle Openworld 2011 Oct 2, Sunday at Moscone Center West:  Session ID:  27800, by Dan Vlamis Fast Complex BI Analysis  with Oracle OLAP Session ID:  27201 by Mark Rittman  Oracle Business Intelligence 11g Architecture and Internals Session ID:  27380 by Shyam Varan Nath / Florian Schouten OBIEE and Oracle BI Apps New Directions and Case Studies Session ID: 31480 by Carl Dudley Analytic Functions Revisited  Session ID:  27241 by Richard Solari/Ryan Hoffmeister OBIEE 11G, 7.9.6.3: Case studies and Lessons on OBIEE 10G / 7.9.6 Customers Session ID:  27180 by Ian Abramson Big Data: Are you Ready? ---------------------------------------------------------------------- Call for Speakers for "BIWA Summit " at COLLABORATE 2012 closes on Oct 14!

Dan Vlamis will be the featured speaker in Cleveland, Ohio at the NorthEast Ohio Oracle User Group meeting on September 16, 2011. Dan's presentations include: How Executives Visualize Corporate Data with Oracle Business Intelligence 11g Fast Complex Analysis with Oracle OLAP Hands On with Oracle Business Intelligence 11g The final presentation will include a quick overview of the changes in OBIEE 11g. Bring your laptop for a unique experience as you get to experience for yourself just how easy it is to create a simple dashboard yourself in OBIEE 11g. Be sure to have a browser configured for wireless internet access so you can participate yourself! For more details, see the NEOOUG Home page or the presentations page at vlamis.com .

People are often drawn to the fierce battle between the technology giants such as Oracle and SAP for business software (ERP) and IBM, HP and Oracle (Sun) for high end servers. However, there the reality is IBM Global Business Services (GBS) is the largest Oracle System Integrator (SI). Let me quote a Tweet here: --- abhinavagarwal   Abhinav   co-opetition at its best :-) RT  @ shyamvaran :  # IBM  is now an  # Oracle   # Diamond  partner!  # bigblue   # oow11   # opn As pointed out, the fact that IBM -GBS is now a Diamond Partner (highest level) and is one of the 4 top "Elites" proves that the top technology players work very closely with each other.  shyamvaran  Shyam Varan Nath #IBM  and  #Oracle  – They work a lot closer together than you think… Recent #Diamond  Partner status of IBM is proof!  goo.gl/TmaKM   #OPN Aug 30, 9:28 PM  via web What does Diamond Partner level mean? Check out this page: http://solutions.oracle.com/partners/ibm

Come join Sunil Ranka, from  BIWA SIG  Oracle ACE at 12:00 Noon (CT) on August 31 for the webinar   How to Enhance Performance of OBIEE Tech Stack.     Ranka  runs the gauntlet of issues surrounding performance enhancement, specifically in the key areas of: -Database Tuning Techniques -Cache Settings (not the documented) -Dashboard Design -Data Model Consideration -Miscellaneous Don't miss this opportunity to sharpen your Business Intelligence acumen from the comfort of your office. Register today:  https://www1. gotomeeting.com/register/ 132190008 Title: How to Enhance Performance of OBIEE Tech Stack Speaker: Sunil Ranka, Oracle ACE, FCS, Inc. Date/Time: Wednesday, August 31st at 12noon CT Registration Link:  https://www1. gotomeeting.com/register/ 132190008 Audio will be streamed, recording and slides will be posted later, check  http://OracleBIWA.org  for details Thanks Shyam Varan

I have been reading the book Oracle Warehouse Builder 11g R2: Getting Started 2011 and post my feedback here over next few days. The author is Bob Griesemer and publisher is Packt Publisher.  This edition is similar to the first version on OWB with the addition of a whole new Chapter 10 on code templates (knowledge modules - KM's from Oracle Data Intergrator - ODI) and a complete redoing of all the screen shots due to changes of the interface of the product. More to come...

I will post the KScope summary here....

KScope (earlier called Kaleidoscope) started today. It is organized by Oracle Development Tools User Group. This time it is in Long Beach, CA, just South of Los Angeles.  The first day (Sat June 25) is the Community service day. It was great to see many familiar faces who helped to paint and clean up the Boys and Girls Club of Long Beach. We gathered near the conference venue at 8 AM, got our lemon green T-shirts and headed to the place in two buses. I helped paint the basket ball court  and its lines. The day started with us gathering for breakfast, that was time for meet and greet, before taking the bus to the Boys and Girls Club. It was nice to see many conference attendees brought their local firends / relatives including kids. Look forward to the BI / EPM Symposium tomorrow. (more to come...)

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

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 instal

"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 • 

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)

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/8 21849 265 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

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 iP

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...

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_biee   Oracle EPM and BI   Win x86 32/64-bit, Linux x86 32/64-bit, Sun Solaris SPARC (64-bit) available for  #Oracle  BI 11.1.1.5.0  http://bit.ly/lE6UmS   #obiee   #11g 2 minutes ago   Favorite   Retweet   Reply oracle_biee   Oracle EPM and BI     by shyamvaran #Oracle  Business Intelligence Applications, v. 7.9.6.3 also available for download from OTN  http://bit.ly/lE6UmS   #obia 4 minutes ago   Favorite   Undo Retweet   Reply 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 plat