1 Reply Latest reply: Jul 5, 2013 7:45 AM by niranjan RSS

    Section access - choose data and values

      I have some few questions:

       

      Lets assume i have two tabs:

       

      Tab 1: Includes my  hidden script

      Tab 2: Includes all my dimensions and facts

       

       

      Now i want to create section access based on some values from a dimension. Here i got some problems understanding how it relates to my dimension.

       

      Lets take my hiddenscript tab:

       

      Section Access;

      LOAD * INLINE [

          ACCESS, USERID, PASSWORD, OptionText

          admin, admin, admin, *

          user, hans, 1234, Open

          user, gert, 1234, Closed

      ]; 

      Section Application;

       

      It looks like this:

      I want hans to see Open and gert to see only Closed.

       

      Optiontext is from my Dimension: DimSalesStatus

      which looks like this:


      QUALIFY*;

      UNQUALIFY SalesStatusKey;

      DimSalesStatus:

       

       

      LOAD SalesStatusKey,

          OptionID,

          OptionText;

      SQL SELECT *

      FROM DW.dbo.DimSalesStatus;

      UNQUALIFY*;

       

       

      My questions is then - How should my section access script really look like to filter on open and closed for gert and hans?

       

      Section Access;

      LOAD * INLINE [

          ACCESS, USERID, PASSWORD, OptionText

          admin, admin, admin, *

          user, hans, 1234, Open

          user, gert, 1234, Closed

      ]; 

      Section Application;

       

      and then what?

       

      Cheers

       

      Thomas