Functionality to see what tables are used in dashboards

Comments

5 comments

  • Avatar
    Nathan Giusti

    Hi Christina, Sisense has a tool for this. Contact your CSM for more info. 

    0
    Comment actions Permalink
  • Avatar
    Roopa Raghavan

    Can you share what that tool is here Nathan? Would love to know as well.

    Thanks.

    0
    Comment actions Permalink
  • Avatar
    Nathan Giusti (Edited )

    Please create a support ticket and our team would be happy to get this set up with you and provide the most up to date version of the scripts. In the near future we will release a public version of this tool. 

    1
    Comment actions Permalink
  • Avatar
    Roopa Raghavan

    Thank you Nathan!!

    0
    Comment actions Permalink
  • Avatar
    Ruslan Bondarenko

    Hi All,

    By this link https://www.dropbox.com/s/pr4uqdvhrkp3z59/sanity.zip?dl=0 you may find the script that will analyze all dimensions usage in a dashboard - filters, widgets for all cubes and generate an output log file. Please unzip the archive into the drive C
    To use the script, first, you need to get AppUser credentials by running GetAppUserCred.exe as Administrator, after what you may run AnalyzeDIMs.bat in CMD that you will run as Administrator as well. Additionally in the archive, you may find MongoBackup.bat and MongoRestore.bat that will help you to create a backup of you Sisense Mongo.
    Important note, all scripts must be run in CMD that you will run as Administrator.

    Important to note, the provided solution is not an official feature and is not supported or goes through the proper product life cycle.

    This will require maintenance and proper testing on your side, we also highly recommend running on a staging environment before upgrading or implementing it on production environments.

    If this is a core requirement you would like to explore proper support routing, I do recommend reaching out to your Customer Success Manager, to involve our Professional Services engagement.

    0
    Comment actions Permalink

Please sign in to leave a comment.