Skip to Content
avatar image
Former Member

How to get the dimension name of the second dimension?

Dear community

I am developing a dashboard that contains a query which includes a couple of dimensions (and of course measures). The first column is the dimension which gives me the sorted order of the second dimension/column. The reason for that is that we cannot sort the keys of the second dimension. So the first column/dimension contains numbers from 1 to 10. The second contains titles (words). When I add this query to a crosstab it shows me the right order when I add the first and the second column.

But what I actually have to do is to get the names/titles of the second dimension into graphomate tiles (title) (or in an array as another option) in the right order. At the moment, the design studio takes the second column (titles) in the alphabetic order.

Has somebody an idea to fix this issue?

Glad for every help.

Add comment
10|10000 characters needed characters exceeded

  • Hi Roman - would it be possible to post some screen shots? I'm having a hard time following; I think if you share screen shots the community will have a better chance to assist.

  • Former Member Tammy Powlas

    Hi Tammy

    Mustafa described it absolutely right and this exatcly my point/issue. So I have tried the Data Iterator but I get the error messages below.

  • Get RSS Feed

1 Answer

  • May 08, 2017 at 02:31 PM

    Hi Roman,

    Based on your scenario, I am guessing that you are probably trying to retrieve the dimension member names/titles using the data source getMembers() method. If that is the case, this is a known limitation whereby getMembers() does not return member values in the same order as the data result set but rather in master data order, which is usually alphabetical, as you have experienced.

    You can use the Community Design Studio SDK Data Iterator component to loop through the data result set in the correct sort order and obtain the required names/titles that way.

    Regards,

    Mustafa.

    Add comment
    10|10000 characters needed characters exceeded