Skip to Content

Change order of Measures in Initial View

We are having an issue with re-arranging our Measures in our initial view. They are currently being sorted by the order that they appear in our BEx query, however we would like to be able to manage them manually in our Design Studio Application as opposed to changing the order in the back-end.

Other posts have suggested that you should be able to drag and drop these columns in the Initial View however this doesn't seem to work when we have a BEx data source.

We are using Design Studio 1.6 and a standard Waterfall chart to represent the measures in our datasource.

Can the order be changed in the initial view or even via the Waterfall chart?

Chart.PNG (36.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 20, 2016 at 01:43 PM

    Ross and I have now traced the issue back to our Bex Query. We often nest key figures in Query Designer so that they can be expanded / collapsed in Bex Analyzer.

    Although Design Studio recognises this and allows you to expand / collapse the fields, it will not allow us to re-order the initial view and defaults to alphabetical order.

    This presents us with issues, as for our Waterfall Chart we need to be able to re-order the columns. At least now however we understand why this is happening and can request this functionailty is added in a future release.

    Thanks for all of the previous replies.

    Capture.JPG (57.6 kB)
    Capture1.JPG (17.1 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 15, 2016 at 09:18 AM

    Hi Ross,

    I am running DS 1.6 SP01. You can re-order the measures by dragging and dropping in the Columns pane for example as shown below, rather than trying to drag the columns in the live preview section:



    SCN_Measures.png (187.3 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.