LOv Values not referenced when underlying object tech def is changed in uni

[Former Member]

Please help with this Issue

We have a object in OLAP Universe as " Allocation Channel" that object technical definiation was pointing to originally in the object in cube. and have values like CDMA, ISIS, IRDF. which we used in WEBI report to filter using this object " Allocation Channel" in query panel and 3 reports were build for each Allocation channel values like CDMA, ISIS, IRDF But now we replaced that object technical definiation to a navigational attribute which have the exact same values CDMA, ISIS, IRDF but

ISSUE is that reports are not pulling any values and blank out since the reference to that lov value is not working anymore so as a work around we need to take out the LOV values from " Allocation Channel" filter in webi report and put the values back for Allocation Channel" filter from list of values. But we have 100+ reports like this so it is not feasible to do this manual task

Please suggest if we can implement any fix or do some step in universe so " Allocation Channel" lov values are automatically referenced now to new navigational attribute which we did change the tech definiation of same object

Thanks

Soniya

[Former Member · Accepted solution]

Soniya,

Go to Universe:

View==>> Refresh Structure

Now you can see the updates, are you??

If not, Delete that Allocation Channel from Universe & try above steps again & see.

Then Save the latest Universe & Export it.

It will resolves the probs.

I'm Back