Skip to Content
avatar image
Former Member

How show more than 3 key figures in Bex Query Designer report

Hello experts

when I run an report using Bex Query Designer, I can only see up to 3 key figures even when I have added more than 3 key figures in the columns section. Is there any setting I can change ( No of columns ) so that I can see all my key figures added to the column section ?

Thanks for your input.

JHN

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Best Answer
    Feb 14, 2017 at 09:21 AM

    Hi John,

    check which Web template is used for running your queries - if you run them out of the query designer - it should be 0ANALYSIS_PATTERN, if they are already included into the portal, check it is the portal.

    Then check the analysis table item properties within this template.

    There the number of columns = key figures can be specified.

    Change it to the numer you need - but be aware, this might influence also other applications within your system.

    You might need to define your own template...

    Next time, please post a screenshot, then it will be easier to understand your topic.

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 12, 2017 at 03:32 PM

    BEx uses a standard template to display the query results on the web (you can access this template using WAD). Once you have opened that template in WAD, look for a setting in the template under properties for displaying number of rows/columns. You might want to adjust that setting in order to show additional rows/columns in the default template. Remember, this is a global setting and by changing this you would globally change the number of rows/columns displayed.

    Arun

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07, 2017 at 08:34 AM

    which frontend are you using?

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 07, 2017 at 11:06 AM

    Hi John,

    Please check whether you Keyfigures are hidden in BEx Query Designer. If yes, please unhide that in Keyfigure properties.

    Regards,

    Abdul

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 07, 2017 at 07:31 PM

    I'm using the portal. I can see all my key key figures in the Bex Analyser, but not in the portal when I run the query from the Query Designer .

    With respect to settings, all the key figures are set to the same settings , "Always show". But the report only shows the first 3 figures on the list.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 07, 2017 at 07:40 PM

    Hi;

    You should have a button on top or down that allow you to navigate in the report

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09, 2017 at 04:54 PM

    Yes Ricardo, I can navigate to the next key figure, but that's not what I'm looking for. I'd like to see all my key figures on one view on one line without having to click on next/down arrows.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 24, 2017 at 02:42 PM

    Thanks Arun and Cornelia for your help.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 07, 2017 at 07:13 AM

    Hi,

    If you are using Web Application Designer then you may adjust the setting of the WIDTH of your portal.

    If not, you may ask your BASIS team on how to change the setting of the WIDTH in your portal.

    Regards,

    Loed

    Add comment
    10|10000 characters needed characters exceeded