SAP Design Studio - Sorting Dimension for Dropbox

[former_member385171]

Hi All,

I am working on Design Studio 1.6 SP4 and source is Universe.

I have below dimensions in Universe

Position Product 1 B - Product 2 D - Product 3 A - Product 4 C - Product

I need to map Product Dim to Drop down as per specified position.

I did sorting while sorting base don Position while creating data source in Design Studio.

Unfortunately when I am mapping Product to drop down box it is sorting it in below order

Product A - Product B - Product C - Product D - Product

If I map Position to Drop Down it is appearing in sorted way

Is there any workaround to achieve this.

[MustafaBensan]

Hi Swapnil,

Your issue would be much clearer if you posted a screenshot of the Initial View of the universe data source.

Regards,

Mustafa.

[former_member241445]

Hi Swapnil.

Is this value sorting? "Position Product 1 B - Product 2 D - Product 3 A - Product 4 C - Product".

If it is,maybe you can try like follow.

I've faced this issue before,and I give up banding demission method.I'm succeed,I hope this can help you.

DROPDOWN_1.setItems(JR.getMemberList("CALMONTH", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 100));
DROPDOWN_1.sort(false);

Regards.

Jing