https://community.sap.com/t5/financial-management-q-a/how-to-pass-the-context-of-a-cell-to-another-sheet-in-the-same-workbook/qaa-p/603599#M16244 <P>"The client wants to be able to select a data cell in Report Tab A, and double click/select a data cell and have it open and refresh Report Tab B in the <U>same workbook</U> with the context from the selected data cell intersection from Report Tab A." - sorry, but not clear.</P> <P>Please list actions step by step, illustrated with screenshots!</P> Fri, 09 Feb 2018 16:15:27 GMT former_member186338 2018-02-09T16:15:27Z https://community.sap.com/t5/financial-management-q-a/how-to-pass-the-context-of-a-cell-to-another-sheet-in-the-same-workbook/qaq-p/603596 <P>Currently I can use EPMLink to open a separate report based on the context of a cell in an existing report. However, what I'd like to do is use EPMlink or similar EPM formula to point to a report in the same workbook as my existing report? Is there such a formula? If not, has anyone worked out a solution similar to this? </P> Thu, 08 Feb 2018 16:05:12 GMT https://community.sap.com/t5/financial-management-q-a/how-to-pass-the-context-of-a-cell-to-another-sheet-in-the-same-workbook/qaq-p/603596 michael_hutchins2 2018-02-08T16:05:12Z https://community.sap.com/t5/financial-management-q-a/how-to-pass-the-context-of-a-cell-to-another-sheet-in-the-same-workbook/qaa-p/603597#M16242 <P>Sorry, and what is the issue:</P> <P>EPM link can reference cells containing dimension members on other sheets!</P> <P>You can use EPMContextMember in some cell to have a context value...</P> Thu, 08 Feb 2018 16:38:14 GMT https://community.sap.com/t5/financial-management-q-a/how-to-pass-the-context-of-a-cell-to-another-sheet-in-the-same-workbook/qaa-p/603597#M16242 former_member186338 2018-02-08T16:38:14Z https://community.sap.com/t5/financial-management-q-a/how-to-pass-the-context-of-a-cell-to-another-sheet-in-the-same-workbook/qaa-p/603598#M16243 <P>Hi Vadim,</P> <P>The requirement is I have two report tabs (ie. Report Tab A, Report Tab B) in the <U>same workbook</U>. The client wants to be able to select a data cell in Report Tab A, and double click/select a data cell and have it open and refresh Report Tab B in the <U>same workbook</U> with the context from the selected data cell intersection from Report Tab A.</P> <P>EPMLink only works if you have two separate workbooks based on the testing I've done. I'm thinking a VBA solution would need to be written to achieve this.</P> Fri, 09 Feb 2018 15:45:47 GMT https://community.sap.com/t5/financial-management-q-a/how-to-pass-the-context-of-a-cell-to-another-sheet-in-the-same-workbook/qaa-p/603598#M16243 michael_hutchins2 2018-02-09T15:45:47Z https://community.sap.com/t5/financial-management-q-a/how-to-pass-the-context-of-a-cell-to-another-sheet-in-the-same-workbook/qaa-p/603599#M16244 <P>"The client wants to be able to select a data cell in Report Tab A, and double click/select a data cell and have it open and refresh Report Tab B in the <U>same workbook</U> with the context from the selected data cell intersection from Report Tab A." - sorry, but not clear.</P> <P>Please list actions step by step, illustrated with screenshots!</P> Fri, 09 Feb 2018 16:15:27 GMT https://community.sap.com/t5/financial-management-q-a/how-to-pass-the-context-of-a-cell-to-another-sheet-in-the-same-workbook/qaa-p/603599#M16244 former_member186338 2018-02-09T16:15:27Z