Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
BO Question
- Thread starter Ghazal222
- Start date
BrianTyler
IS-IT--Management
One of the basic features of BO is that grouping is automatic.
You then come to the problem of the HAVING phrase. This is done by comparing the measure against a CALCULATION.
Theoretically, you simply use the wizard and it's all done for you - but always check the SQL before you run it!
You then come to the problem of the HAVING phrase. This is done by comparing the measure against a CALCULATION.
Theoretically, you simply use the wizard and it's all done for you - but always check the SQL before you run it!
Make sure your measures have SQL aggregation on them.
Sum(table.column). Group Bys will autmatically be done. A measure is rarely correct without this. You can't rely just on the aggregation setting. That one on the 2nd tab simply deals with the objects behavior on a report.
Steve Krandel
VERITAS Software
Sum(table.column). Group Bys will autmatically be done. A measure is rarely correct without this. You can't rely just on the aggregation setting. That one on the 2nd tab simply deals with the objects behavior on a report.
Steve Krandel
VERITAS Software
- Status
Similar threads
- Locked
- Helpful tip