3 Replies Latest reply: Nov 12, 2015 10:42 AM by Dimitri Obrant RSS

    DD & section access problem

      I use DD and section access. I find one problem .

       

      the DD script:

      DIRECT QUERY

         dimension

          KEY_IOD

      //    key_gof,

      //    key_stock

         measure

          ActualQty

         detach

          SizeName

      //    NATIVE('cast(SizeName  as varchar(20))') as SizeName 

         detail

          UpdateDate

      FROM TestData.dbo."Inv_Material";

       

      My section access is related to KEY_IOD and no relation with SizeName.  

          I open the file in IE client like accesspont . It is ok.

          I open directly in computer . The SizeName disappear as the pic1. If I reload it ,it is ok .

       

      I know the section access cause this problem . How to solve it  ?