4 Replies Latest reply: Jul 4, 2014 3:58 AM by Tresesco B RSS

    Section Access - How to prevent data been reduced/deleted from a hierarchy table

    Susann Moennig

      Hi everybody,

       

      my situation is the following:

       

      I have several reference/dimension tables with texts in my datamodel. These texts are often a part of a hierarchy and have no connection to the data table itself, just some of the values.

       

      When I now use section access within the document, the mechanism also reduces the reference table with the texts and my hierarchy does not fully exists anymore.

       

      How can I prevent the data reduction on the dimension/hierarchy tables?

       

       

      star is *;

      section access;

      LOAD * Inline [

      ACCESS,USERID,PASSWORD,COLUMN1

      admin,admin,admin,1

      ];

       

      section Application;

       

      H1:

      Hierarchy(Code,ParentCode, Text,,Text,Tree)

      load * inline [

      Code, ParentCode, Text

      ALL,,ALLE TEXTE

      A,ALL,TEXT_A

      B,ALL,TEXT_B

      C,ALL,TEXT_C

      D,ALL,TEXT_D

      Aa,A,TEXT_Aa];

       

      Data:

      load * inline [

      COLUMN1,COLUMN2,Code

      1,1,Aa

      1,2,B

      1,3,C];