Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Learn HANA over a cup of coffee

Former Member
‎04-19-2012 2:12 PM
0 Kudos

/********* 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

1 Comment
Labels in this area
Popular Blog Posts