Can I create LOVs from Objects-->Edit Objects in Universe.

[Former Member]

Can I create LOVs by Editing an Object in Universe?

I have two objects 1. Job Code  2. Job Name

Job Code        Job Name

01                  System Engineer

02                  Senior System Engineer

03                  Team Leader

Now I want List Of Value for Job Code as below in the table

Jobe Code
01 System Engineer
02 Senior System Engineer
03 Team Leader

Kindly help us to suggest how can this be achieved.

[Former Member]

Hi Ram,

Each LOV associated with any object is extracted using a SQL query. So in universe,

1. Select Object -> Properties -> Edit  option
2. It will open new window
3. In that window click SQL button

This will show a SQL which is being executed to get LOV. And you can change the SQL to get your required output.

So in your case SQL should be:

Select Job_Code + " - " + Job_Name from Table Name Order by Job_Code (prepare similar SQL as per your database tables and column names)

1. Click oK on windows and save it.

Now if you click on Display LOV, it will show data in your required format.

I hope this should solve your problem.

You can take guidance for steps from below post as well.

http://www.dwbiconcepts.com/reporting-a-analysis/25-business-objects/79-bo-list-of-values.html

[Former Member]

Hi Ram,

Create a new object in the designer:-

1) Object1:-

{fn concat({fn concat(Convert(varchar,Region.region_id),'   ')},Region.region)}

2) Right click on "Job Code" go to properties, click "Edit", you will see a query panel.

Remove "Job Code" and put this new object.

3) Save and close

4) Select "Export with universe" option.

5) Hit display you will get the answer.

I used convert() because in my case region.region_id is number and region.region is character.

I can hide this *new object* in the universe so that user don't see it in webi etc.

Let me know if it works for you.

Thanks,

Vivek