SAP Business Warehouse (7.3/7.4) on Hana

• Data Modeling - Creating and managing the Info Areas, Info object catalogs, Info Objects, Info cubes, Multi providers, Application components, IS, DS, DSO Objects, Transformations, Migration, Re-Modeling, Object Transportation, DTPâ??s ,Open Hub Destination,  Process Chain  and Managing PSA.
• Data Extraction - LO Cockpit Extraction, Flat File Extraction, Activating and transporting Data sources, deleting contents of setup tables, Customizing and Enhancement of Extract structure and Master Data extractions from R/3 to BI.
• Reporting - front-end Business Warehouse Components like Queries, Variables, Conditions, Exceptions, Filters, Free Characteristics, Restricted Key figures, Calculated Key Figures and RRI.
• Performance Issues -  Aggregates, Indexes, and Compression/collapse.

SAP BW on HANA

Analytical Views,Calculation Views and Composite Providers,Transient Providers, Advanced DSO (ADSO) in HANA Studioextraction of data from Flat file, External data-base, Bw, Ecc, SAP Landscape Transformation (SLT) to HANA Data Base.

       Automation of loads by process chain creation and use of BW Monitor to supervise data loading.

Handing all production failures in process chains which includes incorrect data during DSO activation, Error DTP.

Creating copy cubes, DSOâ??s and transformations for an RFC (Request for change)

Creating Aggregates, Line item dimensions, High cardinality Indexes and DB statistics for query performance.

Creating Master data Attribute & Text Data sources.