Cognos Analytics

Expand all | Collapse all

cross join issue in cognos analytics 11

  • 1.  cross join issue in cognos analytics 11

    Posted Thu April 16, 2020 07:19 AM
    Hi,

    In my report even though we have join between 2 query subjects, when I try to add other 3 new fields to the report.

    I am getting below error, please help me to solve the issue.

    Thanks
    Gopi

    ------------------------------
    gopinath murthy
    ------------------------------


  • 2.  RE: cross join issue in cognos analytics 11

    Posted Fri April 17, 2020 12:02 AM
    Hi Gopi,
    This is the kind of error that can be a bit frustrating.
    One approach is to narrow it down by adding the 3 new fields one at a time.
    This will at least identify the one new field when the issue starts to occur.
    Which query subject does that field come from? It is probably not from one of the query subjects already in this query.
    If you have access to FM, it may be easier to track down how the queries are related to one another.
    Please post how things are going.
    // Henk

    ------------------------------
    HENK CAZEMIER
    ------------------------------



  • 3.  RE: cross join issue in cognos analytics 11

    Posted Fri April 17, 2020 06:24 AM
    What query subjects to each of these fields come from?
    Where did you create the relationships (FM, DM, directly in the report)?
    Can you add a picture of that

    ------------------------------
    NORBERT Bracke
    IBM
    ------------------------------



  • 4.  RE: cross join issue in cognos analytics 11

    Posted Wed April 22, 2020 09:08 AM
    Gopi,

    I get this when I'm joining two tables by a single field and one of the tables has a null values in the join field.  If you filter out the null values in one of your tables, the query should run.  

    Jeanie

    ------------------------------
    Jeanie Krieger
    Business Analyst
    California State University, Sacramento
    Sacramento CA
    ------------------------------