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

BEx : Replace keyfigure values by characteristic values (URGENT)


For a certain implementation, I want to replace key figures (status value) by texts contained in a characteristic in the same query.

Both the key figure for status and charcateristic are contained in the same ODS.For example :

A row in the ODS has the planning status(characteristic) of 'in process' for a certain company, the representative key figure value for which is 2(key figure).

Can this be done by using BEx variables or formulas somehow ?

I need a status key figure to be able to do exception reporting on it.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Jun 07, 2005 at 06:47 AM

    Hi Anuradha,

    I think there are two ways to solve your problem:

    1 - "copy" the char values to keyfigures during data loading. You can do this in Update or Transfer Rule. Obviously by the term "copy" I mean that you have to develop a suitable routine. But be aware that this solution needs particular attention with different aggregation levels ...

    2 - use "Virtual Key Figures" to replace KEy FIgures values ... Let me say that this should be the last option because of the performances (if you are using an ODS the problems are double!).

    Hope it helps


    Add a comment
    10|10000 characters needed characters exceeded

    • Well now it's clear to me ... as per my knowledge in order to color the char cell I think you should use some VBA coding if the Query is published in a WorkBook and something similar to work via WEB.

      By the way

      1) define the kf with 1 if char = "new" and 2 if "in process"

      2) define the query with 0COMPANY, status_char and status_kf and the realted exceptions

      3) with some VBA coding in the WorkBook copy the color format to status_char column from status_kf and then hide status_kf column.

      Hope it's clear enough and sorry if I didn't understand well the problem from the beginning


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.