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,