Categories Uncategorized SAP HANA Idea Incubator – Hana & exception Aggregation June 20, 2014 | 216 Views | Koen Hesters more by this author SAP HANA Databaseexception aggregationhanaidea incubatorsapsap hana share share tweet share like 0 Follow Hi Hana-guru’s, I’m making my first steps in Hana developments in the hana studio and I’m quiet struggling with the need of having exception aggregation on my key figures. Does someone know a good way how to treat this? Grtz Alert Moderator To report this post you need to login first. 8 Replies 8 Comments You must be Logged on to comment or reply to a post. Lars Breddemann June 20, 2014 at 11:33 am Hi Koen there is no equal feature available in SAP HANA modeling. Depending on your actual requirement you can create a similar aggregation with scripted calc. views. Window functions are popular examples here. So, if you provide more information on what precisely you want to achieve, we might be able to give you hints. – Lars like (0) Koen Hesters Post authorJune 20, 2014 at 11:36 am Hi, I’m afraid so, I added it in the ideaplace. Grtz Koen like (0) Lars Breddemann June 20, 2014 at 11:49 am Hmm… well, the point for SAP is not to replace every OLAP feature with a similar feature in SAP HANA. Currently SAP HANA and SAP BW will continue to exist in parallel and I am not aware of any changes to this planning in the short/medium term. As I said: let us know what kind of modelling problem you face and you’ll surely get input to that here. – Lars like (0) Koen Hesters Post authorJune 20, 2014 at 11:52 am Hi Lars, I understand, but in our case we are doing a POC of replacing BW with Hana (ECC on Hana). For Purchasing I had to combine data from Header, Item, Item History and HR data together. I managed to do so by “aggregating my data to Item level” But it would be nice to stay on account assignement level and have an exception aggregation on my net value on item level. Grtz Koen like (0) Lars Breddemann June 20, 2014 at 11:59 am And that is something that you can achieve on different ways. E.g. you can have two separate aggregation “channels” in your calc. view – one that aggregates on item level and one that keeps your account assignment aggregation. Using JOIN/UNION you can re-combine the data before the final output. As you are definitively not the first “we replace SAP BW with HANA” project, I reckon you will find plenty answers to your questions here. – Lars like (0) Former Member July 7, 2014 at 10:14 pm Just FYI, thought this article from Ravindra Channe on exception aggregation might be relevant: Exception aggregation modeling with Graphical Calc view like (0) Koen Hesters Post authorJuly 8, 2014 at 9:38 am Hi Jody, Thanks, it is indeed a very good article about this idea. But his conclusion is that his solution is not the ideal solution. So it strongest my point, that there is an interest for this feature and it would be a great advantage to have it working smoothly. Grtz Koen like (0) Koen Hesters Post authorSeptember 19, 2014 at 8:46 am Now I’m playing with Design Studio directly on Hana and nice features as : Conditions, Customer exit variables are really hard to replace. I hope SAP will add this to the DS on Hana- flow. I wonder where SAP will add those features, will Hana be more BI frontend enabled or will DS develop in more than just a new WAD. Exciting times 🙂 like (0) Leave a Reply Cancel replyYou must be logged in to post a comment.