Skip to Content
author's profile photo Former Member
Former Member

Bex Query - how to hide characteristic value for

In Bex Analyzer, I have 2 characteristics and one key figure. One is employee, the other is activity type. Because of salary sensitive issues, for certain activity types, I do not want the employee number to show. However, I do need activity type and key figure (rate) for this record to display so the total for the project will be correct. How do I hide the employee number for selected activity types. See example below.

ProjectEmployee Activity Type Rate (kf)

1000 123 W01 $15

1000 G01 $20

Thanks in advance.

Vicki Tankersley

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Posted on Jan 25, 2008 at 12:36 AM

    Vicki,

    would it do to hide the key, yet show the text description for the employee number? You can set on characteristic what information to show.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 03:07 AM

    Hi

    Have u tried using the NO DISPLAY OPTION IN THE DISPLAY TAB...??/

    TRY ..IT\hope this helps

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 25, 2008 at 06:01 AM

    Try using conditions to supress these records. I am not completely sure but I think this wont affect the result, so your requirement will get fulfilled. Please update the thread if it works.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2008 at 07:44 PM

    In most situations, the key and name should be displayed. It is only for a limited number of activity types that the key and name should not be displayed but the dollar value should always be shown. Another other ideas? Thanks.

    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.