2 Replies Latest reply on Oct 14, 2016 4:34 AM by aqua.lover

    Tableau server repository -  Cannot find the 'view_metrics_aggregations' table

    aqua.lover

      Dear all,

       

      I'm trying to access the data of the Tableau server repository to create custom reports on the server usage to show our users (we do not want to grant them access directly to the server).

      One table that is important for me is the 'view_metrics_aggregations' one which shows how many views a report had within a certain period of time.

      However I can't seem to find it. It is listed here: http://onlinehelp.tableau.com/current/server/en-us/help.htm#data_dictionary.html%3FTocPath%3DServer%2520Administrator%25…

       

      Am I missing something? I could find the tables 'workbook', 'views' etc.

       

      I would like to build 2 reports:

      - 1 report shows the number of views my worskheets had in a given period along with the users who saw them during this period

      - a report whos the number of views my workbooks had in a given period along with the users who saw them during this period

       

      Could you recommend which tables/views I should use?

       

      Thanks!

       

      best