1 / 71

SAP & SQL Server 2005 Analysis Services Integration

SAP & SQL Server 2005 Analysis Services Integration. Microsoft Corporation SAP-Microsoft Competence Center (Tokyo). Landscape. SAP. Reporting on Web browser. SAP R/3 Enterprise 4.7. Master (Product). Master (Customer). Master (Product type). Master (Region).

roshaun
Download Presentation

SAP & SQL Server 2005 Analysis Services Integration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SAP & SQL Server 2005Analysis Services Integration Microsoft CorporationSAP-Microsoft Competence Center (Tokyo)

  2. Landscape SAP Reportingon Web browser SAP R/3Enterprise 4.7 Master(Product) Master(Customer) Master(Producttype) Master(Region) Multi dimensionaladd-hoc analysison Excel Pivot table Master(Product) Master(Customerall) Master(Country) * Major : Sales* Dimension : Product, Customer, Time Master(Producttype) Transaction(Sales all) Transaction(Sales header) Transaction(Sales detail)

  3. Data source(on SQL Server) retrieved from SAP (by Integration Services) for customer dimension (on Analysis Services)

  4. Data source(on SQL Server) retrieved from SAP (by Integration Services) for product dimension (on Analysis Services)

  5. Data source(on SQL Server) retrieved from SAP (by Integration Services) for product dimension (on Analysis Services)

  6. Data source(on SQL Server) retrieved from SAP (by Integration Services) for sales cube (on Analysis Services)

  7. Goal:Sales analysis on Excel pivot table

  8. Goal:Sales analysis on Excel pivot table

  9. Goal:Sales analysis on Excel pivot table

  10. Procedure • Defining data source and data source view • Creating customer dimension • Creating product dimension • Creating time dimension • Creating sales cube • Browsing dimensions and cube • Browsing cube on Excel

  11. 1. Defining data source and data source view (1)

  12. 1. Defining data source and data source view (2)

  13. 1. Defining data source and data source view (3)

  14. 1. Defining data source and data source view (4)

  15. 1. Defining data source and data source view (5)

  16. 1. Defining data source and data source view (6)

  17. 1. Defining data source and data source view (7)

  18. 1. Defining data source and data source view (8)

  19. 1. Defining data source and data source view (9)

  20. 1. Defining data source and data source view (10)

  21. 1. Defining data source and data source view (11)

  22. 1. Defining data source and data source view (12)

  23. Procedure • Defining data source and data source view • Creating customer dimension • Creating product dimension • Creating time dimension • Creating sales cube • Browsing dimensions and cube • Browsing cube on Excel

  24. 2. Creating customer dimension (1)

  25. 2. Creating customer dimension (2)

  26. 2. Creating customer dimension (3)

  27. 2. Creating customer dimension (4)

  28. 2. Creating customer dimension (5)

  29. 2. Creating customer dimension (6)

  30. 2. Creating customer dimension (7) Drag each attribute (one by one) to create a hierarchy

  31. Procedure • Defining data source and data source view • Creating customer dimension • Creating product dimension • Creating time dimension • Creating sales cube • Browsing dimensions and cube • Browsing cube on Excel

  32. 3. Creating product dimension (1)

  33. 3. Creating product dimension (2)

  34. 3. Creating product dimension (3)

  35. 3. Creating product dimension (4)

  36. 3. Creating product dimension (5)

  37. 3. Creating product dimension (6)

  38. 3. Creating product dimension (7) Drag each attribute (one by one) to create a hierarchy

  39. Procedure • Defining data source and data source view • Creating customer dimension • Creating product dimension • Creating time dimension • Creating sales cube • Browsing dimensions and cube • Browsing cube on Excel

  40. 4. Creating time dimension (1)

  41. 4. Creating time dimension (2)

  42. 4. Creating time dimension (3)

  43. 4. Creating time dimension (4)

  44. 4. Creating time dimension (5)

  45. Procedure • Defining data source and data source view • Creating customer dimension • Creating product dimension • Creating time dimension • Creating sales cube • Browsing dimensions and cube • Browsing cube on Excel

  46. 5. Creating sales cube (1)

  47. 5. Creating sales cube (2)

  48. 5. Creating sales cube (3)

  49. 5. Creating sales cube (4)

  50. 5. Creating sales cube (5)

More Related