Using object from another query #context error

[former_member185138]

Hi Experts,

Query 1 is used to fetch all the data and query 2 is a independent FHSQL to get a last month's date from time dimension with some logic.

I want to create a formula to get all query1.cases on this query2.date but I dont have any common field or join in both queries.

Once I use it I get #Context error

Can you please suggest how to avoid it and use it independtly.

[jyothirmayee_s]

Hi,

Look at Forcemerge() option. Below is a blog that might help.

https://blogs.sap.com/2014/01/08/web-intelligence-significance-of-forcemerge-function/

You can try using a calculation context: IN, ForAll or Foreach.

([Query1.Case]) IN (Query2.Date])

Thanks,

Jothi