Problem with a query of a list of values

[Former Member]

Hi,

In BO XI 3.0, when I edit the query of the list of values of one information object, in the results objects panel, I've 2 objects : the Information object and a warning objects (the symbol is a warning sign with a strange name like PK4041) !

When I edit the SQL of the list of values, I can see :

SELECT DISTINCT

MASS_REFR_HIER_ORGA_ANLS.LIBL_CENT_COUT,

MASS_REFR_HIER_ORGA_ANLS.COD_CENT_COUT

FROM

MASS_REFR_HIER_ORGA_ANLS

I don't understand why the SQL of the Dimension Object appear in the generated SQL query.

When I delete the warning objects, the SQL is the same.

Some information objects are working well as usual, others have the same behavior.

Any ideas?

[Former Member · Accepted solution]

Hi,

I have heard something similar to your issue in the past. I think it was identified as a bug in BO XIR2 base release.

Try deleting the object and recreate the object again from scratch.

Note: Try to give it a different name in your test.

I know this is not a solution, however, it seems as a buggy behavior for me in XI 3.0 as well.

Thanks,

Sheeba