Skip to Content
0

SI SDK Assigning table to measure object

May 22, 2017 at 12:54 PM

80

avatar image
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);

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Daniel Paulsen
Jun 02, 2017 at 07:22 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded