Last load date

[M]

Good day ,

in our framework model we have extract date query subject with extract date , month etc  ,this comes from warehouse . For the Last load date we had custom query to retrieve max(load date) from warehouse .It is a query subject with a single query item. 

There is no link between last load date  query subject and extract date query subject .

When we try to use the filter extract date = last load date to get the latest data. cross join error thrown by the cognos server.

How to resolve this:
1, any other way to bring last load date or 2,can we create a link between last load date  query subject and extract date query subject ?

Regards
VM

[blom0344]

If you are dead certain that only one row is returned you might consider allowing cross joins (FM setting), or model a dummy join over a constant value defined in both query subjects  (1 = 1 for instance)

[adik]

why don't just create a relationship between the last load date query subject and the query subject with the extract date? there is no reason why it won't work