IES 01507

[Former Member]

Hello guys,

i have been developing a sample universe with few tables.

Joins have been made, cardinalities have been set.

i am also getting table values if i select individual table.

But..

When i am trying to get data from more than one table in dfx &/or blx, i am getting attached error.

When i am using the same join in SQL query browser, i am able to get desired result.

Solutions tried as per SAP note:-

1. Multiple SQL statements for each measure has been checked.

2. Multiple SQL statement for each context has been checked.

Please help me in resolving this issue.

Thanks,

Mayur

[Former Member]

Hi,

If the option "Multiple SQL statements for each measure" didn't solve the issue, then it can be a product defect which is documented in the following Note: 2183592 - “The query cannot run because it contains objects that
reference incompatible tables. (IES...

Regards,

Amine.

[Former Member]

hi amine,

thanx for the prompt reply.

coming to ur suggestion, i tried the same process of getting data from multiple tables, it gives desired result.

this issue is specific to universe which i am developing which have only 12 tables without any loops.

[amitrathi239]

Hi,

Check if this sap note is relevant to your issue.

2183592 - “The query cannot run because it contains objects that reference incompatible tables. (IES...

Amit

[Former Member]

Hi amit,

i did check some extra notes too which says i have to uograde to SP5 from my existing SP3