Solution Reports vs FR Reports

Summary: In FR Reports we can run a report in Smart View, add Lookup function etc., in Spreadsheet and then reuse the workbook in the following months by opening the same workbook and changing the POV like Month & year - All the lookups still work, you don't need to re do them. The same is not working in MR.

In MR Reports to run the report in Smart View, need to import the report and it will create a new fresh workbook each time we run it. therefore, any additional tabs, Lookup functions are lost. This is severe limitation because all the Lookup functions need to recreate every single time, or else copy the report output to an existing workbook that has the Lookups. This takes many hours to recreate.