admin, answers, OBI, obiee

Working on a system without full access can often be a pain and prevent you from being able to get information necessary for your work. One of those areas is access to system variables. Good thing is. that bits and pieces are flying around all over the web and can be found for example both Oracle’s own SampleApp or this little gist here from @rmoff.

I’ve started mixing and matching together as much as possible of “things you can potentially get out of the system” without having anything else than Answers access and combined it into a single analysis. You can find the gist here. To put it into your system all you need to do is create a new analysis, copy over the XML and reference any of your Subject Areas (two locations; top and bottom of the file). Doesn’t matter which one as long as it parses correctly. Not a single query against actual data sources is run.

gist_top

gist_bottom

I’ll keep adding to this and expand it with whatever hack I can find to circumvent the pesky “you’re not an Admin” situations.

sysvars

event, kscope, obiee, odtug

Next week from June 26 to 30 it’s time again for the epic ODTUG KScope16 which is happening in Chicago, Illinois this time. After unfortunately missing last year’s KScope15 in Florida I am happy to be back with two presentation slots of my own plus a joint presentation.

You can find the full agenda here including my three sessions in the BI and Data Warehousing stream of the event:

  • 50 Shades of #Fail: OBI Worst Practices in Real Life
  • Back2Basics: A Day in the Life of an Oracle BI Query
  • OBIEE Security: It’s a Jungle Out There(joint presentation with @G_Ceresa)

This year I had the pleasure and privilege to be a member of the content committee for the BI/DWH stream in order to do my part of making the event as epic an experience as possible for all participants.

Looking forward to seeing all my friends and fellow Oracle ACEs again.

general

“If you have a tool and arn’t aware if what it can do, its dangerous. A jedi can do amazing things with a lightsaber. A roomful of chimps with lightsabers… would get messy. 

Source

blog, general

I am currently in the process of moving all assets over from blogger and it seems that a miraculous multiplication of blog posts is happening – once with and once without images as it seems. Will clean up in the coming hours.

Update: So it seems that even after trying 3 different import tools not all images have made it over. A pity but that’s life – you’ll still be able to see the original posts including all images under the old URL: hekatonkheires.blogspot.com

Uncategorized

Date: Monday 7th December – Wednesday 9th December
Location: ICC Birmingham
Agenda: http://bit.ly/Apps15_ag

UKOUG Apps15 is the must attend event for Oracle Apps professionals, with over 120 sessions there is something to suit everyone.

My session will take place on Wednesday, 9th from 10:00-10:50 and is entitled

    “50 Shades of #Fail – OBI worst practices in real life”

I look forward seeing you at Apps15!

Uncategorized

Leaving some time between the trip home from OOW14 and finishing up the blog post on the 4 official days of the event has had an interesting effect: excellent write-ups of the news and announcements have already popped up, so it’s a pleasure to simply link to Mark Rittman’s “News and Updates” post for all your needs in that regard.

Session or rather content-wise over these four days there are a couple of things to point out:

1.) OakTableWorld

Not a session per se but rather OakTables concurrent event with brilliant presentation content from the likes of Kent Graziano, Alex Gorbachev, Jonathan Lewis etc. Full agenda of what happened this year can be found here.

What I really appreciated was the fact that OakTableWorld – in contrast to OOW itself – sports a host of 10min TED talks over lunch. The TED talk format can be loved or hated but mostly it depends on the content and the speaker. Listening to Jonathan “Breaking Exadata” is huge fun and he doesn’t need more than 10min to convince anyone that there’s sales&marketing talk and then there’s reality. Exadata’s great, but no holy grail and you CAN break it.

Another real “WOW” effect was Eric Grancher from CERN (“those guys” with the Large Hadron Collider and the Higgs Boson … maybe). Eric had a pretty neat TED talk about ASH to understand disk IO, but the killer was to see how they pipe that gathered information into Endeca to actually analzye their disk IOs through the Endeca engine. Very nice!

2.) Roadmap sessions

I sat in just about every roadmap session touching Business Analytics topics from the engineered systems over OBI 12c to the new Visual Analyzer and BI Mobile App Designer futures. Perfect place to catch up with the product managers and have some post-presentation chats with them. Looking forward to their upcoming initiatives and hopefully being an early adopter.

These sessions aren’t as detailled – technically – as the ones you may see at KScope, but they’re official, they’re sanctioned, they aren’t under NDA and they represent Oracles road into the future. If you plan on visiting OOW…pencil them in for the products you work with!

A special mention of the BI Apps roadmap session:
I was pretty surprised to see an almost total lack of reaction from the crowd when the slides reached the official declaration of the Informatica version of OBIA being discontinued and all OBIA projects having to move to ODI if they want to stay on the upgrade path. Maybe the message was too well hidden in marketing speech, but it should have been clear enough – so here it is again: there will be NO 11g release for BI Apps with Informatica and also none whatsoever in future versions. Informatica is out. OBIA customers will have to get onto the ODI train!



3.) Customer success stories

Not my thing. Tried sitting through one, but this is more for other end-clients to listen to and maybe get an idea or benchmarks.

All in all Oracle Openworld 2014 was an epic experience and I wouldn’t have missed it for the world. If you’re interested in another OOW-freshman’s experience report, look no further than my good friend Robin Moffatt’s write-up.

In terms of meeting people, tightening my community bonds with other Oracle ACEs, the OTN community and the superb ODTUG folks this event is definitely “up there” in the stratosphere called “that’s just about as good as it gets”!

BTW: Presentations are still not all up so bear with me.

Uncategorized

OOW14 day 0

w00t! One compound word? Mind-boggling!

As a first time OOW participant, when I arrived at Moscone this morning, the sheer size, grandeur and general over-the-top-ness hit me like a brick. Seeing it in pics and on youtube is one thing but experiencing first hand…wow. KScope back in June was a family party in comparison! Which isn’t a bad thing by the way

For me, Sunday was all about getting my bearings and participating – both as audience as well as speaker – in the ODTUG sessions. “Figures” you may say as I’m more on the hands-on and technical side of things rather than sales + marketing presentations and – again – you’d be 100% correct.

First things first though: heart-attack and vessel constricting breakfast with my good friend Robin Moffatt. Because. BACON!

In hindsight I probably shouldn’t have taken the ubercaffeinated version of coffee offered there since combined with the adrenaline of pre-OOW-presentation makes fingers tingle. Lesson learned for next time!

I was part of the ODTUG Sunday Symposium (big h/t to ODTUG in general and Stewart in particular on that one), so let’s jump into the action:

SESSIONS!

Engaging Oracle Business Intelligence Users Through Collaborative and Embedded BI

Christian Screen provided a nice, visual overview of the evolution and life-cycle of BI initiatives from birth to near-death (a state which you hopefully never reach). Accompanying this life-cycle are all aspects of collaboative and embedded BI he showed in the form of biteamwork as well as real-life examples of embedding BI content into any web-portal – literally at the click of a button. Really clever stuff utilizing and extraction and direct referencing of the divs inside the rendered OBI GUI. Neat!
Unfortunately I had to realize about that time that my phone takes really BAD pictures when the lighting is low and you’re in a sombre room.

2014 Swiss Community Brunch

I had to skip this one when I saw just where the Hyatt is situated geographically and how long it would take me to get there and back again (unintended Lord Of the Ring reference) without missing my scheduled sessions.
OOW is huge, OOW is crammed full of content…OOW is tricky in terms of scheduling your activities! 

Oracle Business Intelligence Development in the Cloud

Stewart was up next and immediately disappointed some pin the audience since his talk wasn’t going to the BICS – the Oracle BI Could Services – but rather actual OBIEE development work in the cloud. Gotta read the abstract of the session as well, gents, not just the title 😉
Anyhow a presentation not for the faint of heart as things got technical very quickly with MDS XML, Git, Jenkins, push, merge, branch. I loved it and if you’re doing OBIEE dev and don’t know how you could manage it across multi-dev departments? Well have a look what he was talking about. May be an interesting starting point for you.

No Silver Bullet: Oracle Business Intelligence Enterprise Edition Performance in the Real World

Good old Robin Moffatt! I’ve Stewart had set the techie tone with his then it definitely went “downhill” in a very good sense – the technical one – from there and I think reached the abyss with my presentation thereafter. More and more “Ey?” and “WTH?” faces in the crowd.
I’ve seen this presentation of Robin before and I just love it. Firstly because Robin trashes “best practices”…the only real “best practice” there is, is “use your brain”. I agree 100%. All other so called “best practices” are contextual and need to be adapted to the actual situation, so “it depends”.

His approach of tracking and analyzing performance and capacity issues is neat to say the least and everytime I discuss these subjects with him there’s stuff to add and something new to try out. But I digress.

Performance and capacity tracking isn’t magic but neither is it “follow this 10 point list….oh and by the way disable logging and use caching”. Ah my pet hates. NO! You want to do performance mgmt? Get Robins presentation. Read it. Understand it. Adapt it to your situation. Do it.

I’ll try to add links to the presentations as (if) they become available and do a complete wrap-up after OOW with a link list so you have a single point to go to in order to access all of it. 

Neos Voyage in Oracle Business Intelligence Enterprise Edition

My presentation. Was fun, but I lost about 80% of the audience mentally after slide 8 or 9. NQS function calls? Recursive ODBC calls from the BI server through the BI server into its own instantiated RPD in order to have it as a data source within itself?

As promised for those who stuck around until the end and want to dig deeper themselves: shoot me an email on christian dot berg at dimensionality dot ch and I will get back to you with the RPD you need to make this work. 

Quick Dive into Big Data ETL with Oracle Data Integrator 12c and Oracle Big Data Connectors

Last content session of the day was Mark Rittman and this also was a presentation I’d seen before but let me just say this: I don’t know how he does it. Mark has this way of just writing slides on the darndest (pardon my french) of topics and make it look and sound like he was writing a grocery shopping list for Friday afternoon. Precise, to the point, gets the information across, not overcomplicated and definitely without all the sales and marketing hubbub.

Best wide-ranging overview of Oracle’s Big Data initiatives in the wider Business Analytics context you can read right now.

Funny addition: after the presentation there was a definite fan-club behaviour going on and I just couldn’t help myself. Apologies again Mark, but here goes:

All in all a very productive day with meeting tons of people. The number of ex-colleagues, fellow community members and ACEs you run into here is just immense.

Gotta rush now to get some breakfast before today’s sessions. I’ll do an extra post on Sundays ACE dinner later.

Uncategorized

Oracle OpenWorld 14 Day -1

Saturday was a rather quiet day. After having spent 2 hours on Friday night, trying to get the connectivity working in my hotel room, Friday started out with another almost 2 hours which culminated on a recabling of the room and replacement modem to finally get things working. After that I was able to put the finishing touches to my presentation.

Lunch was…american. Very american. Think 50s-type diner. Think chili-chedder-hot-dog. Think fries. LOVE IT! There was some mutual “prying away from work” going on there and Stewart Bryson and Kevin McGinley completed our epic-food triumvirate. Great find Stewart and thanks for saying on “I have my heart set on Lori’s”. Not the last time I go there this week!

Then: check-in time!

Feels good 🙂

Later in the afternoon I joined a whole funky bunch of ODTUG people at a place called “Toronados” for beer. Really good beer. IPA galore you could say and you’d be correct. Sarah Zumbrum, THAT Jeff Smith, Monty Latiolais, Tim Gorman, Joel Kallman, Danny Bryant, Kellyn Pot’Vin…I can’t even name them all (anymmore).

After too many weird-named (but all the more tasty) beverages we trudded off to a dinner with current and ex RittmanMead guys from which I zombied my way back to bed since the 30+ hours travelling and a really bad night of sleep had simply killed me by then.

Hard start. Off to day 0!

Uncategorized

THINK and UNDERSTAND before you give “advice”

One tag. Rant.

Every now and then when I’m on the OTN forums, I run into gems like this: https://community.oracle.com/thread/3589607

The problem isn’t the question – it’s the “answer” which is both mind-blowingly wrong on so many levels and ends with the usual childish “Gimme points, I crave attention!” footer. I’m not going to go into details on the technical solution since that’s covered in my response to the thread itself, but let me just make one thing clear:

Use content from a presentation like Jeff’s without thinking just to – wrongly – “prove” your point and you will tick me off. Seriously.

Why did Jeff include the 1=1 join option? Did you see that it was an option and not the ultimate answer ® ™? Do you even know what a content level is?

< / rant >