Archive

Archive for January, 2014

Sorting LOVs in a prompt

January 3, 2014 Leave a comment

Hi,

environment: SAP BI 4.0 SP6 P6, repository database: Oracle Database 11gR2, Universe Designer, Information Desgin Tool

Issue:

Within a prompt, based on a LOV, the values aren’t alphabetically ordered. In case of a large list, this makes it very difficult to pick the right values.

issue

Solution:

Add sorting to the “Associated List of Values” of the Dimension Object.

STEP 1: Open the universe using universe desginer and navigate to the Dimension Object. Open the Object Properties

step1

STEP 2: Navigate to the “Properties” tab, Activate checkbox “Export with universe” and click “Edit”

step2

STEP 3: Drag an drop the sort-button to the object

step3

STEP 4: Save and export the universe. Result:

step4

If you are using IDT, things look a bit different:

STEP 1: Create a LOV

idt_1

STEP 2: Define sorting ont he LOV

idt2

STEP 3. Assign the LOV to the dimensional object

idt3

kr

Hans

Advertisements
Categories: IDT, SAP BI, Universe Designer, WeBi