Below is this week’s Oracle analytics and data roundup for obiee.co.uk readers, covering OAC/OAS, Fusion Data Intelligence, Autonomous Data Warehouse / 23ai, and a practical SQL tip. This edition is intentionally light: there were no specific articles or announcements provided to summarise, so the focus is on stable capabilities, patterns…
Oracle Analytics Weekly Roundup — 11-May
Below is this week’s Oracle analytics and data roundup for obiee.co.uk readers, covering Oracle Analytics (OAC/OAS), Fusion Data Intelligence, Autonomous Data Warehouse / 23ai, and a practical SQL tip. Note: there were no new official product announcements or blog posts in the provided feed this week, so this roundup focuses…
Oracle Analytics Weekly Roundup — 13-Apr
Note: No official product updates or articles were provided this week, so this roundup focuses on practical guidance, patterns, and reminders drawn from recent customer conversations and field experience rather than new feature announcements. Oracle Analytics (OAC & OAS) 1. Hardening OAC / OAS Data Sources and Connections TL;DR: Spend…
Oracle Analytics Weekly Roundup — 04-May
Below is a WordPress-ready weekly roundup template. You didn’t provide any source items (the JSON payload was empty), so this edition uses placeholder bullets and links that you can replace with the real articles when you have them. Oracle Analytics (OAC & OAS) 1. Placeholder: New Visualisation Enhancements in Oracle…
Oracle Analytics Weekly Roundup — 27-Apr
Below is a WordPress-ready weekly roundup template. You didn’t provide any source items (the JSON payload was empty), so this edition is structured as a “meta” roundup with evergreen guidance and placeholders where you can drop real links and details once you have them. Oracle Analytics (OAC & OAS) 1….
Oracle Analytics Weekly Roundup — 20-Apr
Note: No specific news items or links were provided this week, so this roundup focuses on current themes, recent patterns in the Oracle ecosystem, and evergreen techniques that remain highly relevant for OAC, OAS, FDI, ADW/23ai, and SQL practitioners. Oracle Analytics (OAC & OAS) 1. Hardening Data Access with Row-Level…
Oracle Analytics Weekly Roundup — 06-Apr
Below is this week’s Oracle Analytics & Data roundup for obiee.co.uk readers, focusing on OAC/OAS, Fusion Data Intelligence, Autonomous Data Warehouse / 23ai, and a practical SQL tip. Note: there were no new product-specific items provided this week, so this roundup focuses on stable, battle-tested patterns and usage tips rather…
Oracle Analytics Notes
Oracle Analytics (OAC & OAS) Item 1 – Using Data Flows for Repeatable Data Prep TL;DR: Data Flows in Oracle Analytics Cloud and Oracle Analytics Server let you turn ad‑hoc data wrangling into a repeatable, schedulable pipeline. They’re ideal for lightweight transformations without involving DBAs or ETL tooling. Many Oracle…
Oracle Analytics Notes
Note: No new items were provided this week, so this roundup focuses on practical reminders, evergreen techniques, and conservative summaries of existing capabilities rather than new feature announcements. Oracle Analytics (OAC & OAS) 1. Hardening Data Access with Row-Level Security TL;DR: Revisit your row-level security (RLS) in OAC/OAS: centralise filters…
Oracle Analytics Weekly Roundup — 23-Mar
Note: No external items were provided this week, so this roundup focuses on recent themes, common questions, and practical tips we’re seeing in Oracle Analytics and data projects. Where relevant, links point to core product documentation and reference material rather than news announcements. Oracle Analytics (OAC & OAS) 1. Hardening…
Oracle Analytics Weekly Roundup — 16-Mar
Note: No external items were provided this week, so this roundup focuses on practical guidance, recent themes in the community, and evergreen techniques rather than specific news announcements. Oracle Analytics (OAC & OAS) 1. Hardening Data Security with Row-Level Filters TL;DR: Use row-level security (RLS) in OAC/OAS to ensure users…
Oracle Analytics Weekly Roundup — March 8th
There were no specific news items or links provided this week, so this roundup focuses on current themes, recent trends, and practical guidance across Oracle Analytics Cloud (OAC), Oracle Analytics Server (OAS), Fusion Data Intelligence (FDI), Autonomous Data Warehouse / 23ai, and SQL. All content is intentionally conservative and based…
Oracle Analytics Weekly Roundup — 23-Feb
There were no new items provided to summarise this week, so this roundup focuses on a set of “evergreen” topics and practical tips across Oracle Analytics, Fusion Data Intelligence, Autonomous Data Warehouse / 23ai, and SQL. Where relevant, links point to core product documentation and landing pages rather than news…
Oracle Analytics, OAS & Data Warehousing – February 19th
Welcome to another Oracle Analytics and Data Warehousing roundup — a focused summary of useful updates, blog posts, and technical resources across: 🔷 Oracle Analytics (OAC & OAS) – Platform Updates & Governance Recent updates across the Oracle Analytics ecosystem continue to focus on AI-assisted analysis and stronger governance controls….
Fusion
Read more
🔦 Fusion Data Intelligence Feature Spotlight
Prebuilt KPIs & Extensible Semantic Model With Fusion Data Intelligence (FDI) — soon to be renamed as Oracle aligns its AI & Data branding — one of the most powerful (and sometimes underused) capabilities remains: Prebuilt KPIs delivered on top of an extensible semantic layer running on Autonomous Data Warehouse….
Oracle Analytics & Data Warehousing – Weekly Roundup
February 18th 2026 (already!) Welcome to this week’s Oracle Analytics and Data Warehousing roundup — a quick TL;DR summary of useful updates, blog posts, and technical resources from across the Oracle community. As always, this focuses specifically on Oracle Analytics Cloud (OAC), Autonomous Data Warehouse, Fusion Analytics, and useful SQL…
Oracle Analytics and the AI wave
🚀 Oracle Pushes Forward with AI-Driven Analytics and Data Warehousing in 2026 As businesses continue to embrace AI and data-driven decision-making, Oracle is rapidly evolving its analytics and data platform offerings to meet the demands of modern enterprises. From unified AI platforms to next-generation autonomous data warehouses, the pace of…
Good Old Fashioned Hardware
In a world that has gone cloud and visualisation crazy, it was a joy last week to install some Oracle onto a Physical Server. Yep, a real server you can look at, touch, pickup and move office And best of all? It was soo easy to install on, and re-install,…
Addidici is on Holiday
After 25 years of hard graft, its time to take a break! Working hard, often under extraordinary client pressure, takes its toll, even on the unflappable Addidici, so we have taken a break from work, from Analytics and from blogging. This has given us time to travel, to reflect and…
Cloud
Read more
October News
Wrapping up Oracle AI World Connor McDonald writes that there was lots of buzz around AI but it was great to still see the high level of interest in the core database tech. Read his wrap up here. Implementing the Model Context Protocol (MCP) in Oracle Database 26ai Bruno Reis writes:…
Analytics
Read more
July News
1. Using Spatial Studio to Extend / Enhance Dimensions for OAC Wayne D Van Sluys writes, “Oracle Spatial Studio is a great tool that can be leveraged to extend or enhance location based data you may already be working with in your analytic projects.” He walks us through an example…
Weekly News
Read more
May News
1.SQL Server Vulnerability: Audit Failure for SERVER_PERMISSION_CHANGE_GROUP in SQL Server 2022 This blog begins by saying, “Important Disclaimer: This vulnerability was reported to Microsoft. After assessment from Microsoft side they concluded that this is a low impact vulnerability and will fix it in a future “cumulative update” patch.” It concludes with “security…
Installing Windows Server 2025
Just a quick note to cover the install of a new Windows server on my blade. The first part of the process is to get the software. I use Microsoft Partner Centre, which seams to change the way it works, every YEAR! Annoying, but after an hour of setting things…
Install Apache Tomcat on Windows
One of the recommended webserver/app server systems to use in you ORDS/Apex stack is Weblogic, the other is Tomcat. I prefer tomcat because it is soo much quicker and easier to install, and more importantly, to configure. Pre-Requisites For this install I am using the JDK we already install (GraalVM…
Installing JDK 21 on Windows
Continuing our series on using apex to manage Oracle Analytics security. The APEX ‘Stack’ consists of five components The good news is that all of the above can be installed for free, even on windows, for you to learn from. Lets look at how we ‘install’ JDK Firstly we download…
Installing Apex on Windows
Oracle Analytics security can (and should in my view) use database tables managed using Oracle Apex. These tables can enable The reason we would do this is because user administration does not exist in OAS, the nearest you can get to it would be to use Console to manage the…
Cloud
Read more
February News
Stew Ashton writes, “Finding the difference between two dates or timestamps is hard! I am not fully satisfied with any of the solutions I have already proposed (or read), but I think this time I may have a decent answer.” 2. Step-by-Step Guide to Creating a New Forms Server in…
Automating the OAS System
Oracle Analytics Server Estate If you have chosen the Analytics Server route, either installed on your kit, or on Cloud virtual machines then you will be running the install yourself, and the patching, and the upgrading, and bug fixing. One of the key benefits of this approach is that it…
Analytics
Read more
January Reading
This blog opens with: “A couple of my students wanted me to write a switch and parameter handler for Python scripts. I wrote it just to show them it’s possible but I also show them how to do it correctly with the Python getopt library, which was soft-deprecated in Python 3.13 and replaced…
Analytics
Read more
Some Pre-Christmas Reading
1. Oracle ASM Filter Driver (AFD) Filtering and 5.15 UEK7 kernels Ron shares the background: “As a long time fan of the Oracle ASM Filer Driver, one of the major benefits for Oracle ASM Filter Driver (AFD) is AFD Filtering. AFD can ensure writes are only performed by trusted and…
Analytics
Read more
December Musings
1. Lock Control in Database Onur Ardahnli began with, “In today’s article, we will discuss checking for LOCKs in the database, which is one of the checks we perform when there is a problem in the database.” 2. Spring Cleaning This blog goes through two different scenarios and concludes with: “Wrangling…
Oracle
Read more
November Reading
Recent Blogs I’ve Read: 1. How Can a Data Breach of an Oracle Database be Managed and Analysed? Pete Finnigan asks, “If you become the latest victim of a data hack and your Oracle database is compromised then what do you do?” 2. Applying the first Monthly Recommended Patches (MRP)…
Installing ODI 12c
This is a quick guide to manually installing ODI on a Windows machine. This will take a blank machine and set up a fully functioning ODI system. For this you must have a database in place already and have an account at oracle.com so you can download the software. You…
Oracle Analytics
Read more
October Reading
Nikhil Kotak shares abuot: 2. Should you use the Override and/or Replace Features? Jim Marion asks this question! He ends the blog by saying, “The Override/Replace features are fantastic for REPLACING Oracle’s delivered code. In other words, if you don’t want Oracle’s code to run at all, then override or…
Setup Linux User
I am creating an ODI server, and the first task is to setup the linux user. This post will show how to create a user and connect to it in MobaXterm using Keys. The Tasks involved are: Create the User Set the Password Login Here I have created a session…
Analytics
Read more
End of Summer Reading
1. Staging Tables in Oracle 23ai Dani Schnider begins this blog saying, “Browsing through the Oracle 23ai New Features Guide, I once again discovered a small, inconspicuous feature that I had previously overlooked: There is a new option to create stage tables. What is the advantage of this enhancement?” 2. Separating…
Analytics
Read more
Some Summer Reading
1. Installing Xfce on Oracle Linux 9 Martin Bach shares, “This post explains how to install Xfce on Oracle Linux 9.4 x86-64 using the EPEL (Extra Packages for Enterprise Linux) repository. I’m fairly sure the same applies to ARM64 as well, but I didn’t have time to test. The article is based on…
Analytics
Read more
The Best of May
1. Compatibility Issues David Fitzjarrell begins with: “Oracle can be set to use a broad range of version settings, controlled by the compatible setting. Normally upon install this is set to the current version of the database that’s been installed. There may be times, however, when a lower compatibility setting…
Analytics
Read more
April’s Best Blogs
1.Configuring Shared Global Area (SGA) in a Multitenant Database David Kurtz shared, “I have been working on a PeopleSoft Financials application that we have converted from a stand-alone database to be the only pluggable database (PDB) in an Oracle 19c container database (CDB). We have been getting ORA-4031 (unable to…
Analytics
Read more
April News
1.Connection to Oracle Autonomous Database In this blog, Selvakumar Nagulan explains how to connect to an Oracle Autonomous database using SQL developer, SQL plus or other tools. He refers to this document in his blog. 2. Reading a LOB in another session Martin Berger begins by saying, “Reading a LOB in…
Oracle Analytics
Read more
Multi-File Datasets vs Multi Datasets
Managing data in Oracle Analytics can be done in a variety of ways – So how do you know which is the best way? Lets looks at the options Here’s a great video showing the muti table approach So lets recap the simple file upload methods we can use to…
Deep Dive AC36 Datasets using Data Flows
Credit: 37th America’s Cup (americascup.com) The individual races for each team are available in separate files, and we saw in the previous post that the file can be imported (into Datasets) and analysed. We are also able to create calculations on the datasets: But those calculations only exist in the…
APex
Read more
Weekly Update w/c 4th March 2024
Maria Colgan shared, “The longer an application has been successfully run, the more likely you are to have indexes that are no longer used or beneficial. Removing these indexes not only saves space but can also improve the performance of any DML operations. But knowing which indexes can be safely…
Oracle Analytics
Read more
Analysing Americas Cup Performance
The Sport of Sailing has the usual types of championships; National, European, and World Championships, as well as a vast array of Regatta’s – Famous ones include Cowes and Antigua. The Championships are fought in boats that are identical, with very strict rules that boat owners must abide by. There…
Oracle Analytics
Read more
My Setup
Before we can investigate tuning options and create a performant Analytics system, we need to have a set of test servers and the capability to rapidly implement a change and compare it to a known baseline. “Hardware” Options Cloud You could choose to use a cloud based setup, AWS, Azure,…
Analytics
Read more
Weekly Update – w/c February 19th
In this blog, Atul Kumar covers: 2. Using server-side JavaScript in APEX processes Martin Bach writes, “In this installment of the mini-series you will learn how to write more complex server-side logic using MLE/JavaScript ECMAScript modules.” He goes through: 3. Oracle Sharding methods compared to YugabyteDB Franck Pachot begins his blog…
Analytics
Read more
Weekly update
Neil Chandler begins this blog with, “Gathering object statistic in Oracle is important. The optimizer needs metadata about the object, such as the amount of rows and number of distinct values in a column, to help it decide the optimum way to access your data. This takes effort, and takes…
OAS Operating System Tuning
This post is part of the Analytics tuning series. see Analytics Performance Intro There are two major factors at the machine level that have a huge impact on the performance. Although there is some benefit from CPU core available, I find that CPU usage is not that high. Making the…
Analytics
Read more
Monthly Round Up
This blog by Federico Venturin links to his article ‘Handling Fine-Grained Data Visualization Permissions in Oracle Analytics Cloud.’ It goes through: In his conclusion, he writes, “Until now, the all-or-nothing approach for handling permissions in Data Visualization posed a significant hurdle to its widespread adoption since administrators understandably preferred to…
Monthly News
Read more
Monthly Round Up – December 2023
Some of the best blogs I’ve read in the last month or so: This blog begins with, “I started some home lab cleanup this long weekend, and one of the first steps was to set up a separate DNS server for the lab. This is really just to make it…
Cloud
Read more
Monthly Round Up – October 2023
Blogs of the Week This blog centres around the new Oracle Cloud Infrastructure (OCI) Product Tours page. This is the analytics section The page also features links to useful YouTube videos. 2. Extract OCI Monitoring Metrics Using REST APIs Alfredo Krieg shares how you can list metric definitions and how…
Monthly News
Read more
Monthly Round Up
Blogs of the Month 1.How to study for 1z0-1067-23 – Oracle Cloud Infrastructure 2023 Cloud Operations Professional In this blog, Alex Zaballa gives some vital tips on what to focus on for the Oracle Cloud Infrastructure 2023 Cloud Operations Professional. He suggests you focus on: He also includes some handy…
Analytics Performance
ALL installations of Oracle Analytics require some form of performance tuning, either as part of the the initial build, or as a separate exercise. However, if you have not tuned prior to bringing users onto the system, you may find yourself responding to performance issues, and need to resolve them…
Analytics
Read more
Monthly Round Up
Blogs of the month Here’s 10 of the best from the last few weeks: 1.Enabling Search Framework Real Time Indexing (RTI) Jim Marion writes, “As we prepare our HCM PUM 46 training servers, we decided to enable Real Time Indexing (RTI). We found several great sample videos and resources but still made…
Analytics
Read more
Installing Analytics Server 2023 – Windows
Install Oracle Analytics Server 2023 Release, in Windows
Analytics
Read more
Recent Blogs and News
Blogs This blog begins with: “Today when checking a recently installed server with Oracle Linux 7.9 and ASM 19.17 with ASMLib, we found that when performing any reboot on the server, ASM could not mount the disks.” Read how the fix was applied! 2. Health Check for DB Nikhil shares…
The RCU Hokey Cokey
I have always preferred doing the RCU install separately to the Analytics/OBIEE configuration, but in recent installs they combined them into one step. So I am quite pleased to see in OAS 2023 they are shown separated again Yes its optional, but its an option I choose 🙂 Configuring Oracle…
Oracle Analytics Server 2023 Release
AKA 7.0 As promised, and just in time, the Annual release of Analytics Server is now available What New? A big list, far too many, so just read them here => Oracle Analytics What’s New for Oracle Analytics Server Two items have been called as as de-supported Check the Certification…
Installing Oracle Analytics – 6.4 in Windows
This post series is part of the installation series, which will attempt to add to the standard instructions Preparation This article will focus on the Manual OAS installation on windows, including the required weblogic install, therefore you will need already prepared: An Oracle Database, one of the supported ones for…
Monthly News
Read more
What’s New?
Blogs of the month 1. OEM: ASH Package Version Status – manual update In the Performance Hub page, it can show a yellow warning sign (⚠️) Read the blog to find out how to fix it! 2. Document Data Extraction – Data Mapping for Donut Model Fine-Tuning Dataset (Document AI)…
Monthly News
Read more
What’s going on this February?
Blogs of the month Patching my environments with the January 2023 Bundle Patches Mike Dietrich shares information about January’s Security Alert and gives a quick overview of the patch bundles he intends to apply to his 19c and 21c environments. 2. Fixing up oem 11g This blog begins with, “Although oracle enterprise…
Analytics
Read more
Pre-Christmas Blog
I’d love to take this opportunity to wish you a wonderful festive season – and all the very best for 2023. If you’ve got a few moments amongst the mince pie eating, here are some great blogs and videos to read and watch: Blogs of the month Star Schema Design…
Analytics
Read more
November News
Blogs 1. ORA-00479: RVWR process terminated with error followed by ORA-479 Mahmmoud Adel posted about an error that occurs on a 19c DB, when trying to enable the FLASHBACK mode on a standby DB. He gives an analysis and solution. 2. Natural Selection & Converged Databases (Oracle finds good solutions…
OBIEE
Read more
Mid-October News
Blogs of the week 1. indirect partition pruning This blog begins with, “During one of the discussions, <at POUG2022> I claimed Oracle can – under specific circumstances – do a partition pruning, even when the partition key isn’t somewhere defined as a filter. It’s probably easiest to show it by a…
Oracle Analytics
Read more
Fail: Signing UP to OAC from a Free Cloud Account
I thought I would create a trial OAC instance in my Oracle Cloud instance Apparently you need a paid account to sign up, because you need Oracle support, which is not included in a trial cloud account
Conference
Read more
Back to School
Have you had a good Summer? Here’s a round up of the blogs that have caught my eye over July and August: Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c Mike Dietrich shares why this isn’t just a simple upgrade. You MUST upgrade to Oracle…
Analytics
Read more
News from May 2022
Blogs of the Month qgis with Oracle Cloud Database “One of these complex situations is the connection to an Always Free Autonomous Database. Oracle tries to secure the database access, so by default it does not allow a simple connection with host, port, service_name and username/password. Instead a wallet is provided…
Oracle
Read more
April’s Blogs
Blogs of the Month Building a REST API with ORDS, PL/SQL Functions, & Arrays Jeff Smith shares how to build a REST API that return a JSON array list of strings. 2. Configuring Nginx on AWS EC2 for Oracle GoldenGate 21c This blog begins with: “When installed, Oracle GoldenGate (Microservices) will…
Cloud
Read more
Autumn Days…
Blogs of the month 1.10 Best Database Management Software of 2021 (+ Examples) This blog lists the Best Database Management Software as: ManageEngine Applications Manager DBeaver Raima Database Manager Valentina Redis Enterprise DbVisualizer Oracle Database Database Labs Sadas Engine Percona Monitoring and Management and gives an extensive overview of each….
Oracle Analytics Cloud
Read more
Latest OAC Features and Updates
New Features and Updates for Oracle Analytics See the release announcement. A summary: Oracle Analytics Cloud Release 6. 0 is a significant update. Highlights include: 1. Extended data management capabilities 2. Custom Knowledge 3. Data Quality Insights With every release, OAC includes User Experience enhancements and new visualizations. Highlights for…
APex
Read more
Best of last year
Here is my take on the good reading stuff from last year. Obviously there is a bit of a covid theme to a lot of the blogs I read, but also some great tech updates. Learn how Oracle used APEX to quickly launch its COVID-19 therapeutic app Read about how…
Get Oracle Software
The Linux Problem I have nothing against Linux, but… When you want software from Oracle and you have a windows machine, you just browse to the oracle website, hit the download, boom you have your software. But from Linux? I have tried different methods over the years, including download to…
Graph Database Install
Fail! So I installed the Spatial and Graph server available on the Marketplace https://console.uk-london-1.oraclecloud.com/marketplace/application/75067377/overview It installed, but couldn’t get it to do anything. No connection worked. So, I thought thats OK I will just install it myself, and I saw the documentation in Oracle database 20c, https://docs.oracle.com/en/database/oracle/oracle-database/20/spgdg/property-graph-overview-spgdg.html#GUID-FF149F69-574D-43B8-B888-4CCD019DAE56 that the graph…
Analytics
Read more
Latest blogs and videos
Just a few for these chilly October/November evenings … Blogs of the Week 1. Announcing Oracle APEX 20.2 Joel Kallman shares (the original post is here) : “This release of APEX introduces several new features and enhancements to help developers be more productive than ever before. From the all new Cards…
Graph Databases for Analytics Developers
Database trends come and go over the years, dressed up as the new thing to take down the good old fashioned relational database system. New ways to store and retrieve data pop up, gain some interest, and then end up a a niche offering. I have noticed however that some…
APex
Read more
Autumn is on its way
The colder nights are setting in. Light the fire, grab a cuppa – and here are some blogs worth a view: 1. Using Information Publisher Reports in Oracle Enterprise Manager for RMAN backup reporting. Adityanath Dewoolkar begins by saying, “Recently one of BU person in my project requested us to send…
OBIEE
Read more
A mid-September blog
Blogs of the Week 1.OBIEE – SSO — Integrating with a third party login with AD authentication / passing user and pass in URL Erman Arslan begins by saying, “Implementing SSO or Windows Native authentication in OBIE is something we do frequently. Basically, we integrate OBIEE with Microsoft Active Directory…
APex
Read more
End of Summer…
Today is the last working day of August (It’s a UK Bank Holiday Monday on 31st August…) next week we will be into the beginnings of September and Autumn. Slow down over the Bank Holiday and read some of the latest blogs and articles or watch some videos…. Blogs of…
APex
Read more
An early July blog…
Blogs of the Week 1. Announcing SQL Developer, SQL Developer Data Modeler, & SQLcl versions 20.2 Jeff Smith says, “However, there are bug fixes that we need to get into your hands, and our developers have never stopped working on new features, so we ARE releasing version 20.2, TODAY.” He…
Weekly News
Read more
A bit of light reading…
Blogs of the week 1. Copying a SQL Plan Baseline from one database to another Martin Bach starts by saying, “Hopefully this post saves you a few minutes looking the procedure up. I know it’ll save me some time 😉 In this rather lengthy article I’d like to cover how I…
Uncategorized
Read more
May the 83rd?
It’s been a long couple of months… Here are some blog posts, videos and articles to break up your lockdown experience… Blogs of the Week 1.Visualizing Oracle Object Dependencies with SQL Developer Jeff Smith says, “This isn’t a supported feature. But if you want to use it, have at it!…
Uncategorized
Read more
More lockdown reading for May…
Blogs of the week 1. How to run Oracle 12c on a Kubernetes Cluster with persistent storage Ron Ekins begins with: “Back in April 2017 I blogged on how to use the then official Oracle 12.1 Docker image to run an Oracle 12c database on Docker, if you want to…
Uncategorized
Read more
Easter reading material
This blog coincides with the start of the Long Bank Holiday Weekend. With us all being on lockdown, this means that we need to find a new way to spend it. Whatever it is you may be doing, #staysafestayhome Here’s some reading material, videos and presentations for you to plough…
Uncategorized
Read more
Some escapism reading (March 2020)
A majority of the world is now on ‘Lockdown’/Self Isolating and Working From Home. Take a break from it all and read something non-virus related – I’ve collated some of the latest blogs, news and videos. Stay safe. Blogs of the week 1.Optimizing SQL with LIKE expression Quanwen Zhao writes, “This…
Uncategorized
Read more
Some reading material for March
Don’t use “beef stew” as a computer password. It’s not stroganoff. And here’s some of the last few weeks’ finest… Blogs of the week 1. Oracle Analytics Server – Data Visualisation Access Issue This blog begins by saying, “Oracle Analytics Server 5.5.0 was recently released and I’ve been testing out the…
OBIEE
Read more
OAS – Oracle Analytics Server
All things ‘OAS’. 1.Oracle Analytics Server to replace OBIEE Mazen Manasseh writes about the following advantages: Business users benefit from enhanced Data Visualization and Data Preparation features. Augmented analytics with machine learning capabilities become available to end-users. Analytics platform remains Oracle supported so you get the latest features and remain…
Uncategorized
Read more
A mid February blog…
A few ‘Valentine’ inspired jokes this week! Why do melons have to get married in churches? Because they cantaloupe! Why do skunks love Valentine’s Day? Because they’re scent-imental! What’s the best part about Valentines Day? The day after when all the chocolate goes on sale. And now for some of the best…
Uncategorized
Read more
January blues?
The third Monday in January (#bluemonday) is supposedly the most depressing day of the year. Not scientifically proven, and perhaps made up by the media – but maybe take some time out for yourself anyway and relax with a coffee and some of the best news, blogs, videos and articles…
Uncategorized
Read more
Some of the best bits of 2019
Happy New Year! Hope everyone has had a good break and is ready for all that 2020 will bring. Workwise and otherwise! A few bad jokes to start off the year! If at first you don’t succeed, call it version 1.0. A wife send her husband an SMS on…
Uncategorized
Read more
A pre-Christmas blog
Only 3 weeks left until Christmas. Hope all the preparations are well underway. In the meantime, have a break from the decorating, shopping and wrapping and read the latest blogs and articles. And of course, enjoy a little Christmas joke: Who hides in the bakery at Christmas? A Mince Spy!…
Uncategorized
Read more
Mid November news
Although it’s only November, the shops are filled with Christmas items, the decorations are up in all the major towns and the shopping is in full swing. So, we obviously need a Christmas joke to go with the non-Christmas blogs this week. What did Father Christmas say to his wife…
Uncategorized
Read more
A rainy November blog
“I keep pressing escape. But I’m still here…” Read on for the latest news and blogs, including how Oracle Cloud helps illycaffè deliver ‘world’s best coffee’!! Blogs of the week 1. SEO for Single Page Oracle (SPA) JET Application Andrejus Baranovskij says, “This is a quick tip post related to Oracle…
Uncategorized
Read more
The latest reading material from this past week…
Why was the computer cold?It left its Windows open! Here’s the latest… Blogs of the week What is Preview Versions for Autonomous Database Julian Dontcheff writes, “A first preview is not exactly a pleasant experience for producers, directors and actors. In the IT world, it is exactly the opposite: DBAs can…
Uncategorized
Read more
OGB Appreciation Day : A big, big thank you #thanksOGB
Today is Oracle GroundBreakers Appreciation Day. We’re all spreading the love with the hashtag #thanksOGB I’d like to extend my thank you to all the bloggers and tweeters who make up this community – just a few of which are featured below. Keep up the great work! Here’s this…
Uncategorized
Read more
#UKOUGAnalytics and other news
A password cracker walks into a bar. Orders a beer. Then a Beer. Then a BEER. beer. b33r. BeeR. Be3r. bEeR. bE3R. BeEr The keynote for the #UKOUGAnalytics Modernisation Summit has been announced! Oracle’s Duncan Fitter will be providing an update on the World Bee Project, talking about how the…
Uncategorized
Read more
#OOW2019 and UKOUG Analytics Modernisation Summit
I think my neighbour is stalking me as she’s been googling my name on her computer. I saw it through my telescope last night. #OOW2019 has been and gone. But UKOUG Analytics Modernisation Summit will be upon us soon. See the agenda here. Are you going to the Analytics Modernisation…
Uncategorized
Read more
A few more of the latest…
Did you hear about the monkeys who shared an Amazon account? They were Prime mates. Onto this week’s blogs, news and videos… Blogs of the week pgbench retry for repeatable read transactions — first (re)tries Franck Pachot begins by saying, “In a previous post I was running pgBench on YugaByteDB in serializable…
Uncategorized
Read more
Latest news and blogs…
A few of the latest for your enjoyment… Blogs of the week 1. Oracle JET – How To Reference JavaScript Module in HTML Andrejus Baranovskis says, “I will explain how to reference JavaScript module function in Oracle JET HTML. In previous Oracle JET versions, we were using $root to access…
Uncategorized
Read more
The last of the summer?
A woman in labour suddenly shouted, “Shouldn’t! Wouldn’t! Couldn’t! Didn’t! Can’t!” “Don’t worry,” said the doc. “Those are just contractions.” The weather has been questionable this Summer in the UK – hoping to eek a little bit of sunshine before September… In the meantime, here’s some of the latest news…
Uncategorized
Read more
A few of the latest…
Did you hear of the mathematician who avoided negative numbers? He’ll stop at nothing to avoid them… This event is definitely worth a mention. “Bringing experts in the community together to #PASSTHEKNOWLEDGE on analytics & reporting. Submit your content now on Oracle Analytics Cloud, data warehousing, visualisation, finance, AI, and any other…
Uncategorized
Read more
#Kscope20 and #Kscope21 locations announced and other news
A password cracker walks into a bar. Orders a beer. Then a Beer. Then a BEER. beer. b33r. BeeR. Be3r. bEeR. bE3R. BeEr #Kscope20 and #Kscope21 locations announced this week – Boston and Nashville respectively! Registration is open now for #kscope20 It’s nearly a year away – so you have time…
Uncategorized
Read more
#Kscope19 week
Why do Java developers wear glasses? Because they cant C#. Cats spend two thirds of their lives sleeping, and the other third making viral videos. If you’re at #Kscope19 this week – enjoy!!! Here’s some of the latest blogs and posts we’ve been reading this week: Blogs of the week…
Uncategorized
Read more
18c, Analytics and some Kscope excitement!
I didn’t realise how bad of a driver I was until my sat nav said, “In 400 feet, do a slight right, stop, and let me out. I wonder if my first cat appreciates being at least slightly immortalized in my passwords. Some of the latest blogs,news and videos for…
Uncategorized
Read more
Some of the latest
A SQL Query walks into a bar. In one corner of the bar are two tables. The Query walks up to the tables and asks: – Mind if I join you? Some of the latest blog and videos below for your Monday enjoyment. Have a good week! Blogs of the…
OBIEE, APEX and Neo4j
One of the most important aspects of an OBIEE project is getting the design right. Of course you say, but how do I document it, and how do I update the documentation when the model is updated. Many of you seasoned OBIEE developers will know about exporting the metadata from…
Uncategorized
Read more
A new blog for a sunny May!
Moses had the first tablet that could connect to the cloud. And another… The first computer dates back to Adam and Eve. It was an Apple with limited memory, just one byte. And then everything crashed. The sun is out in the UK! Pull up a deckchair, slap on the…
Uncategorized
Read more
Spring has Sprung!
A wife send her husband an SMS on a cold winter evening: “Windows frozen”. The husband sends an answer back: “Pour some warm water over them”. Some time later husband receives an answer from his wife: “The computer is completely and utterly broken now”. and another one… I changed my…
Uncategorized
Read more
A few more blogs!
3 Database Admins walked into a NoSQL bar. A little later, they walked out because they couldn’t find a table. Enjoy the latest news and blogs! Blogs of the week Selecting Optimal Parameters for XGBoost Model Training Andrejus Baranovskis shared “There is always a bit of luck involved when selecting…
Uncategorized
Read more
#worldbookday2019 – Read a book or read some blogs instead
Today is #worldbookday2019 and children (and some adults) have been dressing up as their favourite characters from books. We are celebrating by reading some of the latest blogs and news instead! But first some jokes about all things ‘books’: What did the frog say when he went to the library?…
Uncategorized
Read more
Some new blogs to read!
Q. Why aren’t dogs good dancers? A. Because they have two left feet! We are well into the swing of 2019 now and starting to see some beginning signs of Spring and benefit from some milder (warmer, dare we say it) weather. Come and read some of the new blogs…
Uncategorized
Read more
January Blues?
Q: Erin, spell mouse. A: M O U S. Q: Yes–and what’s on the end of it? A: A tail? Happy New Year! We’re well and truly back into the swing of things and over half-way through January! Have the January blues? Read our first blog of 2019 and some…
Uncategorized
Read more
It’s nearly Christmas!!
What’s the best Christmas Present? A broken drum – you can’t beat it. Merry Christmas everybody – have a great time and see you in the New Year with some more great blogs to read! Blogs of the week 1.Date Format Handling in Oracle JET Andrejus Baranovskis shares his thoughts…
Uncategorized
Read more
A weekly round up
What did the traffic light say to the car? Don’t look, I’m about to change Groan. Read some of these blogs and watch some of these videos instead. Blogs of the week Table Order Jonathan Lewis begins his blog by saying, “Over the last few days I’ve highlighted on Twitter…
Uncategorized
Read more
#OOW18 and other news
Q. How do vampires start their letters? A. “Tomb it may concern…” This week has seen Twitter filled with #oow18 fun and presentations. It looks like a great time was had by all. Looking forward to reading the blog posts about it soon. For now, we have a few pre-OOW18…
Uncategorized
Read more
A few of the latest…
What do you call a belt made of watches? A waist of time Oracle Open World is done and dusted for 2018. There’s still time to register for the UKOUG Conference and Exhibition in Liverpool this year. 3rd – 5th December – have a look here. In the meantime –…
Uncategorized
Read more
#thanksODC and other news
What’s black, red, black, red, black, red? A zebra with sunburn Some great blogs lately and also ODC Appreciation Day on twitter sparked off some good blogs and posts on social media. Have a look at just a selection of them below, and check out my twitter feed @Addidici and Weekly…
Uncategorized
Read more
Plan for Oracle OpenWorld 2018 in advance!
Why did the golfer change his pants? Because he got a hole in one! Oracle OpenWorld 2018 is nearly upon us! There’s some great sessions planned – have a look at the sessions. Also some super blogs and videos to watch below! Have a brilliant week. Blogs of the week…
Uncategorized
Read more
#ShowUsYourCode plus some really good blogs
Why did Mozart kill all his chickens? Because when he asked them who the best composer was, they all said, “Bach, Bach, Bach.” Did you know today was #ShowUsYourCode day? It’s a fun way to share the range of developer content that is being presented at Code One and let the…
Uncategorized
Read more
A new school term, some more blog posts.
How many tickles does it take to tickle an octopus? Tentacles! Summer is officially over, so pull up a chair and read some of the blogs that have been published over the summer and watch some videos! Blogs of the week Error!?! What’s going in APEX? The easiest way to…
Uncategorized
Read more
Where did August go??
What do you call a bear without any teeth? A gummy bear! September and Autumn and the new school year is nearly upon us. (Some of you will be doing a big sigh of relief at school holidays nearly being over!) August has been quiet blogwise, but we’ve managed to…
Uncategorized
Read more
More blogs for your perusal!
Why shouldn’t you write with a broken pencil? Because it’s pointless! And on that note, maybe read some of these blogs instead!! Blogs of the week 1.Spark docker images Brendan Tierney explores some docker images and suggests building a Cloud environment here to create your own Spark environment to play and…
Uncategorized
Read more
The heatwave continues but the blog posts keep on coming…
What’s brown and sticky? A stick The UK Heatwave continues…grab some shade and read some of the latest blog posts from the finest of bloggers! Blogs of the week When No Data Found: Our New Podcast Check out the new podcast from Jeff Smith and Scott Spendolini: 2. Integration of…
Uncategorized
Read more
Some summer reading…
What does a baby computer call his father? Data! I hope you are all enjoying the wonderful weather we have been having in the UK. Here is some reading material to sit in the sun and read! Blogs of the week 1.New Journey!! Celvin Kattookaran talks about his new technical…
Database Data Modelling meets the new world
A farmer in the field with his cows counted 196 of them, but when he rounded them up he had 200. This weeks round up of blogs and posts show just what a diverse world of Oracle Business Intelligence we live in. We have to mix the known and trusted…
Video Week
I just ate my watch, but it was very time consuming Things are quiet in OBIEEland, so to keep you entertained I have found some nice things to watch. Most of this weeks updates are around the OBI world, not directly related to OBIEE, but stuff you need to know…
Past the Worst of It
Whats the best way to communicate with a fish? Drop them a line! (or Give them a wave) Apparently, last week we had the most depressing Monday of the year. Post xmas blues, no money, yuck weather. So I’m glad thats over and we can all get back to…
End of The OBIEE Year
Christmas and New Year this year was spent on a yacht cruising around the British Virgin Islands, which is the best place in the world. A yacht with family in the sunshine is fantastic and the BVIs this year were quiet, making it even better. One island we visited is…
OBIEE Job Available Now!
There is a great RPD Developer role available in the UK, Manchester Area – Who wants it? There is also another job available in the USA – Any Takers? There are hundreds of other jobs too, but these are worth taking a look at. Message me if you are…
Uncategorized
Read more
Good Oracle, Bad Project Manager
While Storm Brian batters the UK, Oracle batters us with update after Update!. I am especially looking forward to Oracle XE 18. It’s clear to me that the pace of Oracle change is picking up, and that we all need to embrace that change. This month the DBA role…
Uncategorized
Read more
OBIEE Jobs Market Going Strong
A quick search for OBIEE jobs last week (for no reason at all!) showed just how many jobs there are out there still. Indeed has over 1300 jpbs. Obviuosly some are duplicate and not all pure OBIEE jobs, but it does show that its still worth keeping the skills up,…
OBIEE Security – Layers
Applying security in OBIEE involves a myriad of controls that weave layers of protective barriers over the data. There are three Main layers, each with it own strata that work in isolation or in association with the other layers. The main layers (from bottom to top) are: Database OBIEE…
OBIEE Beats the Holiday Blues- Again!
The great thing about working on OBIEE projects is that when you come back from holiday (Got back last night from Croatia), you can get excited wbout going bck into the office. In fact, I cant wait til Monday – So I am going in tomorrow. Heres what i found…
Conference
Read more
OBIEE is not dead, just has a new name
With just one more holiday to get through before back to work, there’s just enough time to catch up with the latest blogs we read this month. Also happening this month were the speaker announcements for UKOUG, and unfortunately I didn’t make the cut. With so many submissions for a…
OBI EE
Read more
OBIEE 12c Security
Security of Data, Integrity of Systems and Ease of Use are fundamental cornerstones of any system, -and OBIEE is no exception. This is the first blog in a series which demonstrates security features and design choices that can made when building your secure Oracle Business Intelligence system. In the series…
Uncategorized
Read more
Summer Fun with OBIEE
I used to get earache on flights, but not any more … this year I’m booking my kids five rows back Why don’t mummies go on summer vacation? They are afraid to relax and unwind! The sun has got his hat on in Europe this week – time to head…
Uncategorized
Read more
Summer Holiday Reading for OBIEE Fans.
This week we have a great collection of updates – Including a great blog from Stephen Few, and some free stuff from Oracle. We also see some more tips from the prolific Red Stack team – keep them coming guys! I hope this week finds you on a beach, refreshing…
Uncategorized
Read more
Data Visualisation Desktop and Data Visual Analyzer
This week we have a look at some DV blogs If you would like to trial – and you should – then download free here:http://www.oracle.com/technetwork/middleware/oracle-data-visualization/index.html By far the best way to learn DV is to watch the Data Viz Daily series from Kevin McGinley. Available on You Tube https://www.youtube.com 1….
OBIEE 12c Book Published
Finally, our follow up to Oracle Business Intelligence Enterprise Edition 11g: A Hands On Tutorial has been released. The new book is named Oracle Business Intelligence Enterprise Edition 12c – Second Edition. Co-authored with myself, Christian Screen and Haroun Khan, Oracle Business Intelligence Enterprise 12c – Second Edition is described…
Uncategorized
Read more
OBIEE, You’re soo cool
Auto-correct can be your own worst enema. Charles Dickens walks into a bar and orders a Martini. The Barman says: “Olive or Twist?” Claustrophobic people are at their best when thinking outside the box. Seriously, have a look out of the window. Its sunny, the economy is doing great, there…
OBIEE Week
Read more
Catching Up with OBIEE News
My mate has been fired from his job at a dress alteration company. Apparently he didn’t turn up enough. OK, lets keep up the pace this year. Soo much to learn in the OBIEE world, so little time. Lets talk about size. How big is your OBIEE? I was recently…
Uncategorized
Read more
Best of OBI 2016
My News years resolution is to stop using spray deodorants. Roll on 2017 So that was an interesting year! If you ignore all the celebrity deaths, the Brexit, Wars, BI companies imploding, OTN mixing things up a bit, and the rise of the robot, then 2016 was actually a good…
Uncategorized
Read more
Winter Analytics
My Fireworks didnt go off in the right sequence. Thats Bang Out of Order! The nights are drawing in, the leaves have dropped and snow is on the hills. Time to stay in, curl up by the fire, and read a good blog. So, here’s my Top 10 OBIEE blogs…
OBIEE Week
Read more
Back to Work Everybody
Club Tropicana. Closed, due to poorly thought out business strategy! OOW IS Over The Summer is Over (for up here in North Earth at least) The Children has been sent of to University (Seems quiet around here!) No more holidays this year (New York was a blast) So let’s get…
OBIEE Week
Read more
Shake off those Chicago Blues
My mate has written a book about birds Apparently, it has flown off the shelves. Life goes on in the OBIEE community. Just as those Chicago Kscope16 memories start to fade, the excitement begins for OpenWorld 16, then on to Tech16 (+Apps16). The good news is that I finally got…
OBIEE Week
Read more
Armagedden Avoided
What kind of Rock is never delivered on time? Slate FTSE is up, Exports Up, Government borrowing down. Mortgage rate down. Crisis over. Can we now get back to geeking now? While you were all enjoying yourself in Chicago I decided that I couldnt watch enviously from a wet,…
Uncategorized
Read more
What Does Brexit Mean for the UK OBIEE Market
May you always live in Interesting Times Not sure who said that but I am sure he didnt meant this interesting! Markets plunging, Jobs at risk, political turmoil. First, if you are analysing the market reactions, then please use OBIEE If you want to improve the analyse of Polls, then…
OBIEE Week
Read more
Two Minute Tech Tips
The OTN will be at Kscope16 looking for willing Volunteers to video their tech tips. I can’t get there this year, so may have to do a selfie video 🙂 But what subjects would I cover? Use of Advanced SQL? Jquery in OBIEE? Apex and OBIEE? Hidden Cascading Prompts? Result…
OBIEE Week
Read more
Deadlines Met and News @ OBIEE
Deadlines. Some are ‘pretend’, you know you can get away with being a little bit late, because the you KNOW the project manager has factored in you being late! Others are very fixed. Like the deadline to submit proposals for speaking at conferences. Luckily I met the two that just…
OBIEE Week
Read more
Go Self Service or Go Home
Who understands your company Data best? Is it the OBIEE RPD Developer? Is it the DBA? Is it the Warehouse Designer? How about the source System Architect? Or the department analyst? Lets ask the question another way, Who knows what to do with the company Data in your system? The…
OBIEE Week
Read more
OBIEE Went to Las Vegas
We have been busy, and so have all the OBIEE Bloggers. This year I thought it was about time we went to Collaborate, and boy was it worthwhile. Our room at the Delano was massive. The hotel was massive. The conference was huge. Grand Canyon unbelievable. And what can I…
Uncategorized
Read more
OBIEE In Decline?
Last month we heard that OBIEE was not on the Gartner Magic Quadrant for Business Intelligence and Analytics Platforms, so I looked at the up coming conferences Collaborate16 and Kscope16, and found they are lighter on OBIEE sessions. Suggesting that OBIEE is on the decline, and is no longer the…
APex
Read more
APEX and the Cloud
APEX is finally getting the credit it deserves as a corporate tool, and the Cloud is the latest and greatest useful trend in the IT world. So it makes sense that they come together. (No i don’t count the Big Data Hype as useful yet) Its great to see more…
Uncategorized
Read more
My Oracle Week ft. Jeremy
This week was all about COLLABORATE 16 for me. I bought my flights to Vegas on Virgin Atlantic thanks to Lucy, a Virgin Pilot friend of mine. Booked the hotel room at the Delaney, asked my mates on Facebook where to party in Vegas, joined IOUG (finally). Now I really…
APex
Read more
APEX Bloggers
This last month has been all about Apex for me. After OBIEE 12c installed so easily and working well, I decided its time to learn something new. Apart from buying a few books (PL/SQL Programming, Expert Apex, and Pro JQuery in Apex) I headed into the Apex World, and found…
Uncategorized
Read more
New features of OBIEE 12c
So, you have the install done, and that went pretty well. Didn’t it? You can now start to play with the new toy. This week we look at the new things you play with. My favorite is the command line stuff – feels like we are back in the…
Uncategorized
Read more
OBIEE 12C Install blogs
This Week “Blogs of the Week” are about the installation of OBIEE 12c. My Favorite is the video one. Very well done everyone. I do have some advice though. Don’t assume the install steps and community comments are always applicable to your environment. I found that the proposed install location…
Uncategorized
Read more
I’m reading a book about anti-gravity. I can’t put it down
This week in the OBIEE Enterprise group on google (Join Up!) someone asked the question, How can we document the Joins in the RPD? Garish replied… Goto Tools->Query Repository Set Type to “Physical Foreign Key” Click on “Columns” button to add interesting details like the Join Expression Click “Query” Click…
Uncategorized
Read more
Movember Time
Its Movember Again. https://uk.movember.com/ Check those Balls Guys! There are a few 12c Blogs coming out, but 11.x.9 is not dead yet. See below More on Usage Tracking in the next blog. Ad. Blogs of the week 1. Customizing Charts and Graphs in OBIEE 11.1.1.9 – Quickstart Video Christian…
Uncategorized
Read more
Building on top of the Users
The Usage Tracking (UT) project will build on top of the out of the box tables, and that includes using the “SA System” ‘Users’ table as a starting point for our Users table. Have a look at Gerard blog/Wiki ( is that WikLog?) http://gerardnico.com/wiki/dat/obiee/sa and also, the all important oracle…
Uncategorized
Read more
Delete that Index
All indexes are good, right? Wrong. An index can make a join fly. but it can also slow you down. As I’ve said many times before, most of the time I delete or hide indexes, especially on an Exadata box and add carefully. However, whilst query performance is helped by…
Uncategorized
Read more
Addidici Usage Tracking Project – Part 01
Today is day one of a new project to keep me busy, The OBIEE Usage Tracking Project. The aim of the project is to build a system to analyse usage data. This will include a database build, ODI code, RPD and Catalog metadata. This will all be free to download….
Uncategorized
Read more
Catching Up
Has it really been that long since I caught up with the Market? There loads of great stuff going on in the OBIEE world but I have been preparing for the Sailing world – UK Championships, European Championships and World Championships all happening within a 4 week window. So, for…
OBIEE Week
Read more
Post Conference Blues
Whilst in Miami we had the chance to catch up with co-author Christian Screen and meet his great team at the Art of BI. His OBIEE Products are exactly what we need, and I cant wait to implement them on my current project. Watch out for news on the next…
Conference
Read more
#KScope15 Special blog
Each year the O D T U G runs a conference called KScope. It started as Kaleidoscope but is now known as Kscope and this year was kScope15. What is ODTUG? See the video… Anyway, this year I went along to see why everyone was raving about the conference….
Logical SQL
Read more
YesSQL! for OBIEE
Monday is YesSQL day at Kscope15 and to show that OBIEE can party with the best, here is some useful implementation of SQL in the OBIEE front end. Ok, so it’s Logical SQL but the principle is the same. Below I will show you how to join datasets using just…
Uncategorized
Read more
KScope Excitement Building
I am a relative Conference Newbie, and I have never been to Miami. So to say I’m excited about going to Kscope15 is an understatement! I’m not speaking, so can just relax, learn something about OBIEE 12c and enjoy the after parties. We also have a meet the authors event…
Uncategorized
Read more
Just The Latest OBIEE Market Updates
Blogs of the week 1. OBIEE 11.1.1.9 released – link library Christian Berg posted links to the new release downloads and also to the New Features Guides. 2. BITeamwork 3.5 Releases to Great Excitement – OBIEE Financial Reporting Begins Here Christian Screen writes, “We’ve never had such interest and anticipation from our customers…
OBIEE
Read more
Simples (Or how to OR or AND)
Setting a filter to find results that match one of your requirements is easy, e.g. Find me People who have used OBIEE in April or May. Peasy. (You were thinking Multi-select on your Dashboard Prompt, right?) But, what if we want to find people who have used OBIEE in April…
OBIEE Week
Read more
Don’t Share! (Use your Own Filters)
Yes I know Sharing can be fun, but not everyone likes to share. If you share you have to play nice with the other children (developers). I like to keep everything for a single ‘project’ in one folder, all the prompts, analyses, dashboards, etc and that includes the Filters. For…
Uncategorized
Read more
Sailing Holidays Again
Just had another holiday at the seaside, where my daughter was competing in a Youth National Championships, and achieved Bronze Medal. Therefore I am a bit late with the blog, so on with the show… Blogs of the week 1. OBIEE – Selecting columns dynamically – part4, working with and…
Uncategorized
Read more
Catalog Surprises
It’s amazing how far you can push OBIEE. This week we saw a blog about copying a page on it’s own, no dashboard, just a page. One of the methods I like to use is keep all the dashboard, analysis, prompts and filters for a ‘dashboard’, in a set of…
OBIEE Week
Read more
Forgot your Password?
I recently started using a password manager, due to the fact that its impossible to remember all the different ones, and it would be plain stupid to have one for all sites and systems. The only problem is I have forgotten the master password to get into the password management…
OBIEE Week
Read more
Webinar Anyone?
We are well into the conference season, January saw a gathering in San Francisco, Next week Ireland, May in Brighton and Atlanta, then the BIG one in Miami, and of course another San Francisco trip in September, before wrapping up the year in the UKOIG. Phew, thats a lot of…
OBIEE Week
Read more
Here Comes Summer
Spring is here, Have you not noticed going to work in daylight? Of course I am referring to the Northern Hemisphere. For those down under now is the time to pack your bags and head north to the sun. There are many things you can get online, soo much fun to…
OBIEE Week
Read more
European Highs and Lows
These last few weekends I have been visiting Spain and Switzerland. Sailing in Spain and Skiing in Switzerland. Down on the Coast in Spain and Up in the Mountains in Switzerland. The car rental in each country demonstrates the major difference between these countries. In Spain we pre booked a…
Obiee 11g
Read more
Wearable Oracle
A parcel arrived this week, while I am away in Barcelona, and it was a nice Oracle ACE Program top. I hope it fits! Photos to follow (of the top not my Barcelona trip) Anyway, despite being away, the show must go on… Blogs of the week 1. Using ODI Knowledge…
OBIEE Week
Read more
England 21 Wales 16
Some stats don’t need a big database and business intelligence systems. Sometimes we are asked to write fancy javascript or create links, or put lots of colour on the page, but remember… It’s the numbers that matters, not how clever the developer is. Blogs of the week 1. APEX 5.0 EA3…
OBIEE Week
Read more
And we’re Off
The OBIEE community really took off this week, Conference Updates, Product News, some great Blogs and the jobs market all back in swing. Can the OBIEE world keep this pace up? Blogs of the week 1. Hadoop and Oracle Technologies on BI Projects Daan Bakboord links to the slideshare to the presentation…
OBIEE Week
Read more
OBIEE SampleApp 406 by The Oracle A Team
Somewhere in Oracle HQ I imagine someone is saying ‘Don’t you love it when a plan comes together‘. Years ago, members of the team were sent on a mission to get together all the tools needed for the Big (data) battle. Someone made a database, ‘B.A.’ came back with a…
Obiee 11g
Read more
New Year, New OBIEE Blog
You may have noticed that I am now blogging from a new domain, obiee.info, also known as obiee.co.uk and sometimes referred to as obiee.guru ! Addidici is now just for the company stuff. Please update your links (You have links to my blog right? eh?) Also blogging at a new…
Obiee 11g
Read more
The Best of 2014
Well. This is it, the end of another great OBIEE year, and what a year of blogging it was. I tried to find a top 10 blogs for 2014 but when I got to 22 blogs to choose from I decided to cover them all! Happy New Year. What will…
Obiee 11g
Read more
OBIEE Weekly Roundup
This week I have updated the Blogger database, adding more members and putting links in place to the ACE Directory and oracle community. Also this week I heard from ODTUG that my submission to talk at next years conference in Miami was not successful, but I think I will go…
Obiee 11g
Read more
OBIEE Up a Mountain
This weeks blog is brought to you from up a mountain in Italy, at a cafe overlooking Lake Garda. We come here for fantastic sailing competitions and pizza! Nothing to do with OBIEE except I sometimes get to wear my OracleNerd OBIEE T-Shirt 🙂 Blogs of the week 1. Statement of…
Obiee 11g
Read more
Insert OBIEE name here
How many emails do I get each week where it says, “hi (insert name here) I just wanted to catch up with your current situation, I have an opportunity you may blah blah blah.” IT enables mass communication at the expensive of the personal touch. And when it comes to…
Obiee 11g
Read more
To Dashboard or not to Dashboard. No Question about it.
Dashboard, Dashboard, Dashboard. It’s the Dashboard, stupid. We will fight them on the Dashboard and we will fight them in the delivers. Dashboard 5 San Marino 0 Which ever way you look at it, the Brits are a proud Dashboard Nation. We are traditionalists, who eat Dashboard Pie. The British…
Obiee 11g
Read more
OOW Special
In case you didn’t notice, last week was OOW week. I personally stayed at work and delivered some great dashboards (I thank you), but some people (um hum, Christian) had a whale of a time in sunny/foggy San Francisco (that place where they used to host the Americas Cup!) Luckily,…
Obiee 11g
Read more
OBIEE at OOW
Blogs of the week 1. Installing BITeamwork on SSL Configured WebLogic Admin Server Christian Screen writes, ” Although not a very common integration but every now and then an organization will install OBIEE with SSL configured between the components.” He lets us know of common errors and how to fix them! 2. APS…
Obiee 11g
Read more
Summer Loving – And OBIEE Greases the wheels of Industry
You may have noticed that Sailing features strongly on this blog, so today was a great day for us as we joined thousands of sailors around the World who raced against each in Barts Bash – http://www.bartsbash.co.uk/ The only downside is that a certain large competitor of Oracle is presenting…
Obiee 11g
Read more
Sweet Summer Lovin OBIEE
Blogs of the week Have a look at our blogger database. Contact us if you would like to be added on. 1. OBIEE 11g: Unable to Add condition to run Agent during the Agent Creation or Insufficient Privileges.Access Condition Evaluation Service Service Venkata Nagarjuna says that the scenario is as follows: “I would like…
Obiee 11g
Read more
OBIEE did not have a Holiday
Blogs of the week Have a look at our blogger database. Contact us if you would like to be added on. 1. Partnering with Peak Indicators Kevin and Stewart announce a planned partnership with Peak Indicators in delivering the following courses in North and South America: OBIEE 11g Advanced Bootcamp ODI 11g Advanced…
Obiee 11g
Read more
Live Racing on the inter web
Addidici and TracTrac have teamed up to provide live tracking. Could you use it for your event? http://www.race-face.org.uk/?page_id=77
Obiee 11g
Read more
Addidici Race Tracking is LIVE
For sports fans out there Addidici have teamed up with Race-Face and TracTrac to run the race tracking system at this years Zhik 2014 29er UK National and Open Championships. You can follow the racing live, play back at the end of the day and re-live those glory moments….
Back to the OBIEE Future
Blogs of the week Have a look at our blogger database. Is yours there? Contact us if you would like to be added on. I am planning on heading over to Kscope 15 next year. Are you? 1. BUCKET_WIDTH: Calculating the size of the bucket Brendan Tierney writes that he had a…
Phew, is it just me or is OBIEE HOT?
12c, more like 30C. Blogs of the week Have a look at our blogger database. Not listed? Contact us to be added on. 1. OTN The World’s Biggest Oracle Community Debra posted a link to this infographic 2. Table to Table Mapping in ODI 12C Praveen told us how to create Table to Table mapping…
Are you good at OBIEE Dashboard Building?
The art of writing superb analyses and building popular interactive dashboards is not something that we see much of in the OBIEE blogsphere. Sure we have to build fast databases, and configure the servers, but what the customer sees is the dashboard. I will look a bit harder this week for…
OBIEE Jobs Market Powers Ahead
The OBIEE jobs market seems to have heated up again, if my missed calls list is anything to go by! Check out the 522 jobs on Indeed.co.uk http://www.indeed.co.uk/jobs?q=obiee&l=UK Paper.li This week’s OBIEE News – Edition of 7th July Stories from mandsconsulting.com and thatjeffsmith.com Videos such as: Real Time BI with Kevin & Stewart:…
Kscope 14 Special
Paper.li This week’s OBIEE News – Edition of 30th June Stories from: mandsconsulting.com and videos such as: KScope 2014 Preview: Stewart Bryson on OBIEE, ODI Blogs of the week They went, they heard, they blogged about it: 1. KScope14 (Sunday) – APEX Symposium – before noon Dimitri Gielis blogs about the APEX symposium…
On the Ferry to France
OBIEE News is out! Edition of 23rd June Stories from: artofbi.com, kentgraziano.com and siebel-essentials.com Videos such as: Edward Roske of InterRel talks about Oracle HPCM at MD Anderson Cancer Center at Collaborate 2014 http://www.youtube.com/watch?v=0tbSlRofLig and Oracle Database 12c: Introduction to a Multitenant Environment with Tom Kyte http://www.youtube.com/watch?v=2MrouEW9j88 I am off to the European championships, so…
Happy Birthday to Me!
Thank you all for your kind birthday wishes. Here is how I mixed business with Birthday…. This is the only Pie chart I would use…
Sir Ben Ainslie Challenges Oracle
America’s Cup: Sir Ben Ainslie announces British bid Olympic Gold medalist Sir Ben Ainslie was joined by the Duchess of Cambridge as he launched Britain’s bid to win the 35th America’s Cup. Sir Ben says, “We can bring America’s Cup back to Great Britain!“ http://youtu.be/YwwZBxm3QwM OBIEE News is out!…
Summertime, and the OBIEE is easy
Paper.li OBIEE News is out! Edition of 2nd June Stories from artofbi.com, thatjeffsmith.com and @KPIPartners Videos such as: What is Oracle Enterprise Repository (OER) and Glenn Hoormann of Ludus talks to us about Oracle Business Intelligence and ERP at Collaborate 2014 https://www.youtube.com/watch?v=TaAsmELcHeM Blogs of the week Have a look at…
OBIEE technical stuff!
Paper.li This week’s OBIEE News is out – edition of 26th May Stories from blog.3sixty-analytics.com, siebel-essentials.com and thatjeffsmith.com Videos such as: WEBI to OBIEE / BI Publisher conversion tool https://www.youtube.com/watch?v=-KoQV8pVOQI and OBIEE Bulk Scheduler https://www.youtube.com/watch?v=Dd_FBAEesGU Blogs of the week Take a look at our blogger database. Is your blog there?…
A Great Collection of OBIEE 11g Experience
Paper.li OBIEE News is out! Edition of 19th May Stories from mkashu.blogspot.com and artofbi.com Videos such as:OBIEE RPD Merge Tool Blog of the week Take a look at our blogger database. Is your blog there? If not, email us at adrian.ward@addidici.com to be added on. 1. Oracle BI 11g –…
There goes another OBIEE week
Paper.li OBIEE News is out! Edition of 12th May Stories from sranka.wordpress.com, mkashu.blogspot.com and kentgraziano.com Videos such as: Using SQL Pattern Matching with Big Data Lite VM and Working with the Trace File Analyzer Collector Blogs of the week Have a look at our blogger database. Not listed? Contact us…
OBIEE Forum Week, All the Hotshots in Town
Paper.li OBIEE News is out! Edition of 5th May Stories from emerald-cube.com, mkashu.blogspot.com and kentgraziano.com Videos such as: How Does This Code Make You Feel? – Interview with PL/SQL and Custom Interactions: Master Detail Blogs of the week Have a look at our blogger database. Not listed? Contact us to…
Back to OBIEE 11g Land
Easter was fun and hugely successful for us on the Sailing front. Number one son was top 10 British sailor and Number One Daughter was third females, winning selection to represent Great Britain at the Europeans Championships (EUROSAF). I hope yours was as good. Anyway, back to work and here’s…
Easter is Sailing Time
Every year my Easter involves a major sailing competition. This year we are at the Olympic venue of Weymouth, and we are staying in one of the Olympic village houses, which are vry nice and up for sale Should I get one? Keep up with the action here. You heard…
OBIEE and the Big Data
Paper.li This week’s OBIEE News is out! Edition of 31st March Stories from kentgraziano.com, obibb.wordpress.com and mkashu.blogspot.com Videos such as: Crystal Reports to OBIEE conversion https://www.youtube.com/watch?v=ByQ9t4Yt03o Blogs of the week Have a look at our blogger database. Not listed? Contact us to be added on. 1. Big Data and Analytics…
A HUGE OBIEE Week
Paper.li This week’s OBIEE News is out! Edition of 24th March Stories from thatjeffsmith.com, sranka.wordpress.com and rittmanmead.com Videos such as: The Intelligence Guy – Oracle BI Mobile https://www.youtube.com/watch?v=oNuVBp9nyLM Blogs of the Week Have a look at our blogger database. Not listed? Contact us to be added on. 1. EPM patch…
Better Late Than Never
Paper.li This week’s OBIEE News. Edition of 10th March Stories from thatjeffsmith.com, obibb.wordpress.com and kentgraziano.com Videos such as: Hackers are Reputation Thieves and Creating a Studio chart using data from multiple views Blogs of the week Are you featured in our Blogger Database? If not, please contact us in order…
National Jeff Day
This week’s blog is dedicated to Jeff McQuigg, Senior Architect at KPI Partners A little bit about Jeff: He developed many of Siebel’s early Analytics v7.0 best practices & wrote part of the certification exam. He has personally been involved with over 35+ OBI projects in every capacity (BI Architect,…
Super Busy in OBIEE World
Business Intelligence as we know it may be changing, and that very good news, because it means much more work. Upgrades, installing new tech, new Fusion, New OTBI, new hardware, new ETL, new Bigger Data – All very good news for the eager to learn OBIEE consultant. Keep Moving. Keep…
Available for OBIEE Contracts
The last three years have been hard work. Working on a very challenging project, whilst writing the OBIEE 11g book, kept me busy to say the least. We recently went live with a huge HR Analytics 11g implementation, which went very well and is actively used by hundreds of users…
It’s all about Big Data this week!
OBIEE News is out. Edition of 10th February. Stories from Emerald Cube, obiee-oracledb.blogspot and Rittman Mead Videos such as Storage Optimization – Reducing the Cost of your Oracle Database Estate Blogs of the week See our blogger database here. Contact us if you are not yet listed. 1. Oracle BigDataLite…
Soo much OBIEE and more
OBIEE News is out! Edition of 3rd February Stories from sranka.wordpress.com, the OTech Magazine – Winter 2014 and videos such as ‘The Bold Data Project: The Big Data Doctor Is In’ http://www.youtube.com/watch?v=8eTp5SbgY30 Blogs of the week 1. Prepare Your OBIEE Emergency Plan This post by Corporate Technologies says “having a…
APEX 5.0 will revolutionize the developer productivity
OBIEE News is out. Edition of 27th January. Stories from mkashu.blogspot.com, artofbi.com and siebel-essentials.com. Also videos such as David Peake: “The Page Designer of APEX 5.0 will revolutionize the developer productivity” Blogs of the week. View the blogger database We have been adding our favourite bloggers and blog posts to…
Even For OBIEE, its all about the database
OBIEE News is out. Edition of 20th January. Stories from Jeff Smith, Sunil S. Ranka’s Weblog and M&S Consulting Videos such as ‘Oracle Business Intelligence Spotlight at Gallup’ Blogs of the week View the blogger database. 1. How-To: File hunt for OBIEE GUI changes Christian Berg blogs about How to…
Yet more Patches for OBIEE
The Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.140114 is now available, fixing a huge list of bugs. There are plenty more bugs in the product so expect many more patches to come. OBIEE News is out! Edition of 13th January! Blogs from Siebel Essentials, and John Goodwin. Videos from Oracle…
Multiple OBIEE 11 on the same server.
Whilst Addidici are not allowed to talk about their current (Military) installation activity, I do like to share what I have been reading each week. A few years back I installed 10 OBIEE 10g environments on a box (10 env on 8 boxes actually), which was very simple to do….
News of the week plus some of the best bits of 2013
OBIEE News is out! Read the last edition of 2013! Featuring posts and blogs from KPI Partners, Siebel Essentials and Art of BI Also videos such as: Blogs of the Week 1. Advanced Filtering in OBIEE 11g This post is an extension of M and S Consulting’s last blog post…
Real Time Understanding OBIEE Deployments and Scheduling
OBIEE News is out! OBIEE News is out. Edition of 9th December Featuring blogs from KPI Partners, The Art of Business Intelligence and Siebel Essentials. Blogs of the week 1. Scripted RPD deployments using UDML and WLST In Ben Mackin’s blog, ‘Adventures in OBIEE’, it states that “with OBIEE 11g,…
Agents, Passwords and the Oracle Data Warrior
OBIEE News is out! OBIEE News is out. Edition of 2nd December. Blogs and News of the Week 1. Configuring Agents with OBIA and EBS Cookie Integration This blog contains an explanation of what Ben Mackin did to get Agents up and running when using EBS and OBIEE in a…
OBIEE 11g End of Movember Blogs and News
OBIEE News is out! OBIEE News is out. Edition of 25th November Blogs of the week 1. Direct Links to various OBIEE User and Administration Presentation functions This post by Praveen Reddy lists some direct links to various OBIEE User and Administration functions. These can be useful to know for…
OBIEE 11g, Hadoop and facebook in the News
OBIEE News is out! OBIEE News is out! Edition of 18th November Blogs and interesting articles of the Week 1. Presto: Interacting with petabytes of data at Facebook In this post, Martin Traverso discusses Background, Architecture, RoadMap, OpenSource and Current Status in Presto: Interacting with petabytes of data at Facebook…
This week’s favourite blog posts.
OBIEE News is out! OBIEE News is out! Edition of 11th November Blogs of the Week 1. Formatting a Field Globally in OBIEE 11g In this blog post by M & S Consulting, there are detailed instructions and screenshots of how to format a field globally in 11g. They say,…
Last week’s OBIEE News
OBIEE News is out! OBIEE News is out! Edition of 28th October Blogs of the Week 1. What are the Long-Term Prospects for Oracle Application Express? In David Peake’s blog, he asks “What are the Long-term prospects for Oracle Application Express?” He says that the simple answer is that Oracle…
My Favourite Blog Posts of the Week
OBIEE News is out! OBIEE News is out! Edition of 21st October. Blogs of the week 1. Steps to Apply OBIEE 11G Patch In this blog, Sandeep Venu goes through three simple steps to apply the OBIEE patch: 1. OPEN Command prompt as administrator and set the given variables 2….
Blogs of the Week
OBIEE News is out! OBIEE News is out. Edition of 14th October Blogs of the Week 1. Comparing Performance Using a Union Query In Kevin McGinley’s blog, he investigates comparing performance using a union query. He states that this is not really new functionality, but a technique he used many…
Blog posts of the week
OBIEE News is out! OBIEE News is out! Edition of 7th October Blogs of the week 1. Physical Layer Tips from OBIEE Express In this blog post, Kishore looks at the physical layer problems of: Circular Joins Nullable Flag Primary Keys Complex Joins Filtering 2. Oracle Open World 2013 –…
Blog of the Week
OBIEE News is out! OBIEE News is out! Edition of 30th September Blogs of the Week 1. Conditional Formatting of Calculated Items in OBIEE 11g Victor Fagundo, in ORACLENERD, discussed the problem of while calculated items in OBIEE are easy and flexible, they do have one important drawback: they take…
Blog of the Week
OBIEE News is out! OBIEE News is Out! Edition of 23rd September. This week’s blogs 1. Just Analytics – OBIEE 11g – Change Default Behavior when editing a report In this week’s blog, Shwetank Sheel discusses the move from OBIEE 10 to OBIEE 11 and the consequent change in default…
Another week of OBIEE
Oracle Racing News Racing with giants Oracle Team USA captures first victory in the America’s Cup Oracle Team USA – The Launch Paper.li OBIEE News is out!! Edition of 9th September This week on Twitter Oracle Analytics tweeted “Oracle E-Business Suite Extensions for Oracle Endeca” http://www.youtube.com/watch?v=B_WJzR46ek0&feature=share&list=PLEOdbv_Kaxnuz04M7neeMnNc9nseQioKS Oracle Blogs posted ADF…
Weekly OBIEE News
Oracle Racing News Inside the Deadly Quest to win the America’s Cup Get to know Simeon Tienpont Have you ever sailed faster than the wind? Challenge yourself and your friends by helming Oracle Team USA 17, the defender of the 34th America’s Cup! Download the Oracle Team USA game for Android or iOS now!…
OBIEE News
Oracle Racing News ORACLE TEAM USA Defender Practice Racing on San Francisco Bay http://www.youtube.com/watch?v=pkBAfIiK38s Oracle Team USA has an official fan hub. Tag your posts and photos with #oracleteamusa to see them featured. Paper.li OBIEE News in out. Edition of 19th August This week on Twitter Oracle Blogs tweeted Integrating…
OBIEE News
Oracle Racing News Get to know: Will McCarthy Win a day behind the scenes! Enter here. Paper.li OBIEE News is Out! Edition of 5th August This week on Twitter Oracle Blogs tweeted A peak into the usability labs that build Fusion Applications and Customize Your ADF Application As You Like:…
This week’s News Blog
Oracle Racing News Get to know Jonathan Macbeth WISeKey becomes Official Fan App Supplier of ORACLE TEAM USA, Defender of the 34th America’s Cup Paper.li OBIEE News is out!! Edition of 29th July This week on Twitter Jason Shaffner tweeted “SmartView and OBIEE Integration…
Another busy week in the world of OBIEE
Oracle Racing News Kai Lenny’s Kite Board vs. ORACLE TEAM USA’s AC72 – watch the AMAZING YouTube video here. Read NO SECOND PLACE – Episode 2 Oracle Team USA asked ‘What caption would you put on this picture?’ Paper.li OBIEE News is out! Edition of 15th July This week on…
Opening of 34th America’s Cup and Other News.
Oracle Racing News The 34th America’s Cup officially opened on the 4th of July – Independence Day. Crowds filled the new AC Park on a warm, sunny day in San Francisco as ORACLE TEAM USA was introduced during the Opening Ceremony. The celebration also included cultural performances from all four…
Oracle News of the Week
Oracle Racing News Last Sunday (30th June), saw the opening of the new series of Top Gear with Jeremy Clarkson racing the fastest car in the world (a hire car!) against James May who was onboard with Sir Ben Ainslie on an Oracle Racing AC72. Read more about it here…
News of the week
Oracle Racing News America’s Cup Oracle Team USA: Racing on San Francisco Bay Tickets from $7 ORACLE TEAM USA’s crane-man Ron takes us through the view from the top, and what it’s like lifting an AC72 wing on a daily basis. Watch the Youtube video ORACLE TEAM USA – In…
Last week’s OBIEE News
Oracle Racing news With ORACLE TEAM USA’s two-boat testing program on the horizon, the team re-activates their first AC72 following a few weeks of upgrades. Watch the youtube video. Friday fun on the San Francisco Bay with the AC72. Paper.li OBIEE News is out! Edition of 17th June This week…
This week’s OBIEE News
Oracle Racing News Watch the youtube video ORACLE TEAM USA – Testing the Waters Congratulations to Ben Ainslie and crew! 2 hours, 52 minutes, 15 seconds to break the Round the Island Race record. OBIEE Paper.li OBIEE News is out! Edition of 3rd June This week on Twitter OracleBlogs…
Andrew ‘Bart’ Simpson’ Dies on Americas Cup Training
A tragic day on the water saw the capsize of one of the Americas Cup boats, and the death of British Olympic Gold medal winning Andrew Simpson. http://artemis-racing.americascup.com/news/4522 Our sympathies go out to his wife and children. RIP Bart.
OBIEE News of the Week.
Oracle Racing News The Wind Gods – Official trailer. Watch it here. BUILT FOR SPEED exhibit opens May 10th at the California Academy of Sciences Installation of the Oracle Team USAs AC45 OBIEE Paper.li OBIEE News is out! Edition of 6th May This week on Twitter Oracle Blogs tweeted links…
Read this week’s OBIEE news…
Oracle Racing News ORACLE TEAM USA launches second AC72 ORACLE TEAM USA AC72 Boat 2 – All Signals Go – view the Youtube video here. On the final day of racing at the America’s Cup World Series in Naples, Italy, ORACLE TEAM USA won the match race championship. Skipper Tom…
OBIEE news this week…
Oracle Racing News Tom Slingsby takes the helm for ORACLE TEAM USA in Naples. View the video here. ORACLE TEAM USA SLINGSBY captured the match racing title in Naples, Italy, and second in the final fleet race, earning the team the overall America’s Cup World Series 2012-2013 season championship. US…
Oracle JDeveloper and Oracle ADF 11.1.1.7.0 Release and other news…
Oracle Racing News Launching the AC45 in Naples for the distance regatta. How Oracle’s $8M Yacht Takes On the Strongest Winds – watch the video here. Oracle J Developer and Oracle ADF 11.1.1.7.0 Release. The new Oracle JDeveloper & Oracle ADF 11.1.1.7.0 includes fixes as well as several new features:…
A week of OBIEE
Oracle Racing News Tickets on sale from April 3rd 2013! America’s Cup World Series brings top teams to Naples for season decider. Out of all the sailors who would win a karaoke contest?! Watch the youtube video here. OBIEE Paper.li OBIEE Paper is out! Edition of 8th April. …
Collaborative BI
Finally, the BI Teamwork Collaborative BI Tool has arrived! Watch a video demo! This tool allows users to: add dashboard comments create tables create pivotal table cell annotations manage functionality by setting privileges and constraints The community version can be downloaded for free here. Installation takes under five minutes. BI…
This week in OBIEE
The LinkedIn group is continuing to grow both in number and activity and valuable content is being shared amongst its members. I thought it would be helpful to begin to share some of the week’s activities from both Twitter and the LinkedIn Oracle Business Intelligence group here. The LinkedIn group…
My Oracle Links
Just a Handy list of links so I can remember where everything is! I will keep adding to this as I find more. http://psoug.org/reference/hints.html http://oracle-randolf.blogspot.co.uk/ Performance Execution Plans http://www.oracle-base.com/articles/misc/outlines.php Favorite ADF Bloggers and Links http://multikoop.blogspot.com.au/ http://andrejusb-samples.blogspot.co.uk/ http://mjabr.wordpress.com/ https://blogs.oracle.com/mobile/ http://dkleppinger.blogspot.co.uk/ http://jobinesh.blogspot.co.uk/
Oracle OBIEE Blogs
Where do I read the good stuff? Name Link Summary Authors The Art of BI www.artofbi.com Posted by BI/EPM thought-leaders and masterminds. Passionate about BI and EPM technologies, the processes they enhance and the insight they provide. Christian Screen Achieving Great BI with Oracle BI http://greatobi.wordpress.com/ 95 followers. Links to…
BIWA 2013
The next Oracle BIWA Summit, organized by the leading Oracle Special Interest Group (SIG) for Business Intelligence, Data Warehousing and Analytics professionals, will be held on Jan 9,10 2013, at The Oracle HQ Sofitel Hotel, in Redwood City, California, USA. The Oracle BIWA Summit brings together Oracle ACE experts, customers…
OBIEE 11g Book OUT NOW!
It gives me great pleasure to announce that the OBIEE 11g book is available to buy from today. The book is directly aimed at newcomers to OBIEE, and given the rise in OBIEE sales there are lots of potential buyers! Buy it from these stores: OBIEE 11g Book on the…
RCU on MS SQL Server
One of the several per-install task for the rcu on a MS SQL Server database is to set the general database security to allow SQL Server Authentication as well and windows. @ddi
Dylan Wan in Todays OBIEE News
The latest edition of OBIEE News is out, featuring a headline article by Dylan Wan on ODI.
OBIEE 11g R1.6 New Admin Feature
“Scan and Update Catalog Objects That require Updates” I wonder what that does…
OBIEE 11.1.1.6 Installs in record time
For the last three years I have been installing OBIEE 11g. It has been a painful and disappointing process – unitl now. I just downloaded, installed RCU and full Enterprise edition in less than ONE HOUR. Amazing! Thank you Oracle. It took you a while but you now seem…
OBIEE 11G version 11.1.1.6 Release
The tweeters did a good job of sending out the word that version 6 of version 1 is now available for download from edelivery.oracle.com. I have downloaded and installed the RCU and guess what?, IT WORKED! Yippee. It’s definitely time to start recommending version 11g to your clients. I will…
Avoid Firefox 10
Note: Christian had beaten me to this! http://www.artofbi.com/index.php/2012/02/firefox-10-not-compatible-with-oracle-bi-11-1-1-5/
Active Directory Installation
We recently installed a set of new servers at Addidici HQ for testing and development of OBIEE 11g. I wanted to make it more real world so we included Microsoft Active Directory (MSAD) on one of the servers. Having never installed or used MSAD as an administrator previously, I quickly…
OBIEE 11g and IE9
Just a quick note to say that IE9 does not appear to work with 11g. Viewing Dashboards can work but editing dashboards does not, and BI Publisher wont even start. Best avoided for now, stick with Firefox which works well. @d
There will be no OBIEE
11.1.1.5.3 that is. All to come in 11.1.1.1.1.1.1.6.7.8.9 (or something like that) http://blogs.oracle.com/proactivesupportEPM/entry/there_will_be_no_obie
Reconfiguring Oracle EM
When running lots of VirtualBox VM’s I often find that during some reconfig the database Enterprise Manager gets in a confused state. This is usually due to network changes, and most people end up re-installing Oracle. One solution is to keep snapshots of a working Database set-up but I find…
Steve Jobs
I never got into the Apple Hype, prefering my PC’s for the last 15-20 years. That changed last year when I got a MacBok Pro (I got it in lieu of £2,000 I was owed). I didn’t really want it but had to find some way of getting my money…
Exalytics Details
While I am still trying to figure out if I like the name of the new Oracle BI Box (I suppose Exalytics is better than OBB), more details have emerged. Not only do we have some blogs to read but even a WHITE PAPER. You may have already seen extracts…
Exalytics Launched
There was much speculation before the event (or was it insider info?). Anyway, the big announcement from Oracle Open World (#OOW11) is the new hardware for OBI. Exalytics I am not a great fan of conferences, down time not earning is not my cup of tea, so it’s great to…
Oracle 11g
The long awaited Oracle 11g Express is out. I will try it in a couple of VM’s before installing on our production machine here at Addidici. The question will be what integration is there for OBIEE 11g (Repository and Warehouse?) http://www.oracle.com/technetwork/database/express-edition/downloads/index.html
The Art of Pivoting
One of the nice features of OBIEE is being able to view your data from various angles. A table of data is prefered by some people, but for others they would prefer to see totals by Month, then drill in where they see issues. One of the mistakes I often…
Addidici is Born!
We are pleased to announce the new name in Oracle Business Intelligence – Addidici. Following the legal dispute with RM we have been forced to find a new home for our blog, our company, and our goods friends to find us. It’s a company name that I was toying with…
New ODI Blog
I see that John Minkjan has started a new blog on ODI. Nice one John. http://odiee101.blogspot.com/ I look forward to reading about how Oracle are going to move from Informatica to ODI!!! Or is that when?
Lifetime Support Policy
Thanks to Bindi for a posting on the Linked In Oracle Business Intelligence group for the Lifetime Support Document http://www.oracle.com/us/support/library/lifetime-support-middleware-069163.pdf @Ad
Huge Temp
I have just looked in the web server under the tmp folder, in C:fmwuser_projectsdomainsbifoundation_domainserversAdminServertmp and found 5.0 GB of space being used!! It basically creates a new folder every time you deploy an application. During dev and test this can get out of hand. To clear this down I stopped…
Filegroup1 Error on 11g
One issue that is still present in the 11.1.1.5 version of OBIEE 11g is the corruption of the download files. This happens to me one more than half the downloads of the enormous software bundle that is now OBIEE. It seems that I am not alone, and a quick lap…
Multiple OBIEE Environments on one Box
The Oracle preferred method of having multiple environments is to have them installed on their own machines, either real or virtual. For many organisations this is simple enough, particularly if you run a good environments service which facilitates the easy set-up of virtual Windows or Linux boxes. Where there are…
OBIEE 11g Windows Services
In 10g half your installation job is done for you; unix scripts and windows services all delivered out of the box, and pretty much working too! In 11g you have to do the hard work yourself :(. Firstly, you may be wondering why Oracle did not provide windows services already…
Free stuff from Oracle
The 11g Express Database is finally out in Beta: http://www.oracle.com/technetwork/database/express-edition/11gxe-beta-download-302519.html?msgid=3-3822972261 And the free SQL Developer is in version 3 – time to upgrade? http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html?msgid=3-3822972261
They’re doing it again
Another year, and another set of interviews, for another project, but still the same poor candidates. If you want a job on an OBIEE project, as an OBIEE developer then you should be able to answer simple questions about the BI Server, The repository and using Answers. AM I asking…
OBIEE 11g Integration With Active Directory – Part 2
In part one I shared with you the first section of the Oracle white paper on integrating 11g with AD. Following it to the letter worked fine, but there were a couple of glitches. The only groups we wanted to match into Application Roles were those with OBIEE in their…
OBIEE 11g Integration With Active Directory
Having just installed 11g in a Windows 2008 I thought I would share the experience. It was actually fairly simple, but there were a couple of gotchas. Thankfully Oracle produced a white paper on this in December last year, which I will show extracts of below: Introduction The paper…
Goodbye DB, Hello World
What a breath of fresh air. I just completed an INstallation of OBIEE 11g in Windows, clustered and integrated with Active Directory. The people were great, it’s so nice to be working with friendly people again, you know, the type that does not try to stab you in the back…
Not an OBIEE blog posting
This is just too weird…. http://en.tackfilm.se/?id=1264016746390RA38 But looks like I am vain enough to pass it on adrian.ward@addidici.com www.addidici.com
OBIEE Recruiting
Below is the ad we just posted on Jobserve. If any of you bloggers or readers can pass this on or know anyone coming available (who would pass the technical exam) I would be very grateful. (what do you think of the ad? Too geeky, not enough, too salesy?) …….
It’s Movember
Sorry but I can’t stay quiet any longer. I’ve had enough. Why are people wasting my time. If you don’t know OBIEE – DO NOT pretend you do know it. The next person who turns up to an interview had better match his/her CV. Am I asking too much? –…
Jeff’s New Place
Well worth keeping an eye on. http://greatobi.wordpress.com/ Jeff is one of the old boys! adrian.ward@addidici.com www.addidici.com
Another new blogger
Have a look at Tips On OBIEE => http://tipsonobiee.blogspot.com/I like the one about the short URL name, what shortname can I think of….. Keep them coming. the more the merrier (as they say). If you are wondering why I’m not blogging much, I have several excuses, including writing the book…
State of the OBIEE Market
Recession, what recession? Ever since I started up Majendi (Now Rittman Mead), the market for Siebel Analytics (now Oracle BI) has been a roller coaster. Looking back, supply and demand for consultants / contractors / permies has either been heavily biased to supply or to demand. Getting the balance right…
Dont Try This At Home Kids
Having just spent some time on a prjoect with Christian Berg and Venkat, and seeing some of the presentations at the BI Forum, I have come up with my all time top 10 of ‘Don’t do this without an Adult Supervisor’ 1. Implement Essbase in OBIEE2. Use xml editors to…
BI Forum
Read more
BI Forum Lunch
Not only were the presentations excellent, but the food was great too. Although we did sneak off to the pier for fish and chips and donuts one lunchtime. Mind you our hotel was a bit odd! and Mark is very scary! adrian.ward@addidici.com www.addidici.com
Love Hate Essbase in OBIEE
Just you just love the speed of reporting on Essbase Cubes. Building the cubes is super fast. Having a simple report with one Measure is a pleasure to to build and run. Now try doing anything that OBIEE is good at. How about having a flat hierarchy? No Ok, what…
What is BI Apps?
I keep getting this question, along with how does Informatica interact with the OBIEE, and just what is the DAC? BI Apps can simply be described as 4 repositories. – rpd file for BI Server– Webcat files for Presentation catalog– xml files for DAC– rep file for Infomatica After you…
BI Apps Installation on Solaris 10, Essbase on 10.1.3.4.1
Sorry I have n’t been blogging much, life has been crazy busy.I did start trying to keep a running commentry at the BI Forum, but found that I was getting too engrossed in the content to write properly. It was great to meet evryone at the forum, some I had…
BI Forum – Session 3
Mark is showing us some new features in the DAC 10.1.3.4.1 which helps to optimize the ETL and warehouse performance adrian.ward@addidici.com www.addidici.com
Bi Forum – Session 1
Excellent preview of ODI BI Apps. Looks like a version of the DAC! Not available for 7.9.5 but is 7.9.5.2 Not sure if I should tell customers to use it yet??! adrian.ward@addidici.com www.addidici.com
A sneak preview of 11g?
I think I have found my favorite client. Not only are we analysing 4GB of data, 4 times every day, in a 10 minute ETL, but we’re adding some cool features to the dashboards. One feature is tree view. Those who use APEX will be familiar with how these work,…
iMAP the iPhone
I may be a bit slow, but I catch up eventually. Given that I am reading my emails on the iPhone I did not want to read them again in Outlook. Turns out that instead of using POP you can use IMAP, which keeps all the mail readers up to…
Uncategorized
Read more
Rittman Mead and Majendi Join Forces
I am pleased to announce today that Majendi is Joining forces with Rittman Mead. All my technical bogging will now be on the Rittman Mead blog, but watch out for some personal stuff on here. We finalised the deal over lunch in Zurich, a very civilised part of the world….
Me down to a tee
http://peterthomas.wordpress.com/2009/04/01/pigeonholing-a-tragedy/ adrian.ward@addidici.com www.addidici.com
The day after April Fools
I hope you all got fooled yesterday. I fell for one, hook line and sinker! Anyway, to continue with happy thoughts for a day or two longer… A man flying in a hot air balloon suddenly realizes he’s lost. He reduces height and spots a woman down below. He lowers…
New iPhone
I finally took delivery of my iPhone today. Although it 16Gb, which is more than enough for my music collection, I know it will be out of date by tomorrow. So can someone tell me what the iPhone replacement will be please! Of course on it I will be able…
MICS
“KISS is out, MICS (make it complex stupid) is hot” Great Article by Toon Koppelaars. If you are more than 21 then this will be an interesting read. Everyone else, stick to the PS3 /PSP tonight! Many of you will have heard of Jonathan Lewis – http://jonathanlewis.wordpress.com/who has some great…
Brilliant
The brilliant, yet undiscovered talent that is Christian Berg finally launched into the blogging world http://hekatonkheires.blogspot.com/ Good luck with that Christian. News UPDATE. Final details are being put to the announcement which will be out very soon now. Can you guess what it is yet? Market Update Who do you…
What Occuring
As usual I have been keeping an eye on the Jobs Market, checking out the availabilty of consultants and roles.As you will see from previous posts I have been guaging the state of the Oracle BI / Siebel Analytics market by the number of jobs advertised, and number consultants I…
OBIEE Forum
I am pleased to announce that I will be presenting at the Rittman Mead BI Forum in Brighton on May 14th and 15th this year. Take a look at the agenda and I think you’ll agree it has an excellentline up of OBIEE talent: http://www.rittmanmead.com/rittman-mead-bi-forum-brighton-may-14th-15th-2009/. There are only limited numbers,…
More Big Tips Please
Reply from Phil as follows: Of course Adrian, I’ve got loads. How about this one: When you do a combined request you can’t change the column headings in the Edit Column Formula window as any changes you make there aren’t saved. However, you can change the column name in the…
Uncategorized
Read more
Big Phils Tip – Page Moving
Imagine the scenario. You have a dashboard with 35 pages on and you have to add a new page, at the TOP! Normally you add your page, and it goes to the bottom of the list, so you would click 35 times on the up arrow. On this button the…
Siebel Analytics Tip of the Day
I know I don’t normally do these, but here is one for today: When you work in MUD mode, and merge your rpd, the 7.8. Admin tool will not update the variables you set offline. It will also have trouble dealing with presentation column name changes – you will find…
Tonsils Out
Not only has it been very busy on the client work front, busy on the sailing front, busy on the consultancy, and trying to dig out of the snow drifts, but I had my tonsils out. Will be back to shouting again soon I hope. It went pretty well apart…
Another New Blogger
Hi Grubble, Welcome to the OBIEE blogging world http://grubble.net/index.php?blog=1 adrian.ward@addidici.com www.addidici.com
Localisation of OBIEE
I have no idea who these people are, but just found an interesting service which claims to double increase of user acceptance. Thats a pretty tall order, but if it works thats great. The more the merrier! http://www.bi-localizer.com/en/index.shtml They dont say which languages they cover but I assume German for…
How is your Croatian?
New blog on OBIEE. Good luck with it Goran. http://108obiee.blogspot.com/ Update: Thanks to Daan we can now view it in Englishhttp://translate.google.com/translate?u=http://108obiee.blogspot.com/ adrian.ward@addidici.com www.addidici.com
Informatica vs ODI
As you would expect, the debate still goes on as to what is happening on the OBIEE ETL front. As all you ex-Siebel people will know Informatica is the system that every uses for their databases. It was licensed by Siebel to run their CRM ETL Packaged Applications. Then when…
OBIEE
Read more
OBIEE Snowflakes and Stars – Part 3
A Quick recap: From Part 1 we saw that you can organise logical tables in a normalised fashion, and in a simple model the SQL will work without errors. The use of a normalised model in the Data warehouse is not something that you would normally see being advocated by…
HAPPY CHRISTMAS
I hope that at this time of year you are able to have some fun, see the family and get some rest from those projects! Lets keep our fingers crossed that 2009 will turn out to be a better year for the world, and in particular the hard working IT…
OBI EE
Read more
Stars and Snowflakes
Part 2 Continuing on the discussion about OBIEE (Oracle BI EE) structure of the Logical Layer – please read Part 1 before this chapter. To set the context, The discussion is around your choices in table design in the warehouse and I am only referring to the reporting in OBIEE…
Uncategorized
Read more
Stars and Snowflakes
PART 1 We like to talk about the weather in England, and today it is fine – Sunny and Cold. Here in the West at night you can see all the stars and over in the East they are having light snow falls.Nature has not yet figured out how to…
X Marks the spot
So after all the hype it turns out that Oracle X is their first forray into the hardware market. Nothing to do with OBIEE? Well, maybe this is the best thing to happen for the product we all love. Having a faster platform to run the Oracle OLAP and OLTP…
Urgent Requirement
Filled the roles now. Thanks. Hi there, we have an urgent need for the following: – technical Consultant for Siebel Marketing 7.8 (OBI knowledge would be superb)– Oracle DB Admin Start date: yesterdayDuration: think at least 3 weeks – probably up to a yearSalary: up for negotiation, but I think…
Talking about users
A funy thing happened on a recent project (not saying which one but security was a TOP priority) The rpd used LDAP to authenticate the users. The developers (me!) had a user set up in the rpd to do the dev work.When then rpd was pubished to Production, my username…
Multi User
Having been put off by the multi user dev environment in previous tests I was reluctant to use it in a 7.8 environment. However, so far so good. provided everyone plays the game properly then it should be safe to dev across multiple sites. But there is a catch. The…
Actuate Anyone?
Another reuqest. Hi guys,There is an actuate requiement in central london for 3-4 weeks,immediate start, if you know anyone, please let me know. cheers,Ram adrian.ward@addidici.com www.addidici.com
Australia Anyone
We had a call in the night from Australia. They must be desparate to call long distance. Anyway, get in touch with them direct if you fancy the gig Their original email =>We are after a number of Siebel Analytics consultants in Australia and we can get visas for you….
Analytics Developer Required
Yes, we are recruiting for a UK based Analytics consultant. More on the Reporting side, but with strong links to the rpd developers. This worldwide implementation needs someone to start soon for a one year contract. Working for Majendi in the south of England. Pay is 50 – 60 k…
More work coming online
Still nothing in the UK but some work is out there in the US and Europe (Mainly Germany and Netherlands) Here’ one from Gerald I am urgently looking for experienced Siebel Business Analyst / Funstional consultants and Siebel Technical consultants who have experience with the latest Siebel 8.0 for an…
A Conditional, Data-Driven Action Link
The initial release of this functionality was seen as a positive step towards tighter integration of the Siebel and Analytics applications. Since then, many versions onward the functionality has moved on little and there are still limitations which continue to frustrate developers. The ‘so-called’ increased usability of action links available…
Uncategorized
Read more
Is that It?
They say that technology happens in waves. They being Gartner and the like. You get early adopters, then rapid growth in popularity, a peak of excitment then a long decline. Drawn on a digram, representing, say, adoption, it’s like a big wave. Well, the OBIEE wave formed and a whole…
Long Time no see…
Nearly four weeks in the Carribean really slows you down. You get used to the slow pace of life. Breakfast at the marina cafe takes until lunchtime, Lunch takes hours, and dinner takes all night. Sailing at 5 miles per hour from glorious beach to fabulous snorkling bay is a…
BI Conference Afternoon session
Hold that last thought. Apparently Excel is central to BI! The roadmap for BI (including Hyperion) was actually very good at keeping me awake after lunch. The 11g features of OBIEE are good, and should be out before May next year. There were hundreds of updates and improvements, which I…
Hot news from th BI conference
Firstly, Lunch at the conference is excellent. Well done Radisson! Secondly, Frank says that we should ditch Excel for BI, it’s destructive! Most importantly. Oracle now has true data mining capability. I’ve seen it here and it works. If you thought SAS was the only solution, think again. BTW, Informatica…
And Ross joins in
I have just noticed that Ross Goodman at Ecelectic is blogging, so I’ll add him to the blogroll. http://www.rossgoodman.com/2008/02/28/modelling-change-in-your-dimensions/ adrian.ward@addidici.com www.addidici.com
Not really my thing.. but ..
Just to show you I can be nice!. A note from a friendly agent. PLEASE CAN YOU HELP ME??? xxx I am looking for an Application Developer (Middleware) consultant for a highly prestigious Dutch client based in The Netherlands. You will be working as a software specialist for customer, where…
Rate Card
I keep meaning to put the rate card on the Majendi website. If anyone is interested this is what we charge. (all in GBP) Senior Consultant – 800 plus expensesConsultant – 750 (expenses included in home country, add on for Europe)Junior Consultant- 250 plus expenses What are the levels? Senior…
More Groups Please
I have had lots of new members sign up to my OBIEE group on linked in, most of which have some relationship with the product. I am rejecting anyone who is an agency recruiter or just a professional networker. The next step will be to develop the OBI portal which…
Need a loopback Adapter
This took me ages to find If you need to install Oracle database on a Vista Machine then this may help. 1) start device manager2) right-click top node3) add legacy hardware4) select Netwrok Adaptor5) select Microsoft6) select Loopback adapter This was from an original post at http://davedotnet.blogspot.com/2006/06/installing-loopback-adaptor-in-windows.html Also useful was…
Execute
Probably already covered elsewhere, but I had this lying around from my book notes (Many Thanks to ed Higgins) These are the executables you can find in the bin directory. Nb. Siebel support recommends the following executables are not used without prior knowledge or consulting technical support first. JobManager.exe Previously…
OC4J as a Service
Following the last post on stopping oc4j from automatic running, you may want to run oc4j as a service, so that is can be added to a batch file that starts all the analytics services. So, to Run OC4J as a windows service If you want to run oc4j as…
Auto running OC4J
I kept meaning to do a brief note on the issue of OC4J automatcally running when you start windows. I’m sure you all know how to stop it, but just on case check out http://knowledge.ciber.nl/weblog/?p=84 adrian.ward@addidici.com www.addidici.com
And another thing
You wait ages for a blog to come along, then three turn up at once. I just had to mention the WHOPPING great rpd that I had to investigate the other day. It was 50 MB. Supplied by Oracle as part of the 7.9 Applications install. It’s not that it…
Is the future here already?
Have a look at the Oracle whitepaper on OBIEE and SOA. It’s the future you can read about while getting on with maintaining your 7.7 Siebel reporting (Actuate) system. http://www.oracle.com/technology/pub/articles/rittman-biee-soa.html?rssid=rss_otn_articles Don’t let people tell you otherwise – Oracle Business Intelligence is the future – what? including OWB? are you mad….
Happy New Year? ummm, we’ll see.
A few random thoughts for OBIEE and life at the keyboard… A few years ago we used to write javascript to refresh the screen, based upon an input value. In APEX we can put some code into the header ” meta http-equiv=”refresh” content=”60″”, so I thought why not put it…
“Living in America”
If that’s you, and you know your rpd from armpit, then please get in touch. I may be able to put you in touch with some projects that need OBIEE consultants. adrian.ward@addidici.com www.addidici.com
Quiet Christmas
I had a few emails, texts and calls today from people who are available for work. Good Siebel Analytics / OBIEE consultants who may be having an extended xmas holiday! If you have a need for someone for short or long term please get in touch and I’ll forward their…
Trimming
One little ‘feature’ of OBIEE keeps popping up in my projects – Automatic Trimming.If you have a field with data, or calculated field, that has a trailing space in then OBIEE can remove the space for you. This can lead to some issues, particularly when drilling down.Lets say you have…
Complete Blogger
Like all good bloggers I am finally able to sit in an airport lounge and write something about my day. I’m off to a client in the North so am flying out of Southampton.I may go to the pub tonight and may have a dinner with someone. Whilst there, I…
New LinkedIn Group
If you are using the Networking tool LinkedIn, I have created a group for Oracle Business Intellegence professionals. Look out for the group on my profile, and join in if you think it is appropriate for you.I will connect anyone who is working in OBIEE, Siebel Analytics, Oracle Business Intelgence…
OBI EE Consultants Needed
The OBIEE world is still going strong and demand is high. We need a couple more consultants – one experienced contractor for a project in Germany where we are the technical leaders, and one junior (on a decent salary). If you are ready for a new project/consultancy then do get…
Remembrance Day petition
http://petitions.pm.gov.uk/remembermonday/ A petition has been launched requesting a new public holiday falling on the Monday after Rembrance Sunday in November each year. To be known as the National Remembrance Holiday, it’s purpose is threefold: To emphasise the remembrance of those servicemen and women who have given, and continue to give,…
Uncategorized
Read more
Using Catalog Manager
If you want to have a consistent Header or Footer on each page of your dashboards then you can add the default settings to your custom messages file and all NEW reports will have the same settings. You can edit these settings per page afterwards. However, if you have built…
New Version of OBIEE
Version 10.1.3.3.3.1..3.1.1.2..3.1..3. of OBI Enterprise Edition is now released. It’s got some new stuff in. How exciting! adrian.ward@addidici.com www.addidici.com
Ex-Oracle
NOT quite sure why it exists, but I just found a forum for ex-Oracle employees. Probably useful for networking with people who left to earn a decent wage contracting.It was listed in the LinkedIn groups section.Have a look at http://www.ex-oracle.org/html/index.php adrian.ward@addidici.com www.addidici.com
I found this link the other day. It lists the average rate for OBI consultants in the USA. http://www.hotgigs.com/rates/skill/Oracle-Business-Intelligence-hourly-consultant-bill-rates/ At 137 dollars for an average consultant and on a straight conversion these look slightly lower than the UK, but the cost of living over there is lower. adrian.ward@addidici.com www.addidici.com
Foreign Travel
So lets recap…. Ireland – Two OBI/Analytics requiredAmsterdam – One senior OBIEEMidlands – One OBIEE expertFrance – 2 month contract for Siebel AnalyticsLondon – Training x 2 then along comes Australia !!!! Anyone fancy going to Sydney for the winter? Where’s my suitcase. Seriously, there is more work than I…
Sign up for the Arrows
Speechless… “Organisers of the event say that the Arrows military background might be “offensive” to other countries taking part in the Games. The display team have performed at more than 4000 events worldwide, but the Department of Culture, Media and Sport have deemed the display team “too militaristically British”. Red…
Amsterdam anyone?
There is a contract in Amsterdam that is looking for an experienced analytics consultant. Please get in touch with me if you are interested. I can put you in direct contact with the manager there. adrian.ward@addidici.com www.addidici.com
Role of Honour
I received lots of good feedback on my recent rantings about the market, so have decided to set-up a role of honour for OBI specialists. We know who the major players are, so I’ll set-up a webpage listing consultants, companies, projects, agents and general information. If you would like to…
Cluster ….
It appears that there is a significant change that I had overlooked in the new OBI 10.1.3.2, compared to the Analytics 7.8 version. I had noticed that there was a new webcat structure, that was easy, but one of our contacts spotted that there is a new way of clustering…
Long live the King
Siebel Analytics is Dead, long live Analytics. Actually it’s not, it’s still a damn good product, but the son of Analytics, OBIEE, is the new King. Why? Because I’m now having fun without Siebel 😉 The new world looks like this: An Apex application is the portal.Identity management is by…
Help!
Help!, we need somebody, Help, not just anybody, Heelp!! Can you tell I’ve been listening to the Beatles tonight? Anyway, we really do need more Analytics people. We have OBI and Analytics work coming out of our ears, so if you are looking, or know someone with Analytics then please…
Catching up
As I have been in hiding on a secret client site (with no access to the internet) for a while, I thought that I would go for a large blog today. To start with, there is some new functionality in 10.1 that you should know about. One feature is called…
Urgent Requirement
We need a Siebel Analytics consultant for a contract in the UK – not in the North 🙂 As usual, we have more work than people. If you are an Analytics consultant (i.e. know all about rpd development) then please get in touch. There will be a technical interview, so…
SE One is here
Oracle have officially launched SE One – Like Siebel Analytics only cheaper. This is the pricing package we have all been waiting for. There is no excuse for any company to not buy Analytics. This can be used for what Analytics is good at => RAD (DSDM) warehouse projects. Finance…
Freedom of the City
I had a great day today. I had to go to the Camberlains court and swear allegiance to the Queen and to the Lord Mayor. We (my wife and I) were then granted the Freedom of the city of London. I can now drive sheep over tower bridge. adrian.ward@addidici.com www.addidici.com
Interesting Note from Oracle
This note was published today. It may explain the questions I have been getting. “The Standard Cost General table (W_STANDARD_COST_G) and the Exchange Rate General table (W_EXCH_RATE_G) are general reference tables. Both tables have surrogate keys (ROW_WID). But unlike dimension surrogate keys, these surrogate keys are not referenced as foreign…
Professional Indemnity Schedule
Just so I can point people to the evidence, here is our insurance certificate. Professional Indemnity Schedule adrian.ward@addidici.com www.addidici.com
Oracle Warehouse Builder Documentation
Today was spent installing Oracle databases and Warehouse tools onto one of the Majendi Laptops. It’s good to keep doing these to keep your eye in. A valuable resource if you cannot memorise everything is : Oracle Warehouse Builder Documentation adrian.ward@addidici.com www.addidici.com
A typical question
Please keep sending in your questions, it’s interesting to see what challenges you guys (and Girls – Vicky!) face. Here’s a recent one Hello Adrian, I need little help. Our company is implementing Oracle BI 10.x. We don’t have much experience in Siebel Analytics/OBI. We have few fact tables e.g….
Analytics Projects – Who wants one?
Whilst looking around for my next client I realise that we, as Analytics consultants, need to talk to each other more. Whats more, the consultancies and clients really need a place to go for reliable, experienced Analytics specialists. I was discussing one new project with Haider and it turns out…
Insurance time
I just had to renew the Professional Indemnity insurance, which this years comes to over 1,300 pounds! We use Trafalgar, seem to provide good cover, but not sure if they are the cheapest. However, you can do it all online which saves a huge amount of time. Use the link…
FAQ 2289: How Do You Customize Default Header Links in the Oracle BI Presentation Services Interface?
This supportweb note came out today. It’s well worth looking at if you need to customize the links in your BI Publisher. FAQ 2289: How Do You Customize Default Header Links in the Oracle BI Presentation Services Interface? adrian.ward@addidici.com www.addidici.com
Uncategorized
Read more
Majendi Day out pics
The team went for a day out on the Company Yacht! adrian.ward@addidici.com www.addidici.com
Uncategorized
Read more
Link to Me!
Come on you lot. Let get networking! adrian.ward@addidici.com www.addidici.com
The ‘WebCatalogServiceSOAPKPI’ Outbound Service Web Port
Here’s a techie from Justin Townsend. We’re working on some interesting ideas and clients (and client bids), where this is relevent. Using the integrated application (Core Oracle/Siebel modules combined with Analytics & Marketing functionality) relies quiet heavily on the use of web services. These services are invoked in a ‘traditional’…
What Does Metadata mean
I’m i the middle of writing the book (along with Mark) and I was using the word Metadta alot. Then something happened on a client project which made me realise that few people probably understand what this word actually means. The OraFaq makes a good start“Data that is used to…
More from Oracle
I have been to two Oracle partner events recently, where I am mainly trying to ge tot he bottom of what their ETL tool strategy is. The issue is on of platform AND application choice. The fight is between Informatica, OWB and Data Integrator. Informatica has a huge head start…
Loyalty Anyone?
Has anyone seen an Analytics repository which connects to the Loyalty vertical? We may be able to come to a commercial agreement with anyone has already built one. adrian.ward@addidici.com www.addidici.com
Uncategorized
Read more
My New Yahoo group
I’m going group crazy Just added a fourth Yahoo group. They’re great to share stuff with your mates. We have some club messages and information that needs sharing, so we put this is the group and hey presto everyone is up-to-date. No excuses! Click to join papercourt adrian.ward@addidici.com www.addidici.com
The Future of CRM
I attended one of Oracle’s ‘Ask the Experts’ seminars on CRM strategy last week, not some thing we often have the time to do, but worth doing for an insight into what makes Oracle tick, and more importantly to meet some real people, many of whom at this particular event…
Uncategorized
Read more
Init Blocks, init.
That’s repository variable Initialization Blocks to you. Init blocks as they are more commomnly known retrieve the data that is held in memory by the Session and Repository variables associated with them. They are of course accessed through Manage>Variables in the Administration console, and this is another area where subtle…
Naughty 7.9
Apparently there is a little buggette “Customers installing Oracle BI Applications Version 7.9 must first install Oracle Business Intelligence Enterprise Edition 10g Release 3 version 10.1.3.2.0 with Quick Fix 150. “ tut tut adrian.ward@addidici.com www.addidici.com
7.9 Is here, Huh?
So you thought that OBI EE was the new Analytics. Think again. Siebel analytics has jsut gone into version 7.9, but so far I have only seen Applications 7.9, so it looks like platform is either 7.8 or OBI EE : There new names though: Siebel Analytics Application now becomes…
Uncategorized
Read more
Connecting People
Is there a clear winner in the war for Networking platforms? I started using LinkedIn a while back and have developed a great network of business contacts, but then I realised that wasn’t the first one I had signe dup to. Friends Reunited was the leader originally and everyone flocked…
Make the most of your repository
Quick and Easy Mail Merge Why not make the most of your repository, as well providing the backbone of your reports it is also a great source of clean organised data that is easily accessible by other programs. Here’s one way to address envelopes or letters using MS Access and…
Oracle to buy Hyperion!
Ha. Good for Oracle. Essbase is a horrible tool in my view but the accoutants love it, so Oracle have taken on a popular product, and have a foothold in hundreds more companies. Trouble is, now I’m stumped as to how they are going to integrate Essbase into the new…
OBI EE
Read more
How good IS good?
I’ve been interviewing loads of candidates recently (you may have seen my ads on Jobserve and LinkedIn) for Siebel Analytics consultants. By the way, if you would like to connect on linkedIn (www.linkedin.com) please send an invite to adrian.ward@majendi.com; in the note say you are reading the blog.Most of the…
Technology!!
I have the worst phone in the world. It’s the O2 XDA lli. Oh it may also be a PDA, has windows, can pay music, runs Excel/Word/PDF, has a web browser to connect to the internet, has email and can syncronise with my Outlook, has vidoe and a camera, plays…
Questions, Questions
Why have I not written a blog for ages ?Does Siebel Analytics work on IE7 ?Is there a version 8 of Analytics, if so what is it called ?What is the difference between Siebel Analytics and Oracle BIEE ?Where are all the best Analytics consultants ?How do I find good…
Just Another Date
Well there’s lucky, Justin had dates in mind and so did I! I have been fortunate toenough to have easy access to W_DAY_D and a plethora of pre-calculated YTD andaccount period end figures so all plain sailing.As we are working on Analytics for a Siebel Financial Services implementation wehave a…
Date Formats in the Analytics Application
Justin Townsend, a member of the Majendi team has some useful advice… Dates are often a point of consternation – for users and developers alike – in theanalytics application, but there are many reasons why they are used. Dates andtheir derivations are often drawn from the warehouse table W_DAY_D, but…
For Instance
Bit of a techie one today, a short introduction to instanceconfig.xml. Instanceconfig.xml (we’ll call it IC) is a configuration file for the Analytics web. It is a replacement for using the registry. You could use the registry but there’s little point, and you probably won’t have access rights anyway. The…
And then there were three…
ETL tools used in Oracle BI that it. With Oracle going round buying up lots of companies they have been creating a huge potential for confusion for the integration community, including their own consultants. We had an Oracle consultant in the other day to tune up the database performance (he…
Self Configuring Warehouses
One of the reasons people don’t like the DAC is that it takes control over the ETL.One of the reasons I like the DAC so much is the fact that it manages the ETL process with ease! Not only does it run the Informatica tasks in the right order (providing…
Two weeks to go
With only two weeks to go we’re getting very nervous. This has nothing to do with UAT (Which is actually going very well), but all to do with this years skiing holiday! We’re off to La Plagne with the kids over xmas. There’s a webcam service that was showing lots…
Sorted!
An easy and quick tip to sort out the order of time. When the gods invented time they were not considering the Manager running his analytics reports! It’s a simple question that the manager asks; Give me sales figures by month. The answer should look like this January 10February 11March…
Uncategorized
Read more
Navigation
Another popular topic on the message boards of late has been navigation between reports on Dashboards. Most commonly this involves guiding the user to another report/dashboard from a particular value displayed in the results of the initial report, for example, at a financial quarter end you may wish to drill…
All about the Cache
Here a thing that will makeyour reports run faster! Introduction to Cache Decision support queries sometimes require large amounts of database processing. If you reduce the amount of database querying then you can speed up the time to produce reports. In an Analytics system the way to reduce database accesses…
Three sheets to the wind
No, not a description of the weekend’s activities unfortunately, not a drop passed my lips. The sheets to which I refer are CSS or Cascading Style Sheets, PortalBanner.css, PortalContent.css and Views.css. You probably will not be interested to know that the original form of the expression was ‘three sheets in…
Do you feel insecure?
Security. Love it or loathe it? Most of the time the choice is yours, you can choose not to lock your house or car, you can choose not to fly, you can choose to keep your PIN in your phone memory under PIN, what you probably can’t choose is whether…
DAc days
Question. How do you load 80 million records into the Data warehouse?Answer. Slowly! As we are now in version 7.8 of the CRM application there is lots of work around upgrading from previous versions. Normally an upgrade of the data warehouse will provide companies with an opportunity to reassess what…
A quick note on Narratives
Narratives are very useful to give user information in a readable format. Some data is not easy to name so a more descriptive comment can be used instead of jus the column nameConsider:Run Date24/08/06 What does this mean? You could use: ‘The date when the latest ETL was run is:…
A slow day at the Coal Face
August 31st Today is a slow day. The database is down due to constant ORA-03113 errors, and sometimes 12152 errors. I don’t know what they are but it means we get to work late nights and weekends til the end of the project. If any of you know what these…