Skip to Content
avatar image
Former Member

SI SDK Assigning table to measure object

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jun 02, 2017 at 07:22 PM

    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

    Add comment
    10|10000 characters needed characters exceeded