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

Restrict a keyfigure

Hi Experts,

I have to restrcit a keyfigure.please guide me ,the scenario is like this

In the infocube my records are like this.

Char1 Char2 KF1

100 10 500

100 10 500

when i execute the query (by placing the respect info objects into columns and rows).

I get this

char1 cahr2 KF

100 10 1000

But i need only to display

cahr1 char2 KF

100 10 500

Can you tell me the way to achive this ?

Regards

Naresh.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2010 at 11:57 AM

    Hi,

    As per my suuggestion try to design ODS may be ure issue solve.

    Regards

    sivaraju

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 29, 2010 at 01:04 PM

    Hi,

    Change the aggregation type of the key figure to "Overwrite". You do this in the transformation.

    Regards,

    Z.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 30, 2010 at 05:59 AM

    Hi Naresh,

    Solution: Use the Counter in Query Designer

    Creatre a InfoObject type Key figure type/unit as Number, Data Type Decimal and insert it in Data Target,

    in transformations : Rule Type Constant, give constant value 1, aggregation Overwrite activate the transformations, load the data.

    in Query Designer:use the Zcount (hide this) in the columns along with the KF1 (hide this), take a new formula and insert as NODIM(KF1/Zcount)

    this will work out, and hope your problem will solve

    Regards

    ReddY A

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ALL,

      Thanks for Your Repsponse,

      Actually The problem is that value is coming ,by using average property in ECC..SO in query we made the respective keyfigure property to

      Exception Aggregation : Average on the detailed values.

      we achived the ouput but,we are getting some wrong values for only 3 records.

      I think we missed some other point also

      Any way the problem is resolved up to this point.

      Once again Thanks to All

      Naresh.

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.