strtoset/strtomember function violated error

  • Hi All,

    my problem is: my reports are based on production cube, recently another cube was build to replace the production cube with all necessary modifications, this cube in TEST now. we are modifying the existing reports basing on TEST CUBE.

    here we are copying the existing shared datasources , shared datasets, report also( all these are pointing to the TEST CUBE). some more modifications in query are like, changing the DIM name or HIERARCHY name.

    After changing all report expresions, when trying to preview: getting some error messages.

    1. The restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated.

    2. Getting String cannot be converted to date type error while previewing the report for all report.

    but I could not find any reason/difference otherthan changed names.

    can anybody please suggest something on this.

    Thanks,

    Niharika

  • Hi,

    If there has been any change in reports(recreated ?) then have a quick look on parameters and ensure they have same Datatypes.

  • There is something more to it.

    If the new Cube returns Null Data for some Selection and Constrained Flag is set to ON then this error appears.

    The Solution to this is to ensure that Data in both of your cube is same, or at least some rows are retrurned for the MDX Query being fired to run the report.

    Hope it helps.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply