5 Replies Latest reply on Aug 17, 2016 8:48 AM by Baji Bonam

    Filtering data from data source1 based on other data source2 input

    Baji Bonam

      Please find attached a simplified workbook of what I am trying to achieve. In short, I have two data sources – one sales and one user info.

       

      The sales database is always an extract, whereas user database is a ‘live connection’ to the database. When a user logs in I will first authenticate and authorize and then determine whether the user is an admin and if not, their region.

       

      See the calculated field – Region filter

       

      iif(attr([Region])=[Region info from live DB]

      or ([Region info from live DB]="Admin" and attr([Sheet1 (live user info)].[Isadmin])="Y"),

      1

      ,0)

       

      The user db will only have one row from the below at any given time.

       

      isadminregionregionid
      YAdmin5
      NNorth1

       

      When I am trying to apply this filter in the view then it always fails for some reason. I tried using the concepts of blending but wasn’t helpful.

       

      All that I need is the data to be filtered based on the live connection to user details data and using an extract for real sales data.

       

      Any suggestions to solve this and/or alternate approaches are greatly appreciated.

       

      Many thanks