I dont know why, but suddenly Im always getting the error
[Microsoft][ODBC SQL Server Driver][SQL Server]Column FIELDNAME’ is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.8118
and BO never adds a GROUP BY at the end of the SQL sentence!!!
BusinessObjects add a GROUP BY clause at the end of a query when the query involves at least 1 dimension and 1 measure with aggregation function.
In example,
If you have DIM_OBJECT as dimension, and MEA_SURE as measure, defined as count(MEA_SURE), B.O. automatically will GROUP BY DIM_OBJECT because you wish to yield the list of the distinct DIM_OBJECTs with the number of occurrences for each DIM_OBJECT.
Ive my repository alone in a db, and Ive tried access to different productions db, getting always the same error . These productions db are the same that yesterday, when all was working fine
yes, all problems are related to MS SQL Server using ODBC connections; I’ve just changed the data source name used, but I promise I’ll never do it again