cancel
Showing results for 
Search instead for 
Did you mean: 

BO4 - how to customise a list of values

former_member272336
Participant
0 Kudos

Hi,

We have an object which is a code.

When user selects this wouldlike to show name alongside this.

unx bo4 sp6 using idt tool.

Is this possible?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Philip,

You have to create a LOV in the Business Layer/ Datafoundation layer.

  • Inside the LOV select both the objects- one with ID and  the other with the Relevant Name,and set the order of the ID object to Ascending/Descending and save it. You can check the SQL before saving it as well- which you can run and check whether it provides your desired output.
  • Now attach this LOV with your desired object in the Business Layer.
former_member272336
Participant
0 Kudos

Hi,

Thanks for replies.

Have created an lov in business layer

One question I have - why does it have an x listed next to it - seems same whenever attach a custom lov to a business layer object.

Assume this deliberate and just allows you to dissacciate it?

Also,

Also why only 1 green tick , seems only can select one to show a tick if select parnet title code it shows tick but then parnet title code doesn't.

Again assuem deliberate.

Thanks

nscheaffer
Active Contributor
0 Kudos

You are correct on your assumption about the "x".  The green tick signifies which column in the list of values is to be mapped with your dimension.  The types must match here.  You cannot choose a numeric column to map to a dimension that is a string.

Hope this helps,

Noel

former_member272336
Participant
0 Kudos

Thanks for advice.

Answers (1)

Answers (1)

CdnConnection
Active Contributor
0 Kudos

Philip,

     You have TWO option.

1. You can create &/or update the Dimension to  Code_KEY + " - " + Code_TXT

2. You can leave the Object as is and just update the LOV to Code_Key + " - " + Code_TXT

Regards,

Ajay