Incomplete List of values in prompts coming from BEx

[Former Member]

Hi,

We are BO 4.1 SP3 patch 6. Month/year prompt is not showing all values in the LOVs.

All values are comimg up in BEx query but not in webi based on OLAP universe.

In BW object property is set right to show values from master data table but in BO report its still shows value from infoprovider only.

Webi LOV Limit is set to 100000 which is more than required. Month/year LOV has 20000 values.

Thanks,

Haseeb

[marcelovictor]

Good afternoon Haseeb,

How is set the property at Query? Try to score in the query also display the master data values.

I hope this helps.  Any doubt i am at your disposal. 

[Former Member]

Marcelo,

In BEx click on the object and in Properties>extended check values from Mater data Table.

Now , we have archived historical data in NLS. As bex query can get data from both bw and archived source and values are present in BEx , but not coming up itself in webi Report.

Thanks,

Haseeb

[Former Member]

I Think you have to do this at infoobject level If you are using UNV, so my experience.

Worth also also a try on info provider level, not BEx query.

Best regards,

Victor