Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How can I resolve calc context from diferents queries?

Hi Experts,

I have a dubt on a web Intelligence report about sum calc with dimensions from different queries. Let me give you an example.

Imagine we have from one query A:

And from query B:

We have City as merge dimension

And we need this result on the report:

The formula that I would writte to resolve it would be:

=Sum([Revenue] In ([City])) In ([Country])

But as we don't have the dimension Country on the query A I get 900 for all countries.

Can you help me to resolve that?,

Thank you

Tags:
Former Member
replied

The solution is quite simple - use:

=forcemerge([Revenue])

Description of Forcemerge:

Includes synchronized (e.g. Merged) dimensions in measure calculations when the dimensions are not in the measure's calculation context.

HTH

NMG

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question