Multi Context - Compound Metrics

In XI 3.1, I have a situation where I am trying to build a compound metric. For example:

 A/B

Where metric A is in one context and metric B is in a seperate context.

When trying to use the metric on a report I get an error that says: "The query cannot run, because it contains incompatible objects. See your Business Objects Administrator. (Error: WIS00008)

Anyone have any suggestions for an approach to resolve this?


gzollinger1 (BOB member since 2003-01-23)

Hi,

Such metrics need to be created on a report side, not on a universe side.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

Thanks Marek, It works fine built on the report.

The problem is that we hundreds of this type of metric, and 1000’s of reports, and we don’t want to introduce variability into how the users define these things on their report. Any other possible approach to this issue then building it as a variable on each report?


gzollinger1 (BOB member since 2003-01-23)

Get them combined into the same fact in the universe, either physically via a materialization process or virtually via a view.


Dave Rathbun :us: (BOB member since 2002-06-06)

Running into the same problem.

I see this is an older post. Is the proposed solution the same?


ericksobj95 (BOB member since 2018-08-13)

Welcome to B:bob:B!

Yes, the solution is the same.


Dave Rathbun :us: (BOB member since 2002-06-06)

Hum, I long time I didn’t get into this kind of problematic or I m on the wrong topic :mrgreen:
So whithout giving any suggestion/solution… Should we alert on the behaviour of the coupound metrics and how the database aggregate the data and THEN how the report aggregate/manipulate the objects and the variables.
To be very careful with the AVERAGES if you want to Weight them etc.

Some times even no aggregation at the Universe level is mandatory.


mathieuBO (BOB member since 2011-01-06)

I submitted an improvement request for this: https://influence.sap.com/sap/ino/#/idea/109370/?section=sectionDetails


joepeters :us: (BOB member since 2002-08-29)