Overwrite dimension filter using SAC Add-in

[mayiya]

Hello experts, 

I have 2 sources of information: live model and import model. 

I have table 1 as:

Table 2 as:

And I need to build a table with Account A, B, C using a date filter:

I make a filter for table 1 as: SAP.GETDIMENSIONFILTER("Table1","Date",4,4,1)

For table 2 I want to use the overwrite dimension filter, so I can filter the Date dimension using same filter as on Table 1. For example if in Table1 the filter is 082024-102024 then filter for Table2 should us the same dates, and then I can construct on Excel table 3. 

I haven't found clear examples of how to use SAP.OVERWRITEDIMENSIONFILTER, and it isn´t working for me. I try to use: SAP.OVERWRITEDIMENSIONFILTER("Table2","Period", D3,D4,D5, 5,1). 

D3,D4,D5 are the cells which contain the members I need to filter. For the example, 08/2024,09/2024 and 10/2024. 

Any idea or example of how to use this formula or achieve table 3. 

Thanks in advanced, 

Maria

[jmoon]

The table 2 formula should be 

SAP.OVERWRITEDIMENSIONFILTER("Table2","Period", D3:D5, 4,1)

The list of members to filter on should be a range formula, not individual cells. As long as the date formats are the same between the models your idea should work. 

Other option would be to use SAP.GETDATA() with your 2 different data sources. Accounts A, B would reference your Live Model source and Account C would reference your import model source.