Friday, April 30, 2010

OBIEE: Physical Development Environment

I had contemplated about using source control before.

Related:
OBIEE Software Configuration Management by Mark Rittman
- Part 1 : Initial Deployment from DEV to PROD
- Part 2 : Subsequent Deployments from DEV to PROD
- Part 3 : Version Controlling the Project
OBIEE Enterprise Methodology Group Discussion
- OBIEE development, test and deployment
- Multiple RPDs/WebCats

Those deal with more of the software side of things. I want to explore the physical set up a little. I don't have the definitive answer, just thinking out loud perhaps.

The client is considering a ramp-up of development efforts (good thing). We were asked to think about an environment to allow parallel development. This is no easy task in OBIEE as the RPD can be a bottleneck.

While talking about it though, it sounded a lot like classic software development and source control. You pull down the code locally, fix/create/update it, and then merge that up into your trunk (subversion lingo anyway). You merge it up into a common repository.

What if you physically separated your environment? Here's my thinking:
  1. Find the common code (init blocks, connection pools, etc) shared by all subject areas. Especially relevant if setting some variables or something for security.
  2. Create virtual (or physical) machines with the full OBIEE environment (services, rpd, web cat) set up for each subject area and only that subject area. Of course this would include all components identified in step 1.
Something like this:

pretty environment picture

Pros
  1. Allows for parallel development
  2. Easier to identify changes
  3. Easier to import than merge?
  4. ????
Cons
  1. Separating RPD into sections, scary
  2. How do you handle physical tables shared across subject areas?
I need some good contrarians out there to discuss this with.

I don't know if this has merit or not, but I wanted to put it out there. Good or bad, I'm OK with. The goal is to give the client the most reasoned, researched, supportable analysis that I can.

Wednesday, April 28, 2010

ORA-01820: format code cannot appear in date input format

I learned something new today...you can't use week date format qualifiers in TO_DATE.

I was trying to transform a week to a month like this:
CJUSTICE@TESTING>SELECT TO_DATE( 200803, 'YYYYWW' ) FROM DUAL;
SELECT TO_DATE( 200803, 'YYYYWW' ) FROM DUAL
*
ERROR at line 1:
ORA-01820: format code cannot appear in date input format
Then tried one "W"
  1* SELECT TO_DATE( 200803, 'YYYYW' ) FROM DUAL
CJUSTICE@TESTING>/
SELECT TO_DATE( 200803, 'YYYYW' ) FROM DUAL
*
ERROR at line 1:
ORA-01820: format code cannot appear in date input format
Then "IW"
  1* SELECT TO_DATE( 200803, 'YYYYIW' ) FROM DUAL
CJUSTICE@TESTING>/
SELECT TO_DATE( 200803, 'YYYYIW' ) FROM DUAL
*
ERROR at line 1:
ORA-01820: format code cannot appear in date input format
Datetime Format models in 10gR2

Lo and behold the Error messages manual didn't have it (at least where I would expect it).



Put it up on twitter and Gary Myers responded:



That's good to know.

Now I just need to figure out how to transform that week into a month.

I'm trying to generate some test data for a quick...test.

I switched to using SYSDATE as that would allow more more flexibility to transform the other way.
SELECT DISTINCT
TO_NUMBER( TO_CHAR( r, 'YYYYWW' ) ) fiscal_year_week,
TO_NUMBER( TO_CHAR( r, 'YYYYMM' ) ) fiscal_year_month
FROM
(
SELECT SYSDATE - rownum r
FROM dual
CONNECT BY LEVEL <= SYSDATE - TRUNC( SYSDATE, 'YEAR' )
)
Which gave me exactly what I needed
FISCAL_YEAR_WEEK FISCAL_YEAR_MONTH
---------------- -----------------
201015 201004
201014 201004
201012 201003
201011 201003
201007 201002
201006 201002
201002 201001
201016 201004
201010 201003
201003 201001
201017 201004
201013 201003
201009 201003
201009 201002
201005 201002
201004 201001
201013 201004
201008 201002
201005 201001
201001 201001

Job: DBA in Philadelphia

Oracle's latest acquisition has created a need for an Oracle DBA in Philadelphia, PA.

Contact information is below.

Job Summary: Oracle Database Administrator (DBA)

The Oracle DBA will be supporting multiple environments from Development, Quality Assurance (QA) and Production databases running Oracle 10g in a clustered environment. Experience working in a production UNIX/Linux environment is required for this position. Experience in performance tuning, change implementation, backup and recovery, monitoring and installation are key requirements. Candidate will also be expected to provide application-level support for our in house J2EE applications running on Tomcat and OC4J. Ideal candidate will be a self-starter and a team player with a strong organization, process and communication skills. This is a permanent position, not a contract. No 3rd parties please. No H1's or L1's.

Job Description
  • Installation and patching of Oracle RDBMS on Linux – adhering to standard operating procedures
  • Performance tuning and administrative functions on Oracle production databases
  • Enforce best practices in all areas of database administration and architecture including
  • Review and implement database changes
  • Participate in 24x7 on-call rotation for production databases
  • Ensure backup and recovery of all Oracle data using RMAN, Standby Database and import/export
  • Develop scripts for reporting, data manipulation and automation of daily tasks
  • Provide support to Development and QA teams on applications/database issues
  • Engage and support Software Developers during the SDLC
  • Administration and support of Oracle’s Business Intelligence, Informatica, Tomcat and OC4J applications
  • Develop and document formal processes and procedures
Job Requirements
  • Computer Science, or related science/Engineering degree (B.S. or equivalent).
  • At least 3 to 5 years production Oracle DBA experience in a Linux/UNIX environment
  • At least 2 years of experience with Oracle Real Time Application Clusters 10g or 11g with ASM or NFS.
  • UNIX/Linux system knowledge sufficient to configure, maintain and monitor Oracle instance(s)
  • Experience with OLTP, OLAP, DW, and ETL concepts
  • Experience with indexing strategies and reading explain plans
  • Experience with parallel processing, and partitioning
  • Experience with Oracle Data Guard
  • Experience with Oracle Grid Control, especially monitoring and alerting and managing multiple databases
  • Database performance tuning ability is required
  • Familiarity with the Full Software Development Lifecycle (SDLC)
  • Demonstrated knowledge of Oracle and Oracle tools to support database environments
  • Demonstrated knowledge of shell environments (C, Korn, KSH, Bourne)
  • Demonstrated proficiency of SQL and PL/SQL
  • Familiarity with HTML/ JAVA /Java scripts / JSP / PERL is a plus
  • Familiarity with Oracle’s Business Intelligence suite, Informatica and J2EE administration is a plus.
  • Will require after-hours or occasional weekend work to make changes during outage windows.
  • Excellent oral and written skills
Resumes should be sent to careers@fiberlink.com

Subject line must contain the following: Oracle DBA Position (Job ID: careers119)

Compensation is negotiable and based on experience.

Relocation package is not available.

Tuesday, April 27, 2010

OBIEE: Gotcha #1

When generating SQL for testing, make sure you set the database to the database you will be running against.

I found this out the fun way, of course, by going through, grabbing the SQL from the logs, and then modifying said SQL to run against Oracle. I should have paid attention to that "Check Consistency" warning.



I spent an hour or so "fixing" the SQL, removing stuff like the following:
fn ifnull
{ curly brackets }
d '2004-04-10'
ts '2004-04-10 13:44:39'
mostly small stuff, but annoying none-the-less. Strangely (to me anyway), this was the SQL submitted to an Oracle database...without errors. I'm guessing that somewhere, either in OBI or in the driver itself, the SQL is rewritten.

After I realized what had happened, I went back into the RPD and updated the database properties.



It was ODBC basic



I changed it to Oracle 10R2/11g



I tried the Consistency Check again and still received the warning. Opened up the database properties again and selected the Features tab



Then selected "Revert to Defaults"



Run the Consistency Checker again and voila!



So don't waste your time like I did. Make sure you use the Consistency Check Manager and make sure your database defaults match.

Monday, April 26, 2010

Thomas Roach: Oracle's Latest Acquisition

In Dan Norris fashion, I am announcing the acquisition of Thomas Roach by Oracle Corporation.

I've had the please of knowing Mr. Roach since before moving to Tampa as he was the President of the local users group, Suncoast Oracle Users Group (SOUG). He's also helped me out numerous times in both an advisory role and...well, just getting stuff done for me.

A few weeks ago I got to help him by letting him rehearse his MAA presentation on me. That apparently sealed the deal for him. Oracle Corporation flirted with acquiring him late 2008, but didn't pull the cord.

I've been teasing him the last few weeks about anouncing him as the Tom Kyte successor, as he'll be working in the Public Sector group that Mr. Kyte worked for a few years back. He said he didn't want the "Rittman Effect" so I am playing nice.

Mr. Roach is a great guy and this position (whether Mr. Kyte's old job or not) is very well earned. Congratulations Mr. Roach. Perhaps you can help out Mr. Kyte with his small niche site...since you share the same name.

Fun with ORA-28547 and ORA-12571

I'm trying to get an Oracle instance configured with OBIEE for an Exadata POC. Mostly, it just getting all these disparate "security" tables into a single database.

As I was building out some reports to drive some iBots, I kept getting connection problems. I thought it had to do with the fact that I had multiple Oracle clients installed (10g and 11gR2), as I had problems with that before.

I could tnsping the database:
F:\>tnsping exadata

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 01-APR-2010 15:42:29

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
c:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CO
NNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = EXADATA)))
OK (0 msec)
just fine, but I couldn't connect.
F:\>sqlplus cjustice/testing

SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 1 15:42:33 2010

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error
Interesting.

I then removed any references from the PATH to the 10g client.

Same thing.

Testing it through the ODBC applet gave me this:

tns error

I checked the listener.ora file...nothing out of the ordinary. No references to HS (as one of those errors mentions). I then opened up Net Manager (which I never do), changed the trace level to Administrator and then tried to log in again:
F:\>sqlplus cjustice/testing@exadata

SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 1 15:55:49 2010

Copyright (c) 1982, 2010, Oracle. All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Process ID: 0
Session ID: 0 Serial number: 0
Ah...interesting. The server isn't even running. WTF?
SQL> startup;
ORA-00065: initialization of FIXED_DATE failed
And there you have it.

Just before I shut down the database, I set FIXED_DATE just before shutting down. Not only did I do that, but I issued:
ALTER SESSION SET NLS_DATE_FORMAT = 'MM/DD/YYYY HH24:MI:SS' ;
Thankfully I was able to
CREATE PFILE FROM SPFILE;
I then edited that, removing the FIXED_DATE setting and voila! I was up and running again.

Analytics in Views

The question:

Does embedding an analytic function into a view cause a WINDOW SORT every time the view is called?

I say no, only if it is specifically referenced.
SH@TESTING>SELECT * FROM v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
The view definition:
CREATE OR REPLACE
VIEW vw_sales
AS
SELECT
prod_id,
cust_id,
time_id,
channel_id,
promo_id,
quantity_sold,
amount_sold,
SUM( amount_sold ) OVER
( PARTITION BY
prod_id,
cust_id
ORDER BY time_id ) amount_sold_running
FROM sales;
I run an explain plan as SELECT *
SH@TESTING>EXPLAIN PLAN FOR SELECT * FROM VW_SALES;

Explained.

Elapsed: 00:00:02.19
SH@TESTING>@EXPLAIN

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------------
Plan hash value: 2700574370

----------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop |
----------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 918K| 87M| | 7841 (3)| 00:01:35 | | |
| 1 | VIEW | VW_SALES | 918K| 87M| | 7841 (3)| 00:01:35 | | |
| 2 | WINDOW SORT | | 918K| 25M| 84M| 7841 (3)| 00:01:35 | | |
| 3 | PARTITION RANGE ALL| | 918K| 25M| | 389 (12)| 00:00:05 | 1 | 28 |
| 4 | TABLE ACCESS FULL | SALES | 918K| 25M| | 389 (12)| 00:00:05 | 1 | 28 |
----------------------------------------------------------------------------------------------------
Now if I just select the columns I want/need, will Oracle perform the WINDOW SORT?
SH@TESTING>EXPLAIN PLAN FOR
2 SELECT QUANTITY_SOLD, AMOUNT_SOLD
3 FROM vw_sales;

Explained.

Elapsed: 00:00:00.02
SH@TESTING>@explain

PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------
Plan hash value: 1550251865

---------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | Pstart| Pstop |
---------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 918K| 7178K| 389 (12)| 00:00:05 | | |
| 1 | PARTITION RANGE ALL| | 918K| 7178K| 389 (12)| 00:00:05 | 1 | 28 |
| 2 | TABLE ACCESS FULL | SALES | 918K| 7178K| 389 (12)| 00:00:05 | 1 | 28 |
---------------------------------------------------------------------------------------------
Oracle is smart enough not to perform the WINDOW SORT if the column is not selected.

Nice.

Sunday, April 25, 2010

COLLABORATE: "I Hate Toad"

Saying something like that really endears you to a vendor.

Thankfully, I know Jeff Smith of Toad from his recent trip down to Tampa.

At dinner later that evening, I told him as much. He finally got it out of me that it isn't really Toad's fault, but the developers that use it. I agreed.

Unfortunately when I said it at COLLABORATE (jokingly of course), one of his colleagues heard me. Uh oh. Anyway, I had to explain why it is I "hate" Toad and think he was mostly happy with my answer.

Ultimately, a tool that helps you increase your productivity is a good thing. I like and have used the DBA pack that comes with Toad. However, many "developers" I have worked with can't live without Toad...and that's where I have a problem.

So trying to be fair, I asked Mr. Smith to walk me through Quest Code Tester. I "like" testing and think it is one of the bigger problems in the database developer community; in that we don't do it very well. Java, .NET, and many others have it built in (mostly anyway) to what they do. How many times have you seen a database developer run through unit tests on his or her code? I've seen exactly 1 shop (where I learned it).

quest 1quest 2
quest 3quest 4

From that demo, I would say it has much, if not more, of the functionality in SQL Developer. I haven't had a chance yet to really use that one either.

But if you would like to try out it, there is a free trial version (registration required)

Thursday, April 22, 2010

COLLABORATE: Day 5 Wrap Up

I covered everything conference related early today here.

My stay at the Excalibur was uneventful. I wouldn't stay there again, unless it was free and I had no money. I'd still have to think about it though.

The walk from there to Mandalay Bay however was...interesting. Not once did I navigate the maze without having to backtrack. I know/understand that is on purpose...but it's still annoying. Maybe that's taking marketing (or whatever it's called) just a bit too far. If people want to gamble, they'll gamble.

Last night I got lost in the Luxor for an hour. I could have gone outside, but I was determined to figure it out. I had help from beer too.

The other highlight of my day was eating lunch with Mr. Floyd Teter. No adjective is descriptive enough to describe him...I'll settle for Awesome though.

I did manage to get some shopping in today...I hate shopping, but the family deserves something. So I got them all "My dad/husband went to Las Vegas and all I got was this lousy T-Shirt" t-shirts.

Since my flight didn't leave until 1 am (Friday morning), I had time to kill. So I parked myself in front of a slot machine and within minutes lost $10. I then played roulette, only to lose $20 in 3 minutes. I blame Mr. Mark Rittman...he paid me for the iPad I got him in cold, hard cash. It burned. It had to be spent. I think it was payback for my little stunt the other day.

So I left the hotel(s) and went to the airport so I wouldn't spend any more money. Though those stupid slot machines behind me are calling my name. I can't wait to get out of here if only for the silence.

Kate +3

kate, chet and me
It wasn't until today at lunch that I realized the 3 year "anniversary" of Kate's brush with death had come and gone. April 21, 2007.

For those not in the know, I'll do a quick recap.

Kate was born. They said she had seizures so they put her in the NICU and placed her in a phenobarbital coma for the next 6 weeks. Each time they tried to wean her, she would "seize". On more than one occasion (twice while laying on my stomach), she would "seize" and the process would start all over. Atavan, phenobarbital and all kinds of other crap.

Turns out she was twitchy. Benign Myoclonus of Infancy.

The only good that came out of that was that we couldn't have given 2 shits about her hands.

Fast forward 2.5 years and many, many hospital visits later, the doctors felt Kate was ready to get her tonsils and adenoids removed. You see, they believed that in conjunction with her Laryngeal Tracheal Malacia (in my terms, a floppy airway) her adenoids and tonsils were affecting her breathing in a negative way.

So there she went into the OR waving like a little princess on the cart. Surgery went fine and I spent the day with Kris and her. I then went home. About 4:30 that morning I got a text from Kris, Kate had crashed (lungs stopped working). I drove about 1 billion miles an hour to the hospital to find that Kate had stabilized.

Later that afternoon, Kate's heart just quit working. They revived her and got her stable again. An hour or so passed and it happened again. In a very "out-of-body" experience, we were discussing how long to keep trying to save her with the doctor.

Thankfully she eventually stabilized and 4 weeks later came home...addicted to morphine.

Within 3 months though, Kate took her first steps. She has progressed very well since that time...albeit slowly. Lately we've taken on behavioral and speech therapists who spend about 10 hours a week with Kate at our house.

The speech doctor believes Kate can read and showed Kris...so we got her an adaptive learning device which, sure enough, she knows which button is cookie (it's a word, not a picture).

She continues to inspire and amaze all those who know her. We consider ourselves very lucky Kate walked into our life.

So, here's to Kate who kicked death square in the balls!

COLLABORATE: OEM 11g and Podcast

It's about a wrap.

I'm...exhausted.

I finally managed to make it to the OEM 11g release session, which was just a satellite feed from New York that everyone else in the world could see. However, had some live Oracle people here to answer any questions after the presentation.

Unfortunately, I did not get their names as I was 40 minutes late.

I haven't used OEM in years so it was all new stuff to me. The additions did look pretty cool though especially the ability to drill down into specific applications to locate performance problems.

I stayed to listen to the questions people had as sometimes that's the most interesting stuff.

I then headed over for lunch with Mr. Floyd Teter and we were eventually joined by Dave Ferguson and his wife Paula. We ate at Burger Time which was quite good.

Mr. Teter's enthusiasm is infectious to say the least and his energy level is out of this world. It has been an absolute pleasure to get to know him in real life.

Somehow he talked me and about 10 others to join him in a podcast with Mr. Bob Rhubart of ArchBeat fame (and the best voice ever) to discuss our experiences at COLLABORATE 10.

In attendance:
- Elke Phelps
- John King
- Paul Jackson
- Mark Rittman
- Floyd Teter
- Dave Ferguson
- Gavin Whyte
- Srini Chavali
- John Nicholson
- me

Mr. Rhubart said that he would have it posted sometime next week. I'll link it up when it's released.

COLLABORATE: Day 4 Wrap Up

The day started out with the realization that I pulled off the best (COLLABORATE - self annointed) prank ever. Twitter was...all atwitter about the fact that Mark Rittman was Oracle's Person of the Year. Of course it wasn't true. If you look at the picture, you'll realize that he's wearing exactly the same clothes in the magazine cover as he is in real life.

I ate lunch in the exhibition hall. Sat down at my table, opened my soda and it exploded. Everyone at the table seemed to ignore me after that. What can you do?

From there I headed over to the OBIEE and JavaScript session by Sunil Ranka. Guess who attended? Mr. Rittman. Thankfully he knew I was joking...but he did spend a significant amount of time debunking the rumor that I started.

From there I spent the next 2 hours writing and "relaxing" (sitting down).

Then I went to the Exadata SIG.

On the way there though...I finally met @tyf who spotted me (probably my dirty oraclenerd). We had been trading tweets for the last couple of days but could never seem to meet. Within about 3 seconds I realized that she was one of those rare, awesome people. You know, the ones where you instantly feel comfortable with?

So I asked for a picture with her which turned into an absolute fiasco. We tried twice holding the camera out in front of us...and I'm not very good at that apparently. I finally asked a passerby to take a picture and he agreed, only to spill his ice all over the floor at the base of one of the escalators. We kicked the ice out of the way and finally got a picture.



After an informative Exadata SIG meeting where I got to meet Arup Nanda (again actually) and a couple of Oracle folks including Jean-Pierre Djicks (JP) of The Data Warehouse Insider blog.

With a 2 hour wait until the Beach Party, I headed back to the room. On the way back, I ran into Floyd Teter and we talked for a bit before being hassled by one of the "wives of fishbowl" and her husband Rick.



I then headed back to my room and got completely lost.











Obviously I did make it back...but it took close to an hour.

How could I forget?

I met Debra Lilley today. She's the keeper of Stanley. Of course I asked if I could take a picture with Stanley, you know, oraclenerd meets Stanley photo.



As I put on the vest, all I could think of was Tommy Boy
Tommy: Richard? Is this your coat?
Richard: Don't do it.
Tommy: Fat guy in a little coat. Fat guy in a little coat.
Richard: Don't
Tommy: [singing] Fat guy in a little coat. / Fat guy in a little coat.
Richard: Take it off, Dickhead, I'm serious!
Tommy: Richard! What's happening?
[coat rips]
Tommy: Uh oh!

COLLABORATE: The Beach Party

It wasn't quite Universal, but I had fun.

Let's start with some of the IOUG crew



What was to eat? Scallops...mmmm...scallops.



Due to "inclimate" weather, it had to be moved inside. By "inclimate", I mean it was only 60 degrees outside.



Sadly I couldn't find the OAUG crew...the helped me out quite a bit this week (as well as getting me a pass). Allison Dixon was my laison and she was awesome.



After the lights were dimmed (remember that in kindergarten?), we sat outside the room and played...beach ball. Yeah, it was interesting. Then tiki statues somehow were incorporated into various dances. Interesting indeed.

Wednesday, April 21, 2010

COLLABORATE: Exadata SIG

From 4 to 5 today, I attended the Exadata SIG.

Why?

Because it's fun.

Dan Norris was supposed to be there, but he got caught by the ash cloud from the Icelandic volcano.

Here's what I got from the meeting.

1. The database software that runs atop the hardware is 11gR2. Exactly the same software that I run on my OEL virtual machine. It is no different.
2. Exadata is a "game changer." The word I was thinking about was it represents a paradigm shift. What do I mean? Well...the consolidation of roles means that IT has to figure out how to deal with Exadata. Who's going to be the point person on support issues?

If you read that article I just linked to, it talks about the consolidation of roles...meaning that the DBA can (should?) handle all things Exadata. In other words, no system administrators, no storage administrators...just the DBA.

From my point of view, this is exactly what technology is supposed to do.

I'm hoping to volunteer for future endeavors with the group...you'll be duly notified.

COLLABORATE: OBIEE and JavaScript

I managed to attend a session today.

It was probably made possible by:
1. The presenter kept calling me and hassling me (joking)
2. The presenter had laptop issues and asked if he could use mine in case his disintegrated during the presentation. (true story)

How to Enrich OBIEE UI Using Custom JavaScripting
by Sunilkumar "Sunil" Ranka [ blog | twitter ]

The basic gist of his presentation was that if you can understand HTML and how a page is rendered, you can do just about anything you want with the page.

A couple of examples he walked through:

- How To disable hyperlink for Value Interaction column
- What-If Analysis needs JavaScript on OBIEE
- Using Breadcrumbs on drill down reports (unfortunately, no link)
- Way To Solve Multiselect Prompt Bug - Mr. Ranka did not actually get to this one, but it's definitely worth sharing.

Sadly I didn't write down the rest of the examples.

Not only was I the "AV geek", I was also the collector of names/business cards for prizes to be handed out at the end.

I did like the reminder that this is just HTML and if you know JavaScript (I don't...not well enough anyway), manipulating pages in OBIEE is relatively simple.

COLLABORATE: On The Web

I was shocked to find that other people were writing about COLLABORATE. (@nephentur & @rnm1978, that was sarcasm ;))

Pre-COLLABORATE
Roel Hartman - No Collaborate 2010 for me - thanks to the Icelandic (bank) e-ruption...
Peter Scott - Collaborate 10 – The Early Days
Eye on Oracle - Oracle Collaborate ‘10: More questions, more needs, less resources
Oracle BI Publisher Blog - BI Publisher at Collaborate 2010
Brent Lowe at The Lowe Down - Collaborate 2010 Preview
The JD Edwards Advisor by David Andrews - I Can’t Wait for Collaborate
ORACLE CERTIFIED PROFESSIONALS - COLLABORATE 2010 Begins Today
Shyam Varan Nath at BIWA SIG - Collaborate 2010 - Las Vegas, April 18-22
George Trujillo at A DBA's Journey in the Sun - Virtualization at Collaborate 2010 Oracle Users Conference

During COLLABORATE
Floyd Teter
- Highlights From The Bright Lights
- Highlights From The Bright Lights - Sunday
- Highlights From The Bright Lights - Monday
- Highlights From The Bright Lights - Tuesday
- Highlights From The Bright Lights - Wednesday
- Highlights From The Bright Lights - Thursday
Profit: Spare Change - Blogging is Hard
Oracle BI Publisher Blog
Collaborate 2010 Sunday Update
BI Publisher - Hottest Show in Vegas
Arup Nanda - My Sessions at IOUG Collaborate 2010
Oracle Federal Applications - Quick Collaborate ‘10 Update
Bex Huff - Bezzotech and IRA Merge Into One!
Brent Lowe at The Lowe Down
- Collaborate 10 Day 4
- DataZing Product Launch, BI Publisher Fun and More From Collaborate
The JD Edwards Advisor by David Andrews
- Live from Collaborate – Day One observations
- Collaborate Day Two
IOUG blogs by George Trujillo - Collaborate 2010 Conference – Las Vegas: Day 1

Post-COLLABORATE
The EPPM Blogspot - Thank you for joining us @ Collaborate!
RittmanMead
- Stewart Bryson - Wrapping up Collaborate 10
- Mark Rittman - What Happens at Collaborate...
The Data Warehouse Insider by Jean-Pierre Dijcks - Collaborate10 – THEconference
Billy Cripe - Fishbowl Solutions at Collaborate 2010
IOUG blogs by Unknown - COLLABORATE 10: Users Rule!
Bob Rhubart
- Podcast Show Notes: Collaborate 10 Wrap-Up - Part 1
- Podcast Show Notes: Collaborate 10 Wrap-Up - Conclusion
Ben Prusinski - Collaborate 10 Conference Experiences in Vegas
Sunil Ranka - Collaborate-10 : Round Up
Debra Lilley
- The Great Escape
- Collaborate 2010
- Collaborate 2010 Roundup

These were pulled mostly from the OraNA feed with a few coming from the Oracle Blog feed. If you know of any others, please let me know and I'll add them here.

COLLABORATE: Day 3 Wrap Up

Despite going to bed at around 4 am Vegas time (7 am my time), I managed to get up around 8 (Vegas time).

I headed down and visited with some of the vendors to get some information on what they do, what they provide, etc.

I found a spot in the main lobby and parked myself there to start writing.

Ten minutes in, this guy comes over and we started to chat. He had just given a presentation on the MODEL clause so we spoke about that for a few minutes. His name was John King, which is my mother's maiden name. Talked about some other stuff before he took off for his next session.

Shortly after he left, this woman sits down next to me and we start to chat. I notice she has an ODTUG shirt on and I ask her if she is a member. "I'm on the board of directors." How cool. I then told her about pestering Mike Riley (and then Mark Rittman) about getting a blogger pass to the event.

Then it hit me who she was...



If you've seen the site recently, specifically the "T-Shirts in the Wild" slide show at the top right of the page, you would have seen David Peake (APEX Product Manager) and this other woman. Turns out I was sitting next to the "other woman". Barbara Morris was her name...I quickly showed her that her picture was up on my blog (since replace by Superman, Brian "Bex" Huff). Small freaking world.

When I was rested up, I went back into the exhibition hall where I ran into Mr. King again. I asked him if he was stalking me. He denied any such behavior. The exhibition hall was closing so that could prepare the food (and beer) for the 5 o'clock rush. I had asked him if was leaving and he said, "No, I'm an Exhibitor"

"Really, where's your booth?"

"I'm with ODTUG"

"No shit?"

"I'm on the board"

LOL.

I then told him about pestering Mr. Riley (and Mr. Rittman) and told him I had met Mrs. Morris just after I first met him. I'm thinking that I was meant to attend ODTUG as a blogger...or at least that's what the universe was telling me.

Had my requisite beer(s) while perusing the exhibition hall finally ending up at the IOUG "booth"



I then followed these young ladies to the BIWA SIG event where many more IOUG workers were hanging out.



Met Stewart Bryson, who will be presenting at the Suncoast Oracle Users Group next month. Met these guys too...



This is also where I found out about Mark Rittman's "Person of the Year" award too...so I'm glad I attended.

After that it was off to the Fishbowl Solutions and (finally) an early night for me.

COLLABORATE: Best Party (so far)

Fishbowl solutions hosted a party at the Mix Lounge atop THEhotel this evening. While distracted by the "wives of fishbowl"



(not pictured the lovely Amanda who loves to email blast me throughout the year)

and also distracted by pretty blue drinks (that didn't glow, much to my consternation)



I eventually made it outside to the balcony where I was greeted with a fabulous view of Vegas



Now the voting isn't over...tomorrow night is the big "Beach Party" put on by the COLLABORATE team...but this one was pretty freaking cool.

COLLABORATE: FLOAUG

Also known as the OAUG for the state of Florida.

I was told about the event by Chad Johnson, a frequent attendee of the local Suncoast Oracle Users Group (SOUG) and someone who I have come to like and respect. Mr. Johnson found me falling asleep, I mean, writing, in the main hall.

Of course I was interested in a Florida specific group...anything I can do to get people involved I'm all for.

Unfortunately, it ran right up around beer time (5 pm), but as John Piwowar pointed out:



So I was patient and attended the meeting.

Fortunately for me, the director(s) live in Tampa which means most (quarterly) meetings will probably be close.

This group is mostly comprised of functional people as opposed to the nerdy types, just an FYI.

They began to talk of a "Tech" day somewhere in Florida concentrating on the application side (EBS --> Payroll, HR, etc). SOUG is thinking about doing a tech day later this year. (I raise my hand) What if we combined forces? They seem to like the idea so I stuck around after the meeting to discuss further (again...putting off my beer consumption; it's for the greater good right? can we move this meeting downstairs? please?)

So we have plans to get everyone together to see if it's feasible. I think it makes sense...kind of a mini-COLLABORATE if you will.

Oracle's Person of the Year

It's apparent my humor didn't come out in this writing. This was just a fun post. Mr. Rittman was at an Oracle Magazine event and anyone could get their picture on the cover as "Person of the Year." I will probably try to score one for myself. If you have one, send me a picture and I'll post your story. :)

In what appears to be, to this writer's knowledge anyway, the first "Person of the Year" has been awarded to Mr. Mark Rittman.



Mr. Rittman, a shy man by nature is an Oracle ACE Director in the BI/DW world. He's also one of the principal owners of RittmanMead consulting.

Mr. Rittman was given this high honor in a private ceremony in the Oracle Magazine party this evening. Sadly, this reporter was not invited to the event to cover this momentous occasion.

Congratulations to Mr. Rittman. His wife, Janet, was on hand (which tells this reporter that he knew about the award prior to coming to Las Vegas). The only comment I could get out of him was, "I am very humbled by this prestigious award" (spoken in a British accent of course).

Tuesday, April 20, 2010

COLLABORATE: The Vendor Edition

No conference would be complete without the vendors.

I don't have exact numbers, but there seem to be quite a few. If I had to guess, it would be around 100.

So far, I've mostly visited the ones where I know someone, but today I will try to get around and meet more of them so there is no bias in my reporting.

Some may dislike the vendors, and I may have said the same at one point in time, but I have come around (or turned to the darkside). Back in 2004 I raised 50K to start my own business and managed, somehow, to keep it going for almost 2.5 years. I understand that the marketing and sales part is very, very difficult.

If you are one of those vendor haters...I'll just say they give away cool stuff, mostly. There are a few iPads, Kindles and other such cool devices being raffled off. Just give them your contact information and your good to go.

Here's a list, and pictures, of the ones I have visited so far.

BEZZOTECH



Website
Bezzotech is a St. Paul-based software consulting and development firm, specializing in Oracle's Enterprise Content Management product suite, formerly Stellent.

The name Bezzotech is derived from the word Bezzo, which is a 17th century Italian coin. This name is a constant reminder that technology is worthless unless it can deliver genuine value to its users.

Originally implementRadvantage, The acquisition of Bezzotech Inc, has fused two of the most respected and experienced Oracle Enterprise Content Management solution providers in the industry into THE Premier Oracle ECM Solution Provider.

implementRadvantage was founded by Jason Clarkin, who has been a leader in delivering Oracle Enterprise Content Management Solutions to clients around the world over the past decade. An avid contributor to the ECM community, he is a moderator of the "intradoc user group" - a user group focused on Oracle Enterprise Content Management. He is also a speaker, sharing his knowledge of Content Management at such conferences as Crescendo & Collaborate. implementRadvantage has grown into a full service consulting company, attracting some of the most experienced and knowledgeable ECM talent in the industry.

Bezzotech Inc was founded by Brian "Bex" Huff, who was a senior software developer for Stellent, before it was acquired by Oracle. He is the author of The Definitive Guide To Stellent Content Server Development, and was awarded the title Oracle ACE Director by Oracle for his work in the developer community.

This combination of talent has created a ECM "Dream Team", that can be put to work for you today!
SEEBURGER
(Everyone seems to be going all caps huh?)



Website

I got to torture these guys for awhile, threatening them with the telling of one of my most favorite stories. I think I needed a few more beers though. When I initially read their press release and I saw mention of EDI, I about threw up...I had the wonderful experience of working with some of the healthcare 820 and 835 formats. Thankfully, their software would save me from such torture.
SEEBURGER is a leading provider of global business integration solutions designed to optimize transactions throughout the extended enterprise by automating trading relationships with all partners, regardless of their size and technical resources. Launched in 1986 to provide integration solutions to the automotive industry in Germany, the company today serves more than 7,800 customers in 50+ countries and more than 15 industries through its flagship B2B Gateway and related products and services. SEEBURGER has global offices in Europe, Asia Pacific and North America.
fishbowl



This is where the famous Billy Cripe went to after leaving Oracle. Guess what he was wearing today?



There is no easy "About Us" section for me to copy and paste in here, check out their site for more information. I did receive a brief demo of their iPad application which was very cool.

I'll write about more in Part II and Part III.