Standart Deviation using Teradata and Business Objetcs.

[juanjoseruiz]

Good Morning from Spain:

I want to do a Standart Deviation using Teradata and Business Objetcs.
The Object in Universe is defined STANDART DEVIATION --> STDDEV_POP(OBJECT)

But when i use it in a report, the SQL generated do not have the 'GROUP BY' around this object.

I am trying to put it in a .PRM file in C:\Archivos de programa\Business Objects\Data Access 5.0\Teradata\TERAV2SP.PRM
and in C:\Archivos de programa\Business Objects\Data Access 5.0\ODBC\RDBSP.PRM and ODBC10SP.PRM but not works.

Plase help me, and thanks.
Juanjo Ruiz. Spain.

 

[satinsilhouette]

Did you try to use Aggregateawareness on the object you want to group by?

 

[juanjoseruiz]

Problem solved, it was the UpperCase, because all in PRM, in universe Business etc cound be in LowerCase and it works.

 

[satinsilhouette]

Interesting! Have you read the white paper on limitations of crystal reports with universes?