Question:
Hi all,
I have an InfoObject including Attributes based on a key figure InfoObject
This Attribut is used in a BEx Analyzer Query as a new formula with
Replacement Path to use it as a measure. But that measure always
yields an X as the result. There is no way to calculate the result as summation. Further measures including this formula yield the 'red X'
too. Does anyone has an idea?
thanks
Answer:
Hi
You canl only use _navigational_ attribute of type _Characteristic_ (not KF) in replacement path formula variable.
Then it works fine.
Parent object should be in the same query as well!
And do not forget to activate md.
Ruslan
SAP BW Certified consultant
Answer:
Hi,
try to create a calculated key figure with your formula in it. Then it should work. Depending on your version and support package, there might be a few problems with this. With 30B and SP10 it is working OK.
If you use the formula locally (not as a CKF), the query will only show values if the infoobject is in the drilldown. The red X indicates that the values shown are aggregated.
BR
Hubbi