2 Replies Latest reply: Feb 3, 2013 10:01 PM by EsbRookie RSS

    XWRITE with Cross-Dimensional Operator

    EsbRookie
      Hello,

      I am not able to get the below code working:


      SET COPYMISSINGBLOCK OFF;
      FIX(SparseD1,SparseD2,SparseD3,SparseD4,@DESC(SparseD5),@DESC(SparseD6))

      Dense1Mbr(

      @XWRITE(SparseD5_Mbr0->SparseD6_Mbr0->"No Year",@loopback,&BudYear);

      );

      ENDFIX;

      I am using this code to create blocks. I am copying flags from sparse dim5_Mbr0, sparse dim6_Mbr0, and No Year to all the intersections in dim5,dim6, and Budget year.

      I tried this code without -> operator and it works fine. When I check the application log for the above query it shows 0 blocks read.

      Any pointers? XWRITE works with cross-dimensional operator?

      Thanks,

      Nitin
        • 1. Re: XWRITE with Cross-Dimensional Operator
          SauravSarkar
          HI nitin,

          Xwrite dows not suppport cross dimensional operators .

          You can try this code .


          SET COPYMISSINGBLOCK OFF;

          FIX(SparseD1,SparseD2,SparseD3,SparseD4,SparseD5_Mbr0,SparseD6_Mbr0,Dense1Mbr)

          @XWRITE("No Year",@loopback,&BudYear);/* copies the block from No year to BudYear*/

          ENDFIX;

          FIX(SparseD1,SparseD2,SparseD3,SparseD4,Dense1Mbr,&BudYear)

          FIX(@RELATIVE(SparseD5,0))
          @XWRITE(SparseD5_Mbr0,@loopback,SparseD6_Mbr0); /* creates all blocks for all level 0 members of Dimension SparseD5 at SparseD6_Mbr0 */

          FIX(@RELATIVE(SparseD6,0))
          @XWRITE(SparseD6_Mbr0,@loopback,);/* creates all blocks for all level 0 members of Dimension SparseD6 for SparseD5*/
          ENDFIX
          ENDFIX
          ENDFIX





          Regards,
          SS
          • 2. Re: XWRITE with Cross-Dimensional Operator
            EsbRookie
            Thanks Saurav. Let me try it out and I will update.