资源描述
,Click to edit Master title style,Click to edit Master text styles,Second level,Third level,*,SAP BusinessObjects Business Planning and Consolidation Version 10.0 Report Training,Intro,Introduction BPC Basics,Lesson Objectives,2,After completing this lesson,you will be able to:,Explain the BPC Architecture,Explain the basic BPC components,Explain the difference between relational and OLAP systems,3,Introduction BPC Basics,Architecture and Platform Support(MS),4,Introduction BPC Basics,Architecture and Platform Support(NW),5,Introduction BPC Basics,Architecture and Platform Support,Client Support,Windows Vista Client(32 and 64-bit),Windows XP(32-bit)and Windows 7(32 and 64-bit),Internet Explorer 7 and 8(IE9 in Service Pack 7),Microsoft Office 2003,2007,2010,6,A,Model,(formerly known as,“,Application,”,)is one functional unit used for a particular purpose,such as a Budgeting model or Management Reporting model.Models are part of an Environment(formerly known as,“,Application Set,”,).Models may share some dimensions with other Models within the same Environment,and may have some dimensions that are unique to that Model.,An,Environment,(formerly known as application set)is a group of Models.An Environment contains a set of dimensions that may be shared amongst the Models.In SAP BW,an Environment equates to an InfoArea;that is,there is one InfoArea for each Environment.,In order to provide the multi-dimensional aspect of the records contained within the database tables,those records are utilized to create multi-dimensional cubes within BW.The cube provides the ability to aggregate values by the various record fields contained with the data.Additionally,cubes provide the ability to,“,drill,”,on assigned parental reporting elements and analyze lower levels of detail.The parents(determined by the hierarchies)are stored in the cube.,Introduction BPC Basics,BPC Definitions,In a relational database world you have tables,These tables link to data in your main data file/table,7,Introduction BPC Basics,Relational vs OLAP,Similarly the Columns in a relational database represent the axes of a cube,8,Introduction BPC Basics,Relational vs OLAP,Width,ACCOUNT,ENTITY,TIME,And each layer representing a piece of the intersection of data,9,ENTITY,ACCOUNT,18001,19001,20001,TIME,Introduction BPC Basics,Relational vs OLAP,10,ENTITY,ACCOUNT,18001,19001,20001,FIN,FIN,FIN,MKT,MKT,MKT,IT,IT,IT,TIME,And each layer representing a piece of the intersection of data,Introduction BPC Basics,Relational vs OLAP,11,2008.Mar,ENTITY,ACCOUNT,18001,19001,20001,FIN,FIN,FIN,MKT,MKT,MKT,IT,IT,IT,2008.Feb,2008.Jan,TIME,And each layer representing a piece of the intersection of data,Introduction BPC Basics,Relational vs OLAP,I want to look at a particular record or data point(2,105),12,2008.Mar,18001,19001,20001,FIN,FIN,FIN,MKT,MKT,MKT,IT,IT,IT,2008.Feb,2008.Jan,Introduction BPC Basics,Relational vs OLAP,13,2008.Mar,18001,19001,20001,FIN,FIN,FIN,MKT,MKT,MKT,IT,IT,IT,2008.Feb,2008.Jan,I want to look at a particular record or data point(2,105),Introduction BPC Basics,Relational vs OLAP,I want to look at a particular record or data point(2,105),This point resides within the Cube,14,2008.Mar,FIN,MKT,IT,FIN,MKT,IT,2008.Feb,18001,19001,20001,FIN,MKT,IT,2008.Jan,2105,Introduction BPC Basics,Relational vs OLAP,15,Introduction BPC Basics,BPC Client Components,BPC Admin Consol,Configures BPC Environments,Manages Models,Manages Dimensions,Builds Calculations,BPC Web Interface,Reporting,Advanced Variance Analysis,Consolidation Manager,Journals,EPM Add-In For Office,Reporting,Data Input,Data Management,16,Introduction BPC Basics,Lesson Objectives,You should now be able to:,Explain the BPC Architecture,Explain the basic BPC components,Explain the difference between relational and OLAP systems,
展开阅读全文