Showing Text for months using LOV

[Former Member]

hi guys

I want to see month and month number in my lov togther is it possible if so how? For example my LOV should show JAN and "1"  when i refresh my LOV for a month dimension.

I have 2 dimensions in my universe (Month Code and Month TXT). One shows the number "1" the other shows the text "JAN". How do i combine the 2 into on LOV for one dimension Month.

Regards

Adnan

[Former Member]

Hi Adnan,

You can create an object with following SQL Script in Business Layer and use it in LOV

{fn concat({fn concat(LEFT(@Select(Month-Number),2),{fn char(32)})},left(@Select(Month Name),3))}

hope it helps you

Ambreen

[Former Member]

is there a way to manualy create a LOV. lets say i have a diemension Month Number which has a LOV 1 to 12 numbers coming from my source data. but it has no text dimension to go with it. How can i create a LOV that shows text as well as numbers?

[Former Member]

Hi AZH,

Yes you can create custom LOVS.

Follow the procedure below:

1. Open the for which you want to create the custome LOV.

lets say , your object is month name  and you want to add month number to month name during prompt disply.

2. In the edit list of values, in the query panel, you can select monthnumber object along with month name.

3. Save the query and check the option Export with universe.

4. Export the universe in repository.

You should be able to see month number and name now, for your object month name.

Thanks

Gaurav

[Former Member]

hi gaurav

what if i dont have Month Name in my source data. all i get is numbers 1-12 and i want to generate my LOV so that it shows Month names as well.

how can i achieve this?

[Former Member]

Hi AZH,

If you done have month names than write case statement in sql of object properties.

for eg. Case when month number = 1 THEN 'JAN' etc...

Note:- You have to select the check box 'do not generate sql'

This code you have to write in:

month number object-->properties-->edit list of values-->sql.

Thanks

Gaurav

[Former Member]

Go into the properties of the object and on the second tab, choose to edit the list of values. You will be greeted with a query panel where you can add an extra item as you require.