Skip to Content

Changing Query View definition results in KF always being at the end

Hi All,

I have been tasked with changing a load of query views to add in a new key figure that has been added to several queries. But I have run into a slight problem. When I add in the new KF it always appears in F4 help and in the result set at the end of the row or column of where ever the key figures are. This is irrespective of where the KF is positioned in the structure.

Anyone know how I can change this without having to recreate all the query views?

I should point out that if I create a new query view the new KF is in the correct position as defined in the structure.

Any help appreciated.

Thanks

Craig

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Sep 27, 2011 at 02:04 AM

    You will have to open the query view and adjust the position of the new KF using select filter value and overwrite the views.

    Add a comment
    10|10000 characters needed characters exceeded

    • Vineet,

      The problem is I have tried this and I get the same result. The new key figure ends up at the end of the filter listing in F4 help screen and when selected ends up at the end of the key figures. It doesn't matter if you deselect all the other key figures and insert only the new one then start to add in the others.

      It's almost as if the view definition retains the key figure structure from when it was saved and doesn't adjust itself if it has changed, merely shows any new elements at the bottom.

      Cheers

      Craig

  • Posted on Sep 27, 2011 at 07:15 AM

    Hi,

    I am not sure but also check the starting alphabet whetehr it is starting with Z and hence it is pushing it to end alphabetically. Try changing it and see whether position gets modified?

    Thanks and regards

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Kiran,

      It doesn't matter what technical naming convention is used, if I recreated the query view from the changed query the new key figure ends up in the right place. But obviously this is not what I want to end up doing, since we have a lot of query views that need adjusting to accommodate the new key figure.

      Thanks

      Craig

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.