GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Business Objects
Go To First  |  Previous Question  |  Next Question 
 Business Objects  |  Question 249 of 253    Print  
LOV in BO Reporting
If a user wants to report a list of values that is not available in the Universe/DB, then how will you help him/her to use it in a report?


  
Total Answers and Comments: 5 Last Update: November 11, 2009     Asked by: harakrishnav 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
August 13, 2009 06:48:12   #1  
anil.ganga1 Member Since: August 2009   Contribution: 3    

RE: LOV in BO Reporting
There could be one possible reason why the user was unable to see the list of values.

In universe in object properties there is one check box "Assosiate list of values" select this check box and try.
By default every object in universe will associate with list of values.

Hope this helps.

 
Is this answer useful? Yes | No
August 31, 2009 16:35:17   #2  
ravi_kumar_garre Member Since: November 2007   Contribution: 35    

RE: LOV in BO Reporting
You can edit the list of values for the required object and load personalized list of values for the user if data is not available in Universe / DB.

Regards
Ravi Kumar Garre

 
Is this answer useful? Yes | No
September 15, 2009 04:21:40   #3  
boe_123 Member Since: September 2009   Contribution: 3    

RE: LOV in BO Reporting
LOV is used:

1. For prompts
2. For display in reports

If the values are required for prompts then you need to edit the object in the universe to a union to your query for that object.

If it is for display in the report then sort the values using custom sort where you can add temporary values to LOV.

 
Is this answer useful? Yes | No
September 17, 2009 07:22:50   #4  
54446 Member Since: September 2009   Contribution: 5    

RE: LOV in BO Reporting
Strange but not immpossible.

You have to create a dataprovider by selecting others-->personal files.

Now you have to create a dummy object and when you are using that in BO reporting then add that to filter panel and go for query results of dataprovider then you can take that and proceed.

 
Is this answer useful? Yes | No
November 09, 2009 06:28:52   #5  
mani14dec1984 Member Since: November 2009   Contribution: 2    

RE: LOV in BO Reporting
There is one way to incorporate LOV for this problem.

1) In Universe

In Universe designer Goto Tool >>List of value>> Edit Lov. Select the object in which you want to associate the LOV then check the Personal data radio button below Click Ok. Provide the personalised list of value either in Txt excel or DB file and export the universe with these cutomizes LOV. Then only these LOV will be available during reporting.

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape