Restrict a keyfigure

[Former Member]

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.

[Former Member · Accepted solution]

Hi,

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

Regards

sivaraju

[Former Member]

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

[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.

[Former Member]

Hi,

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

Regards,

Z.

[Former Member]

Or in query designer you can view calculation properties for key figure and set calculate single values as MAXIMUM

[Former Member]

Hi Khaled,

Thanks for your Response,

Can you please tell me What actually Calculate single values will do? i don't about this option.

If possible ,Please give a pdf Link.

Regards

Naresh.