Archive for the ‘Tips & Tricks’ Category

Business Objects auditing

March 11th, 2010

Business Objects Enterprise includes auditing functionality that allows you to verify if reports and user management are appropriate, are efficient,

and are adequately controlled to ensure valid, reliable, timely, and secure input, processing, and output at all levels of a system’s activity.


What’s in it for me?

  • A controlled environment in which it’s clear which users and user groups use objects and reports.
  • Root cause analysis to easily relate the disruption of a service to changes and users.
  • Which reports are used and which reports are ‘dead’.
  • It enables efficient license usage. Why pay for want you do not use?

The audit should answer the following questions:

  1. Who is using your reporting solution?
  2. Which groups use your reporting solution the most?
  3. Which objects they are accessing?
  4. Which reports are they using?
  5. How many user licenses are we using at any given time?

You can audit the actions of individual users of Business Objects Enterprise as they log in and out of the system, access data, or create file-based events. You can also monitor system actions like the success or failure of scheduled objects. For each action, Business Objects Enterprise records the time of the action, the name and user group of the user who initiated the action, the server where it was performed, and a variety of other parameters available in the documentation with Business Objects.

The auditable actions I like the most are:

  • Track when Objects are created, deleted of modified;
  • Track when reports are opened, saved, refreshed, created, modified and deleted;
  • Job monitoring and failure;
  • Changes and history in login behaviour of users and groups;
  • Monitoring of license usage.

A post last year on the Chennai Bi blog gives some useful guidelines on how to implement auditing: http://chennaibi.wordpress.com/2009/04/07/business-objects-auditing-in-xir3/

Martijn

Tip: how to change the default color palette for graphs and charts in BusinessObjects XI?

March 3rd, 2010

Have you ever wondered, just like me, how you could change the default color palette that is used for graphs and charts in BusinessObjects XI?

Here’s how! The color definitions of the (first) palette are located in a file called ‘defaultConfig.xml’ located in one of the 16(!) folders that contain that file under the BusinessObjects home directory:

For the Web Intelligence Rich client this file is located under:
%BusinessObjectsHome%\BusinessObjects Enterprise 12.0\classes\AppletConfig

For the http Web Intelligence client this file is located under:
%BusinessObjectsHome%\Tomcat55\webapps\AnalyticalReporting\webiApplet\AppletConfig

Search for the following string in the file and that’s were you will have to change things:
<!– Palette used by graph –>

Next task on my ToDo list is to come up with a good set of colors to use in the palette so if you have any suggestions let me know!

David

Around the interwebs: self-service BI

January 13th, 2010

“Self-service BI” is a bit of a watchword these days, and certainly one that we’ve been taking a long hard look at from a marketing standpoint because it describes pretty neatly what SMI Suite is and does, and draws a nice dividing line that separates out the sort of BI that requires written reports in triplicate and fifteen different meetings with the “BI specialists” before you can get your hands on a simple report.

So it was with much interest that I read James Kobielus’ piece on Self-Service Business Intelligence: Dissolving the Barriers to Creative Decision-Support Solutions.

The whole piece is of interest, but the first paragraph struck a resounding note:

Self-service is all the rage in the world of business intelligence (BI), but it’s no fad. In fact, it’s the only way to make BI more pervasive, delivering insights into every decision—important or mundane—that drives your business. It’s the key to empowering users with actionable insights while removing many mundane BI development and maintenance tasks from IT’s crushing workload.

I think we probably need to hire James to sell SMI Suite for us, because what he’s talking about is exactly the same thing we’ve been banging on about for years: operational BI is not (or, at least, should not) be about the same dry reports run week in, week out. It should be about spotting a trend, or spike, or glitch in a particular report and then immediately running off to run a slightly different report that zeros in on that one particular detail. And then spotting a spike in that report and starting the whole process again. It should be about exploring the complexity of the data and about the data inspiring you to want to understand more about where it comes from and what it means. That’s the key to BI being a truly effective tool for saving money, working more efficiently, improving customer satisfaction and all the other things that we all strive to do every single day.

And as James so succinctly points out, self-service is at the heart of that concept.

Tom

Around the interwebs: IT Skeptic Awards 2009

January 6th, 2010

it_skeptic_3I’ve mentioned the IT Skeptic blog previously on Westblog, but the Skeptic has given you the perfect excuse to go reacquaint yourself: the very inventive 2009 awards.

Who wins is completely secondary to the energy put into the names for the awards. A few highlights include:

  • The Trump Medal for Most Inappropriate Empire Building
  • The Deng Xiao Peng Memorial Spittoon for Services to Democracy
  • The Marie Antoinette Memorial Cake for Most Patronising Attitude

Head over to http://www.itskeptic.org/it-skeptic-awards-2009 for the full list.

Tom

Business Objects tips

December 14th, 2009

One from around the interwebs for you today:

BOtipshttp://www.businessobjectstips.com/tips/

There are a bunch of different tips useful for those navigating around Business Objects. There’s also a blog, which I’ll be adding to the list of other blogs we like.

Personally, whenever I’m confronted with a new technology and I’m trying to get my head around it, there is nothing more valuable than advice from someone else who has been in your position and had to try to figure stuff out. With the best will in the world, vendor user guides, by their very nature, are broad-ranging and general, whereas user generated content can – and generally does – focus on the issues that crop up commonly and deal with them in greater detail.
So the question remains: which of you is going to set up smisuitetips.com?

Tom

Other blogs that we like: updated

November 12th, 2009

Happy is the clam that gets to spend all day surfing the internet looking for interesting stuff. Sadly most of my working week involves actual work, but I do get to spend some time hunting out other blogs that cover similar ground to this one. So I figured it was probably worth adding a post listing these out, and adding new ones as I go along.

So this list is very much a work in progress and I’ll be adding more sites as I come across them. If you write a blog about ITSM, change management, HP, etc, then please let me know and I’ll take a look.

The list:

Leading at Lightspeed by Eric Douglas -  Executive Business Coaching
Mainly business coaching stuff, but with an interesting section on change management with some interesting things to say

The Business Intelligence Blog by BI Guru
As referenced in another recent post, Maloy has some really interesting things to say about practical use of Business Objects.

The IT Skeptic
Reads a bit like the people so gloriously sent up over at Speak Your Branes (a personal and perennial favorite of mine) but actually has some interesting things to say.

Business Objects Tips
This is the blog section of the Business Objects Tips site. It’s slightly self-promoting (something we’re never guilty of, natch) but there are some nuggets of interest in there as well.

Tom

f78f1ehttp://blog.leadingresources.com/category/change-management

SaaS and ITSM and eccles cakes

November 6th, 2009

I hate to dispel the myth that writing for Westblog is nothing but being fed eccles cakes by scantily-clad Revs girls, but what with the economy and all, those days of hedonistic abandon are long gone, and, actually, writing these posts can sometimes feel like a bit of a chore.

Eccles-cakesSo happy is clam who discovers that someone else has written a really interesting piece on another blog, all about SaaS and ITSM, that can be brazenly hijacked and plagiarized for the purposes of Westblog… um… that provokes interesting thoughts about the things it mentions.

SaaS 3.0 and ITSM, Match Made in Heaven!!, is the piece, found over on Service Sphere’s blog. Aside from the Guinness World Record™ for longest blog entry in history (seriously, I’ve read Salman Rushdie novels in less time), the piece is notable for the fact that it takes a long hard look at SaaS – the topic on everyone’s lips, seemingly – but only from the ITSM standpoint, which itself raises some interesting questions. After all, is the fact that we sat up and took notice of this piece an indication that other ongoing and general discussions about SaaS seem a little disconnected from ITSM? Is that because yes, of course it’s easy to see why it makes sense to have your word processing app or whatever in the cloud, but ITSM software is not the same beast as MS Word?

After all, you can send your mother a CD (or is DVD these days?) of the Office suite and reasonably expect her to be able to install it herself, with maybe only one or two panicked phonecalls about having read the entire user agreement but not quite understood all the technical terms. The same is patently not true for Service Manager 7. My preconception – and in this I may be completely wrong (it has been known, just ask my wife) – is that any software that requires significant deployment or installation assistance, will require it no matter what the delivery method of the software. And if that is the case, is that reliance on specific personalization at odds with what we think of as the SaaS model?

Well, I’m not the person to ask, because I don’t know enough to be able to present a cogent argument. If only there was some sort of link to someone else’s blog covering this very topic…

Tom

PS Does anyone else reallllllly want an eccles cake now, or is it just me?

Paul Wilkinson guest blog part four: buzzword of the year – holistic

October 29th, 2009

paul-rectA fool with a tool is still a fool.

More than 10 years has passed since GamingWorks first published their book IT Service Management From Hell: A Guide to Worst Practices. 10 years later there still appear to be too many fools in IT. In this series of four guest blogs, IT Service Management from Hell co-author Paul Wilkinson will be looking at the reasons and giving some best practice advice for solving this ongoing problem.

Find part one of the series here, part two here and part three here.

In the previous three blogs we have examined the continuing lack of business and IT alignment, exploring how worst practices in ABC (Attitude, Behavior and Culture) underpin our lack of alignment as well as the way in which we adopt and deploy the frameworks such as ITIL. We stressed the need to ensure that attitudes are changed so that everybody understands the value they must deliver to the business and that we must translate the value propositions into all our initiatives. In this final blog we examine how our approach to applying people, Product, Process and Partner needs improving.

The second aspect of the four ‘P’s that can be improved upon?7diamondscardjpeg-s

2. The  ‘holistic’ approach.

Last year ‘leverage’ was the hot buzzword used by consultants. This year it seems to be ‘holistic’. So if we say we need to leverage a holistic approach then we must really be top notch consultants. It is the failure to adopt a really integrated or holistic approach that causes many initiatives to fail.  This stems from the different levels of ‘maturity’ of IT organizations. Some leap onto the ‘PROCESS’ bandwagon, adopt a framework like ITIL, produce process flows and procedures and ‘throw them over the wall and hope that people will follow them’. Other organizations are so technology focused they throw a tool at the problem. Creating the situation of ‘a fool with a tool is still a fool’. The most common approach to addressing the ‘People’ side is simply to send people en masse to ITIL training, assuming that when they return they will be able to magically ‘do’ ITIL.

This point is partly proven by the fact that the ABC of ICT survey revealed “throwing solutions over the wall and hoping people will adopt them” scores number five in the top ten worst practices. This applies to both the ‘Process’ focus, and to the ‘Product’ or tool focus. The largest common failing in applying the four ‘P’s is too little effort and energy on the most important P – People. Says who? Successful ITSM improvement initiatives are all about changing the behavior of people. People don’t like to change. Indeed another Forrester report revealed that 52% of these types of initiatives fail because of resistance. In our mind it is ABC that is the fundamental success or fail factor for tool focused or process focused initiatives.

This point is proved by the results of a survey into the key success factors from 1000 students having participated in an ITSM simulation. The biggest single success factor was ‘people’ scoring 44%. (In the ITSM simulation teams had to translate a set of business demands into the four ‘P’s and demonstrate that they could deliver the performance demanded by the business).

apollo13

Now you have read all four blogs you can test whether your ITSM improvement initiative will close the ever widening gap between business and IT.

  1. Ask a selection of your IT employees to tell you what a service is according to ITIL.
    ‘a service is a means of delivering value to the business in terms of outcomes the customers want to achieve without the ownership of specific costs and risks’. Ask them ‘What VALUE and OUTCOMES does the business demand and expect from ITIL?
  2. Go and look at the project plans and proposals for all tool, process and training programs or any partner agreements and sourcing initiatives and look for the business case. Is there a section related to the value and outcomes these initiatives must achieve?
  3. Look at your ITSM improvement initiatives. Is there a balance in the amount of effort between the four ‘P’s? Is there a significant investment in ‘People’? Ensuring the ABC worst practices described in the previous blogs have and will be addressed? And that initiatives are taken to ensure that this will not be one of the 52% of initiatives that fail due to resistance?
  4. If the answers to these tests are negative you now have to ask yourself the question “what AM I going to do about it?” Remember one of the top three ABC worst practices is “not my responsibility”. If you do nothing about it who else will? I’ll see you in 10 years time. My presentation slides are already made.

Paul

Paul Wilkinson guest blog part three: making value happen

October 23rd, 2009

paul-rectA fool with a tool is still a fool.

More than 10 years has passed since GamingWorks first published their book IT Service Management From Hell: A Guide to Worst Practices. 10 years later there still appear to be too many fools in IT. In this series of four guest blogs, IT Service Management from Hell co-author Paul Wilkinson will be looking at the reasons and giving some best practice advice for solving this ongoing problem.

Find part one of the series here, and part two here.

In our first two blogs we explored the ever increasing gap between business and IT and how Attitude, Behavior and Culture (ABC of ICT) are the key reasons we have failed to successfully adopt and deploy frameworks to solve the problem. We mentioned that more than 70% of IT organizations are unable to measure and demonstrate value using frameworks and tools. In blog two we said the first step is to firmly embed into the mindset of every member of IT the concept of a service according to ITIL v3. A Service is “a means of delivering value to the business in terms of outcomes the business wants to achieve without the ownership of specific costs and risks

So where does the problem lie in how we adopt and deploy the frameworks? Once again I’ll use ITIL v3 because it is a good starting point and reference as to what we are doing wrong and what needs improving.  According to Service Design improvement initiatives should be based around the four ‘P’s: People, Product, Process, Partner. If we examine most of the improvement programs and initiatives we can map them onto this. However there are two aspects about the four ‘P’s  that can be improved upon.

  1. The 5th P – “Performance” – should be added to the model. Performance, or Value in ITIL v3 terms should be ‘leading’ in the design of service management improvement initiatives. See the diagram. Before you design and implement processes, adopt and deploy management technology, send people on training or engage partners you should ask the question ‘Why? What value? and/or how will this reduce costs and risks’.

Five 'P's

As we mentioned in blog two, this point is proven by the fact that when we did an ABC of ICT survey with more than a thousand IT professionals the number one IT worst practice they selected in the workshop was “no understanding of business impact and priority” and number three was “IT is too internally focused.” If we do not understand the business needs then how can we hope to realize value? The fact that we are still too internally focused explains to me one of the reasons we keep presenting the same worst practices every ten years.

qspadescardjpeg-sThe second reason being that one of the top three chosen worst practices by more than a thousand IT professionals is “not my responsibility”. Nobody apparently feels responsible or accountable for breaking through the problems, hence the fact that business & IT alignment seems to be a constantly recurring theme and the reason we keep giving the same worst practice presentations every ten years! When we do decide to make a project proposal for implementing tools or ITIL is it any wonder that many of the projects in these difficult financial times gets cancelled. The number ten in the list of ABC worst practices – “IT thinks it doesn’t need to understand the business to make a business case.”

So that is one aspect of the four ‘P’s that can be improved upon. Ensure that the ‘Performance’ or ‘value’ underpins all of our initiatives. We must be able to demonstrate the value and the outcomes the business needs when we apply the four ‘P’s. What is the second aspect of the four ‘P’s that can be improved upon to ensure lasting, sustainable success?

Paul

Paul Wilkinson guest blog part two: taking the first step in closing the gap

October 14th, 2009

paul-rectA fool with a tool is still a fool.

More than 10 years has passed since GamingWorks first published their book IT Service Management From Hell: A Guide to Worst Practices. 10 years later there still appear to be too many fools in IT. In this series of four guest blogs, IT Service Management from Hell co-author Paul Wilkinson will be looking at the reasons and giving some best practice advice for solving this ongoing problem.

Find part 1 of the series here.

In our first blog we discussed the fact that the gap between business and IT seems to be growing and despite all the best practice frameworks we are not bringing IT under control. The first blog declared that the reasons were not the frameworks but the ABC of ICT. Attitide, Behavior and Culture within IT.

This second blog is entitled: Taking the first step in closing the gap.

Lau Tzu the great Chinese philosopher made a quote that very roughly translated goes “A journey of 1000 miles begins with the first step”. This is sound advice for those of us embarking upon our long, tiring, sometimes painful, journey with ITIL in an effort to bring IT under control and close the business and IT alignment gap.

ITIL v3 is the latest of the frameworks that claims to help address the alignment issues we mentioned  and help IT organizations finally gain control, so I will use this as a starting point to show why ABC (Attitude, Behavior and Culture) is still a problem and what we should be doing to finally resolve it.

qclubscardjpeg-sWell first of all let’s look at what ITIL v3 says about a Service. This to me is crucial. If IT people could grasp, embrace and fully understand this concept we’d have the gap closed in no time. A Service, according to ITIL V3,  is “a means of delivering value to the business in terms of outcomes the business wants to achieve without the ownership of specific costs and risks”. If every single IT person could ask themselves the question ‘how does this activity contribute to business value’ or ‘how does my current behavior cause unnecessary business costs and create business risks’, we’d be a long way onto solving business and IT alignment.  This is the crucial first step changing people’s attitude about what it is they do and why they are doing it? We can’t possibly be aligned when most people in IT don’t understand the business needs. Don’t believe me? In a series of global ABC workshops with more than 1000 IT professionals the number 1 chosen ABC ‘worst practice’ was “no understanding of business impact and priority”. We in IT do not know or understand business priorities.

Changing attitude is the first step. But what about now embedding this into ‘Behavior’. Actually make it happen. This is where the tools and frameworks come in. Adopting and implementing process based working is all about introducing new ways of working. New ways of behaving. The way in which we currently adopt and deploy the frameworks and tools is also one of the key fail factors as to why we are still failing. 70% of IT organizations are unable to demonstrate the value gained by implementing these types of improvements.

So where are we going wrong in our adoption of frameworks? And how can we ensure that we can adopt and deploy them successfully? In the next blog we will tell you how.

Paul