Objects in Query Filter Giving Error

[Former Member]

Hi,

I am trying to create a report in which i need to bring some objects .

The issue is that the objects in the select clause are fine , when i run the query . But when i bring the same object in the Query Filter . and when i go for Value(s) From the List , it gives me the following error .

But in the Select Clause it runs fine

[Former Member · Accepted solution]

Hi Usman,

The universe might been deleted or shifted to different location, so the ID of universe was changed or deleted. (Pls Refer: SAP Note- 1527638)

Resolution:

Re-map the Universe from the properties of the report.

1. Open the report.
2. Click on EditQuery.
3. Click on Properties tab.
4. Remap the Universe.

--Raji. S

[Former Member · Accepted solution]

Even if i make a new fresh report with those specific objects , it gives me that error which putting as Prompt or List of Value(s) .

i did a little research , i figured out that it has to do with the LOVs at the Universe level, either they corrupted  or has to be refreshed and then export ot CMS again . Do you think this could be the reason? because its just coming when refreshing putting in the Query Filter . It runs fine when the objects are in the Select Clause

[Former Member · Accepted solution]

Found the issue , the Lov's were custom build , so when they made the new universe , the universe developer forgot to make those Custom Lovs.