Skip to Content
avatar image
Former Member

IES 01507

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

Error.png (26.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 03, 2015 at 01:00 PM
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi amit,

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

  • avatar image
    Former Member
    Nov 03, 2015 at 01:01 PM

    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 00008)" when running query in Information
    Design Tool

    Regards,

    Amine.

    Add comment
    10|10000 characters needed characters exceeded

    • 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.