User emails a universe which has customized lov - with SQL for LOV edited to using ‘Do not generate SQL before running’ checked. However, the lov is getting lost when universe is opened in email and the customizations are not taking affect.
It seems like .lov file has to be exported to the repository once. How do I do this?
If user sends the .lov file from local machine and emails it, where do I put it in frs,so that customizations take affect and are not changed into default.
Ask the user to send you the universe (.unv file) with all associated LOVs (.lov files) again.
Then save the universe (.unv) into your PC. Then all LOV files need to be stored in a subfolder that has the same name as the unv file. The structure on the file system should be like:
User develops the universe in standalone mode while customizing lov. Where are these customized lov located in standalone mode? I cant seem to locate these .lov file for universe developed in standalone mode. I am on BO XI 3.1.
User needs to find this customized lov file to email to me.
Normally (standard BO installation, no changed settings related to where universes are saved) in BO XI r2, the folder where universes are saved to is:
C:\Documents and Settings<domain username>\Application Data\Business Objects\Business Objects 11.5\Universes
I believe a similar folder exists in BO XI 3
Also, the user is insisting that this was working before even when they had not emailed the .lov file…but when i imported this universe that they had emailed and i had exported to the Production domain, I found that the custom .lov was not preserved.
The user is insisting it was working before and there is no need to email custom .lov file.
Is there a workaround, if the user does not want to email the .lov file?
Also, I think it was/is working on the user’s machine as the user had .lov file already there while creating the universe. Do you agree?
A custom LOV file does get exported to the repository if the proper checkbox is marked. A custom LOV will never get emailed if only the .unv file is sent.
This is true, I think, only if the universe is developed locally and exported to the repository from the same machine where it is developed.
But if the universe is developed somewhere else and then just the .unv file is sent via email, then how will BOE know what the customization is?
In other words, in this case both the unv file and the custom .lov file needs to be emailed to the IT team. Does anyone disagree?
Also, what are my options, if end user does not want to email the .lov file?
That’s basically what I just said. If you get emailed a .unv file by itself, it will never contain customized LOV definitions. Custom LOV definitions are stored in the .lov files contained in a sub-folder with the same name as the universe name.
Definitions of customized LOVs are stored in .lov files. So if you don’t have them, and you have only the plain .unv file, then you don’t have customized LOVs.
This is correct. If you need to export the universe into the repository, then you need also .lov files. The .unv file is not enough. Otherwise the exported universe does not have customized LOV.
To re-create the customized LOVs in Designer by your self.
Also, for Webi (XI 3.1), the .lov file is created per session and gets deleted after end of session. The only time,it persists is if is custom sql but this custom sql has to be first uploaded to the repository (especially if universe is developed elsewhere and emailed to IT as is the case here).
Are these statements correct?
Also, even though i did not customize .lov files for these universes, I do see, the following .lov file in EC:?program files/Business Objects/BO 12/storage/universes
I opened it in notepad and I see this:
TRANSACTION_REF D D - M M - Y Y Y Y H H 2 4 : M I : S S ’ d d - M M - y y y y H H : m m : s s ’
_ N o L o c a l e _
_ N o L o c a l e _ H Product category \ Product Status - - h o w d o w e r e p l a c e n u l l s ?
I copy pasted the universe file and universe folder containing the lovs in this location but the lov customizationss are being picked for some objects and not all.
I am on BO XI 3.1. Not sure why this is happening?
Is the folder to use for BO XI 3.1?
Every customized LOV has it’s own .lov file. These files are not shared across more LOVs. So you have as many customized LOVs in the universe as many .lov files are in the universe subfolder.
So if you have fewer .lov files than dimensions that have an LOV then it’s normal to find dimensions without a customized LOV.
(BOB member since 2003-11-27)
(BOB member since 2002-06-06)
(BOB member since 2003-11-27)