LOV file not being updating in WebI

building reports webintelligence
1

Hi everyone,

When refreshing the prompt for my WebI report, I am only seeing a small list of values that does not resemble what is in my infocube. I have looked around in the universe/query/bw but cannot seem to find what I am looking for. Asking for some guidance on how I can finally get my WebI report to refresh with a correct set of values.

Thanks!

msullivan3 (BOB member since 2011-11-15)

2

Welcome to B:mrgreen:B!!
Just create one more object in the universe for the same field and goto the properties and click display and then click refresh, if you do not get the expected values still then check the database values for that field…

SivakumarS :singapore: (BOB member since 2006-08-10)

3

Welcome to B:mrgreen:B Sullivan,

In the Universe, open the properties of that object & go to the Properties tab & in Associate List of Values check the option Export with Universe. Refresh the LOV, Save and Export the Universe again. And then try to run the query again.

Hope that helps.

M H Mohammed :us: (BOB member since 2010-06-16)

4

Hi SivakumarS,

I tried recreating a field like you mentioned and it still gives the same result. What am I checking my database for?

Just to add some more information, this report is being built off of an OLAP Universe pointing to a BEx Query pointing to a Multiprovider. We have other reports that point to Data Federator and the prompts are working fine.

There seems to be an issue with the Universe being built off of the BEx Query.

msullivan3 (BOB member since 2011-11-15)

5

Thanks everyone for the support. The above issue has been resolved. It required a small piece of code being added somewhere I do not know.

I do however still have another issue. We have our LOV file which is pulling all values from Master Data. I want to change that to point to my InfoProvider in BW. I made a change in the properties of my BEx Query, and also tried unchecking ‘Associate List of Values’. I am just wondering what settings in my BEx Query, Universe, and WebI will give me my desired result. I am attaching some screenshots incase they help.

msullivan3 (BOB member since 2011-11-15)

6

Hi,
How did you solve the LOV issue?

Even after I increased “WebiParamMaxLovSize” in the webi_client_default_parameters to “200000”
Program Files > Business Objects > BusinessObjects Enterprise 12.0 > win32_x86 > config

Still not able to see the value in the Infoview , where as it is visible in the WebI rich client.

Can some one help on solving the problem.

Thank You

Mond (BOB member since 2006-07-31)

7

Hi,

I think, the max limit for the parameter WebiParamMaxLovSize is around 65000, you cant exceed that limit.

M H Mohammed :us: (BOB member since 2010-06-16)

8

Hi Mohammed,

I have a document from the sdn which explains briefly about the issue, am facing in the environment.

Mond (BOB member since 2006-07-31)

9

Hi,

Thanks for sharing the document, I’ve used Delegated Search earlier. Does that help you or you are still looking for some other solution?

M H Mohammed :us: (BOB member since 2010-06-16)

10

Hi,

I still have the issue even after modifying the WebI Parameters in the client / server properties and doing the delegated search option in the universe, my LOV doesn’t retrieve the value in the list.
It always gives “Partial Result” and not able to find the account#.

If I run BEx Analyzer on the same query, it populates data with the above account.

Can some one give an idea what’s going wrong in InfoView.

I am able to get the account# in WebI Rich Client.

Thanks

Mond (BOB member since 2006-07-31)

11

Update on LOV values:

I removed the condition on the BEx query and created a prompt on Account in the WebI report, that brings me all the values in the LOV with out having “Partial Result” error.

Hope this helps if some one is looking a solution.

Mond (BOB member since 2006-07-31)