Monday, July 11, 2011

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 »