Author Archives: Ron Keler

Control the size of your Xcelsius dashboard in InfoView

If you ever tried to publish an SAP BusinessObjects Xcelsius dashboard to InfoView by using the “Export” option to “Enterprise”, you surely ran into a sizing problem when viewing the dashboard. As the dashboard designer, you pay great attention to … Continue reading

Posted in Xcelsius | Tagged , , , | 8 Comments

Some keys for a successful BI project

As you set to start working on a new BI project, you will need to address many technical issues sooner or later. Picking technologies and vendors, assembling teams, and working across the corporate silos to bring together information that does … Continue reading

Posted in BI At Large | Tagged , , | Comments Off on Some keys for a successful BI project

Google Charts – the elephant has entered the room..

As a developer I always had a knack for open source. So, when I started working with Business Intelligence I naturally began looking for opportunities to leverage open source software. Of course, MySQL was a great RDBMS choice (i used … Continue reading

Posted in BI At Large | Tagged , , | Comments Off on Google Charts – the elephant has entered the room..

Handle semi aggregate measures in universes

While relatively simple data marts can be designed as true simple stars, more often than we like, our reporting data models contains snowflakes. Whatever you want to call these entities, they represent one basic problem for your reporting tools: Cartesian products. … Continue reading

Posted in Universe Design | Tagged , , , , , , , , , , | Comments Off on Handle semi aggregate measures in universes

Localize your global Xcelsius dashboard

If your dashboard is intended for a global audience, you may need to be able to localize it. By localization, most people refer to the ability to translate at minimum the labels and headers of the dashboard, based on the … Continue reading

Posted in Xcelsius | Tagged , , , , , , | 2 Comments

QaaWS vs LiveOffice

One of the first major decisions you will face when starting to design your SAP BusinessObjects Xcelsius dashboard is which connectivity option to choose. Xcelsius supports a myriad of connectivity options, and two of the most popular connections for BusinessObjects … Continue reading

Posted in Xcelsius | Tagged , , , | Comments Off on QaaWS vs LiveOffice

Google style search on your Xcelsius dashboard

Dashboard designers have long been concerned with design and usability, concepts typically foreign to IT development. Leveraging all types of selectors in the forms of combo boxes, list selectors, radio buttons and check boxes, they try to make information finding … Continue reading

Posted in Xcelsius | Tagged , , , , | Comments Off on Google style search on your Xcelsius dashboard

Creating a dashboard level column selector in OBIEE

Creating a dashboard level column selector in OBIEE Users of OBIEE Answers are accustomed to the versatility of reports provided with the Column Selector. The column selector setup is very easy and intuitive to configure and use. However, it is … Continue reading

Posted in OBIEE | Tagged , , , | 4 Comments

Naming Conventions In The Data Mart

What you call things matter. It matters to you, and it matters to others who interact with you. When you name things, your project, your children, your children’s stuffed animals, you typically consider two perspectives: what YOU think the name … Continue reading

Posted in Data Warehousing | Tagged , , , | Comments Off on Naming Conventions In The Data Mart

Handling the ALL level in Xcelsius selectors

Handling the ALL level in Xcelsius selectors is always a problematic proposition. If you tried using a selector to pass a value to your BusinessInteligence prompt, in order to retrieve filtered data from the database, you must have run into … Continue reading

Posted in Xcelsius | Tagged , , , | Comments Off on Handling the ALL level in Xcelsius selectors