5 Replies Latest reply: Oct 18, 2013 9:02 AM by BrandonNeel RSS

    Possible to Exclude a specific intersection from DATAEXPORT?

    BrandonNeel

      Version: 11.1.2.2

       

      Is it possible to Exclude a specific intersection from a DATAEXPORT in an Essbase Calc Script? I am able to exclude a member but I only want to exclude 1 intersection.

       

      Simplified Cube:

      Fund

      Dimension

      Center

      Dimension

      Account

      Dimension

      F1

      C1A1
      F2C2A2

       

      Working export:

       

      FIX (@relative("Fund",0), @relative(Center,0), @relative(Account,0))

             DATAEXPORT "File" "," "F:\TMP\Exp_Central.txt" "#Mi";

      ENDFIX

       

       

      Trying to exclude only the intersection of F2, C1, A1 (i know it doesn't work this way):

       

      FIX (@relative("Fund",0), @relative(Center,0), @relative(Account,0))

        EXCLUDE ("F2", "C1", "A1")

             DATAEXPORT "File" "," "F:\TMP\Exp_Central.txt" "#Mi";

        ENDEXCLUDE

      ENDFIX

       

      desired output:

      F1,C1,A1

      F1,C1,A2

      F1,C2,A1

      F1,C2,A2

      F2,C1,A1 I want this line excluded

      F2,C1,A2

      F2,C2,A1

      F2,C2,A2

       

      This is extremely simplified (I have multiple intersections to exclude, and a large cube) but should adequately pose the question. This process is moving data cube to cube. As an alternative I was thinking on the target cube I could just do a [FIX...CLEARDATA]. I have been searching for an answer and can't seem to find one, can anyone here offer advice?