characterstics are not available from Query designer formula

[Former Member]

Dear Experts,

I have a requirement where in forumla from query desinger has to be modified with new characterstic filed.

when I tried finding Characterstics from "Available operands" but i could able to see Keyfigures and Formula variables only. Characterstics are available.

Following is the requirement with example.

existing formula structure

A= B+C

now characterstic "B" has to replace with characterstic "D".

hence new formula should be as below;

A = D+C.

Note: Query has designed on infocube

Could you please guide me how to proceed further.

Thanks in advance!

Regards,

Mannu.

[michael_devine]

Hi,

For all details on formulas please see:

http://help.sap.com/saphelp_nw70ehp2/helpdata/en/71/0aec3b6e011341e10000000a114084/frameset.htm

Also, the answer to your question is in this thread:

Regards,

Michael

Edited by: Michael Devine on Oct 19, 2011 9:53 AM

[anshu_lilhori]

Hi,

You cannot use characterstic for calculation.Only keyfigures can be used for it.In order to use characterstic for calculation you need to use formula variable with replacement path.

Please give the details about that characterstic field so that i can give you more inputs and one more thing the characterstic you are going to turn into formula variable has to be present in rows.

Hope it helps.

REgards,

AL

Edited by: AL1112 on Oct 19, 2011 9:45 AM

[Former Member]

Hi AL,

Thank you for the quick and first reply...

Please find the following from the problem area.

existing functionality:

Net due days = Net date - Base line date (defined in existing formula)

*Required functionality:

Net due days = Net date - Document date

Hence, here i need to change the formula to calculate net due days from document date insted of base line date in colums for Net due days calculation.

Thanks in advance!

Regards,

Mannu

[anshu_lilhori]

Hi,

I am assuming your document date is characterstic so in order to use it in calculation you need to make use of formula variable.

Follow these steps for it.

In columns panel -

---

under available operand--formula variablenew formula variable-General tab--processing by replacement path -

---

Reference characterstic -doc date-

Replacement path tabReplace variable with infoobjectreplace with key.

currency/unit tab--dimension date.

Now use this formula variable in your calculation.

Make sure to put doc date in rows otherwise the calcualtion wont give you the proper result.

Hope it helps.

Regards,

AL