Informations Designer Tools - Context

[Former Member]

Hello,

I use the tool Information Designer Tools 4.1 Version 14.1.4.1327

I have a problem with the Data Foundation.

I changed context (add a join) and now it is impossible to view the bo objects found in this context.

In InfoView or Web RichClient, I have the following message:

What is the problem?

In advance thank you for your help.

[amitrathi239]

Hi,

Open the IDT and Go to Business Layer -> Properties for Business Layer -> Query Options  and Check the option "Multiple SQL statements for each measure".

Amit

[Former Member]

Addition to Amit's reply, I would also ask you to check the option "Multiple SQL statements for each context". And the "Multiple SQL statement for each measure" will only work if the select statement of the object will have an aggregation function like "Sum"

Regards,
Abhilasha

[nscheaffer]

, it seems like this thread should be moved to the space.

Noel