Skip to Content

/********* Begin Procedure Script ************/

BEGIN var_oview = CE_OLAP_VIEW(“_SYS_BIC”.”efashion227869/AN_EFAS”,[“ARTICLE_ID”,”SHOP_ID”,”AMOUNT_SOLD”,”YR”]); var_proj2001=CE_PROJECTION(:var_oview,[“ARTICLE_ID”,”SHOP_ID”,”AMOUNT_SOLD”,”YR”],'”YR” = 2001′ );

var_proj2002=CE_PROJECTION(:var_oview,[“ARTICLE_ID”,”SHOP_ID”,”AMOUNT_SOLD”,”YR”],'”YR” = 2002′ );

var_proj2003=CE_PROJECTION(:var_oview,[“ARTICLE_ID”,”SHOP_ID”,”AMOUNT_SOLD”,”YR”],'”YR” = 2003′ );

var_o=CE_UNION_ALL(:var_proj2001,:var_proj2002); var_out=CE_UNION_ALL(:var_o,:var_proj2003); END

/********* End Procedure Script ************/

This is simple projection on a analytic view and it has been unioned to provide a trend of sales for 3 years

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply