It has been a while since I published Part 1 of the Essbase Studio Tutorial by Example. Finally a quick follow-up to the original that I promised I would get out - a second part on adding drill-through capability - is available. This document has been sitting around for a while. I’ve been swamped and with the not too long ago release of EPM 11.1.2 I wanted to at least get this document out while it is still relevant.
If you haven’t already, please read the full OTN article here as a pre-requisite to conducting part 2 of this tutorial series.
Please see the link towards the bottom of this post to download part 2 of the tutorial (PDF).
Let me know if you have any feedback.
Download
Essbase Studio Tutorial by Example Part 2
Pre-Requisites / References
http://www.oracle.com/technology/pub/articles/screen-essbasestudio.html
So, to much excitement, the first GA release of OBIEE 11g is finally available for the public to download. You can download it as Friday August13, 2010 from the OTN OBIEE Page. There is a lot to say for this release and our good friends at BI Consulting Group and Rittman-Mead have already begun blogging on the topic and setting up webinars to relay some great information to the masses about this much anticipated release.
OBIEE 11gR1 Download: http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/index.html
I am quite certain that Oracle pushed this GA release out the door just in time for OOW which is next month in San Francisco, CA. Nevertheless, OBI 11g is finally here, so its time to get crackin’ on some new material. If you haven’t already signed up, I’ll be part of a panel conducting a webinar with BI Consulting Group (OBI11g, What’s in it for Me?) on August 31st, 2010. You can sign up for that event if you haven’t already. The webinar should be very informative for a first look at OBI 11gR1.
Happy downloading!
Recently digging into the strategy and best practice of installing the OBIEE Applications, mainly the DAC and Informatica components, I see two common issues arise more often that any others. One has to do with the Informatica Integration Service not matching the correct locale such at UTF-8 or MS Windows Latin, etc. preventing it from starting and the other has to do with the Informatica or DAC user not able to call the core integration tools pmrep and pmcmd. This issue is common on Linux/Unix environments but not so much on a Windows server environment.
Read the full story
Let it be know that when it comes to X Windows technology and connecting a from Windows workstation to a remote Linux/Unix machine, my support goes to XMing. Now that is not to say that XMing doesn’t have its issues like all other XWindow client technologies. But it is clean, it offers a nice install package and provides, in the world of open source, very good documentation. And as a real quick refresher for those that don’t do much Linux or Unix, it is a best practice to lock down your servers and limit connectivity only to those that really need access. That being said, Linux and Unix when being installed have the option of being installed with a GUI interface for the OS or not. Often times the really astute (geeky) IT pros select the latter and no GUI access is available. More to the point, in order to install such software as required by Oracle and some other software teams, only a GUI interface such as the Oracle Universal Installer, is available. To accomplish the install on the remote computer from a Windows workstation you need an X Windows client, such as XMing.
Confronted the other day with just such an install, Oracle client and the Datawarehouse Administration Console (DAC), I put my good friend XMing to work. Let’s talk about that for a moment. When using XMing, I choose to use it with a solid telnet tool that we all know and love, PuTTy. PuTTy basically has a setting to forwards the X11 (X Windows) from your remote session to your local/workstation machine. Ultimately connecting is accomplished in a few steps:
- Set the DISPLAY var of your remote user profile to the IP of the machine/workstation you are remoting from. many examples on the web show “localhost” but if you are conducting a VPN session to a remote Windows server then you may not be able to get away with just localhost and will need to enter the exact IP of that machine on the network. For example, if you workstation you are on has an IP of 216.55.55.55 then enter that IP address suffixed with “:0.0″ (e.g.: 216.55.55.55:0.0) in the DISPLAY var of your remote user profile. Also enter this in the “X Display Location” of your PuTTy session.
- Execute the command xhost + and/or xhost + IP address
- Before you need to run a GUI program from the remote linux/Unix machine, launch XMing’s XLaunch application.
- As a gotcha to this, you may need to select the option to enable “No Access Control” in order to by pass connectivity errors from the workstation rejecting requests from the remote server.
Recently my need to install the Datawarehouse Administration Console (DAC) cause me issues on a VPN session for a remote connect to a Linux server. Ultimately after completing the above major steps in initiating an X Windows session, the when I ran the installer command for the software, the X Windows session would start and disappear. It would stay visible just long enough for the OUI (Oracle Universal Installer) to start and haphazardly enough when I clicked the “Next” button to continue the install the X Window would close as would the XMing application. I checked the logs and the logs only noted successfully connectivity and GUI transfer from the remote machine. No errors were in the log.
Ultimate what fixed the issue was for me to launch a session of the XLaunch application and before I ran the installer command from the remote PuTTy session window, I right clicked on the Windows Taskbar icon for XLaunch and opened the log file. I left the log file open and then executed the install command in my PuTTy session. Somehow some way the X Window and the GUI remote install stayed alive and I was able to complete the installation. I think that somehow the XMing application was getting hit with some exception that would otherwise cause it to abend but due to the log file being open, the main application could not close. Or, something like that. I was using XMing version 6.9.0.3.1 for this implementation.
Posted on 20 July 2010
Tags: OBIEE 11g
Oracle Business Intelligence 11g has finally gotten going with a whirlwind release tour that started in early April 2010. Today’s launch party takes place in one of the largest business cities in world, New York, NY USA.
After much beta testing, and hush-hush, behind the doors secrecy, this clandestine tool can now be seen via a myriad of marketing paraphernalia online as presented by Oracle. There are a lot of great resources, break-out session videos, keynotes, etc provided on the Oracle site. One of my favorites is a side link at http://ht.ly/2bADM which provides some great webcasts on the topic.
Get ready to see some great in-depth detail on ArtOfBI.com. We are stoked about the EPM/BI integration that now doesn’t have the limitations that 10g had. Everything is better in this version as one could only expect from the amount of delay and anticipation this release has brought upon the Oracle BI communities. We are looking forward to sharing more detail on the topic.
Take a look at some heads up resources from Oracle, et al. I think you’ll find most of the initial collateral most exciting.
