Skip to Content
0
Former Member
Sep 12, 2016 at 11:05 AM

IDT SDK - Tables information not set.

89 Views

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

Attachments