Thursday, April 24, 2014

Does SAP HANA Replace BW? (Hint: Still, No.)

This time , I participated in the blog discussion, indeed a topic that can only grow over time.

http://www.saphana.com/community/blogs/blog/2014/04/17/does-sap-hana-replace-bw-hint-still-no#comment-5510

I am particularly interested in the below statement:
  • If you just have ERP as an operational standalone system then put ERP on HANA and use HANA Live
  • If you just need a data-mart alongside ERP then use HANA Enterprise and SLT for real-time replication
  • If you don't have BW and need an EDW then use BW on HANA, preferably with ERP on HANA and HANA Live


Monday, April 14, 2014

A pragmatic BI Vision



BI won’t work without single source of truth, BI governance, evolving innovation, streamlining with backend technology and self-servicing frontend. All these components are inter-related and play a vital role in the BI roadmap .

Monday, April 7, 2014

BW on HANA , how it speeds up things?

The BW OLAP engine has now become the OLAP Compiler for HANA, also known as the Analytic Manager, pushing down further OLAP operations down to HANA provides offering unrivaled query performance. Additional business insights can be achieved by overcoming existing ABAP based limits. A summary of the OLAP features pushed down into the HANA database is summarized below:

OLAP Features pushed down to HANA in BW 7.3x
  • Restricted key figures
  • Exception Aggregation CNT for quantity key figures without unit conversion
  • Exception Aggregation of currency key figures with optional currency conversion

OLAP Features pushed down to HANA in BW 7.4 SP5
  • Avoid intermediate result set materialization (e.g. Exception Aggregation)

OLAP Features pushed down to HANA in BW 7.4 SP6 and beyond
  • Stock coverage Key Figure
  • Hierarchy Handling
  • Formula exception aggregation
  • Processing of further query scenarios in HANA (Joins, Union, etc.)
  • Handling of inventory Key Figures
* Pluck from http://www.agilityworks.co.uk/our-blog/sap-bw-7-4-sp5-on-hana-better-smarter-faster/



Saturday, April 5, 2014

Everything suddenly seems NEW NEW NEW & BIG BIG BIG

I'd been doing some research over the weekend, well what a way to enjoy life but it is interesting yet troubling for me to grasp so many new things happening in SAP technology. And by this I am not just referring to the new kid in town - HANA Studio. 

SAP HANA Cloud Portal

http://www.sweetlets.com/w/2013/06/hana-cloud-portal-from-the-perspective-of-a-test-partner/



Unified development environment for BW via Eclipse

http://www.agilityworks.co.uk/our-blog/sap-bw-7-4-sp5-on-hana-better-smarter-faster/

                                                                  

SAP BW 7.4 Generates HANA Views accessible via SAP Lumira

http://www.youtube.com/watch?feature=player_embedded&v=33PR1w2_pzs










SAP RIVER

I registered for a trial version but the river is always flooded!! But in short , this is the new language to develop web application base on SAP HANA. 




It is mind boggling technology for a lot of  BW/BO Consultants out there. I bet most of them are hoping to play on the ground of  BW 7.4 on HANA now!


Tuesday, April 1, 2014

LSA and LSA++

LSA seems to be a hot BW jargon three years ago where most companies strive to standardize the data modelling design. Of course, I personally believe not all dataflow require LSA , example straight forward data from excel file. But nevertheless, the beauty of LSA is we minimize the risk of losing historical data (PSA then was supposed to have housekeeping and not serve as historical data storage as in LSA++) and changes in transformation layer can be reloaded from propagation layer safely without the need to re-initialize. Plus if we manipulate data in start routine from propagation DSO to transformation DSO , the key figures are not cumulative when looping the source package, unlike start routine between DSO and Infocube. And finally the aggregated data flows up to InfoCube for reporting. There is also Corporate Memory Layer available in DSO W/O to retain historical data.

Ok, with in-memory technology or famously known as HANA, snow flake schema got flatten out. No more SIDs meaning no longer reporting needs  InfoCube, in-memory-optimized DataStore objects, which can be used for reporting. So we now have LSA++. From 4 layers now it's 3 layers. We can also see they brought back 'InfoSource' in the picture, I'd always think InfoSource is useful when it come to 2 steps transformations.The data is acquired in the open operational data store layer. The PSA serves as the historical data foundation. No transformations or aggregations are defined in this layer.The data is then harmonized and transformed to the core EDW layer. The DataSource and the DSOs in the core EDW layer are connected by an InfoSource. A virtual data mart layer is used for reporting. InfoProviders that reside in this layer do not contain any data. Instead, they describe which data is accessed, and how it is displayed semantically to the end user. MultiProviders usually access the data from DataStore objects.