Focal Point
Using OLAP Tab drop-downs with aggregated data?

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/2661066192

July 15, 2008, 03:12 PM
Jason K.
Using OLAP Tab drop-downs with aggregated data?
I have a tabbed olap report over sales data by day, by salesperson.

If I wanted to show only the values on this report where the days sales were under $10,000 (not where the salesperson's daily sales were under $10,000) how would I do that?

When we load the drop-down of all available sales values in OLAP, it shows only salesperson-per-day values, which are all much less than $10,000, even if the report is SUM SALES BY DAY

Does this make sense?


Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.