oracleace, OTN

If you’re following me on twitter you’ll know that I’ve been travelling and conferencing quite a bit this year. Someone I kept running into was Ms @oracleace herself: Jennifer Nicholson. For those of you who don’t know her – she’s our ACE mom ๐Ÿ™‚ Translation: she runs the ACE program. She organizes the ACED travels. She actually reads all our endless reply-all email chains to the different ACE lists (seriously guys – STOP IT!) and replies in no time flat. She handles nominations/applications. As I said – she’s our mom.

To give you an idea of how much she supports us all around the globe and not just administratively: while I rocked up at DOAG in November after a central european trip through 4 countries she came there after a multi-week continent-hopping convering China and India amongst other places. Still she did the DOAG and after just two weeks back in the US flew over to Europe again for UKOUG. Respect.
Having her on site is always a rallying point for the ACEs participating in these events as well as a point of contact for other people interested in it.


Another thing I’d like to say out loud on here for once – and only once I will not get into this discussion again – is that I want to congratulate her on and thank her for the calm and professional way she has managed the recent restructuring of the ACE program and the ensuing nigh-revolt thunderstorm!

Thank you, Jennifer!

To all other ACEs out there: Please don’t be whining divas bordering or obnoxious bitchiness!

community, conference, oracleace, OTN, Uncategorized

Sitting at Birmingham after a great UKOUG Tech16 and for once using the time to update my much-neglected blog ๐Ÿ™‚

Hadย  a great time again this year both in terms of content and social interaction. Session highlights – in no specific order I’m not ranking here:

  • Query, Integrate & Visualise All Your Data Using Hadoop – Mark Rittman
  • Kafka’s Role in Implementing Oracle’s Big Data Reference Architecture on the Big Data Appliance – Robin Moffatt
  • Data Streaming From Oracle To Kafka – Chris Lawless
  • Source Control, Code Deployment & Concurrent Development for OBIEE 12c – Robin Moffatt
  • Advanced Visualizations With Oracle BICS & Data Visualization – Antony Heljula
  • A Post – Big Data Analytics Platform & Use Of Oracle Advanced Analytics – Brendan Tierney
  • Community Keynote Business Analytics: How to spot the signals that tell you what’s REALLY going on in your business – Philippe Lions and Duncan Fitter
  • Advanced Analytics in Oracle Data Visualization Desktop – Philippe Lions
  • Oracle BI Analytics – An Update From Product Management – Mike Durran
  • Reduce European Flight Delay – Real Time ODI, OBIEE and D3 – Jerome Francoisse
  • OBIEE 12c Upgrade Experience At Liberty Global Case Study – Francesco Tisiot

Phew that’s all. It was refreshing to see that we finally reached the post-hype – and hence post-marketing-sales-BS stage – for Big Data and generally the next evolution of Analytics with many very pertinent real-life talks. Room assignment to Business Analytics talks could have been a bit better though as several of us including myself for one talk were in rooms with 11 person capacity and people standing squeezed up against the wall, in the door or even outside in the hallway.

Personally I did two talks about BI Server Query Execution and OBI Security respectively. For the latter I was joined by Gianni Ceresa for the coveted slot of 08:50 on Monday morning. Very good audience presence for both talks and some good questions which shows that foundation / core topics are still very much in demand rather than being skipped.

Content aside it was an excellent chance to meet up with several people again whom I hadn’t seen in a while and to do some more things for the OTN and ACE networks – more on that in a separate post to come. Tuesday night I hosted a meetup for Analytics geeks which drew a nice crowd in spite of numerous conflicting parties. Probably since we didn’t just “beer & business” around as usual but – being geeks – also had good fun with some card games. h/t to Jerome for bringing along a nice new one I hadn’t tried yet. Definitely something I’l lkeep up

UKOUG completes this year’s conferences and what a year it has been. Be seeing you all in 2017 at one of the Oracle User Groups, independent conferences or the mothership fest that is OpenWorld!

OBI, OTN

Some 2 weeks back Tim Hall had the wonderful idea of getting together on a specific date and making our love for the Oracle Technology Network known to the world.

Continuing on Robin’s list of what OTN does for us I would like to add their conference tours across the different continents like the current one running in the EMEA nordics. Secondly – and obviously – the ACE program which is quite simply the most amazing community I was ever a part of.

Anyone who know me knows that I quite literally worship the power and flexibility of the core BI server which harks back to the end of the 1990 when a couple of extremely clever guys created a metadata engine which was so far ahead of its time that its core remains pretty much the same until today and serves as the basis for Oracle Business Intelligence (OBIEE, OBIA, OTBI, etc), Visual Analyzer, BI Cloud Services, Data Visualization and Data Visualization Desktop.

One of the key functionalities of the BI Server is its ability to read just about any source of data you can imagine or come up with:

obi_data_sources

 

Add to this list of natively supported source types the power of reading literally anything based on ODBC and it becomes almost problem to find something you can’t analyze with OBI and its children.

Databases, multidimensional cubes, flat files, Hyperion applications, XML are at your fingertips just like many of the new kids on the block. Hive, Impala and Spark that is…not these guys.

I raise my glass to OTN. Prost, Zum Wohl, Santรฉ, Cheers, Kampai, Na Zdrowie and Salute!

community, event

I’m currently sitting in yet another very good talk at the Polish User Group 2016 conference – first of it’s type ever to happen in Poland. Second-to-last of my conferences for this year according to current planning I have to really tip my hat to the team here for a very well organized conference with a brilliant line-up of speakers and topics. Especially if you’re considering that it’s their first one ever. Massive turnout in terms of participants as well! ……looking at you there SOUG. Learn from your peers guys.

I think Robin’s gesture here speaks for itself.

In terms of content I’ve managed to grab a number of sessions:

  • “DBA, Heal Thyself: Five Diseases of IT Organizations and How to Cure Them” – Jim Czuprynski: I really hope he uploads the slides so speakerdeck or slideshare. Basically he spent the hour denouncing management stupidity, procedural ridiculousness and political rubbish and why + how this destroys your project, your initiative and generally IT in general.
  • “Introduction to graph databases” – Hans Viehmann: Heard it several times already but it’s always nice to see how Hans makes a rather extra-normal topic in the Oracle family accessible and understandable as a concept to people who have never run into it.
  • “(Still) No Silver Bullets : OBIEE 12c Performance in the Real World” – Robin Moffatt: What can I say on this one. “I agree” or “+1”? Or basically: IF you don’t get this please leave the industry. NOW.
  • “Why has my plan changed” – Neil Chandler: Brilliant analysis of just how badly many things around the optimizer…many times…are gotten wrong, ignored etc. As I said on twitter: Something to give your DBA to ponder.
  • “Analyze This! Practical Examples of Oracle Analytical Functions” – Jim Czuprynski: Another great talk by Jim. I really think analytical functions – even when you’re just talking about PIVOT/UNPIVOT or windowing – are in many cases where a proper analytical environment doesn’t exist just underused. Let alone all the 12c stuff which has been added.
    And with him and his twitter handle “TheWhyGuy” it’s really all about what I constantly preach: WHY you should do things in what way is all that it’s about. Not brainless repetition of things someone said or you’ve read or heard.
  • “Tips on Bulk Data Processing with SQL and PL/SQL” – Martin Widlake: Currently ongoing but as it is with Martin: Very down-to-earth and to-the-point. No flamboyant rubbish or embellishment. Because this is just how things work. Couldn’t agree more.

All in all a very good conference. Very glad I invited one of my client teams to participate in these two days and introduce them to conferencing and the Oracle community! I really wish POUG all the best for the future. A new proud member in the family of Oracle User Group conferences.

Oh yeah. And the beers. Good grief. A place for Jeff Smith ๐Ÿ˜‰

12c, security

Following up on my last post it turns out that the conundrum is nothing but Enterprise Manager currently displaying things in a somewhat sub-optimal manner. The permissions etc are all there but they are just not being displayed under their respective permission class.

WLST confirms this when listing things with listResources(appStripe=”obi”)

So conundrum = just a hick-up ๐Ÿ™‚

11g, 12c, application policies, OBI, permissions, security

So we know that 12c made some small changes in the security area – the most well known being “BI Administrator” being renamed to “BI Service Administrator”.

This can cause some issues when importing 11g BAR files with old “BI Administrator” roles but set “security model=false” during import. Well this isn’t what this post is about but still something you may want to remember ๐Ÿ˜‰

What this post IS about is the little weirdness which is happening in Application Policies and the Permissions you can grant to a policy and its principals.

Let’s look at the permissions granted to “BI Service Administrator”. There’s two set of rights which look suspiciously similar:

Can you spell “redundant”?

Ok let’s turn this upside down and create a new application grant for a “close to Admin”-type set of rights:

Searching by “Permission Class” oracle.security.jps.ResourcePermission yields 14 results.

Funny enough we don’t find all four of the permissions in the screenshot above. Two catalog permissions are present – “oracle.bi.presentation.catalogmanager.manage” and “*” for the oracle.bi.catalog permission type. “*” for oracle.bi-repository isn’t there though. Hmmm. Let’s search by “Resource Type” and try to find the four in question one by one.

Why hello there. Not only do we find all four but also a nice little remark on the two known ones: Legacy Permission from BI 11g

So it seems that those two are about to get dropped and be replaced by the new “*” resources. But why is only one of the two new permissions visible when searching by “Resource Class” when it seems to actually HAVE the correct resource class assigned to it?

Smells like something needing a little fix. Most important though: going through permissions by resource type and checking the ones labeled as “Legacy 11g” is a good idea in order to not be relying on things on their way out of the product…

community, kscope

The ODTUG KScope16 speaker evaluations just arrived in my inbox and I wanted to take a moment to express my gratitude to everyone who came to listen to my sessions and for their magnificent feedback.

Thank you from the bottom of my heart – this is why I do these conferences!

Thanks also to everyone from ODTUG and all my friends from the community. I hope to see you all next year in San Antonio for KScope17.

12c, dashboard, OBI, obiee

A new functionality has been introduced in the latest release of OBI – 12.2.1.1.0 – which has gone a bit unnoticed since it hasn’t been included in the documentation anywhere. This is surprising since it’s been requested since a long time.

Dashboard subpages!

As of this release the usual 3-level dashboard hierarchy has been transformed into a 4-level one:

  • Dashboard group
  • Dashboard
  • Dashboard page
  • Dashboard subpage

dashboard sub-pages

Configuration is very straight-forward. Just click the usual “Add” button which will give you two options as of now:

dashboard_add

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.