Aggregate Awareness and Predefined Conditions

building semantic layer
1

I have set up a universe with several aggregate aware objects. What I want to do now is create a predefined condition on some of those objects. When I do this I get SQL errors from the user module. Here is an example of a predefined condition and the object it references.

Condition: @Select(Session\Session Date) BETWEEN @Prompt(‘Session Beginning
Date:’,‘D’,) AND @Prompt(‘Session Ending Date:’,‘D’,)

Object:
@Aggregate_Aware(DWH.SESSION.PROC_DATE,DWH.SH_CUST_VIEW.PROC_DATE)

The error that I get is as follows:
[IBM][CLI Driver][DB2/6000] SQL0206N “DWH.SH_CUST_VIEW.PROC_DATE” is not a
column in an inserted table, updated table, or any table identified in a FROM clause or is not a valid transition variable for the subject table of a trigger. SQLSTATE=42703 :-206

We are at BusinessObjects 4.0.5.5 and this is going against DB2 on an RS6000

Listserv Archives (BOB member since 2002-06-25)

2

Glenn Fredericks wrote:

I have set up a universe with several aggregate aware objects. What I want to do now is create a predefined condition on some of those objects. When I do this I get SQL errors from the user module. Here is an example of a predefined condition and the object it references.

Condition: @Select(Session\Session Date) BETWEEN @Prompt(‘Session Beginning
Date:’,‘D’,) AND @Prompt(‘Session Ending Date:’,‘D’,)

Object:
@Aggregate_Aware(DWH.SESSION.PROC_DATE,DWH.SH_CUST_VIEW.PROC_DATE)

The error that I get is as follows:
[IBM][CLI Driver][DB2/6000] SQL0206N “DWH.SH_CUST_VIEW.PROC_DATE” is not a
column in an inserted table, updated table, or any table identified in a FROM clause or is not a valid transition variable for the subject table of

This error message seems to indicate that the generated query does not reference the correct table.
First, make sure “you” (as the logged in user) have access to all referenced tables and views.
Second, make sure you have set up the aggrgate navigation correctly.

Third, as far as I know, it is not possible to use a where clause in an aggregate_aware object directly, perhaps it is possible if you use @select(xyz), (which you did), where xyz is an agg_aware object.

I had a similar problem once and long discussions with tech support from BusinessObjects.

Walter.

Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna / Austria Tel: +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at

Listserv Archives (BOB member since 2002-06-25)