keyfigure and characteristic

[Former Member]

Hi together,

i'm facing the following problem and no idea how to solve it:

I've hot a characteristic (A) with a lot of attributes, some are other characteristics, some are keyfigures.

Characteristic A is used in a Infocube. The Cube contains some characteristics and some keyfigures.

Now there's the requirement to calculate a new value in the query as the result of the keyfigure of the characteristic A

and one of the keyfigures in the Cube.

Using a Multiprovider over Cube and Infoobjekt is not a real solution.

Has anyone an idea how to solve this? Hope so.

Kind regards

Lars

[Pravender · Accepted solution]

Create a formula variable with replacement path for the key figure attribute and use it with the cube key figure.

[former_member188011]

Hi Lars:

Please take a look at the document below.

"How to... Calculate with Attributes"

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/72f4a790-0201-0010-5b89-a42a32223...

Regards,

Francisco Milán.

[former_member189638]

Try creating a Formula Type Variable with processing Type as Replacement Path.

Select the Characteristic as A.

and Replace The Variable with Attribute. In the Attribute Dropdown, select the Key Figure Attribute.

Now use this formula variable and the Cube Key Figure in your formula Key Figure