BusinessObjects Board

Is it bug in BO 4.0?

building semantic layer
#1

Hi Experts,

I am developing the universe using BO 4.0 SP2. I am trying to implement ‘ALL’ logic in list of values.

As a step, first I created ‘ALL’ object in designer. Then for country object, I edited LOV’s and used combined query of Country with ALL object. So my Country LOV’s are showing all country names with text ‘ALL’. (e.g : ALL, US, India, China,…….,etc)

However from webi, when I create adhoc prompt on Country, I did not see ‘ALL’ appearing in LOV’s. I tried by creating predefined filter on Country in universe itself on country object (which contains ALL in LOV) and then using this in webi. Still same issue.

Has anyone encountered this issue? Is it bug in 4.0? I can do the same thing in 3.1 without any issues and following same steps.

chinmay1383 :india: (BOB member since 2010-05-11)

ALL value not displaying in LOVs
#2

This is not a bug. This has something to do with access to .lov files.

When you implement ‘ALL’ logic for prompts, you create a custom LOV. These custom LOV’s are stored in .lov files in your system.
Default location is -

C:\Documents and Settings<windows user name>\Application Data\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\Universes<Universe Name>

You can opt to save at other location.
Make sure you have access to these files.

If you are working offline, in Web Intelligence Rich Client verify if the path for Universes is set to your Universe Location.
You can verify this in Setting -> Options in Webintelligence Rich Client.

stiwari :india: (BOB member since 2005-08-23)