PRM Files

building semantic layer
1

My present ODBCEN.PRM file states GROUPBYCOL=YES.

This generates SQL with the syntax:

Group By 1,2,3 …where 1,2,3 is the order the dimension objects appear in the object panel in reporter.

This syntax is not compatible with AS400 SQL.
I have changed the PRM file to GROUPBYCOL=NO and everything works well.

Except now the SQL generated, GROUP BY OBJECT_NAME, is not valid when querying a SAS universe.

Can I have a PRM file for each universe?? Is there another way around this??
:roll_eyes:

Thanks.

Moloney :ireland: (BOB member since 2004-02-12)

2

For more info on PRM(parameter files) see :
http://support.businessobjects.com/tips/pdf/universe_design/ut004.pdf

:confused: :lol: :mrgreen:
The RDBMS section in each PRM (Parameters) file lists the analytic functions that can be
used in a SELECT statement. This list may not contain all the functions available for each
family in each of the RDBMS supported for analytic functions.
Note: The PRM file is a parameter file used to configure universe creation and SQL query
generation in BusinessObjects and WebIntelligence products. There is a PRM file for each
supported RDBMS. PRM files are located in the database folders under \Business
Objects\Data Access 5.0.
Before using an analytic function, you should verify that it is listed in the PRM file. If it is not
listed, you can add the name of the function to the list. Designer will then support its use in
the SELECT statement for an object. See the section Verifying and Adding Analytic Function
Support to the PRM File for more information.

Moloney :ireland: (BOB member since 2004-02-12)