Problem of order in hierarchally propmpt

building semantic layer
1

Hy to everybody…i’ve made a hierarchally prompt, but i can’t find a way to order this values that you see in the picture…(i’ve edited the value list of every object and putted the order flag in the select statement) but anyway it doesn’t change. Can somebody help me?

http://yfrog.com/5mimmagineyzj

flavio20002 (BOB member since 2010-03-23)

2

I am not able to open your link as it is block in my organization.

Please take screenshot and upload.

Rakesh_K :india: (BOB member since 2007-12-11)

3

Here the screenshot
Immagine.JPG

flavio20002 (BOB member since 2010-03-23)

4

What is your LOV SQL statement at the moment?

5

SELECT DISTINCT
trunc(D05_DANNI_AAAAMM.ANNOMESE_RIFERIMENTO/100)
FROM
D05_DANNI_AAAAMM
ORDER BY
1

flavio20002 (BOB member since 2010-03-23)