Contexts and cartesian products

Listers,

I have a report that I am running where I am getting a cartesian product warning. When I look at the sql a join is missing. When I look at the context that Business Objects should be using for the report (I say “should” guardedly) the join is there. I can’t figure out why the join would not be showing up in the report sql. The context it should be using is not the only context I have in the universe.

The table where the join is missing in the report is the reason for the contexts. I’m pretty sure that in the past I have run a similar report without getting a cartesian product warning.

Is there a way to tell which context a report is using?

Any ideas on why the join would be missing?

I searched the archives but none of the messages about cartesian products or contexts seem to quite fit my problem.

We are using B/O 5.0.1, Sybase 11.9.

Thanks,

Debbie Kelly
Museum Informatics Project
University of California, Berkeley
dkelly@socrates.berkeley.edu


Listserv Archives (BOB member since 2002-06-25)

I faced very similar kind of problem recently and made a big issue of it …sending it back to Development team to revisit the Universe design. This is a very weird problem in Business Objects. I was facing something like…the join was being used but…the table which the join uses was not being pulled into ‘from’ clause in SQL…so I was getting ‘invalid column name’ error.

My suggestion…open up the ‘Edit Join’…see if everything is correct (I mean all fields are populated)…Table 1, Table 2, Expression etc. In my case Table 2 was blank. I suppose in your case ‘Expression is missing’…though the join exists. The strange thing here is if you try to parse…BO parses this to OK.

If this has always been working…just re-import the universe…the expression would come and sit in there (if it had one during design). All this, I am writing based on one of my strange experiences…I know I have nothing to quantify it…but with Microsoft and Business Objects…at times we need to “TAKE A DEEP BREATH AND START AGAIN” (Reboot machine in case of MS and refresh universe in case of BO)…that seems to be the panacea.
Cheers,
Vinay.

Listers,

I have a report that I am running where I am getting a cartesian product warning. When I look at the sql a join is missing. When I look at the context that Business Objects should be using for the report (I say “should” guardedly) the join is there. I can’t figure out why the join would not be showing up in the report sql. The context it should be using is not the only context I have in the universe.

The table where the join is missing in the report is the reason for the contexts. I’m pretty sure that in the past I have run a similar report without getting a cartesian product warning.

Is there a way to tell which context a report is using?

Any ideas on why the join would be missing?

I searched the archives but none of the messages about cartesian products or contexts seem to quite fit my problem.

We are using B/O 5.0.1, Sybase 11.9.


Listserv Archives (BOB member since 2002-06-25)