BusinessObjects Board

Globally Disabling List of Values

This is not really a question, but rather a placeholder for my notes. If you want to globally disable the association of LISTS OF VALUES for a universe, there is not a built-in function to allow you to do this. I’m sure you can also do this via VBA, but you may not have access to the developer kit.

WARNING: Requires direct modification of the Repository tables. There are conflicting assumptions about what violates the support contract, and direct manipulation is one of those. Modification (adding, removing columns, addition of tables, inserting or deleting rows) are typically not allowed as they may violate integrity between tables. Updating values to other valid values should not really be constituted as modifications, as you could do this via the tool, albeit much slower.

With that said… You can update a Single Universe, turning off the LIST OF VALUES by running the following SQL:


UPDATE UNV_OBJCONTENT
set OBJ_LIST_VALUES =
substr(OBJ_LIST_VALUES,1, instr(OBJ_LIST_VALUES,','))  || 'N' ||
substr(OBJ_LIST_VALUES, instr(OBJ_LIST_VALUES,',',1,2))
where UNIVERSE_ID = 39

Don’t forget to substitute the appropriate UNIVERSE_ID from the UNV_UNIVERSE table.

========
DISCLAIMER

BOB is not responsible for any errors or omissions, or for the results obtained from the use of this information. All information in this Site is provided “as is”, with no guarantee of completeness, accuracy, timeliness or of the results obtained from the use of this information, and without warranty of any kind, express or implied, including, but not limited to warranties of performance, merchantability and fitness for a particular purpose. In no event will BOB, its related partnerships or corporations, or the partners, agents or employees thereof be liable to you or anyone else for any decision made or action taken in reliance on the information in this Site or for any consequential, special or similar damages, even if advised of the possibility of such damages. :smiley:


digpen :us: (BOB member since 2002-08-15)

A VBA solution, as well as other discussion on this topic can be found here.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)