Excel Data Sources for Webi and Xcelsius

Although using Excel as a data source is not ideal, sometimes there is no other option. In this post I’ll go through what I believe are the best options for getting data from an Excel spreadsheet into Webi and Xcelsius (and Universes and Crystal).

Excel Data Sources for Webi and Xcelsius

Although using Excel as a data source is not ideal, sometimes there is no other option. In this post I’ll go through what I believe are the best options for getting data from an Excel spreadsheet into Webi and Xcelsius (and Universes and Crystal).

Read more »

Waterfall Charts in Webi

Although waterfall charts are not an option in Webi, with a little trickery it's possible to create something that looks and behaves as a waterfall chart should.

Read more »

Security on Components in Xcelsius

When you have a dashboard, usually any user that views the dashboard will see the same as any other user. You may be filtering your data based on row-level security in your data source, but what if you want some components to only be visible to some users?

In this post, I’ll explain how you can set up a dashboard that will allow certain users to adjust a target value used in a chart.

Read more »

Dynamic Measures in Webi (on Any Data Source)

Imagine that you have database that contains a number of different measures, and the reporting requirements call for many identical reports where the only difference is the measure. For example, the one report layout may be required to show either Revenue, Gross Margin, Net Margin, Volume, Average Sale, etc.

Rather than duplicate the reports that are shown, you can let the user decide which measure to show, and design only one report. Previously I’d written a post showing how to do this using a derived table in the universe. This post shows you how to get the same results without a universe (for example if your source is BEx or MSAS or you simply don’t have access to edit your universe).

Read more »

LifeCycle Manager (LCM) Walkthrough

 

LifeCycle Manager is a tool that can be used to promote content from one BusinessObjects system to another. It offers some significant improvements over the Import Wizard, but there are still plenty of users that haven’t made the switch. The purpose of this post is to introduce you to a few of the features of the tool and give you an idea of what’s involved in setting it up.

Read more »

Dynamic Measures in Webi (Using a Derived Table)

Imagine that you have database that contains a number of different measures, and the reporting requirements call for many identical reports where the only difference is the measure. For example, the one report layout may be required to show either Revenue, Gross Margin, Net Margin, Volume, Average Sale, etc.
Rather than duplicate the reports that are shown, you can prompt the user to show a particular measure, and design only one report. Here’s how…

Read more »