Skip to Content
avatar image
Former Member

Key Display

Hi All,

I would like to dsplay account number key with out chart of accounts and profit center key with out controlling area key in bex analyser. Is there any setting in the query designer?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 14, 2010 at 04:09 PM

    In the query, goto the properties of the characteristics Chart of Account and Controlling Area and set Display Option as No Display

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 14, 2010 at 02:13 AM

    If the source cube you have profit center or account number then pull them as free characteristics in your querry designer and save the querry and run in BEx analyzer.

    Or if your question is to display the account number or profit center key in analyzer then just right click on profit center and select properties and in drop down list of display select key. it will show the key instead of text.

    If the key option doesn't exist in drop down list then change the info object in backend to display as key and text.

    Hope this helps.

    Regards,

    Reddy

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2010 at 11:22 AM

    Hi,

    In order to not show the compounded parent, you need to have single value fixed filter

    of this compounded parent in the query filter.

    Would you try this?

    Regards,

    Patricia

    Add comment
    10|10000 characters needed characters exceeded