Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

List of Values

Status
Not open for further replies.
chogben

chogben

Programmer
Apr 5, 2002
73
GB
We have several objects where a list of values would be very useful, but can take a very, very long time to generate...

Is it possible to generate the list on one machine, and distribute the list to all the others?

[morning]
 
Sort by date Sort by votes
Cheers Steve,

How would I go about this?

The list is useful, but we've decided to optimise the database for running queries, but the downside of the mod is that it will take a long to build the list...
 
Upvote 0 Downvote
Try taking your LOVs from something more efficient. You don't have to get your LOVs from denormalized table. Also, avoid the "distinct" operator that most LOVs get.

Do your LOVs change often. If not, then I think you can refresh them and export them with your universe. Steve Krandel
BASE Consulting Group
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DataWife
  • Locked
  • Question
Multiple values from multiple data providers
Replies
0
Views
144
DataWife
DataWife
t1sugar
  • Locked
  • Question
which version of crystal reports for boxi 4.1; Help 1
Replies
3
Views
187
hilfy
hilfy
PWD
  • Locked
  • Question
Count of Dates For Non-Unique Values
Replies
2
Views
87
PWD
PWD
MaryMaryMorrison
  • Locked
  • Question
Export List of Bex Attributes from Query Designer
Replies
1
Views
63
MaryMaryMorrison
MaryMaryMorrison
PWD
  • Locked
  • Question
Query Filter to "End of Month Date Time" Web Intelligence Rich Client Version 12:4:0
Replies
3
Views
105
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top