Skip to Content

Prompt sorting as specified in universe's LOV lost in Design Studio

Hi all,

we have specified a certain LOV with sorting for a dimension in a universe (UNX). In Design Studio we want to create a prompt that should be based on this dimension and use the sorting of the LOV.

In Design Studio, the initial prompt displays the correct sorting of the values as specified in the universe. As soon as we run the dashboard, the sorting is lost and an alphabetical sorting is displayed.

This is the same behaviour that Rashmi Hirematt described at the end of this discussion:

We are currently using Design Studio 16.2.2, IDT 4.1 and BIP 4.1 SP 8.

Does anybody know if this behaviour is a bug or by design or if there is a workaround we can use?

Thanks so much for your help in advance!



Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Posted on Feb 24, 2017 at 10:20 AM

    Where is the sorting lost when you run the dashboard? Can you share screen shots? What about sorting in Design Studio?

    Add comment
    10|10000 characters needed characters exceeded

    • Hey Tammy,

      I just realized, I accidentally didn't reply your comment directly.

      Please view my answer below.

      Plus: There is no further sorting in Design Studio possible for prompts that would force using the sort order from the LOV. Or do you know a way coincidentally?

      Thank you and BR,


  • Posted on Feb 27, 2017 at 08:21 AM

    Hi Tammy,

    when I create the prompt in the query specifications and accept the changes I applied to the query specifications, I'm asked to enter a prompt value and the correct sorting order is displayed:

    As soon as I execute the dashboard locally or on the platform in my browser, I get this alphabetical value sorting (although I selected Prompt with LoV in the query specs):

    screenshot01.png (76.1 kB)
    screenshot02.png (41.3 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 28, 2017 at 01:51 PM

    On the surface, sorting universes may be an issue in the BI4x version - (guessing, honestly) - see

    When I can I will try it on my BI4.2 system

    Add comment
    10|10000 characters needed characters exceeded