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 »Monday, September 26, 2011
Thursday, September 22, 2011
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 »Monday, September 19, 2011
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 »
Subscribe to:
Posts (Atom)