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
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)
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