3 Replies Latest reply on Aug 8, 2016 10:28 AM by Dmitry Chirkov

    Username parsing in query

    sreekanth.upputuri

      Hi Experts ,

       

      To identify which user(Ad-hoc user) is hitting the massive  queries from Tableau to DB we have written below logic it was worked in 9.0.4 when we upgrade the environment same logic is not working

       

      can you please let us issue is occurring here

       

      logic was applied

       

      created calculated dimension(Audit_username)  like Username ()

        we have added the Audit_username dimension to Data Source Filters area

        Click on Add and select the above created dimension (Audit_UserName) ,click on ok à go to condition Tab and select the “By formula” write below formula it’s not filtering any data, it’s a filter that is always TRUE and click on ok

       

      1-1.jpg

       

       

      Publish the data source to the server as live connection

       

      Whenever using this connection and retrieve data from database, the username is also send to and caught in query logs.

       

      We have tested this  functionality in HANA and this is how the query looks like in logs

       

      1-2.png

       

       

      But now we have upgraded environment  after that user is now showing in query . it just showing like null

       

      1-3.jpg