This discussion is archived
2 Replies Latest reply: Feb 3, 2013 8:01 PM by EsbRookie RSS

XWRITE with Cross-Dimensional Operator

EsbRookie Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Thanks Saurav. Let me try it out and I will update.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points