I have a crosstab report that has 2 queries:
1. A prompt page query for an academic term. It only pulls data items from the query subject called Terms.
2. A detail crosstab query that is using the same subject area as the prompt page data items but has several other dimension data items and fact data items. However, they are all coming from the same subject area of the FM package.
The report runs fine and returns valid data but when I validate the report I get the following warning:
Cognos 10.2.1.1 Report studio warning:
XQE-WRN-0042 Join optimization: used the alphabetically first fact table
1. Why if I have a query that only references data items from a single query subject would I get this warning?
2 Why if the other query has a valid combination of dimension and fact data items in the query and on the report page (all from the same subject area of the FM model as the query from question 1) would I get this warning?
I did a test where I even tried to add a reference to the same fact table from query 2 in query 1 and I still get the same warning message. I am just trying to understand why / how this warning gets generated under the conditions listed above. Thanks.