BEx query with conditions is not working as replacement path
I am trying to use one BEx query which is having Transaction Number and Date difference (Created date and System date) as a replacement path in another query. Replacement path will be of Transaction number.
My requirement is to display only those records in a seperate query which satisfy the condition = 30 > (System date - Created Date) > 19.
To test whether replacement path is working fine, I tested it by restricting the first query globally with three transaction numbers and Execute the 2nd query. In this case my 2nd query is only executed for those transaction numbers.
That is replacement path is working.
But when I am applying the condition on key figure (Date subtraction) in my first query it did not work.
2nd query restriction is not working and displaying all the records.
I have tried below scenarios anf non of them worked.
1. Tried using formula
2. tried using calculated key figure
3. tried zero suppression (got warning variable replacement not possible)
I found below post which is for similar problem, but did not work for me. Could you guys please help ?
I am using BW 7.3