Since BI4 has been released a new tool for the semantic layer has been introduced; the Information Design Tool (IDT). This tool is likely to replace the Universe Design Tool (UDT) in the future. In version 4 Explorer (Polestar) will only work on Universes created with the IDT and the Query Browser of Dashboard Design (Xcelsius) will also only work on Universes created with the IDT.
I’ve spent a few days on the tutorials and the tool itself, in this post my findings.
Warning, this solution is very low tech!!!
WebI XI 3.1 is not capable of displaying gauges. It should somehow be possible by embedding Xcelsius objects but I have never tried that and don’t like such solution. The solution described below came from David Gilbertson, in this post I will share the process of how to work this out in WebI XI3.1 Rich Client.
In a previous post I explained how to create a Pareto chart. In this post I will elaborate on this by displaying A-B-C categories. I am doing this in WebI Rich Client on SAP BO XI 3.1 SP3.
Lately I’ve been working with the new version of BusinessObjects, BI4. In a previous post I already covered a bit on the migration process from XI 3.1 to the BI4 platform. From there, most of my attention has gone to working with Web Intelligence. Soon I encountered a problem with charts not showing up, or displaying red crosses. After some research I found it had something to do with a failing Adaptive Processing Server. I installed patch 8 which did not solve the problem, and then patch 9 which also did not solve the problem.
Ultimately I removed some services from the AdaptiveProcessingServer which solved my problem. In this post I’ll explain what I did en how to do it.
The BusinessObjects universe is a business representation of organization’s data that helps end users access data autonomously using common business terms and it isolates business users from the technical details of the databases where source data is stored. Universes are made up of objects and classes that are mapped to the source data in the database and accessed through queries and reports.
Users retrieve data using descriptive terms used in the business environment with the company’s business terminology.
Universe is a semantic layer that maps complex data into descriptive business terms used across the organization, such as product, customer, region, revenue, margin or costs.
I’ve been working on a test-upgrade from BO XI 3.1 to SAP BO4. Here’s what I did, and my findings so far. I haven’t tested the outcomes thoroughly yet, so I might miss some flaws, and I might accuse some errors to the upgrade process while they might be caused by some other factor(s).
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
One thing I really dislike in BO XI 3.1 is the flexibility of the charting objects. Or better the lack of it. In this post I’ll explain how you can take control of the legends from all kinds of graphs in WebI.
We have the following issue:
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.
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’).