Créateur de présentation | Survey | Quiz | Lead-form Accédez à 1,00,000+ modèles PowerPoint (pour les utilisateurs de SlideServe) - Parcourir maintenant
Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
SAP & SQL Server 2005 Analysis Services Integration PowerPoint Presentation
Download Presentation
SAP & SQL Server 2005 Analysis Services Integration

share
play prev play next
play fullscreen
1 / 71

SAP & SQL Server 2005 Analysis Services Integration

144 Vues Download Presentation
Télécharger la présentation

SAP & SQL Server 2005 Analysis Services Integration

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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)