rolling back one year

[system]

@Andreas

To emphasize:
I wish Business Objects would force Designers to use SQL Group by functions such as SUM, COUNT, MAX etc. whenever creating measures.

@Anita

Well, I don’t feel as strongly about it – I’ve seen a universe where it made sense to be able to set the projection to SUM, but to retrieve the rows unsummed. The individual user might want to see the individual rows on one report but not another, and the Reporter option to Format - Table - “Avoid Duplicate Rows Aggregation” was what was needed

This is one of the reasons I wish Business Objects Designer would force you to use SQL Group By statements whenever creating measures: Two Fact Tables

If the user for example wanted to see detailed transactions he/she could either pull in the Transaction ID or the designer could create a Dimension object instead of a Measure.

---

Andreas (BOB member since 2002-06-20)