3 Replies Latest reply on Feb 5, 2019 11:11 AM by Ken Flerlage

    How to switch data sources using dashaboard via a dynamic parameter

    Megha Patel

      Hi,

      I am looking for a solution to allow users access legacy data (10+ years)  via a cross tab dashboard.

      This legacy data is huge, millions of rows as it is financial transnational information.

      Due to performance issue, solution which we were discussing is to create a data extracts of 2 years worth of data.So we have around 5 extracts for 10 years worth of data.

      Then to create a Cross tab dashboard /report which will have a parameter which will allow or switch dashboard  to point  different data sources as per requirement.

       

      Is there a way we can create a parameter (Custom SQL )on cross tab which will allow users to switch  data sources on published dashboard.

      Any advice from the group will be helpful.

       

      Thanks

      Megha