IDT SDK - Tables information not set.

[Former Member]

Hi,

I'm creating dimension objects with the Java SDK, that works as expected, but there is one difference to manually created dimension objects in IDT and the ones I'm creating with the SDK.

The manually created objects will have the table associated under "Tables", but the objects created with the SDK don't have the tables associated (see the attached Screenshot). I tested them in IDT and it says the item is valid, but if I'm clicking on Show Script it will show the error: "The query does not reference any table when attempting to build the WHERE clause. (IES 00022)". The error is due to the missing associated table.

Here's how I'm setting the Relational Binding:

BusinessObject obj = factory.createBlItem(Dimension.class, "Dimension", parentContainer);
RelationalBinding binding = (RelationalBinding) obj.getBinding();
binding.setSelect("TABLE.COLUMN_NAME"); // same for OWNER.TABLE.COLUMN_NAME or QUALIFIER.OWNER.TABLE.COLUMN_NAME

RelationalBinding is also having a method getExtraTables(). I thought if I'm adding the table name there, it would be set, but instead I'm getting the error: "ERROR Cannot find extra table: TABLE_NAME. (SLS 18009)", when I'm saving the business layer.

Is that a bug or am I missing something?

System: BI 4.1 SP6

Thank you in advance and best regards,

Matthias

[Former Member · Accepted solution]

Hi,

just found the cause of the problem myself. I loaded the DataFoundation and the BusinessLayer right after each other and edited the DataFoundation afterwards. The BusinessLayer won't recognize that the DataFoundation has been changed in this case.

Therefore the solution is to edit the DataFoundation fist, save the changes and load the BusinessLayer afterwards.

Matthias

[atul_chowdhury2 · Accepted solution]

Sounds like a nasty one  - great that you found the solution.

Thanks for sharing!