To fellow listers:
In Aggregate Navigation if the query includes a lower level object, removing the object does not automatically redirect the query to point to the aggregate tables. Does anybody know how one can flip-flop between the two queries.
Thanks.
Harsh Singh
Deloitte Consulting
Listserv Archives (BOB member since 2002-06-25)
Harsh,
Aggregate Navigation is pretty touchy. Make sure that you’ve got your joins set correctly in your structure. Question - have you joined the aggregate tables together … are they pathing through each other? If so, disconnect them.
Secondly, make sure that your contexts are set correctly … i.e. one aggregate table per context.
Thirdly, make sure that when you set incompatibilities, you set them manually (do NOT as this can produce some hideous results), and only on the against the aggregate tables.
Once you’ve done all this, try the report / test again.
Ang.
Listserv Archives (BOB member since 2002-06-25)