Hello, I have imported my dashboard solution from one server to another where actual data sources not available. For demo purpose to customer I want to show dashboard with old warehouse data from 1st server where data cubes are warehouses. If I restore warehouse sql dB from server 1 to server 2…will it work? Or is there any better way to show snapshot data? I imported dashboard without warehouse data but dashboard is showing errors.
Appreciate ur help. Thnx.
View datawarehouse data in imported dashboard
Hi Prashant. I’m not an expert here but I think we would probably recommend that you back up and restore the application database together with its warehouse database, which is a fairly normal thing to do.
The warehouse database could contain items not applicable to your other application instance: things like annotations and uploaded Excel files in addition to warehoused data for data cubes not present. If you try this anyway with only the warehouse database, it may work but I would recommend you run the health check afterward and fix the issues it finds.
1 Like