Setup security in BusinessObjects XI 3.1

This article:

Is about setting up security in the Central Management Console (CMC)

Is best used in combination with a demo environment of BO XI 3.1

Is intended for BOBJ system administrators

Expects you to know basic browser functions. Security model knowledge is an advantage

Aims to enable you to perform security related administrative tasks in the CMC

Continue reading

NemisFs: BI for SAP ERP

During the previous year, and last months in particular, I have been working on NemisFs. Hereby a piece of text in dutch which I wrote for our corporate website.

Heeft u ook behoefte aan een flexibele oplossing, die binnen één week de voornaamste bedrijfsperspectieven op een standaard wijze verwerkt en presenteert? Het is mogelijk met NemisFs: Het eerste volledige dataplatform voor SAP ERP. De informatie kan worden geanalyseerd en verspreid met generieke Business Intelligence tools van software leveranciers zoals SAP BusinessObjects, Microsoft, Oracle en Microstrategy.

NemisFs is de afkorting voor: NewFrontiers Management Information Solution For SAP.

Continue reading

Year to date comparison with previous year.

Everyone will once want to compare values from the beginning of a year until ‘a certain date’ with values from the exact same period but then from the previous year until ‘that certain date a year ago’. I found this youtube video where RimGeurts explains how to do this with BusinessObject Web Intelligence.

Year to date WebI

The screencapture is an excellent ‘how to’ guide to make a year to date (YTD) comparison based on an input date field. In this post I make an addition in case you don’t have a date but a month- or fiscal period code (like ‘201106’, or ‘FP201012’).

Continue reading

BI maintains a flat organization and continuous growth for AME

At my previous employer (AME) we were interviewed by the Association for Dutch SAP users (VNSG). The interview was about the BI implementation we did at AME in 2010. The article in dutch can be found here. The rationale behind implementing BI was in my opinion very powerful, and the implementation was very efficient. Here are a few quotes from the article:

We want to use Business Intelligence as tool to ensure that all of our people work at their optimum productivity. By opening up the BI portal each individual employee should see their relevant personalized information. By instantly sharing (real time) information we’re creating high involvement of employees.

Because the organization goes through a learning curve in the new way of working the need for dynamic information arises. To bring more insight we wanted a solution that we can maintain and extend ourselves. In our technological roadmap SAP BusinessObjects was the right choice. Because of the tight timetable and the pursuit of standardization, we searched for a suitable partner, who could provide a solution for translating the SAP tables to a good data warehouse model. We came in contact with NewFrontiers, they had a ready-made solution for the extraction of data from SAP ERP.

Everyone at AME is now able, depending on his personalized portal, to see exactly how the business progresses and how the state of affairs as development, quality, logistics and costs are doing. The hardest part however is yet to come, technically it is now completely done, but organizationally is only starting now. The project must not get stuck at the IT department. It should be “self-evident” for everyone to take action based on BI.

The original article can be found here:

The solution from NewFrontiers is called NemisFs. At my new employer I continue to work with this product, so there will be more posts from me on this in the future.

Self service BI, vloeken in de kerk?

Microsoft BI event QNH Maastricht“Microsoft BI: de gebruiker centraal” was het thema van de events die QNH op 19 Mei in Zeist en 26 Mei in Maastricht organiseerde. Een van de belangrijkste succesfactoren van BI projecten is het centraal stellen van de toekomstige gebruikers. Maar hoe doe je dat en wat zijn de implicaties voor de manier waarop je BI organiseert en het BI project aanpakt? En op welke wijze ondersteunt Microsoft deze manier van werken? Op deze vragen werd tijdens de events ingegaan door medewerkers van QNH en Marcel Westra van Microsoft.

Continue reading

How to create a pareto chart in BOBJ WebI

The purpose of the Pareto chart is to highlight the most important among a (typically large) set of factors. In quality control, it often represents the most common sources of defects, the highest occurring type of defect, or the most frequent reasons for customer complaints, and so on. Wilkinson (2006) devised an algorithm for producing statistically-based acceptance limits (similar to confidence intervals) for each bar in the Pareto chart. Continue reading