Oracle Analytics

State of the OBIEE Market

2010-03-02T07:44:00.002Z

So 2010 is now fully in swing and wow is it swinging!

Supply and Demand

The demand for OBIEE resource is probably higher than I have seen for more than two years. We are not quite in the heady days of Siebel 7.8 but not far off. Oracle have done a good job of continuing to sell the OBIEE package despite the supposed poor economic conditions and imminent release of 11g (did I say imminent!).

A search on Jobserve this week will provide over 2 pages of roles, and not too much duplication, and there are dozens of other sites (including LinkedIn) advertising roles. This is despite several projects stopping or cutting back and letting people leave.

Rates are encouraging but can sometimes be somewhat farcical. Last week I saw an advert for a skilled experienced professional on OBI Apps - and they wanted to pay 150 per day! Surely a typo?
I still stand by the view that clients must pay for your experience, skills, training and more importantly, flexibility. Rates should reflect not only the sum of your consulting but also include an element for the travel and being away from home factor.
Some projects I know well have understood that they have to pay properly for the best experience and they are the ones that are attracting the best talent.

Consultant Supply

Someone asked me today how many Freelance and tied consultants there are in the UK, so I went through my contact list and estimate there are around 70 freelance consultants in total, but I would have to guess at the number of in-house consultants there are, and my guess is 100.
This includes several who I know are on long term roles and 6 of us on my current client!
The weakness of the british pound has seen a general level of movement back into Europe of imported workers in the whole of the UK economy, and for OBIEE this may well have been true but I don't think there were many OBIEE workers in the UK anyway - there has been plenty of work in Europe not to warrant coming over here.
The UK still has a high level of imported workers to fill perceived gaps. We are slowly seeing more UK based consultants entering the freelance market and the most of the ones I personally know have the right attitude and skills to do well in the market. Some do not, and these are the ones I am most worried about. Whilst there is a slight shortage of highly skilled resources clients are taking on people who undermine the credibility of the product.

Skills

Mark Rittman and John Minkjan have both stressed the importance of your skills, not just on a single technical level buth also with client facing skills. The art of the BI consultant is to educate all of those effected by the work - not just the end users, but the managers and IT people whom you rely on (e.g. Database managers, testing teams, etc)
There is one skill that I want to highlight more than any other, as being the most important technical skill you should understand before attempting an OBIEE project. KIMBALL. Get your STAR schema database sorted out and you will have an easy platform to build reports on. If you are struggling with the business model, or reporting, it's probably because you have broken the laws of Kimball.
OBIEE (nee Siebel Analytics) was clearly built to satisfy a STAR schema so give it what it wants.
One more thing. I sometime hear from less experienced consultants that 'xxx is a bug' - often it turns out that the consultant does not fully understand how to do something and tries to hide behind the clients lack of knowledge.
I encourage every client to make good use of their Oracle Support, and make sure that any implied 'bug' is raised with Oracle. They will tell you how to deal with most situations.

Recruiting

I must re-iterate to everyone who is recruiting any OBIEE resources - Get them checked out.

Reference check. Make sure that you have a recent relevant check on their team working skills, and client facing skills. Find out why they left their last project, and the one before that, and the one before that etc. Don't just rely on LinkedIn references (which are important too), talk to other consultants who worked with them already.

Technical Skills Check. Get someone with good technical knowledge to develop a technical test, or use the Rittman Mead tech test (It's free - contact me for details).

Time after time clients, agents and even myself are fooled by those who know some of the buzzwords, and have had a year or two of experience, but actually cannot develop a report to save their life. So get them checked before it's too late. And no, the agent does not check - agent do not kow how to skills check, that is why you shoud ALWAYS use a specialist OBIEE consultancy

A Note on contracts. We all hate paperwork, but there is one price of paper that is vital for you as an employer or as a contractor - The contract. As an employer make sure you can get rid of consultants that do not measure up. Don't be afraid to ask them to leave and get someone better instead.
As a contractor, make sure your contract is IR35 safe (use the PCG).

Not an OBIEE blog posting

2010-01-21T07:03:00.001Z

This is just too weird....

http://en.tackfilm.se/?id=1264016746390RA38

But looks like I am vain enough to pass it on

OBIEE Recruiting

2009-11-04T22:39:00.002Z

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?)

....

Senior OBIEE Developer

Contract/Permanent
This is a full time, London City based role, on site at the client offices. It is a investment banking client developing a world wide bespoke reporting system. We expect the role to last for a minimum of 3 months but there is a real probability that the role will continue beyond this for the right candidates.

The successful candidate will be responsible for:
Converting end user requirements into system design
Developing an appropriate solution
Testing the proposed solution against the individual requirements

Tool sets you will be required to use include:
OBIEE adminstration tool
Dashboard development tools, including answers, delivers and catalogue manager
Database tools such as Toad

Whilst we would prefer permanent employees we are reasonably flexible about our relationship with our consultants and will be happy with either an employed or contract arrangement which we can discuss at a later stage if appropriate.

If you are interested in working with us please provide details of where and how you have done the following, in addition to attaching your cv:

Repository development
Webcat development
Database modelling
Testing

When you provide details - could you please outline how you went about:

Converting user requirements
Creating the design
Developing the solution
Testing
Implementation

For successful candidates at this stage, the next stage will be a technical interview. In anticipation, could you please provide in your reply, your availability for a telephone interview of approximately 30 - 45 mins for the week following your application.

It's Movember

2009-11-03T08:05:00.003Z

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?
- All I want is an expereinced rpd developer, with good Dimensional Modelling

And if it says you do rpd development on your CV, you better be able to back that up.

You have been warned.

Things have bee quiet on the blog because we're working long hours on some pretty big client projects. Well this weekend we went into production. Yippee.
Now, what do we do? There's loads more dashboards to build, reports to write, iBots to create etc.
Where shall we do that?
Given that there will be thousands of people accessing the system, across the world, where do we develop next? Production or Development. If Production, what safeguards are in place? If Development, how do we publish? Some clients use svn as a publishing tool, but Oracle only support Webcat Admin tool operations when working with two webcats.
We have gone for Production. It is actually the safest, easiest and quickest to customer.

It goes without saying that there are certain folders that are secure for only central obiee team to alter, which would be true of any method. We just add two other types of folder/sub-folder. Team based and Work in Progress.
The only issue is the development of reports on subject areas that have not yet been built. Probably go for creating in a deve environment, copy in the xml to a new report in Production.
Your comments are appreciated!

It's Movember, and I'm on the case - You can sponsor me. If I don't get enough sponsors I will shave it off. This is one for the men, so come on ladies give us your support too. http://uk.movember.com/mospace/280234

2009-10-01T14:14:00.001Z

Great blog on running multiple BI Instances on the same box.

http://debaatobiee.wordpress.com/2009/10/01/multiple-rpd-multiple-presentation-service-instance-on-single-bi-server/

Jeff's New Place

2009-09-01T22:01:00.000Z

Well worth keeping an eye on.

http://greatobi.wordpress.com/

Jeff is one of the old boys!

Another new blogger

2009-07-29T06:04:00.002Z

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 for the 11g release, way too much client work and it's the summer (not that you would know it looking out of the train window)

BTW did you see the one from Andreas about Vertical Text

State of the OBIEE Market

2009-06-24T06:00:00.003Z

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 has been difficult for both sides.

Siebel Analytics never had a huge following, and hardly any outside of Siebel projects. Customers were reluctant to put significant investment into the product and therefore there were (relatively few opportunities for consultants to learn).

Then Oracle came along and changed all that.

Customers are now investing heavily in OBIEE, and all of it's features - not just Dashboards and Answers, but Delivers, BIP, and briefing books.

This Oracle takeover caused many new consultancies to switch from Disco, OWB and other Oracle products

In the meantime the great rush to send development offshore took place. Despite the difficulties companies pressed ahead with moving vital code building offshore because of the obvious cost savings. One client I was at tried to pretend that development went to India because they were the best in the world at developing OBIEE. It was nothing to do with the 300 dollars per day rate! (Their project failed btw).

Then the agencies moved in. I cannot tell you how many calls I get every day from someone saying they are specialist in the OBI marketplace. All I can say is that they think there is a pot of gold n the market, but soon disappear when they discover there isn't.

But whilst all this market activity was taking place there was a real economy. With real booms and busts. A friend of mine who has been in business for 10 years says this is the worst ever.

Well I can tell you that so far this has been our BEST year ever. Good ole OBI market does it again. Lots of implementations and few skilled, experienced consultants available.
Last year we saw a dip. That's when the real recession started, way before the banks started to feel the pinch. (In my view the recession was inevitable due to record oil prices).

I have two vacancies right now - you can start next week.
There are lots of jobs on Jobserve
but Contracts are keeping their heads down, so supply is tight

But companies have made an error of judgment, slashing rates by 10% across the board has upset a lot of contractors.

If you are an independent consultant with good OBIEE skills then do not believe what the agencies and companies are telling you - You are still worth the same as you were two years ago. Do not accept rates below GBP 500 per day minimum. If you have the skills and experience then do not be afraid to demand the proper rate.

And if you have just had your rate cut by 10% come to me and I'll show you where to earn properly again.

Dont Try This At Home Kids

2009-06-17T06:55:00.002Z

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 OBIEE
2. Use xml editors to create reports
3. Have your repository created by UDML from a dynamic source
4. BPEL (Leave that to Tony H)
5. Use custom Javascript to manipulate the dashboards
6. Implement WebSSO
7. Use LDAP Groups
8. Use Dynamic Go URLs (Particularly when you have finished the development of the RPD)
9. Integrate multiple stars and Multiple dimensional attributes in a single Subject Area
10. Integrate BI Publisher

Relatively easy compared to the above is:

Settings up delivers, installing BI Apps in a Unix environment, creating multiple instances on a Linux blade, Briefing books, Configuring the DAC, customising BI Apps

But do your homework before going on the client site

Do you have any?

BI Forum Lunch

2009-05-26T10:28:00.006Z

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!

Love Hate Essbase in OBIEE

2009-05-21T06:04:00.003Z

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 about Bins? No?
surely we can put a filter in place? Ah, Of course you can - providing the filter value exists, otherwise your report throws up an error.
Error, no data is an error!!

Ok lets have some nice looking data.
what do you mean every 'member' has to unique? And what a member when it's at home?
I want the value shown to be 'London' not 'London (location)'

I hate errors. I hate rubbish looking data. I hate ragged hierarchies. Give me back my Materialised views.

Christian, Venkat, Tony, Oracle - let's have some decent blogs on this for beginners like me.

BTW We are being good boys and using ASO as recommneded by Edward at the BI Forum ;)

What is BI Apps?

2009-05-20T05:50:00.002Z

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 have installed the Oracle Database for the repositories, the Java into ?:\Java, and the OBIEE platform (BI Server, Presentation Server) you then install the Informatica server and then the DAC server and client. Do not run the DAC client yet. You then install the BI Apps. This appears to mainly be just an extraction of files from a zip. This has to be done on a windows machine.

You then simply point your NQSConfig.ini file at the OracleBIAnalyticsApps.rpd
Then point your instanceconfig.xml at the EnterpriseBusinessAnalytics catalog
Then run the DAC client for the first time. It will create an empty repository in the database. When it is loaded, import the xml files from ?:\OracleBI\dwrep\DAC_metadata\DAC_Client\export. Now you can 'Restore' the rep file into the Informatica Repository service.

You have now installed the BI Apps.

Informatica does not interact with OBIEE, the only connection is that the DAC runs Informatica Workflows.

The issue of the DAC is a whole blog of it's own, so will do that in the RM blog.

BI Apps Installation on Solaris 10, Essbase on 10.1.3.4.1

2009-05-19T22:13:00.004Z

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 been in contact with for many years, and others I had worked with on Siebel Analytics projects over 7 years ago! A hangover nearly managed to destroy my presentation, but I enjoyed the opportunity to speak anyway.

The main reason for being busy is three clients, all with OBIEE projects using cutting edge tech.
I just finished the install of Financial Analytics on Solaris 10, with Obiee 10.1.3.4.1, and it went pretty well, taking 6 days all in.

We are short of staff for the many projects we are running so do
Get in touch if you are free.

The sailing went well for the kids thos weekend, so son is now ranked 20th in the country, but unfortunately we ended up on the rocks in the rescue boat!

The Market has recovered well in the last few weeks, so hopefully the recession is receeding,

BI Forum - Session 3

2009-05-14T10:57:00.002Z

Mark is showing us some new features in the DAC 10.1.3.4.1 which helps to optimize the ETL and warehouse performance

Bi Forum - Session 1

2009-05-14T08:55:00.004Z

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??!

Bee Eye

2009-05-14T06:55:00.002Z

All I can say is 'thanks Borkur'

The first evening was initially led by Mark, but after he had paid the bill for everyone at the curry house, he sneaked off for an early night.
So up stepped Borkur to save the day, and the rest, as they say, is history.

Looking forward to the sessions today at the BI forum (said Bee Eye if you are in West street).

But first, where is the breakfast room?, I need some coffee!

A sneak preview of 11g?

2009-05-07T05:54:00.000Z

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, and I suspect it's the same javascript code in the background.

I am using the tree viewing in two ways, one to navigate through data, organised in hierarchies, and the other as a reports/dashboard navigator. Using a look up table which contains the 'menu' items. This is useful where there are lots and lots of reports and dashboards and you want to give everyone a similar front end menu.

Whilst we were having fun with trees we then added some tabs inside a dashboard page - in fact we even have tabs inside tabs inside pages. The tricky bit is getting content into the tabs, which involves some xml fun and games - not recommended!.

One last bit of gadgetry we put in last night was a simple show/hide routine that is used to display whole reports, or just hide tables or charts on a report. This enables us to load lots of reports on a page then flick between them very quickly - no waiting for a page to load. You have more control of prompts here too.

Busy times and Rubbish Developers

2009-05-06T07:02:00.004Z

Wow. Life got busy.

One minute we were Majendi, happily servicing our projects and keeping our heads down in the recession. Then BANG, we merged with RittmanMead, three new clients in a week, a conference to attend, a presentation to write, and some new admin to learn. I had the spring series final two weekends in the SB3, and the kids were sailing their Optimists in North Wales one weekend, then Weymouth the next.
The rib broke down, the dishwasher failed and this morning the hot water system failed.
I also have to get a new laptop, this time a MAC.

May is going to be a very expensive month!.

ON the client side we are having lots of fun with Essbase and OBIEE (I hate ragged hierarchies), as well as installing BI Apps on a Solaris 10 machine without the use of a windows box - Don't try that at home kids!

We have one client who are using a large integrator that doesn't know how to run a report on two separate subject areas so I will blog on the RM site to show them how. I just need to find 10 minutes spare time.

I have a contact at Oracle who asked me the other day for a sample database, in ACCESS - I laughed!

I also had another consultancy send me an rpd they struggled with. When I opened it I didn't know whether to laugh or cry. Laugh because it was a complete mess and showed a complete lack of understanding on OBIEE, cry because people are giving OBIEE a bad name by poor implementations.

That reminds me , One project I know of is looking to replace it's Siebel Analytics system, they want something more flexible and quicker to create reports than they currently have. The reason for replacing it is obviously because they badly customised it in the first place and are using cheap offshore resources that don't know how to configure so take a long time to produce bad code. This customer is suffering from cutting costs and going for the cheapest offer for development. It is now costing them a fortune to buy new software, train users etc, but they are still using the same cheap outsources, so the result will be the same poor quality reporting system.

Consultancies, I urge you to get your people trained properly and stop undermining the product reputation.
Oracle, get a properly managed accreditation system in place before the amateurs ruin your product sales.
Clients, check out the experience of the people implementing your system and do not accept poor quality - don't pay them when they deliver rubbish.

However tempting it is to cut costs, we will never set up an Overseas development centre just because it is cheap. And we will only ever employ experts. If you are expert already, and probably blog your knowledge then we would love to talk to you

iMAP the iPhone

2009-04-09T11:53:00.003Z

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 date with any change may in any other reader. So using webmail, outlook, and iPhone is now a breeze.

Thoroughly recommend it.

- @drian

http://en.wikipedia.org/wiki/Internet_Message_Access_Protocol

Rittman Mead and Majendi Join Forces

2009-04-06T07:20:00.003Z

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.

From Drop Box

- @drian

2009-04-03T07:50:00.002Z

I was interviewed yesterday by Chad, on Business intelligence, in particular the state of the market, jobs, and skills.

It got me thinking about some of the reading I been been doing recently to keep up to date. And thought I should write things down before I forget them!

I always like to keep up-to-date with market developments, in particular technology advancements.

On that front I saw a presentation recently by a CIO which quoted change and how we need to be prepared for it in IT. Now we always hear that, but he put it in the context of three Laws, Moore's Law, Metcalfs Law and Gilders Law, which actually bought it home really well.

To remind you, Moores (Co-founder at Intel) predicted in 1965 that processing power will double at least every two years.

Metcalfe's law states that the value of a network is proportional to the square of the number of connected users of the system (n^2).
The law has often been illustrated using the example of fax machines: a single fax machine is useless, but the value of every fax machine increases with the total number of fax machines in the network, because the total number of people with whom each user may send and receive documents increases.
Two telephones can make only one connection, five can make 10 connections, and twelve can make 66 connections.

Gilders Law states that the total bandwidth of communication systems triples every twelve months. In my street they are installing 50MB cable soon, so in a year that should be 150MB!!

So, computing power will blow our minds in ten years, networks are really useful when more things get connected, and speed of information flows will be even more awesome and useful for gaming.
BUT, none of the above has directly demonstrated why Oracle and SAP became powerful, or why Oracle is preferred over SQL Server for large databases, or why Column databases are better at certain reports than rowwise databases.
Or why we don't program in BASIC anymore (although it would probably be called ADVANCED now!).

So technology improvements enable us to work from home, with access to fast databases, but why am I using TOAD on Oracle, with OBIEE on top?
More importantly, what do I need to use next year, the year after, and so on. When do I give up learning and go into management!

The Cloud Compute model is already removing the need for hardware in the office, and software on your laptop (except for a browser!). The skills for databases and reporting have been commoditised, offshored and devalued. IS this pattern true for thought leadership?

Maybe I should invent a Law of my own.

How about, The second you master a technology it is obsolete.

There is actually a whole list of 'laws'

http://www.jimpinto.com/writings/techlaws.html

http://en.wikipedia.org/wiki/List_of_eponymous_laws

http://www.ietf.org/proceedings/01mar/slides/burp-1/sld004.htm

http://en.wikipedia.org/wiki/Moore's_law

http://en.wikipedia.org/wiki/Metcalfe%27s_Law

Me down to a tee

2009-04-02T08:38:00.000Z

http://peterthomas.wordpress.com/2009/04/01/pigeonholing-a-tragedy/

The day after April Fools

2009-04-02T08:18:00.003Z

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 the balloon further and shouts to get directions, "Excuse me, can you tell me where I am?"

The woman below says: "Yes, you're in a hot air balloon, hovering 30 feet above this field."

"You must work in Information Technology," says the balloonist.

"I do" replies the woman. "How did you know?"

"Well," says the balloonist, "everything you have told me is technically correct, but It's of no use to anyone."

The woman below replies, "You must work in management."

"I do" replies the balloonist, "But how'd you know?"

"Well", says the woman, "you don’t know where you are, or where you’re going, you expect me to be able to help. You’re in the same position you were before we met, but now it’s my fault."

New iPhone

2009-04-01T07:15:00.002Z

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 to run my OBIEE dashboards. Next week I'll show you how to connect to the Majendi sample/development site with iPhone, PC or simple imagination!

On the subject of new features, whilst reading about the iPhone dashboard features, and the database development it reminded me to test out the integration of the Oracle DB fone with OBIEE.
Developed intially so that the Oracle development teams around the globe (particularly between US and India) could communicate cheaply, this little known Db feature is basically like Skype or MSN, but built into the Database. Larry insisted on the development when it became obvious that offshoring his operations had increased costs and damaged the communication process.
The system uses a Db to Db network and is usually done behind your company firewall. see the Oracle documentation for details on how to enable it (from version 10g).
As yet there are no in-built features in OBIEE you can use, so you have to rely on javascript (make sure HardenXSS is false) to embed/run a thin client.
You will need a microphone (there is no video as yet, but should be in 11g). In my net post I'll show the screen shots and code on how to do this.

- @drian

April 1.

MICS

2009-03-31T10:12:00.003Z

"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 quotes on his front page, check them out

My favorite is:

Niels Bohr: An expert is someone who has made all the mistakes that can be made, but in a very narrow field

Brilliant

2009-03-30T10:26:00.003Z

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 believe? We recently advertised a role in OBIEE. We got three applicants. It is well paid interesting work throughout the UK and Europe.
I spoke to an agent last week who said he had 60 applicants for his OBIEE role, many of whom were good for the work. The rate the client wants to pay is well below 500 per day, because, he said, there are dozens of skilled workers who have been unemployed for 6 months desperate to get into a project.

Now, as far as I can tell there is plenty of OBIEE work for properly skilled workers, with the right visa for Europe, but clients have the usual cost pressures.
Those pressures normally translate into 'Day rate' savings. So a client prefers to take someone on 400 per day instead of 800. OK, seems simple enough. And the agent is happy because their margin increases.

BUT the client pays more in the long run, and the OBIEE project suffers a poor image. A great consultant can implement a really useful system that can be expanded and upgraded and part of the future for BI in the organisation. A cheap consultant who is gaining experience can make a dead end.

Who do you believe? the agency, the salesman for an offshore organisation, or the leading experts in OBIEE?
I challenge any client to compare the costs and benefits of a cheap outsource vs more expensive on shore consultancies.
I also challenge Oracle to set some benchmarks for a skilled OBIEE consultancy and consultants. Just because you reply to simple questions on OTN does not make you an expert.

What Occuring

2009-03-13T09:44:00.002Z

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 know who are looking.
With the current doom and gloom being propogated by the BBC among many others it has been noticable how much the BI market is being talked up, but what is th real picture?

We have certainly been kept busy, and could be on two or three more projects now, as well as doing all the marketing stuff, playing with the new technology and writing updates for the book. And of course there is the conference presentation to finish up.

I do know of a couple of contractors that are at home waiting for the phone to ring, and some projects are closing soon (particularyly a big govenment bank one), but this level is not unusual.

The biggest issue I can see is the lack of roles being advertised in the UK for OBIEE and Siebel Analytics. I can't remember the last jobserve advert for Analaytics, and there is only one in the whole of Europe right now.
OBIEE has fared only slightly better, with 2 roles out there right now. But there never has been too many adverts anyway. This may be due to more direct networking, particularly using LinkedIn, and maybe due to an increase in the number of consultancies advertising themselves as Oracle BI experts. However, 2 is down from the peeks we had last year.

Beware the Squeeze

In the past downturns the agencies have strugggled to maintain their income and have therefore squeezed more from the margins. They do this by telling clients that good consultants are hard to come by as they do not look for new projects in a recession, and are therefore still expensive. At the same time they tell the consultants that the rates have come down due to the recession! Always ask the agent what margin they are on, anything more than 15% is taking the mickey.

If you are looking then do get in touch I can possibly point you to opportunities my network (and no I dont charge!).

BIG NEWS

Look out next week for some BIG NEWS which we are all excited about here at Majendi.

A.

OBIEE Forum

2009-02-25T21:18:00.002Z

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, so it's like always: the early bird catches the worm.

So long and hope to see you there,

Adrian

More Big Tips Please

2009-02-20T10:35:00.002Z

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 Column Properties \ Column Format window just fine.
(I have better tips than this but I'm just warming up).

Surely someone out there can challenge Phil to tip showdown?

Big Phils Tip - Page Moving

2009-02-17T07:55:00.004Z

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 HTML is exposed so you can edit what it is doing (Other pages use Javascript to move items).
The format is:
http://majendiserver/analytics/saw.dll?PortalModify&Action=SetPosition&ItemPath=/users/ADMINISTRATOR/_Portal/My Dashboard&Position=35&Done=PortalProperties%26PortalPath%3D/users/ADMINISTRATOR/_Portal%26Done%3DEditDashboard%2526PortalPath%253D/users/ADMINISTRATOR/_Portal%2526Done%253DDashboard%2526Page%253DIntro

Which has the vital &Position=35 command. Just change this to the number in th elist you want.

Thanks Phil. Got any more?

Siebel Analytics Tip of the Day

2009-02-16T08:52:00.002Z

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 #1 added to many columns and will have to clean this up prior to publishing merged rpd.

Tomorrow I will have a top tip from Phil Henson, legend of the Siebel Analytics world !

Tonsils Out

2009-02-04T17:26:00.002Z

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 from two days after the OP I had a trip in an ambulance when blood started gushing from my throat. Never dialled 999 before, or been in an ambulance with the lights flashing and the siren going, all very excting.

Whilst I was at home recovering I managed to carry on working due to the wonders of modern technology - Broadband, VPN and Laptop. In fact I do much more when working from my home office, and get to save three hours per day travel.

Anyway, apart from the credit crunch there is still some work to do. I hear of one project that needs someone tomorrow for BI Publisher and someone else is after CTI skills.

If you are looking for a new project, drop me a line as I always hear about new projects alll the time.

Adrian

adrian.ward@majendi.eu

Another New Blogger

2009-01-21T17:13:00.001Z

Hi Grubble, Welcome to the OBIEE blogging world

http://grubble.net/index.php?blog=1

Localisation of OBIEE

2009-01-19T16:05:00.002Z

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 now.

How is your Croatian?

2009-01-08T21:40:00.001Z

New blog on OBIEE.

Good luck with it Goran.

http://108obiee.blogspot.com/

Update:

Thanks to Daan we can now view it in English
http://translate.google.com/translate?u=http://108obiee.blogspot.com/

Informatica vs ODI

2009-01-08T08:11:00.003Z

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 Oracle bought out Siebel they stated that Informatica was still the supported platform, even though they had their own tool, OWB. Now, OWB appears to be a great tool, but Oracle did not want to re-write all the Application (Mappings, Workflows, DAC, Documentation) and force their customers onto new software.

However, they then bought an ETL product company and launched another ETL (or ELT) tool called ODI - Oracle Data Integrator. The immediate speculation was that this would replace the Informatica tool in the Applications development. At the conferences I went to last year Oracle were still saying that Informatica was the main tool, but hinted at the the possible use of ODI in the future. In this document from 2007 they only mentioned OWB in the BI suite! and This Oracle Fusion roadmap does not state which tool is king.

Now there is a rumour that Oracle are beginning to use ODI for some applications. Mark Silialks (Oracle employee) pointed out in a debate on LinkedIn that the Oracle stated direction for Financial Analytics is the use of ODI - I haven't verfied this yet, but I think Greg Hutchinson summed it up nicely when he said that "Using ODI for Financial Analytics busts one of the key design advantages....conforming dimensions across all 42 OBI EE modules. So imagine a company that buys an OBI EE SLA now. Does this mean they must support both ODI for one part and Informatica for the rest? What about upgrades? or buying additional modules? "

It is clear from customers that they like Informatica because it is skillset that is already known in the business and can be available from the market (contrators, consultancies, employees).
They have also invested a great deal of time customising - thats what I do! - Adding missing functionality, adapting for changes made in the OLTP, adding other external data.
They do not want to have to repeat all of that work, learn a new skillset and be held to ransom on rates because of a skills shortage.

I'll keep looking out for more signs from Oracle but for now stick to the Informatica stuff.

OBIEE Snowflakes and Stars - Part 3

2009-01-02T17:00:00.019Z

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 the Warehouse experts, and yet we face pressure from clients to reduce the development time and complexity of the warehouse, which can lead to so called sub-optimal performance.
From Part 2 we saw that organising the logical model into a proper star led to the most efficient SQL being generated. This SQL will enable STAR Transformation to work in an Oracle DB. We also see that for this to work you need all the relevant foreign keys on the fact.

In this section we are going to explore the Hybrid design. This design is common to most implementations that I have seen.
The logical model is designed as a star. However, the physical model is a Snowflake.

The LOGICAL MODEL.

I have only shown one dimension here for simplicity, but there can be several dimensions attached to the fact.

Here I have shown three logical tables to demonstrate the different methods for the Logical Table Sources (LTS)
If you look at the Logical table sources in W_PERSON_D, you will see that I have three set up, with the LTS name being the same as the underlying Physical table:

In this example each one contains just one Physical Table. The first one contains just the HYBRID_PERSON_D:

And the column mapping is...

If we look at the column mapping for PERSON_DX

We can see that only those columns that exist in the physical table are matched to the Logical Columns. This will force the engine to use this LTS if any of these fields are used. Also note that I have mapped the ROW_WID field to the DX field that contains the Person Row WID.

Now let’s look at a report being run using this Logical Dimension.

No errors and the SQL does the magic of combining the separate Logical Sources

select T5260."FULL_NAME" as c1,
T5303."ACCNT_WID" as c2,
T5303."BRICK_WID" as c3,
sum(T5274."BLAH_VALUE") as c4
from
"W_XREF_PERSON_M" T5303,
"W_PERSON_D" T5260,
"W_PERSON_F" T5274
where ( T5260."ROW_WID" = T5274."CONTACT_WID"
and T5260."ROW_WID" = T5303."CONTACT_WID" )
group by T5260."FULL_NAME", T5303."ACCNT_WID", T5303."BRICK_WID"

And if I just want to query against the Name:

Then the SQL shows that only the relevant tables are queried:

select T5260.`FST_NAME` as c1,

sum(T5274.`BLAH_VALUE`) as c2

from `W_PERSON_D` T5260, `W_PERSON_F` T5274

where ( T5260.`ROW_WID` = T5274.`CONTACT_WID` )

group by T5260.`FST_NAME`

(unfortunately I am using Access for my sample database and Access does NOT support comments in SQL, otherwise you would see which LTS has been used)

Now let’s look at Person V2

Here we can see that I have added just one LTS

But that LTS has three physical sources,

And if we run a request:
(the same one as above)

Then this time the SQL is as follows:

select T5260.`FST_NAME` as c1, sum(T5274.`BLAH_VALUE`) as c2

from `W_PERSON_D` T5260, `W_XREF_PERSON_M` T5303, `W_PERSON_F` T5274

where ( T5260.`ROW_WID` = T5274.`CONTACT_WID`

and T5260.`ROW_WID` = T5303.`CONTACT_WID` )

group by T5260.`FST_NAME`

As you can see W_PERSON_D and W_XREF_PERSON_M are included in the SQL but not W_PERSON_DX? Why? W_XREF_PERSON_M is not even used in the request columns and it does not help the SQL to answer the request!
We know that PERSON_DX is joined to PERSON_D using a physical foreign key, whereas PERSON_M is using a logical key. So let experiment with the keys to see what happens.
I changed the join between PERSON_D and PERSON_DX to a physical join, not a physical foreign key, and re-ran the report, which resulted in the following SQL.

select T5260.`FST_NAME` as c1, sum(T5274.`BLAH_VALUE`) as c2

from `W_PERSON_D` T5260, `W_PERSON_DX` T5267, `W_XREF_PERSON_M` T5303, `W_PERSON_F` T5274

where ( T5260.`ROW_WID` = T5267.`ROW_WID` and T5260.`ROW_WID` = T5274.`CONTACT_WID` and T5260.`ROW_WID` = T5303.`CONTACT_WID` )

Group by T5260.`FST_NAME`

This time the PERSON_DX tables was added into the SQL even though it is not used in the request.

Now let’s have a look at a third way. This combines the two methods above of creating the LTS’s.
Here I have created the dimension with 3 LTS

Each one contains the W_PERSON_D table. The first is on it’s own, the second contains both Person D and DX, the third Person D and XREF M table. The choice for the developer with this set-up is what fields to map where. Take ‘First Name’, do you map this to just the first LTS or all three?
If I map it to all three then run the following report

I get the following SQL

select T5260.`FST_NAME` as c1, T5267.`ATTRIB_11` as c2, sum(T5274.`BLAH_VALUE`) as c3

from `W_PERSON_D` T5260, `W_PERSON_DX` T5267, `W_PERSON_F` T5274

where ( T5260.`ROW_WID` = T5267.`ROW_WID` and T5260.`ROW_WID` = T5274.`CONTACT_WID` )

group by T5260.`FST_NAME`, T5267.`ATTRIB_11`

order by 1, 2

One piece of SQL gets all the answers
Now if I map ‘First name’ only to the HYBRID_PERSON_D LTS and re-run the report, I get

select T5260.`FST_NAME` as c1, T5267.`ATTRIB_11` as c2, sum(T5274.`BLAH_VALUE`) as c3

from `W_PERSON_D` T5260, `W_PERSON_DX` T5267, `W_PERSON_F` T5274

where ( T5260.`ROW_WID` = T5267.`ROW_WID` and T5260.`ROW_WID` = T5274.`CONTACT_WID` )

group by T5260.`FST_NAME`, T5267.`ATTRIB_11`

order by 1, 2

ITS THE SAME! The Analytics engine just puts together the SQL it needs, irrespective of your chosen method of LTS.

Summary

So what is going on? In the example model we have seen that
it does not matter what logical or physical model is used, OBIEE still works.
It does not matter how you set-up your logical table sources, OBIEE will put them together in a small query to get the results.
If you use a physical join, then OBIEE will always use the joined to table in the query, even if it’s not necessary.
If you use a Physical Foreign Key, and have the joined table in an LTS, it will only use the joined table when it is needed in the results.

So does design Matter?
Given the evidence so far, it would appear that you can do without a specific design. A complete beginner can do what they like and OBIEE will deal with it. So beginners can get away with building however they choose. If your dataset is small then performance will not be an issue, and if speed of response is bad then designers can always blame the network/db/server/web! When a project starts out, or is just a prototype then you do not need to consider the future addition of facts and dimensions so who cares what the technical stuff looks like. If you want to impress the client by saying you can install in 3 weeks then you had better forget design cause this takes longer, and once you have wowed the client you will get further work and no-one else will see your build (I know who you are!).

If a client has gone for the cheapest option, ie offshore, then they do not care about the quality of the work done, so build it however you like – they will never know.
But, I care what work I produce, and I normally work on very large databases which will not forgive poorly written SQL. If you have an Oracle environment then you want to maximise the use of Star transformations. For any large system you will want to take advantage if summaries. In my simple model I have used tables which join using the Person unique code. I have also not used any aggregations. There are no Hierarchies. There are no Level based measures. There are no visibility filters in place.
All of these features are what make OBIEE a useful tool for the analysis of large amounts of data, by end users with no need to fully understand SQL. Without these features, Drilling through data levels to find the specific issues would take too long. Summary reports would be too slow and users would revert back to Access, Excel and SAS. In fact, if your users still insist on using Excel or Access for a large amount of their analysis then your installation of OBIEE DESIGN is failing (You cannot totally remove Excel, in fact you should be encouraging some integration with OBIEE).

In the real world the joins in a dimension can be numerous, not use the Dimension keys and sometimes involve complex joins. The joining of tables in a one-to-many relationship can result in multiple results for a single dimension e.g. Person, which when used with a fact causes duplication of facts. If you have multiple Logical Table Sources then you have to be sure they will work together. If the user were to choose a field from each source do they get an error? If so why?

How do you incorporate Dimension attributes, for example a Contact could be a Doctor who works at a particular Hospital, but later changes to another Hospital. Do you store the doctors hospital in the facts where contact exists (true Star Schema style) or in the Contact dimension, or linking from Contact to Account (Snowflake) or in an SCD? If you use a pure normalised model then this is not a problem, or is it? How do you reflect history? Do all the patients the doctor has treated over time get added up in his new hospital?

So my point is, yes you can do quick and dirty, and you can use normalised schemas or snowflakes or Pure Stars in OBIEE. But please do so knowing the consequences, and have good reasons for doing so. Don’t blindly follow a star schema for small implementations, which need minimal amounts of ETL. Do use as pure a star as possible for very large implementations, or where multiple facts share common dimensions.

HAPPY CHRISTMAS

2008-12-24T10:40:00.003Z

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 consultants :)

Have some fun at http://www.speedysanta.com/

I'll post part 3 of the Schema discussion next week

Adrian

Stars and Snowflakes

2008-12-10T10:24:00.010Z

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 on the datawarehouse, and your design considerations for Logical Tables, logical Table Sources and Physical Joins in the Physical Layer. Another point to note is that I am not too concerned about the theoretical difference between Snowflakes and Normalised, in the example shown in Part 1 you could call that a Snowflake or a Normalised design. Some have described Snowflakes as semi-normalised stars which is a fair decription, but the important point for the discussion is that there is at least one join between dimensions, which instantly makes it a non-star design, and is on the road to normalisation.

In part three I will look at a mixed model - Logical stars with normalised physical tables.

I do believe the actual dataWarehouse design and ETL routines should follow what you decide in your logical design considerations. Having said that though, I don't think that the whole reporting system can be developed in a linear path, you often have to loop back at each stage when more clarity is found.

And finally, Please join in the discussion by posting your comments.

Now, on with the blog...

From Part 1 some of you may be thinking that I'm advocating that Stars are not always required in the warehouse. Well, I tried to put together a fair case for the use of normalised design as best as I could. Now, lets have a look at the case for a pure star.

Continuing with the Contact example used in part 1, we can redraw the model in a logical and physical pure star.

Running the same report.

And obviously it works, but look at the SQL:

SELECT

T3489."ATTRIB_11" as c1,

sum(T3517."BLAH_VALUE") as c2

from "W_PERSON_DX" T3489,

"W_PERSON_F" T3517

where ( T3489."ROW_WID" = T3517."CONTACT_WID" )

group by T3489."ATTRIB_11"order by 1

So this time the join is direct in the physical layer, and therefore the server does not add in another table to get the answer.
Is this reduction in joins THE main reason why you design a pure star? Or are there other reasons why star = good?

So on the face of it there is no problem with either method. The star method was very efficient in the query, minimising the number of joins. But at what cost to the ETL process? Here, in this example, none because it joined to an existing key, however if you were talking about say, Account Id, then the mapping would have to look it up and add it to the target table. Of course the Star Transformation in the db will struggle with the normalised schema (or will it – answers on a postcard).

But. I cheated. Twice. Firstly, this is a very simple model, with little data in, so design is not vital.
Secondly, what if I want to do this …..

Part 2A

Let's build a hybrid. Surely we can use a star and introduce some level of normalisation and all will be well? Consider the following design.

The above 'star' has all the physical dimension tables in the single dimension logical table.

We have a logical star. With Physical table sources arranged in a physical star, except we have a few ‘spokes’ around some of the physical dimension tables (this is essentially what mosst people would call a Snowflake!). A common use here would be a ‘List of Values’.

Does it work? and is it 'better'?

There are two considerations

Errors is Analytics generating SQL
Duplication of data.

I'll explore these in part 3.

Stars and Snowflakes

2008-12-08T08:32:00.014Z

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 combine a clear, star lit night with snow fall.
You can have one but not the other at the same time.
But can OBIEE defy the laws of nature?

A recent debate got me re-thinking about why I design like I do in OBIEE / Siebel Analytics.

Let’s look at the arguments:
There are two main contenders, Star Schema verses Normalised. Inmon vs Kimball. (I’ll not go into the details of these, I’ll assume you know what each looks like.)

Bert Scalzo says in his book on Warehousing "You should not have a star schema with snowflakes in", but he does say 'AVOID snowflakes' which suggests they are not banned completely.

However, many clients I have worked for actively encourage snowflakes. They're not actually requesting them, but they can't see the point of spending lots of money waiting for the warehouse to be ready for reporting. "The data is in there, so just report on it", they say! This is not helped by sales men and women telling clients how easy it is to develop on your existing structure. One client I worked at was convinced that the layers in the database with complex ETL was purely Intellectual stimulus for bored contractors (Who also got paid by the day!).

Then there is the real killer, the POC – Proof of Concept. Certainly proves that you can report on their data without the hassle of ETL, schedules, downtime, etc.!!!

Another project I know of is full of snowflakes, and just like the real thing, each one is unique! Again the client is happy with the design because works for the current reports.

Up until now I have been a convert to the Star Schema, slavishly making sure every table fitted the philosophy, but I need to keep the client happy, which effectively means developing cheaper. When they send their development offshore they also tend to abdicate from significant design decisions, they just want the system up and running as quickly and cheaply as possible. But that’s life, this is the new game, get over it. Compete.

Before I revisit my design principles, Can Siebel Analytics/OBIEE really cope with snowflakes? Or is it smoke and mirrors? The answer depends upon whether you are looking at a Logical Level or Physical, and how well you implement a snowflake.

On first glance you look at the Business Model and Mapping Layer as a pure Logical Level. You normally have logical tables, arranged in a logical star. And in this logical layer the training documents have always decreed that you have a star.

But can you use another logical model? What would happen if you tried to organise your logical tables in a snowflake? Do you get an error when you check for consistency? No? Why not? Surely OBIEE does not understand snowflakes and it should tell you if there is a bad design!?.
Lets have a look at a snowflake, or normalised, logical layer.

Here we have one dimension joining to the fact, and two other dimension joining to it.

So, running a report,
First the list from W_PERSON_D on its own,

Now add the Fact,

NO problem!

Including normal aggregation

Now we add one of the ‘flakes’

And still no problem.

But what if we only query the Flake (W_PERSON_DX) and the fact?

The result is …..

It works !!!

Here is the SQL being produced.

select T519."ATTRIB_11" as c1,
sum(T547."BLAH_VALUE") as c2
from
"W_PERSON_DX" T519,
"W_PERSON_D" T301,
"W_PERSON_F" T547
where ( T301."ROW_WID" = T519."ROW_WID" and T301."ROW_WID" = T547."CONTACT_WID" )
group by T519."ATTRIB_11"
order by 1

It added in the W_PERSON_D table all by itself.
Remember there is no join between PERSON_DX and PERSON_F, not physically and not logically.

So, a normalised set of tables arranged with the joins in normal form does work.

So why bother with stars?

(part2 to follow)

Here we go again

2008-10-02T20:58:00.002Z

Maybe I was a little hasty with the last message.

I think I was caught up in the hype of the moment.

Can you imagine flying all the way to San Francisco, having to stand in a queue for hours along with a bunch of IT execs, and then go through a boring HP advert for an hour. After that, and all the rumour mill, anything would have sounded great.

And on the face of it the new Hardware seemd exciting enough. Oracle is pretty good as it is, put on a box designed specifcally for it and it'll be great.

But then you finally remember that we have been here before. Does anyone remember the Net PC? Larry had a great idea that we would all use computers that were just shells. All the power and storage was on the web. Sorry but we are still 10 years away from the reality on that one.
Does anyone remember the previous Oracle forray into Hardware with Dell? There are plenty of commentators around this week who do (have look at the Oracle BI blogs).

The truth is that this 'Xbox' is not their first attempt (despite their claiming it is), and Oracle has a poor track record when getting involved with hardware.

Why the previous efforts failed I do not know, but I do know that the major outsourcing companies will not fall over themselves to get the 'HP' boxes in. Can you imagine IBM really telling their clients to go out and buy this?

Let hope Oracle have learnt their lesson, and find some way for everyone to win, not just the end client in theory.

BTW Didyou notice the new layout. I'm starting a campagn for all BI blogs to use this style :)

X Marks the spot

2008-09-25T07:56:00.004Z

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 databases should mean that Analytics runs faster (provided the network is up to the job).

Without improving the hardware all the OBIEE product innovations will be for nothing. Users will not put up with advanced reports that take 10 minutes to run.

Mind you, faster kit will probably lead to lazy code, poor index strategies and over large databases, so we'll slow down again soon enough!

So, as consultants we will all be looking for the dream project : Oracle X, 11g databases, Good clients, excellent project management ad all done in the same time zone!!

Dream on.

Urgent Requirement

2008-09-17T15:11:00.002Z

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: yesterday
Duration: think at least 3 weeks – probably up to a year
Salary: up for negotiation, but I think 100 Euro / hour should be ok.
Fancy a stint in Munich while the Oktober-Fest is only a stone’s throw away from your desk ;-) or do you know anybody who could be up for it?

email adrian.ward@majendi.com if you are available (perhaps you worked at Lehmans!)

Talking about users

2008-09-03T08:30:00.002Z

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 was deleted. The Admiinstrator still existed with a diff password.
The LDAP did not contain, nor would the rules allow for, an account called 'Administrator'

So the rpd was very safe in Production. Problem is that no-one can log in to Answers and make ANY changes to the webcat. No new groups, no changing privileges. nothing.

how funny.

They were told, but Security is very important don't you know!.

(btw The obvious solution they woud not entertain was to have a user in the rpd that also existed in the LDAP, which was a member of the Admin group.
The work around that should have used is an Initialisation block to poulate a WEBGROUPS variable that included a high level group, such as Web Administrators.)

Multi User

2008-08-21T07:21:00.002Z

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 trick is to get your Projects right to 'Check-out'. But of course you get a chicken and egg situation. You need the rpd set-up first to create the projects!

I'll let you figure that one out.

Actuate Anyone?

2008-08-04T20:45:00.000Z

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

Australia Anyone

2008-07-31T07:17:00.002Z

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. The requirements are as follows:
We have 3 positions: 1 Sydney, 2 in Melbourne and 1 contract role in New Zealand.
The roles will require experience with the complete life cycle of Data warehousing with SQL, Oracle or Terradata.

Please respond to this e-mail if you would like to know more about these positions or if you know of any one who would be interested.

Kind Regards,
Alex Blake Consultant IT & T
Total Resource Solutions
25-27 Brisbane Street
Surry Hills, NSW 2010
Tel: +61 2 8705 8500Fax: +61 2 9326 9844

Analytics Developer Required

2008-07-25T09:50:00.003Z

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 for the right candidate.

You have to be legal to work in the Uk and here already please.

More work coming online

2008-07-24T13:19:00.001Z

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 upgrade project based in the Netherlands.This is an opportunity to work on a new projEct from the initial blueprint right through to Go live .Please see a brief outline belowSiebel Functional Consultant / Business Analyst - SIEBEL 8.O EXPERIENCE REQUIRED - Our Client a high profile blue chip Organisation requires an experienced Siebel CRM 8.0 Functional consultant / Business analystfor a 9 month project in the Netherlands. The Siebel Business Analyst /functional consultant will be involved in the conception and requirements gathering for a Greenfield Siebel 8.0 implementation. The Ideal Siebel Functional consultant MUST have Siebel CRM 8.0 experience solid exposure to discoverer with fluent Dutch (though not paramount) language skills. This role will include business Case development customer centric strategy definition, business channel integration, functional requirements analysis template building then deployment. You will have proven excellent experience in requirements gathering for Siebel Finance projects. This is a very urgent requirement so please send CV's for immediate attention or telephone Gerald for more information. This is a fantastic opportunity to join a long term and challenging Siebel project. Montash Limited acts as an employment agency/business. No terminology in this advert is intended to discriminate on the grounds of age, and we confirm that we will gladly accept applications from persons of any age for this role.

A Conditional, Data-Driven Action Link

2008-06-17T10:43:00.005Z

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 in v7.8.x onwards is buggy and doesn't provide the same 'mouse-over' information when choosing the custom data format route (accessed via the 'Data Format' tab for the column in the request); so personally, I prefer the custom data format. The syntax can take a little getting used to, but is straightforward to manipulate once you understand the components.

Current limitations aside (such as the inabilty to target child applets in Siebel), a little more intelligence can be added at the request level to make your action links conditional, based on the data you return in your request.

This might be performed using a CASE statement, but more complex functions could provide a range of results to use for your action links. For example column A contains your data, column B your conditional action link. The basic function syntax for column B would be as follows:

CASE Column A
WHEN = 1 THEN 'Action Link 1'
WHEN = 2 THEN 'Action Link 2'
ELSE 'Action Link 3'
END

So you have your basic conditional navigation here, but its important to get the syntax right for each action link created. Ultimately you want this to resolve correctly for the custom data format.

With a standard action link, normally 3 elements are provided in the custom data format: View, Applet and Row Id. In this case, you will provide all 3 elements as one string from column B and amend the data format slightly.

The string will need to be correctly 'escaped' for both Analytics to recognise it as a string, but also for it to resolve correctly using the javascript function NQSWENav, referenced when creating action links.

- Char(39) : SQL escape character for single quotes
- || : double pipes used by analytics here to concatenate strings
- , : commas separate the 3 arguments normally used in action links

Char(39)||'Order Entry - Line Items View (Sales)'||Char(39)||','||Char(39)||'Order Entry - Order Form Applet'||Char(39)||','||Char(39)||Order."Row Id" ||Char(39)

Notice you're adding 2 single quotes each time, the 1st one will be removed by the analytics server leaving the second one when using the javascript function. Add this string after the 'THEN' portion of your CASE statement. For each different condition in the CASE statement add the action link functionality using this syntax replacing the view, applet and row id arguments each time.

Your statement will probably looks something like this:

CASE Column A
WHEN = 1 THEN Char(39)||'Order Entry - Line Items View (Sales)'||Char(39)||','||Char(39)||'Order Entry - Order Form Applet'||Char(39)||','||Char(39)||Order."Row Id" ||Char(39)
WHEN = 2 THEN Char(39)||'All Service Request across Organizations'||Char(39)||','||Char(39)||'Service Request List Applet'||Char(39)||','||Char(39)||"Service Request"."Row ID"||Char(39)
ELSE Char(39)||'All Activity List View'||Char(39)||','||Char(39)||'Activity List Applet - Basic - No Toggle'||Char(39)||','||Char(39)||Activity."Activity Id"||Char(39)
END

Now that you've got your CASE statement, open the 'Format Column' portion of the request and go to the 'Data Format' tab. Make sure the 'Override Default Data Format' is checked and select 'Custom Data Format' from 'Treat Text As' drop-down list. In the 'Custom Text Format' add the following syntax:

@[html]"<a href=\"javascript:NQSWENav("@"); \">"More..."</a>"

- @ : refers to the contents of the column
- NQSWENav : the javascript function used to navigate to the Siebel application

It is recommended not to display the column contents, in this case it will be quite long, rather provide a meaningful link prompt (e.g. 'More...', 'Link...'), but this is entirely personal preference.

Look at the results of the request to check you've got the syntax right, then run it from your integrated application (Siebel/Analytics) to see those action links in action.

N.B. For those new to action links, it is the Row Id column from the base table which is required (not any other identifier) for action links to work correcly.

I give in

2008-06-12T10:44:00.003Z

Well Mr Brown, you finally got your way. I have just taken delivery of a new car to get to the office, and I bought the smallest cheapest, funniest little thing you can get.

see

35 quid to tax, cheap insurance and runs forever on a tank of petrol. I cant say that I did it to be green, I just can't afford Mr Brown fuel taxes every day.

Well done - you win. Til I shut down business in the UK and move to Switzerland!!

Is that It?

2008-06-09T08:48:00.003Z

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 bunch of consulting firms have got there surfboards out. But has the wave already crashed onto the beach?

I tend to use the job market as an indicator of the projects and skills in demand.

Five years ago when we started our Analytics consultancy, there were 1-2 new jobs per week advertised for Siebel Analytics consultants (pre-runner to OBIEE). That grew over the next couple of years to approx 6 real jobs per day. Although there would be 20 adverts, lots were agencies fishing for CV's, others were two agencies with the same job. We knew most of the projects in the UK, as there were not that many. As the market grew so did our business, life was very busy.

The reason for our success was getting trained people onboard. This cost a fortune, as Siebel controlled the training closely, charged high prices, and refused to allow others to publish training material.

Then along came Oracle and bought Siebel, renaming the product and heavily marketing OBI (EE and others).

At first this killed the market off. Uncertainty over Oracle intentions, and re-organisations in the salesforce meant that new sales were low and new projects went to other products.

Momentum was returned to the Oracle Business Intelligence set of products and the wave got going again. Six months ago there were dozens of jobs on the internet and companies were snapping up OBIEE.

I also look at the competition in the marketplace. When we started the business there were two companies in the UK who offered Siebel Analytics consulting, us and Innoveer. Slowly this increased, but mainly in mainland Europe. The UK market was too small and specialised for major investment. Customer Systems, Rossett Stone, Abbusys, ClearPeaks, and a bunch of offshore other companies set about the our market. These were good small companies, run by hard working specialist who know the Siebel product well and added the Analytics skills. I know all these people having worked, with, for and in competition with, on dozens of projects. These people invested a great deal in the hope of a growing market - they joined the curve on the way up!

When Oracle finally got it's act together they completly opened the market up. Publishing deals were allowed, other companies could run training (Including us), the software was made freely available for development, marketing activity went through the roof -the last UKOUG Business Intelligence conference was wall to wall Oracle presentations (I hope we get some variety tomorrow).

This led to an enormous influx of consultancies suddenly interested in the OBI product set. Competition became fierce, but we kept winnning work based upon REAL experience, and due to the fact we stick to what we know, OBIEE and Siebel Analytics Applications. Rates droppped and every independent consultant was putting Oracle BI on their CV. Desperate for experience they were killing the normal rates for contractors and undermning the credibility of the product.

(There are still dozens of high profile firms out there pretending to be experts in OBIEE - ask them how many real projects they have done)

Then along came a market confidence knock.

Due to a credit crunch, fuel prices, or whatever, the floor dropped out of the market. Search today on Jobserve for OBIEE jobs and ONE comes back. It pays really bad and has been open for months, and is in Edinburgh (not too bad in the summer). Search for Siebel Analytics and you get 2 jobs, in Switzerland and France.

I have a good network with the other independent experienced Analytics consultants based in the UK. They are manily working overseas in Europe (thankfully a good Euro-GBP rate at the moment). I know of several individuals that are looking, and will be available soon. Is there an over supply of Analytics /OBIEE experts?

There are a couple of roles that have not been advertised recently but one is not paying enough for a an expert with the level of experience they need, and the other will probably be filled by the available consultants on the market without the need to advertise.

So, has the wave crashed on the beach??

One theory is that projects are on hold or cancelled.

One factor may be reduced Oracle sales (have to wait and see on that one).

I think a huge factor is the type of customer that would normally implement OBIEE. They're big, normally very big. OBI can be expensive to buy (unless you go for the cheaper packages) and be expensive to implement. Maybe the budgets are tight this year, but these companies normally have large outsourcing deals with the major IT/Consulting firms - IBM, Accenture, CSC, TCS, HP, CapGemini, Deloitte, etc, and most of these firms are begining to compete on price - get the work offshore and charge peanuts. Until now the skills have been in short supply. I have worked for every one of the above, filling a gap in their knowledge. But now they have set-up their Indian operations and the skills are getting there (not as good as ours abviously!). My last project manager at CSC has been sent to India to manage the operation.

So my conclusion is that the number of projects are down, the number of consultants available are up, and the offshore model is beginning to bite.

Time to stop surfing and get the Kite board out!!

Long Time no see...

2008-05-15T20:58:00.002Z

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 steady, casual affair, best done one hand on the wheel and a cool beer in the other.

Just as well really, because if I was in a hurry then downloading and installing the Oracle BI software would be driving me mad. I am on day three of night and day downloading. I have a fast broadband and a new laptop, but I have dozens of large files to get, unzip and install.

I started by getting VMware, installing a 50GB virtual machine, then setting up Windows Server 2003, including the updates, then downloading all the relevent Oracle files. There are hundreds of them. Database installs, BI platform (OBIEE, informatica, BI Publisher), EBS files, samples, and BI Apps. I'm mainly interested in the 7.9.5 Analytics for CRM plus HRM and Financials analytics. I'm not even sure if I will bother with the Essbase stuff.

One of the reasons for setting up a whole environment is for a client presentation next week, but the other is that there are rumours that the HR BI Apps repositories are in need of some improvement. This doesn't surprise me if it's true, we have had lots of interesting days with the CRM Analytics, but I would have thought that Oracle have had enough time to get these 'pre-packaged' apps sorted out. Trouble is, they still seem to be unsure what to do about ODI vs Informatica (and what about OWB). At the last UKOUG conference the product development people still had no clear direction on this.

I'm beginning to think that there is rooom for some competition on the pre-built Apps front. Question is, how much effort should I put into this, and should we try an Open Source model?
Then there is the choice of subject. Marketing and Forecasting needs some pre-built work (two clients I know wanted it), but now maybe HR.

Mind you, it'll be a few weeks before I get round to anything. Maybe I should jst start the downloads and head back to the beach!

Let me know what you think of the pre-built ETL, DAC and rpd's.

BI Conference Afternoon session

2008-03-18T16:41:00.003Z

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 will write about tomorrow when I have had time to digest them (and my dessert).

The conference was a sell out, with a huge number of end user companies, but what was interesting was the companies which were not there. No Big integrators - no IBM, o Accenture, no TCS, no EDS. and no Agencies. There were the usual small integrator, Eclectic, SolStone, Majendi, RittmanMead, etc. This just underlined my view that the little guys have all the knowledge, experience and capability and yet the big guys have the marketing clout.

For me it was a great success. I went with three objectives

Find out where the Analytics Applications are going
Find out what developments are being made in the OBIEE platform
Get on the beta program for 11g

The answer is that Informatica is still fully part of the Applications, as is DAC (for now). Development is being concentrated on the new Analytics.

The OBIEE platform is getting better and better and the new flash graphs are a bit of fun.

I have the email of the guy for the beta program :)

I also learnt more about the Data Mining tool. Something I will learn more about I think.

I will be off on Holiday for three weeks. Sailing around the Caribbean.

See you when I get back.

Hot news from th BI conference

2008-03-18T14:27:00.002Z

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 DAC are still going strng. They do have plans to have ODI run in parallel but nothing concrete out there yet.

more as I find out.

I'm off to get some pud

And Ross joins in

2008-03-17T09:40:00.001Z

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/

Not really my thing.. but ..

2008-03-07T21:35:00.001Z

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 Application Support is the main focus. Middleware and Applications as Oracle Application Server, Apache Tomcat, Oracle Portal Server, Siebel and Oracle E-Business Suite are the basic items that need to be supported on day to day bases. This will vary from incident-resolving to security, health checks and problem analysis until performance and tuning. In the role as a software specialist professional you work with a variety of people and skills in a team where you all support and back-up each other in case of escalation and where the pro-active job is to prevent these incidents and escalations. Adding value by developing tools of automation is highly appreciated. I am looking for someone who has strong in Oracle application server, Oracle E-Business and UNIX. You will be working in a large team of about 8 consultants where there will be an opportunity to learn new skills and techniques. Dutch speaking role -
please send CV for full details and immediate interviews.
Kind Regards
Jill Jill Lund
Senior Recruitment Consultant
Best People Ltd

Rate Card

2008-02-28T10:05:00.003Z

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 expenses
Consultant - 750 (expenses included in home country, add on for Europe)
Junior Consultant- 250 plus expenses

What are the levels?

Senior Consultants have 4 years of Analytics / OBIEE expereince. They have at least 6 projects implementing new or upgrading systems. They can lead the reporting part of any Siebel Implementation and take personal responsibity to ensure the client is happy with the deployment. They will also have other skills, e.g. unix.

Consultants are qualified from Oracle University and have worked alongside the Senior consultants on large projects. They have been working on at least 3 projects and demonstrated a high skill level to the seniors.

Junior consultants are qualified from Oracle University but have only worked ont he internal Majendi project. They are not sent out alone, but always in an assisting role with a senior.

Where are we based?

UK -London
UK -Manchester
UK - Glasgow

Germany - Munich
Switzerland - Geneva

South Africa - All

We need more staff, more freelance consultants, and more partners with related skillsets, e.g. Senior Siebel experts, eBusiness Experts, etc.

What Projects do we work on?

The bigger the better. Leading Pharmaceuticals, National Telecoms providers, Military, National Transport Carriers, Global FMCG, National Postal Companies, Power Generator Providers, Very large Banks, Electronics manufacturers and many smaller companies and government organisations too.
Every single customer of ours will provide a positive reference.

Do we negotiate? Never. There is more work than we can shake a stick at. Maybe we should charge more.

If you are freelancing, make sure you are paid your worth. If not, come to Majendi. We are not an agency. Agencies have an important role in matching people to projects too, and we work with the best of them, e.g. SCOM, Aston Carter. We are specialist consultancy that knows OBIEE, and how companies can implement it.

More Groups Please

2008-02-27T09:26:00.002Z

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 will provide resources for OBIEE professionals. This is planned for mid March.

If you haven't joined us please go to http://www.linkedin.com/e/gis/43109/526A0219C124

The main reason for networking is so that we can share useful information. It is amazing how many projects I have worked on where I needed staff and they come via an agency and yet i could have employeed people directly, for more money!! Use your network. If you are looking for OBIEE work just get in touch. I wont spread your details around, but I may know of a project that you may be suitable for. Do not leave your current job to go contracting without giving me a call. I can help. You know who you are!!

On the subject of groups, I think I should join the following groups

IOUG (International Oracle User Group)
OAUG (Oracle Applications User Group)
Oracle BIWA SIG
Oracle BI Network

If you have the link please send it on.

Need a loopback Adapter

2008-02-19T12:35:00.004Z

This took me ages to find

If you need to install Oracle database on a Vista Machine then this may help.

1) start device manager
2) right-click top node
3) add legacy hardware
4) select Netwrok Adaptor
5) 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

http://blogs.msdn.com/astebner/archive/2004/07/06/174576.aspx

Execute

2008-02-15T16:34:00.002Z

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 known as Analytics Scheduler, nothing much has changed, the Job Manager is used to schedule iBots for Oracle delivers and provides an interface to check progress of batches and records details of failures, it can also be used to schedule scripted jobs including triggering workflows in integrated applications, writing data to the database and triggering statistics updates in the database.

Prior to using the Job Manager, the user needs to run SAJOBS.oracle.sql from C:\OracleBI\server\Schema, this creates the tables for the scheduler, alternative versions are provided for most major databases.
Next one must create an entry in TNSNAMES.ora for the Data Source Name, launch the Job Manager from the Programs menu or Administration and add the connection details in Scheduler Configuration, for non-Oracle databases use windows ODBC and create a DSN.

nQcmd.exe

This command line tool executes SQL script on the database and can be used for Cache Seeding operations, it is not recommended that it be used directly as these jobs can be run through Job Manager, it is also recommended by Oracle that remote access tools such as TELNET or remote desktop are disabled on the server running presentation services as direct access to nQcmd.exe constitutes a security risk.

nQLogviewer.exe

nQLogViewer.exe is a utility and part of the analytics installation and resides in the 'Analytics install dir'/Bin directory. It's essentially a parsing tool that allows you to extract info from the NQQuery.log.

The particulars of the utility are:------------
Command: nQLogViewer -u -f -o -s -r

where:
= Analytics user
= NQQuery.log to examine
= File to send results to
= ID of user logon session (unique per user logon/logoff session)
= ID of specific request from an Analytics Web Client sessionNQQuery.log

excerpt:+++administrator: 100: 101: ----2002/05/31 10:53:03 timestampExample to see only those entries under session ID 100:nQLogViewer -f c:\nquire\Log\NQQuery.log -o c:\nquire\Log\NQQuery_session100.log -s 100

nQQueryStatsFormatter.exe

No longer used in Oracle BI

NQSChangePassword.exe

This utility allows the changing of analytics user passwords from the command line.

NQSServer.exe

This is the Analytics Server process and must be running for analytics to function, it appears as a service in Windows (Siebel Analytics Server or Oracle BI Server), and is controlled by the Server Manager process in a UNIX environment.

NQSShutDown.exe

The executable can be called in a Unix script and stops the Analytics/BI server.

I'm not convinced these are still valid in the OBIEE world but are for Analytics 7.x

OC4J as a Service

2008-02-13T16:06:00.003Z

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 a windows service download the open source tool named JavaService.exe from http://javaservice.objectweb.org/ which can create Windows Services for Java Programs, adjust and execute the following command:
javaservice -install "Oracle BI: OC4J Service" "D:\jdk1.5.0_09\jre\bin\client\jvm.dll" -XX:MaxPermSize=128m -Xmx512m "-Djava.class.path=d:\OracleBI\oc4j_bi\j2ee\home\oc4j.jar" -start oracle.oc4j.loader.boot.BootStrap -description "Oracle BI Oc4J Service"

Now you can add to your 'net start' commands batch file.

Credit to Andreass in the Majendi team for this.

UPDATE: Venkat has also blogged on this subject, including some screen shots.

Auto running OC4J

2008-02-08T06:45:00.000Z

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

And another thing

2008-02-07T21:42:00.000Z

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 takes ages to load and edit in the Admin tool, it's just a nightmare to figure out which bits belong to which Licence option. I need to write some UDML scripts to deal with the different packs. Maybe one of you lot already have some to send me :)

Is the future here already?

2008-02-07T21:19:00.000Z

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. You wait, when Larry gets back from his next sailing trip someone will have written some SAS like functions - or maybe just bought SAS!!!

So are Informatica getting ready to be bought out. The rumours have started and speculation is rife. Just imagine what will happen if someone else buys Informatica and oracle have to re-write all those ETL applcations. Come to think about it, that's not a bad idea. Maybe this time they will do better.

Aaaargh

2008-02-07T05:50:00.000Z

Thanks Bill. Thanks for the new windows system. not.

I bought a new laptop last week, it's a Vostro 1700 from Dell. Very good spec, loads of memory, fast cpu etc, but also including Vista.

I went to install my copy of OBIEE and it refused, so it's not backwards compatable. So I tried the latest version 10.1.3.3.2 (download biee_windows_x86_101332_disk1) and it installed fine, except it didn't recognise my IIS, so i only got the oc4j.

Opening up the paint dashboard all looked fine so I prepared some data for a demo to my latest client. I created the demo data in Excell and Access, modified the paint rpd to include the new data. The demo was in an auditorium full of managers! (gulp)

Off to the site I went on a train from Copenhagen (at 5am!!). The journey was three hours so I thought I would walk through the steps I was going to give in the presentation. Opening the dashboard was fine, then clicking on the Answers link I was asked to log in again. Loggin in again I was then presented with a screen saying that I was not logged in!!
Clicking on the Admin link gave the same issue. In fact almost every link required you to log in again.

With 20 minutes to go before the presentation I had re-installed the software twice, searched google, IT Toolbox and the forums, and pulled out most of my hair.
Finally I gave up, thinking that if I ran for it I could just get back to the train before they realised I was gone :)

Luckily I still had the install disks for 10.1.3.2 and I borrowed someones laptop with XP on. I Installed the system and fired up OBI EE with 30 seconds to spare.

The presentatin went ahead without any problems.

Phew!

PS

Why Bother?

My next rant will be about Networking, Client Credit, Being in business, and Project Managment. Watch this space.

Happy New Year? ummm, we'll see.

2008-01-14T15:12:00.000Z

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 in an OBIEE report. The issue is where? Has anyone had a go at this?

I saw this the other day from Ahmad Alkhmous

Restricting the Number of Rows returned in a request:-
Click on the filter icon on any column in answers
Click on Advanced-> Convert filter to SQL
Write "Rcount(1)< N" ... N is the number of rows you want to see

Whats this then?
http://www.oracle.com/technology/oramag/oracle/05-mar/o25xmlex.html

Not OBIEE but could help

Top 10 keyboard Shortcuts in Windows
CTRL N.................New window
CTRL Z.................Undo
CTRL Y.................Redo
ALT F4.................Close current application (if all are closed, will present shut down options)
WINDOWS D..............Show desktop (also WINDOWS M = minimise all)
CTRL A.................Select all
CTRL F.................Find
CTRL C.................Copy
CTRL V.................Paste
ALT TAB................Switch between windows
and a bonus one..
SHIFT F3...............(Word only) Toggle selected text between caps and lower case

A bit of fun..
I love this paper plane throwing game. Enjoy! http://flightsimx.archive.amnesia.com.au/

Want to keep the kids amused?

Word Searches
http://puzzlemaker.school.discovery.com/WordSearchSetupForm.html

If a vegetarian eats vegetables, what does a humanitarian eat?

Adrian

"Living in America"

2007-12-20T16:07:00.000Z

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.

2007-12-20T16:00:00.000Z

I recently commented that Finance departments can start considering how OBIEE can replace/ compliment their MS Access systems. In response to a question on this I replied with the following:

"A little background - I have been implementing MS Access systems for 10 years, and I think they are great. The speed to deliver, the power of the analysis, the very useful VBA make a great product for Finance departments. I came across OBIEE (in previous forms) 5 years ago and found that it solved the big problem of Access databases being restricted to a local team. Using them across the world was very difficult. We needed to report in Australia and USA using European data.

OBIEE can be very quick to develop in (if your IT and project team will let you) you can create reports based upon a standard definitions (i.e. measures created in the rpd), and you do not have to extract massive volumes out of one database to be able to combine with another - we had to put CRM data next to HR data, next to Finance data.

Any good product can be badly implemented, and IT departments can hold you back from doing the quick data analysis you need to do for your job, so using Access gives you freedom to develop what you want when you want - YOU are in control. Treat OBIEE in the same way. Get the IT dept to set up the infrastructure, YOU control the rpd and the reporting.

Best of all - you can put OBIEE on top of Access - best of both worlds."

Quiet Christmas

2007-12-12T14:02:00.000Z

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 details on.

You may have noticed me being busy on LinkedIn recently. I have managed to build a good network of OBIEE consultants, and even started a group specifically for Oracle Business Intelligence consultants. This should benefit us all when it comes to project requirements.
Go to http://www.linkedin.com/e/gis/43109/526A0219C124 and I'll add you in (I only add in OBI consultants and related workers).

I have also been busy on the Oracle OBIEE forum, reading the issues that people have. It annoys me when someone clearly hasn't read the manual or even tried to find the answer to something before posting a request.

Each day I always check out Venkats postings on his blog. He has a great job - he just gets to play with OBIEE all day and write about the new stuff.

Talking of new stuff, the new functionality in 10.1.3.3.xyz, which allows you to call Oracle functions will be a greta boost for the product. Up until now I have seriously wondered by you need a BLOB in an Analytics but now we get to put pictures from a database in you reports.

I was sceptical about the time series functions, particularly as they were causing some people problems, but I have now converted over completely and so far so good. Let me know what you think.

Have you noticed that when you use the functions editor you now get something more useful when you add the function - it actually now tells you what arguments it requires instead of <>. I tended to copy the contents of the edit box into TextPad but may start using the editor more now.

I notice there are more and more companies that are offering OBIEE and Siebel Analytics consultancy. Those of us that were using the product over 4 years ago are seeing others trying to muscle in. All I can say is How much do you really know?? There are so many stories at conference from clients that say their implementation failed due to the integrator not having the right skills. We ALL need to make sure the product is not undermined by consultants who frankly do not have a clue. If you are in a pitch to a client sell your real experience and don't let beginners run your project.

I am still building the OBIEE information website, if you would like to have a listing just let me know.

That's all for now Folks!

Trimming

2007-12-06T16:41:00.000Z

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 a report with :

DimA Top Level Fact 1.
ABC 123

and the true value of DimA is 'ABC ' - note the space
The value displayed in the report is ABC, clicking on the value will start the drill down, using a filter of 'WHERE DIMA = ABC'
Of course NO data is returned.

The solution is to either make sure none of the data has trailing spaces or add the TRIM function. TRIM ( BOTH ' ' FROM DIMA) will do the trick.

TO_CHAR

I noticed this first when using the TO_CHAR function.If you to_char a date into month name (usually using OBIEE Function MONTHNAME) then the answer you get back is always 9 characters, which means AUGUST has three trailing spaces.You therefore have to trim the answer.

Hide

2007-11-29T20:39:00.000Z

Airport lounge again.

Why do people think that business travel is glamorous?

ANYway, I'm bored enough to finally figure out how people are hiding their contacts in LinkedIn. There is a setting you can change in the profile, but I'll let you find out how.

The big question is why you would hide your contacts.

The whole point of LinkedIn is to NETWORK, make contact with people in your business area and share information, ideas, recruit, learn.

I suspect it the recruit thing that puts people off. I do know that recruitment agencies will use the system to their advantage, but surely it is to your advantage too - you get to find out about roles.

Anyway, feel free to browse through my contacts, and if you see someone you may need - a fellow OBIEE consultant maybe - then get in touch with them.

Complete Blogger

2007-11-28T06:46:00.000Z

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 will work on some issues with OBIEE 10.1.3.3.

There.
done it.

I am now a complete blogger !!!

New LinkedIn Group

2007-11-26T12:06:00.000Z

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 (such as OWB).

http://www.linkedin.com/e/gis/43109/526A0219C124

OBI EE Consultants Needed

2007-11-23T10:08:00.000Z

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 in touch.

Remembrance Day petition

2007-11-19T16:42:00.000Z

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, their lives for Britain.
To remind people of the importance of protecting our Nation and what it stands for.
To break that 3 month period between the August Public Holiday and Christmas when there are currently no long weekends, especially as the UK has fewer public holidays than most European Countries.

If you are in agreement, please sign up to the petition
- it only takes a few moments - and it would be great if you were minded to forward the link to other people as well.

Thank you for your time.

Using Catalog Manager

2007-11-07T15:57:00.000Z

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 loads of pages on various dashboards and the Business Analyst comes along and says, 'oh I forgot to say we need a confidentiallity clause at the bottom of each page' you smile through gritted teeth and are faced with a large task of opening each page and editing the print formatting. If you have lots of formats to make this can take some time. The alternative is to dig into the Catalog manager and edit the xml for each page directly. This takes half the time to go through each page. Open the Catalog Manager and navigate to the _portals folder.

Now select the properties for the page (make sure you don't pick the dashboard layout).

Edit the page xml.

The trick here is not to write your own xml!! Copy the xml from one you set up manually in the dashboard editor.

Here I copied in a message about the system being restricted and a nice green message!

The tag added is saw:pageProps

notice saw:pageHeader show="false" / and saw:showFooter showondashboard="true" show="true"

simple really.

UI Messages

2007-11-07T10:45:00.000Z

The most popular customisation for OBIEE is the colour scheme, which you will know is done by Skin/Schema.
This is great but you then come to change the wording and it is not done by skin/schema.
You can update the file uimessages.xml to change the links on the menu, so for example Dashboards could be replaced with 'Sailing' and the link can be changed (in the controlmessages.xml file), but this covers all skins being presented. On of the forum responses recently suggested that the javascript can be altered on a skin by skin basis but I can't find any reference to the messages being presented. I'll keep looking but if you know send a quick reply :)

The normal method for updating messages is to create an entry in your custom messages file, but htis requires you to know which message table the message relates to. This would be fine but this area is not fully documented (in the public domain at least:).

I'll experiment and let you know if I can find the relevent massage table setting to use. In the meantime this type of message customisation has to take place in the original files (which you hopfully have a backup of!)

New Version of OBIEE

2007-10-24T09:25:00.000Z

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!

Ex-Oracle

2007-10-17T07:21:00.000Z

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

Act as

2007-10-16T12:43:00.000Z

Nicholas De Brabanter has a good article on this.

http://www.be-ice.eu/2007/10/04/how-enabling-and-configuring-the-obiee-proxy-act-as-functionality

2007-10-16T10:55:00.000Z

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.

Foreign Travel

2007-10-04T14:08:00.000Z

So lets recap....

Ireland - Two OBI/Analytics required
Amsterdam - One senior OBIEE
Midlands - One OBIEE expert
France - 2 month contract for Siebel Analytics
London - 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 can handle, but rates are still tight. If you fancy trying out contracting then get in touch and I'll point you in the right direction

- Adrian
adrian.ward@majendi.com

Sign up for the Arrows

2007-10-03T09:22:00.000Z

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 Arrows pilots were said to be "outraged", as they had hoped to put on a truly world class display for the Games, something which had never been seen before. Being axed from a British-based event for being "too British" is an insult - the Arrows are a symbol of Britain .

The Red Arrows have been excellent ambassadors for British overseas trade, as they display their British-built Hawk aircraft all over the world.

The Arrows performed a short flypast in 2005 when the winning bid was announced, but their flypast at the Games was to have been truly spectacular.

It is to be hoped that common sense prevails"

If you disagree with this decision, sign the petition on the link
http://petitions.pm.gov.uk/RedArrows2012/?ref=redArrows2012

Amsterdam anyone?

2007-09-25T15:51:00.000Z

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.

Role of Honour

2007-09-19T07:47:00.000Z

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 be included just let me know, and send me a profile. If there is anything you specifically want to have included, let me know. If you want, I'll put a link on your profile, so people can make direct contact (via LinkedIn, Xing, facebook, etc).

I don't think I can put it on a page here (can I?) so may hvae to host it on Majendi.com or majendi.net.

Supply and Demand

2007-09-12T12:09:00.000Z

Spain just called
so did Switzerland
and Sweden
London too (twice)
oh, so did Amsterdam
and of Course there's Munich
not forgetting Wiltshire

There's lot's of work out there

And there's not that many OBI / Siebel Analytics specialists either. A few are catching up, but I know of about 5 truely experienced consultants in the market.

So why, oh why do companies think they can get someone who is skilled for 800 Euros per day??? If you have the skills it's because you have invested in a risky market (come on Oracle SELL MORE), and you have some intelligence.
I am actually beginning to think that companies prefer a cheap rubbish job. Come on prove me wrong.

If you are a consultant. Don't take a low rate, don't let the agency take a huge cut and do Learn the product inside out. The success of OBIEE depends upon succesful implmentations.

If you are a company (or consultancy) looking for someone, let me know and I'll put you in touch with good consultants. I'm not an agency but I can probably give you some good advice and screen out the bluffers.

I know most of the companies that are installing OBIEE so if you are looking for your next contract, let me know and I'll put you in touch with project managers.

In fact, I think I'll put the details of projects in my BizIntel yahoo group. Come on, lets get this market working properly.

and the bad news...
We just had a second rejection for a Work Permit application to bring in a skilled worker from South Africa. Seems the government is happy for our work to disappear offshore, and let the skills shortage in the UK continue to hold back small copanies like ours.

If you know how I can get hold of more decent staff I would love to know!!

Is there a way to get people legally working in this country? How does IBM, Accenture and the offshore copanies do it?

or

Does anyone have any idea how some people are able to buy HSMP tickets?!!!

Cluster ....

2007-08-24T15:01:00.000Z

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 the new Webcat.

Previously, each Webcat server (BI Presentation server) had it's own copy of the webcat file, held within the Data folder.
If you had two or more webcat servers they would syncronise the contents of the webcat using a utility - something that did not work very well.

Now you have one webcat, irrespective of how many web servers you use. They all point to the same webcat.
This neatly solves the problems you get with Syncoronisation, but introduces one significant flaw - a Single Point of Failure.

What do you do? Put your webcat on a SAN, which has all the RAID you can get. Back up the whole webcat folder every night - obviously!
Now take snapshots of the webcat throughout the day, but be very careful how many you take. Too many will slow the system down.

One thing I have always felt though is that you should cluster for Customers' High Availability requirements NOT for performance.

The majority of performance issues should be dealt with by database design, prudent Caching (with seeding), adequate memory, and ETL design. Only when these have been worked through should you look for that extra 5% from clustered servers.

Long live the King

2007-08-18T08:09:00.000Z

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 OIM (OID), managed by the Apex aplplication.
SSO uses OID to authenticate users.
Links on the portal, to your dashboards and Answer subject areas.
ETL by OWB
Database design by YOU, customise as you like.

Is the grass greener, oh yes.

Of course, Elvis is still the real King

Mad Cowes

2007-08-10T08:02:00.000Z

All quiet here due to me being on holiday.

We're having a fantastic week in Cowes.

Best of all we are leading the fleet going into the last day.

Overall Results

Help!

2007-07-11T23:11:00.001Z

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 get in touch. Now.

We need all levels, experts who want to contract through to juniors with one project who want to work as a permanent in the UK. (Work permits can be arranged).

Hardly enough time to work on the book. But don't worry it is progressing.

By the way, do you know how how the get totals working in a report that has TopN (or BottomN) in? Just go to the function dialogue for the field and set Totals to 'None'

adrian.ward@majendi.com

Catching up

2007-07-05T23:00:00.000Z

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 a Presentation Variable. Like repository based variables but it is created in the BI Presentation system.

Bascially you set it up from a prompt. Once set it can be used all over the place, but my favorite is the Title of a prompted report, or column of a prompted report.

Try this

On the prompt, set a variable, which can then be accessed in the Title of the report.
For example, if you select a County of 'Wiltshire in a prompt, you set a variable name called VAR_COUNTY,
then in the Title you can display 'Details for Wiltshire' by changing the title to: Details for @{VAR_COUNTY}{All Counties}.

Neat eh?

In the good old days (last year!) we had to rely heavily on False Titles to perform the above. These may still be useful today. These use Narratives in reports to create what loks like a title. The report uses the same dashboard prompt as the report it is presented with. Using the @1 syntax you can present the value in the column, the there have a title which says something like 'Sheep in Wiltshire'. Formatted properly it will look like a title. Place it above the query in the same section. Viola.
Now I just tend to use the Section names as the titles.

I started using some Oracle dev tools this week, and I'm actually beginning to like them. Call me fickle but I have to say that I may be throwing out TOAD and starting to use Oracle SQL Developer instead. The main reason is that it is free!!

Having a quick look through my emails the other day I came across this message.

Someone asked the following question

Hi,
We have a requirement to switch between the DBs based on the user login. We have two identical/similar dbs. But based on the users, the connection should switch.
Ex: user1 should see the data fram DB1 and user2 should see the data from DB2. Our plan is to keep a single stream of Physical, BMM ,Presentation catalogs and Webcat. Is this possible through Session variables. If yes, how?

Puna replied with this excellent answer

1) Create a table "db_details" in any db with the following details:
Login_Name dbname dblogin dbpassword

2) Populate this table as per your requirements. Create a connection pool in Physical layer which connects to this table (via database)

3) Create three Non-System Session Variables: dbname,dblogin,dbpassword. Create an initialization block with the following SQL Query:
select dbname,dbuser,dbpassword from db_details where Login_Name=':User' and polplute the the above created variables.
Set the connection pool of the initialization block which was created in step 2.

4) Now for the connection pool for which dynamicity is required as per the logged in user, in connection pool of that database in physical layer set the the following properties to:
Data Source Name: VALUEOF(NQ_SESSION.dbname)
User Name: VALUEOF(NQ_SESSION.dbuser)
Password:VALUEOF(NQ_SESSION.dbpassword)

Make sure if you are using ODBC or DSN's then DSN's with the name "VALUEOF(NQ_SESSION.dbname)" already exist in the system.
So now you will be able to switch DB's based on the Login_Name.
Hope this helps.

Nice one Puna.

If you read this (or know them) please send me your details and I'll invite you to our OBI Developers Forum.

Urgent Requirement

2007-06-29T08:22:00.000Z

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 please don't try bluffing me!

For the right candidate we'll pay £550 per day initially, rising to £600 after three months.

Start in mid July

If you know anyone who may be interested please get in touch.

Adrian
07801 480900
adrian.ward@majendi.com

SE One is here

2007-06-29T08:16:00.000Z

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 departments should take a really good look at replacing their Access Databases with this.

You'd think I had shares in Oracle (I Don't)!

http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci1262237,00.html

Freedom of the City

2007-06-27T18:01:00.000Z

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.

Interesting Note from Oracle

2007-06-25T21:21:00.001Z

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 keys by any fact tables. Therefore the general tables do not participate in the star schema. They are not designed for use in reports and queries.

The general tables are intended for use as lookups during Extract-Transform-Load (ETL). For example, the Standard Cost General table provides cost information for a particular product in a particular inventory. The cost information will then be stored in the fact table directly. Similarly, the Exchange Rate General table provides the exchange rate between a pair of currencies for a specific day, given the exchange rate type.

The following are some WIDs in the general tables. They are not necessarily populated and they are not intended for use. These columns are:

W_STANDARD_COST_G.PRODUCT_WID
W_STANDARD_COST_G.CREATED_BY_WID
W_STANDARD_COST_G.CHANGED_BY_WID
W_EXCH_RATE_G.CREATED_BY_WID
W_EXCH_RATE_G.CHANGED_BY_WID

If you need to have a cost dimension, you need to design a different table. It is not recommended that you alter the Standard Cost General table for this purpose. "

Professional Indemnity Schedule

2007-06-21T08:38:00.000Z

Just so I can point people to the evidence, here is our insurance certificate.

Professional Indemnity Schedule

Oracle Warehouse Builder Documentation

2007-06-19T17:06:00.000Z

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

A typical question

2007-06-15T08:33:00.000Z

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. W_SALES_PICK_LINE_F, which we need/wish to extend. We are not sure about which methodology we should implement.
When we talked with few SA experts they mentioned we need to extend based on ROW_WID. Well, this column doesn't exists anymore in many fact tables, so currently we are thinking of creating ROW_WID on this F table manually and then create WC_SALES_PICK_LINE_FX and take these two tables in physical layer of RPD.

Additially, we need to create few Informatica mappings, again SA experts pointed out to use Image tables. Our data source is Oracle Applications, I don't have much idea about Image tables, but clearly there is not S_ETL_I_IMGAGe or so tables in Oracle Apps

Please guide us as how to proceed on these two issues.

Thanks in advance

and my answer

I am surprised to hear that ROW_WID has been removed from standard vanilla tables. I don't think your system will work without the ROW_WID field. Add the field back in quick! :)

My advice is to extend an existing table, not to create _FX tables. Providing you keep good control on your alter table scripts there are no issues with extending vanilla tables.

Take a copy of the vanilla mappings and customise these in your custom mappings folders. Do not update the vanilla mappings in place - they will be over written in an upgrade.

You can create your own image tables in the oracle db. The alternative is to use a last modified field in the table being imported.

You only need to create immage tables where there is lots of data, typically more than one million rows

Please can you send me more details on the project. It's good to understand where you are coming from, if you send me your rpd I can provide some feedback

Adrian
-------------------------------------------------------
Mobile: 07801 480900

Analytics Projects - Who wants one?

2007-06-14T21:07:00.000Z

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 he worked on it before. It's a small world, and Siebel Analytics has a relatively small client base (my wild guess is 400-500 UK clients, half of which are active).
I know about 75 Analytics consultants. There are probably another 100 out there, perm employees, that may one day become freelance and pop up in the Majendi radar.

At the moment the Agencies have a good control on the Market. There are some that put out adverts for non existant jobs. They are useful to the liquidity of the market and some work hard for their cut of you pay. Just be careful they are not taking too much, the best ones have a fixed percentage with their clients. More than 15% is excessive.

So how do we help consultants? We probably should look at the networking capabilty that's out there, linkedIn, Xing, ecademy, Yahoo, etc, and perhaps set-up an OBIEE/Analytics forum. There we could share thoughts on prices to charge, new projects, help needed, technical stuff, etc. I have started one group on Yahoo, if you fancy joining in, let me know - it's invite only. I'm not sure if this helps the clients though.

Any thoughts?

On the subject of rate. You are what you charge. If you charge a cheap rate, your will be percieved as local quality, if you charge a premium rate you should deliver a premium level of service.
What are those rates? My view is that a certified consultant with 2 years (min 3 projects) Analytics consultant should be charging a minimum of 600 GBP per day. Lead consultants, with 7+ project should be GBP 750 per day. The consultancies will obviously need to charge clients a higher level. Some of the cheaper ones are charging 6-700 euro per day, the better ones, with good experience and efficient work, will be charging 900 plus.
One client I saw recently had a greatdeal with a low cost provider, the problem was they didn;t trust the work, and the estimate for time was nearly double what was really required. The client ends up paying nearly the same for inferior work. Somehow we need to educate that quality is very important to them, not cheapness.