SI SDK Assigning table to measure object

[Former Member]

Hi,

Im trying to add the measure to existing universe using SI SDK 4.1(Java Code) version.Measure is successfuly added but when Im trying to generate query from BI it is throwing the error as "the query does not reference any table when attempting to build the where clause. (ies 00022)"

I couldnt able to get how to assign the table to this measure. Table already exists in the data foundation layer.I just want to add the measures to the existing universe.

Measure measure = businessLayerFactory.createBlItem(Measure.class, "SampleMeasure",folder); RelationalBinding binding = (RelationalBinding)measure.getBinding(); binding.setSelect("TABLE.COLUMN"); localResourceService.save(businessLayer, blxPath, true);

[daniel_paulsen]

Hi Krishna,

I'm not sure why you're getting the error as the code looks simple enough. What SP/patch level are you currently using? There were some issues around saving the businesslayer around 4.1 SP5/ SP6 but I cannot recall the exact details.

can you try further defining the measure to see if it helps?

measure.setAccessLevel(AccessLevel.PUBLIC);

measure.setDataType(DataType.NUMERIC);

measure.setState(ItemState.ACTIVE);

Dan