!"#$%&##'(%)&**$+&%,&-'./"0#&'12&02$&3'4$5+056' !"#$%&
SAP AG 2006
© SAP AG
!
TERP10
15-3
!"#$%&##'(%)&**$+&%,&- !"#$%&##'.,&%/0$1
! 21"0',134/%5'6/#'$7&%)$8$&7'/'%&&7'810'"#&0#')1' /,,&##'/%7'0&,&$9&'0&410)#'8013'1%&'$%)&+0/)&7' !"#$%&##'#1"0,&:'
SAP AG 2006
© SAP AG
!
TERP10
15-4
!"#$%&##'(%)&**$+&%,&- ./0$,'123&,)$4&#
=)')8&',/%,*"#$/%'/;')8$#')/0$,A'B/"'C$**'2&'72*&')/! 560*7$%')8&'27#$,',/%,&0)#'7%9'7:,8$)&,)":&'/;' <=>'!"#$%&##'(%;/:?7)$/%'@7:&8/"#&''
SAP AG 2006
© SAP AG
!
TERP10
15-5
!"#$%&##'(%)&**$+&%,&-'(%./012)$/%'320&4/"#&
!"#$%&'!()*&+)
156789:8
! ! ! !
!"#$%&##'B/%)&%) CA78'9%+$%& 7")/12)&D'320&4/"#& 6)2%D20D$E&D'6)0",)"0&#
;/%<678
678'!3
!"#$%&##' 9=>*/0&0
?@A
F2)2G2#&
F2)2G2#&
 SAP AG 2006
!
!
The !"#$%&$allows you to analyze data from operational !"#$'()$applications or any other business application. You can also extract and analyze data from external sources such as databases, online services, and the Internet.
!
The system (data storage, loading and reporting), which is preconfigured by Business Content for core areas and processes, allows you to examine the relationships in every area of your company.
!
The realization of !"#$%&$aimed for the following: (1) data warehousing system with optimized data structures for reporting and analysis, (2) separate system, (3) OLAP engine and tools, (4) comprehensive data-warehousing architectural base, (5) automated data warehouse management, and (6) preconfiguration using SAP global business know-how.
!
With these goals in mind, SAP has opted for a separate data-warehousing solution that handles reporting activities as an autonomous business component, even providing a separate server with its own database and SAP system: !"#$%*+,-.++$/-012345,1-$&42.61*+..
!
All of the requirements and objectives mentioned so far have been met in the conception and architecture of !"#$%&. Having implemented !"#$%&$and its metadata repository (description of data), the customer has the clear advantage of being able to use the entire SAP know-how built up over the many years of experience in developing business software solutions. !"#$'()$systems can be configured as source systems, and provide data for all SAP Business Content.
Š SAP AG
TERP10
15-6
!"#$%&##'(%)&**$+&%,&-'.&/0$%1*1+2 O##$+%0&%)'"#$%+'):&'OP!
(%31456&,)# 9:;/;,)&/$#)$,# ! ! ! ! ! ! !
7&2'8$+"/&#
E$>$#$1% =&+0&%) F/1B",) F/1B",)'*$%& =&+0&%) !"#$%&##'G%$) 910H;%2
! ! ! ! ! !
<&)'=;*&# >;/$;5*&'94?= 91%)/$5@ A;/+$% ( =;*&#'4>&/:&;B C'D'E'4>&/:&;B @@@
(3';',:;/;,)&/$#)$,'I31/'&J;0H*&K'L$H',1B&M'$#';##$+%&B')1';%1):&/',:;/;,)&/$#)$,'I31/' &J;0H*&K'#1*BN)1'H;/)2MK'):&'3$/#)',:;/;,)&/$#)$,'5&,10&#';%';))/$5")&'13'):&'#&,1%B
O'B;);'/&,1/B'IH1#)$%+'/&,1/BM'$#';',105$%;)$1%'13',:;/;,)&/$#)$,#';%B'Q&2'3$+"/&#
910H;%2
F/1B",)'*$%&
TUUU
81$*#
F/1B",) STUUUU
<&)'=;*&# R
TKUUU'VGC
 SAP AG 2006
!
"#$%&'()*+! "
Business analysis-objects (companies, sales volumes, and so on) are called InfoObjects in !"#$%&. These InfoObjects can be divided into characteristics and key figures. Characteristics can be further divided into units, time characteristics, and technical characteristics (for example, request ID). Key figures are all data fields that are used to store values or quantities (sales volumes, net sales, costs, and so on). Characteristics describe the affiliation of key figures.
Š SAP AG
TERP10
15-7
!"#$%&##'(%)&**$+&%,&-'.&/0$%1*1+2'341%)$%"&56 (%?1'4"8&'@$)A'./:%#:,)$1%'B:):' 3C&2'9$+"/&#6
F:#)&/'B:):'?1/'GH1*5I.1'J:/)2G
7))/$8")& K
==
9:,)'.:8*& ;< >>>>>>>>>>>>>>>>>> .&D)# K
== L >>>>>>>>>>>>>>
;<
K >>> >>>>>>>>>>>>>> E$&/:/,A$&#
C&2# K H$0M*$?$&5'5&M$,)$1%'1?')A&'#):/'#,A&0:' @$)A'*$%N#')1'0:#)&/'5:):  SAP AG 2006
!
"#$%&'()! !
The central data containers that form the basis for reports and analyses in !"#$%&$are called InfoCubes. They contain key figures (sales volumes, incoming orders, actual costs, and so on) and a link to the characteristics (master data of the !"#$%&$system such as cost centers, customers, materials, and so on). Key figures and characteristics are InfoObjects. Each individual InfoCube should contain a self-contained dataset, since queries refer primarily to one InfoCube.
!
Master data in the BW system consists of attributes of a characteristic (for example, the person responsible for a cost center), as well as hierarchies and texts of a characteristic.
!
An InfoCube consists of several database tables that are linked according to the star schema. They include a fact table that contains the InfoCube key figures, as well as several surrounding dimension tables that store the links to the characteristics.
!
Each InfoCube has one fact table and a maximum of 16 dimension tables.
!
Each fact table can contain a maximum of 233 key figures.
!
A dimension can contain up to 248 freely available characteristics.
!
InfoCubes are stored in structures in the !"#$%&$system. If you want to store an InfoCube, you create a new folder or use an existing one. This is similar to the method used when storing data on your PC: These folders are called InfoAreas in !"#$%&.
Š SAP AG
TERP10
15-8
!"#$%&##'(%)&**$+&%,&-'.&/0$%1*1+2'(Continued) 342#$,5*'65)5'7)1/&# 8&2'9$+"/&#
:45/5,)&/$#)$,# .&C)#
!5#$#' :"F&
;1+$,5*'<$&=#'1>'?42#$,5*'@5)5'#)1/&#'$%,*"@&(%>17&) A"&/$&# E$/)"5*' (%>1 :"F&#
G))/$F")&# H$&/5/,4$&#
I67
71"/,&' 72#)&0
D&01)&' :"F&#
J"*)$'3/1<$@&/#
D&?1/)$%+
!"#$%&##'BC?*1/&/
 SAP AG 2006
!
"#$%&'%()*+'! !
InfoProvider is the super-ordinate term for an object that you can use to create reports in Business Explorer (BEx). InfoProviders are objects or views that are relevant to reporting. InfoProviders include various database metaobjects that deliver data for query definitions. The type of data procurement differs depending on the InfoProvider used. However, the type of data procurement has no influence on reporting. InfoProviders deliver data that can be analyzed using a query.
!
There are two types of data stores. Physical stores include (1) BasicCubes, (2) ODS Objects, and (3) InfoObjects. Logical views of physical data stores include (1) InfoSets, (2) RemoteCubes, (3) VirtualInfoCubes, and (4) MultiProviders. The previous figure gives an overview of !"#$%&$ reportable objects, divided into data targets that contain physical data, and InfoProviders that only contain logical views. From the BEx view, only InfoProviders are accessed. The way in which the data is modeled is inconsequential to the BEx toolset.
,-+'./)%#.0!1./.!2/%'+!3,124! !
An ODS, a data store, stores data at the basic level (document level). It is normally used to resolve and consolidate datasets. These datasets are often from various data sources and/or source systems
5*6)#)7/'./%'!8%'9:+#;<!358=4! !
Administrator Workbench (AWB) is a workplace for SAP BW administrators. AWB functions are used to configure, control, and administrate SAP BW.
Š SAP AG
TERP10
15-9
*+,%&),,'-&")..%$)&/)0 12/3%")/"+2) <52"#.' -&")$2#"%5&
1A>%&%,"2#"52' ?52F7)&/3
*+,%&),,' (EC.52)2
@)"#A#"# B)C5,%"52= @#,")2'9#"#
8D1<
-&45 6+7)
!"#$%&$'(&$%&)
!1< !=,")>,
!1<'*?
89!
:5&;!1<'!=,")>,
 SAP AG 2006
!
!
!"#$%&$enables the analysis of data from operative SAP applications as well as all other business applications and external data sources such as databases, online services, and the Internet.
!
AWB functions allow you to control, monitor, and maintain all data procurement processes.
!
!"#$%&$enables Online Analytical Processing (OLAP) for staging information from large amounts of operative and historical data. OLAP technology permits multi-dimensional analyses according to various business perspectives.
!
The BW server, which is preconfigured by Business Content for core areas and processes, allows you to examine the relationships in every area within your company. Business Content provides targeted information to companies, divided into roles. This helps your employees to carry out their tasks. As well as roles, Business Content includes other preconfigured objects such as InfoCubes, queries, key figures, and characteristics. These objects facilitate the implementation of !"#$%&.
!
The %'()*+(($,-./01+1$2%,-3$component provides users with extensive analysis options.
Š SAP AG
TERP10
15-10
!"#$%&##'(%)&**$+&%,&- ./0$,'1"22345
?/"'34&'%/@'39*&')/! 670*3$%')8&'93#$,',/%,&0)#'3%:'34,8$)&,)"4&'/;' 1<='!"#$%&##'(%;/423)$/%'>34&8/"#&''
SAP AG 2006
© SAP AG
!
TERP10
15-11
!"#$%&##'(%)&**$+&%,&- ./0$,'123&,)$4&#
;)')8&',/%,*"#$/%'/=')8$#')/0$,C'B/"'9$**'2&'72*&')/! 560*7$%'8/9':;<'!"#$%&##'(%=/>?7)$/%'@7>&8/"#&' >&0/>)$%+'7%A'7%7*B#$#')//*#'#"00/>)')8&'A$==&>&%)' 2"#$%&##'0>/,&##&#'''
SAP AG 2006
© SAP AG
!
TERP10
15-12
!"#$%&##'(%)&**$+&%,&- .&/01)$%+ 20+$,3*'3%4'567#$,3*'(%805109$4&1# $%'!:
F2=5 !"#$%&##';</*01&1 !;< =%3*7>&1' ?@$,10#08)';<,&*'01' @A'(%)&1%&)';</*01&1B
:&C'=//*$,3)$0%'
D01E3))&4'.&/01)$%+
@0C$*&'$%)&**$+&%,&
35.000,00 EUR 30.000,00 EUR 25.000,00 EUR 20.000,00 EUR
Auftragseingang
15.000,00 EUR 10.000,00 EUR 5.000,00 EUR - EUR
Becker Berlin
Bayer
VW
Daimler
501)3*'(%)&+13)$0%
 SAP AG 2006
!
!
!"#$is the %&'$!($component that provides flexible reporting and analysis tools that you can use for strategic analysis and supporting the decision-making process in your company. Employees with access authorization can analyze historical and current data at differing levels of detail and from different perspectives.
!
!"#$allows a wide spectrum of users to access information in %&'$!(. This can be done in Enterprise Portal from an iView that you can call alongside the applications where you extract the data, in the Internet or Intranet (Web Application Design), or using a mobile device (for example, WAP-enabled mobile telephones, and personal digital assistants). Web Application Design allows you to implement generic OLAP navigation in Web applications and in Business Intelligence cockpits for both simple and highly-individual scenarios. Highly individual scenarios with customerdefined user interface elements can be realized using standard markup languages (HTML) for example. Web Application Design encompasses a wide spectrum of interactive Web-based Business Intelligence scenarios that you can modify to suit your requirements using standard Web technology.
!
"#$%&'!()%*+$&%,#)!includes (1) single point of entry, (2) role-based staging of information, (3) personalization, (4) publication of iViews, and (5) integration of unstructured data. -.*$/0! 1*2#$%,)+0!&)3!4)&'/5,5!include (1) query design using the BEx Analyzer, (2) multi-dimensional (OLAP) analysis, (3) geographical analysis, (4) ad-hoc reporting, and (5) alerts. 6*7!422',8&%,#)! 9*5,+)!includes (1) interactive analytical content, (2) information cockpits and dashboards, (3) basis for creating analytical applications, (4) creation of iViews for a portal, and (5) wizard-help.
Š SAP AG
TERP10
15-13
!"#$%&##'(%)&**$+&%,&-'./0'!12-'3455#&'6"&78 EC 37&<)&'%&@'F"&78
DC BC
957:;55:# 6"&7$&# .<=&>'?$&@# 12,&A)$5%#'
 SAP AG 2006
!
!
Using the !"#$%&$reporting functions, you can evaluate a dataset from an InfoProvider according to various characteristics and key figures. To do this, you define a query for your chosen InfoProvider in the %'($)*+,-$.+/012+,. By selecting and combining the InfoObjects in a query, you determine the way in which data from the chosen InfoProvider is evaluated.
!
You have various options for calling up the Query Designer: From the %'($"234-5+,$open dialog box; As a separate program using !63,6$ !#,71,38/$ !%*/02+//$'(947,+,$ !)*+,-$.+/012+,:$ Using the &+;$"9940<36072$.+/012+,$(see the %'($&+;$"9940<36072$.+/012+,$unit); With Crystal Reports (Crystal Reports >=8.5 including CR add-ons for SAP).
!
"#$!%&$'!()*+,-!.,/!0!If you choose to access the Query Designer from the BEx Analyzer, the !"#$%'(=$>?77/+$)*+,-$dialog box is called before the Query Designer opens. This dialog box is context sensitive, which means that it offers different choices depending on the type of object selected.
!
%12$34!"5&$: ()*+,-!.,/!67*)+*1+$8!(1)!Workbooks: History, Favorites, Roles, (2) Queries: History, Favorites, Roles, InfoAreas, (3) Stored Query Views: History, Favorites, Roles, InfoAreas, and (4) Exceptions: History, InfoAreas
!
Within the relevant dialog box, you have the option of creating a new query or of finding and selecting an existing query. You can then change or execute the query.
Š SAP AG
TERP10
15-14
()*+,-**./,0-11+2-,3-4 56-70+,2.7.8)-69
Structure Key Figure Dimensions Technical Charact. Organization Sales area Value Type Time Unit Data Package …
!"
%"
&"
#"
$"
'"
SAP AG 2006
!
!
To define a new query, start the !"#$%&'#()*+#$&and choose ,#-&!"#$%.&&In the ,#-&!"#$%/&0#1#23& 4+567$68)9#$&dialog box, select the required InfoProvider. Once you have selected the InfoProvider, the Query Designer displays as shown in the graphic.
!
The Query Designer is divided into "#$!subareas: 1.%#&'()*&+!)&''!*,!)-'!"'.'()'/!01,*2&*3#/'& Once you have selected the required InfoProvider, all available objects (dimensions, key figures, structures) display in the directory tree in the left screen area of the Query Designer. In this example, you can see the directory tree for the InfoProvider 4+56:";#&:"(36<#$&:";#&=>0''?@AB; 2. 4*.561"!7!You define the columns of your report in this area; 3. 8*9"!7!You define the rows of your report in this area; 4. :&''!4-;&;()'&#")#("!7!You transfer those characteristics into the free characteristics area that do not display in the initial view of the results when you execute the query in the BEx Analyzer or on the Web. You can then integrate these characteristics into the results through navigation steps. You can also use free characteristics for selecting filter values in the report; 5. :#.)'&!7!The characteristics displayed in the filter appear neither in the drilldown nor as free characteristics in the query analysis. These characteristics are only used as global filters on the InfoCube data. It is possible to use a filter a key figure, even in combination with characteristics; and 6. 2&'3#'9!(displayed in gray on the screen) This area gives a preview of the query results area. To create a query, you can expand or collapse the InfoProvider directories by choosing the plus or minus symbol. By expanding the key figure node in the InfoProvider tree, for example, you can display a list of all the key figures of the InfoProvider.
.
© SAP AG
TERP10
15-15
)*+,-.++%/-0.11,$.-2.3%4*."5 !.+,$-."67.8 4*."5
No. Document Items Invoiced Quantity Sales Volume Net Sales Technical Charact. Customer Organization Company Division Product Product line Segment Sales Area Document Classification Time Unit Data Package
Sales Volume (Net Value)
!"#$%&%!"'(
Company A Company B
SAP AG 2006
!
Using Drag & Drop, drag the selected objects of the InfoProvider tree to the appropriate subarea, ex. !"#$, %"&'()$ or *+,,-%./+/01,+2$120$ in the right-hand screen area of the screen.
© SAP AG
TERP10
15-16
./0&("00)1(%"##&2"($"3 4&#%"+&(2)5-%-)&()%6")7/"+8) 5"*&(&%&'( !"#"$%&'()*'+),-%"+&-# Selection
Value Range
I: !"#"$%)0&(2#")@-#/"0) '+)-)@-#/")+-(2"
J: C"0%+&$%)@-#/") +-(2"
Between
E: !"#"$%)6&26#&26%"=)@-#/"0) /0&(2)5+-2F5+'>)'+)/0&(2) %6")-++'G
Casing
Blank
100777004
?: !"#"$%)</#%&>#")@-#/"0)/0&(2) ABCD)-(=)#"*%)<'/0");/%%'( OK
9: !"-+$6);8)%"$6(&$-#) (-<")'+)="0$+&>%&'(
Cancel
H: B+-(0*"+)0"#"$%"=) @-#/"0
 SAP AG 2006
!
The figure shows the selection dialog box for the !"#$%&"'(characteristic. It is often necessary to restrict (filter) characteristics to specific characteristic values in your reports. For example, if you are interested in the sales volume of a particular branch of a worldwide corporate group, but the InfoProvider contains the sales volume for the entire organization, you can restrict the query definition to the relevant branch, so that only the key figure for this branch appear in the report. You can restrict (filter) the characteristic values of a characteristic in the )*+,-(.*'/01,-(2%$$( 34"%"3#$%&,#&3,-(and 2&'#$%(areas of the Query Designer. There are "#$!ways of restricting characteristics: 1. By selecting a characteristic from the InfoProvider of the characteristic (in the tree structure in the left part of the screen) and doubleclicking on the 5"'/$,(icon, the selection menu for fixed values displays. You can select single values or values from a value area. The fixed values selected appear in the directory tree under 5"'/$,. You can use Drag&Drop to include these in your query definition. 2. You can also restrict a characteristic that you have already included in the definition. Call the context menu for the characteristic and choose )$,#%&3#. The 6$'$3#&*1(7*%(888(dialog box appears. You can find all of the characteristic values available for the chosen characteristic in the left screen area. The right screen area contains the characteristic values that you want to use to restrict the characteristic. To select a characteristic value, highlight the relevant value in the left screen area. You can select single or multiple characteristic values. Using the 91:/#(field in the lower left area of the selection dialog box, you can find specific characteristic values by entering their description or technical name. The found values are then automatically highlighted. You can then use Drag&Drop to move the highlighted values into the right screen area. Alternatively, you can transfer the selected values using the arrow. If you want to remove the restriction, simply reverse the procedure.
Š SAP AG
TERP10
15-17
!"#$%&##'(%)&**$+&%,&- (%,*".$%+'/&0)'1*&2&%)#'$%'!10' 3%4*56&7'8&9:7)# ;';';' <$#9*45')&0)'&*&2&%)# ;';';'
K45:")
3** L&%&74*M$*)&7#N47$4O*&# /&0)'&*&2&%)#
="#):2&7 >4)&7$4* <$?$#$:% ="#):2&7 3 !
@7:.A*$%& B C B D
EFFG' E H I E
EFFJ I I I H
 SAP AG 2006
!
You have the option of displaying different text elements as additional information in a query (for example the author, last changed by, InfoProvider, etc.). These text elements are referred to as the header information of the query. Choose!"#$%&'and ()*+,"#'-./&'0,.1.2&*. You can either display ",,'or individual (3.2.4",5'6),&.4*5' 7"4)"8,.*) text elements. The text elements are displayed between the filter cells and the results area. You can move or delete individual text elements by moving or deleting the corresponding cells using 9):4$*$;&'0/:.,'menu functions. "#$%&'&()*'!*+!(,-!.-#(!"%-/-'(01!!234!56(,*71!User who defined the query. (2) 8&0(!9,&':-;! <=1!User who last changed the query definition. Navigation steps are not recorded as changes to the definition. (3) >'+*?7*@);-71!InfoProvider whose data is evaluated in the query. (4) A6-7=! .-B,')B&%!C&/-1!Technical name that you entered when you saved the query. (5) D-=!E&(-1! Contains the date for which the ()/-F;-$-';-'(!/&0(-7!;&(&!is selected. You create a key date either in the query definition (in Query Properties) or provide the value using a variable. If no key date has been defined, the system date is taken as the key date. (6) 9,&':-;!5(1!Date and time at which the query definition was last changed. (7) G(&(60!*+!E&(&1!Time at which the data from the last request was posted to the InfoProvider. This can be evaluated for reporting. C*(-1!For H6%()?7*@);-70, the current InfoPackages are determined from the individual BasicCubes and from there, the one with the *%;-0(!;&(-!is referred to for the status of the data. (8) 9677-'(!I0-71!User who currently has the query open or who has inserted it into a workbook. (9) 8&0(!J-+7-0,-;1!Data and time at which the query data was last refreshed. This is the time when you displayed the text elements (the system has to refresh the query in order to display the text elements). (10) K&7)&<%-0L! M)%(-7!K&%6-0L!9*';)()*'0L!"#B-$()*'01!Depending on the current query definition, additional text elements (variables, filter values, conditions, and exceptions) may also display.
Š SAP AG
TERP10
15-18
!"#$%&##'(%)&**$+&%,&- .$%/$%+ 0'1"&23
TERP10 contri. margin schema GRX##
Created or Changed
Last 7 Days 17.12.2004
17.01.2005
 SAP AG 2006
!
!
In order to find a query for which you already know a part of the description or other information, choose !"#$%&&&
!
In the '()*+,&-.*&/0(*"(1&dialog box, enter the technical name or description of the query. If necessary, you can restrict the search to additional criteria. Choose !"#$&.
!
If you are in the BEx Analyzer and have called the search function from the 2,..1(&/0(*3&dialog box, the query result displays as an Analyzer report.
!
If you are using the search function from the Query Designer, the query definition displays.
Š SAP AG
TERP10
15-19
!"#$%&##'(%)&**$+&%,&-'.&/ 0"&12
3$1#)'0"&12
4156",)'*$%&
7&2'3$+"1&#
4156",)'*$%&
8&)'#9*&#
85/*&'H&)9*
C:C<GBC=EE'?@A
85/*&'+9# 35$*#
BC<DDE=DF'?@A ::;<;;;=:>'?@A
SAP AG 2006
!
!
To publish the query on the Web, save it and choose Display Query on the Web . The query displays in a standard Web template. You can change the standard Web template, if required.
© SAP AG
TERP10
15-20
!"#$%&##'(%)&**$+&%,&- ./0$,'1"22345
@/"'34&'%/9'3?*&')/! 670*3$%'8/9'1:;'!"#$%&##'(%</423)$/%'=34&8/"#&' 4&0/4)$%+'3%>'3%3*5#$#')//*#'#"00/4)')8&'>$<<&4&%)' ?"#$%&##'04/,&##&#'''
SAP AG 2006
© SAP AG
!
TERP10
15-21
!"#$%&##'(%)&**$+&%,&- .%$)'/"00123
@9"'12&'%9?'18*&')9! 456*1$%')7&'81#$,',9%,&6)#'1%:'12,7$)&,)"2&'9;' /<='!"#$%&##'(%;9201)$9%'>12&79"#&' ! 456*1$%'79?'/<='!"#$%&##'(%;9201)$9%'>12&79"#&' 2&692)$%+'1%:'1%1*3#$#')99*#'#"6692)')7&':$;;&2&%)' 8"#$%&##'629,&##&#
SAP AG 2006
© SAP AG
!
TERP10
15-22
!"#$%&'#'( )*&+,(-.'&*#''(/*+#00&1#*%#( 234&%,(5$#6+#(6(7.#$8(9#43$+( At the conclusion of this exercise, you will be able to: â&#x20AC;˘ Create a BEx query report and analyze the results
In order to evaluate the data from an InfoProvider, you require queries that are tailored to your individual requirements. You have been given the task of creating these query definitions.
1-1
You are interested in finding out the net sales and operating profit of your customers for product lines in 2005 and 2006. You want to enable the users of your report to select by specific product lines. Create a new query using the !"#$%&'()*+,-./)*(012123!"4')in the InfoProvider ) *(0121235 You can use the predefined structure 6%2$(14"$1%2)&0(312)#67'&0. :#8( ;&1.$#'<(
;&'%60(=#6$( >??@(
;&'%60(=#6$( >??A(
BC#$600( 9#'.0+'(
(
(
(
53*+$<( ( D6$1&*(//(
(
(
(
(
Net sales Variable COGS 53*+$<( D6$1&*(/( Fixed COGS
Sales Overhead R&D Overhead Admin Overhead B4#$6+&*1( ( E$3F&+( Š SAP AG
TERP10
15-23
Save the query in your favorites folder with the name: Description: !"#$$%&'"()*%+,-./012%3,124%) Technical name: &'"()*5#$$ (#= Participant Group A, B, C or D; $$ is your participant number within the group. For example: You log on to SEM System with User: SEMA-01. The Query is named TERP10_A01.) Execute the query and view the results. 67%.81%69.1291.%':;</212%=-%=9-.><<1?%/9%4/,2%@/2A-.>.=/9%>9?%?17>,<.%<>9B,>B1%=-% -1.%./%'9B<=-8%4/,%C>9%2,9%.81%D,124%=9%.81%@1E%,-=9B%.81% E>2F 1-2
%=C/9%=9%.81%1:;</212%
What are the net sales in 2005 and 2006? ------------------------------------------------------------------------------------------
1-3
Which Product line has a better performance record in 2005 and 2006? ------------------------------------------------------------------------------------------
1-4
What are the fixed COGS for each product line? ------------------------------------------------------------------------------------------
1-5
In which product line does the operating profit increase? Where does the operating profit decrease between 2005 and 2006? ------------------------------------------------------------------------------------------
1-6
In which product line does the R&D Overhead increase between 2005 and 2006? ------------------------------------------------------------------------------------------
1-7
In which product line does the contribution margin II decrease, where does it increase? ------------------------------------------------------------------------------------------
1-8
Filter on Product Line A and Fiscal Year 2006, and display the products accross the columns. You should recognize the values based on the sales orders you created in the ECC system.
Š SAP AG
TERP10
15-24
!"#$%&"'() *'&%+),$(&'-(().'%-##&/-'0-) 1"2&0+)34-5%-)5)6$-47)8-2"4%)
At the conclusion of this exercise, you will be able to: â&#x20AC;˘ Create a BEx query report and analyze the results
In order to evaluate the data from an InfoProvider, you require queries that are tailored to your individual requirements. You have been given the task of creating these query definitions.
1-1
You are interested in finding out the net sales and operating profit of your customers for product lines in 2005 and 2006. You want to enable the users of your report to select by specific product lines. Create a new query using the !"#$%&'()*+,-./)*(012123!"4')in the InfoProvider ) *(0121235 You can use the predefined structure 6%2$(14"$1%2)&0(312)#67'&0. 9-7) :&/$4-(;)
:&(05#)<-54) =>>?)
:&(05#)<-54) =>>@)
AB-45##) 8-($#%()
)
)
)
3"'%4;) ) C54/&')..)
)
)
)
)
Net sales Variable COGS 3"'%4;) C54/&').) Fixed COGS
Sales Overhead R&D Overhead Admin Overhead A2-45%&'/) ) D4"E&%) Š SAP AG
TERP10
15-25
To open the BEx Analyzer, choose !"#$%&'($ $)(*+'&**$,'-./012+.'$31/&4.(*&$ )(*+'&**$5678./&/$ $)(*+'&**$5678./&/$"'189:&/!""#$%&'%(()*"
$
Choose +,-.+"&'"/01234 as RFC Destination Microsoft Excel will be launched in a separate window. In that window, from the BEx toolbar, choose ;7&'$ $<(&/+&*. In the next frame choose the NEW icon and select the InfoProvider. You select your InfoProvider by selecting the InfoAreas Icon. Open the 567,893.":9.;6;6<" $!"#=>. Select the InfoCube Customer Training TERP10 and click the OK button. ""
"
"
Open the !2/(?2(/&$@.8A&/. Transfer the !"#$%&'($&"#)*+%,&#)-!./*+ into the B;3!) using Drag&Drop.
" " Š SAP AG
TERP10
15-26
Expand the !"#$ folder. Transfer the %"&'()*+$(,*-(,"(./ into the !"#$%& into using 0,(120,34. Now transfer the F"&'()*+$(, from the !"#$ dimension, into the '(#)*+, using Drag&Drop. Right click on %"&'()*+$(,, then select !"#$%"&'%(. In the -)..&%,,/ 0%,)#$,/0(1, field, select the dropdown and choose 5)6(7&. This will prohibit unnecessary totalling. Select )*. Restrict the fiscal years, to 899: and 899;, using the context menu. Right mouse click on %"&'()*+$(,, then select <=>!<?@!. Select 899:, hold down the '203 key and select 899;. Choose the +,, icon. Select )* to return to the query designer. @)"'A*3.*%"&'()*+$(,*".*/B$*'3)C#.&*&$'/"3.D*/B$.*,$&/,"'/*/B$*E"&'()*7$(,*C&".1*/B$* '3./$F/*#$.C**G,"1B/*#3C&$*HC//3.IJ*<=>!<?@!K*(.L*&$)$'/*899:*(.L*899;*(.L*C&$* /B$*5,,36*/3*#3M$*"./3*/B$*>$)$'/"3.*6".L36N*O,$&&*PQ*(.L*,$/C,.*/3*/B$*RC$,7* L$&"1.$,N** *
* * Now your query should look like this:
Š SAP AG
TERP10
15-27
! ! From the "#$%&'#(&'!)(*+%, transfer the !"#$%&'()*+, and !"#$%&' into the -",,( ./0"0&',"*1'*&1 using Drag&Drop. Note: Free characteristics wonâ&#x20AC;&#x2122;t show up in the initial report but can be inserted as needed. The !"#$%&'()*+, and !"#$%&' fields are in the -,./&#0/1#(&!"#$%&'#(&2 Expand -,./&#0/1#(&2 Transfer !"#$%&' and !"#$%&'(2*+, to -",,(./0"0&',"*1'*&1 using Drag&Drop. !
Š SAP AG
TERP10
15-28
Save the query in your Favorites folder using the !"#$%&'$() icon: Description: !"#$$%&'"()*%+,-./012%3,124%) Technical name: &'"()*5#$$ (#= Participant Group A, B, C or D; $$ is your participant number within the group. For example: You log on to SEM System with User: SEMA-01. The Query is named TERP10_A01.) +6//-1%-781% '91:,.1%.61%;,124%7-%7%21</2.%=>%.61%?'9%@>7A4B12C'#+'DE%F4%:6//-=>G%!"#$%&'(% )*+%!"+,-%
%H%
% I/.1J%%KL%.61%K>.12>1.%'9<A/212%=-%=>-.7AA1M%/>%4/,2%N/2O-.7.=/>%7>M%M1L7,A.% A7>G,7G1%=-%-1.%./%'>GA=-6%4/,%:7>%2,>%.61%;,124%=>%.61%N1F%,-=>G%.61% 19<A/212%F72H%%P/N1812Q%.61%=>-.2,:.=/>-%F1A/N%721%F7-1M%/>%'9:1AH
%=:/>%=>%.61%
% D1781%.61%?'9%@>7A4B12%/<1>%L/2%.61%>19.%1912:=-1%-.1<H% % R=1N%.61%21-,A.-Q%7>M%7>-N12%.61%L/AA/N=>G%;,1-.=/>-H%
Š SAP AG
TERP10
15-29
1-2
1-3
What are the net sales in 2005 and 2006? Net Sales in 2005
$ 1,824,000.00
Net Sales in 2006
$ 1,815,000.00
Which Product line has a better performance record in 2005 and 2006? To answer this question you have to breakdown the total values by product line. In the query designer you assigned the characteristic product line to the frame “Free characteristics”. So you can drill down the total values. To breakdown the contribution margin schema by product line, select Product Line in the header and choose drilldown > across from the context menu. Now you see the results by product line A & B:
!"#$%&'()*+,(-($#,.(/,"0#"1(2,'',"(2,&3%.,('4,(5,6(0*7%",.(+,'(.38,.(3+$(#/,"3'*+7( /"#0*'(3",(2#'4(4*74,"('43+(!"#$%&'()*+,(9:( ( 1-4
What are the fixed COGS for each product line?
© SAP AG
fixed COGS 2005 PL: A
$ 119,235.80
fixed COGS 2005 PL: A
$ 132,484.20
fixed COGS 2006 PL: B
$ 250.000,00
fixed COGS 2006 PL: B
$ 260.000,00
TERP10
15-30
1-5
In which product line does the operating profit increase, where does the operating profit decrease between 2004 and 2005 Operating profit 2005 A
$ 715,190.00
Operating profit 2006 A
$ 725,898.60
Operating profit 2005 B
$ 125.000,00
Operating profit 2006 B
$ 60.000,00
!"#$%&'()*+,(-($,&",./,/0(1"#$%&'()*+,(2(*+&",./,/(3,'4,,+(5*/&.)(6,."(7889(.+$( 788:( 1-6
In which product line does the R&D Overhead increase between 2005 and 2006? ;<,(=>?(#@,"<,.$($*$(*+&",./,(3#'<(1"#$%&'()*+,/A(!"#$%&'(B*+,(-(*+&",./,/(C( DA888(3,'4,,+(7889(.+$(788:A(E+(1"#$%&'()*+,(2F(=>?(4,+'(5"#G(C(9HFD7HA78('#(C( :IF9H:AH8A(
1-7
In which product line does the contribution margin II decrease, where does it increase? Contribution margin II 2005 A
$ 808,261.80
Contribution margin II 2006 A
$ 827,268.20
Contribution margin II 2005 B
$ 460.000,00
Contribution margin II 2006 B
$ 390.000,00
;<,(&#+'"*3%'*#+(G."J*+(EE($*$($,&",./,(*+(1"#$%&'(B*+,(-(.+$(*+&",./,/(*+(1"#$%&'( )*+,(2(3,'4,,+(7889(.+$(788:A(( 1-8
Filter on Product Line A and Fiscal Year 2006, and display the products accross the columns. You should recognize the values based on the sales orders you created in the ECC system. =*J<'(&)*&K(#+(!"#$%&'(B*+,(*+('<,(<,.$,"(.",.(LM((N,),&'(O*)',"(P.)%,(LM(?".J( !"#$%&'(B*+,(2('#('<,("*J<'(LM(QKA( ( =*J<'(&)*&K(#+(O*/&.)(R,."(*+('<,(<,.$,"(.",.(LM((N,),&'(O*)',"(P.)%,(LM(?".J(O*/&.)( R,."(788:('#('<,("*J<'(LM(QKA( =*J<'(&)*&K(#+(!"#$%&'(*+('<,(<,.$,"(.",.(LM((N,),&'(?"*))$#4+(LM(2&&"#//(LM(QKA(( R#%"(",/%)'/(/<#%)$()##K()*K,('<,(,S.G1),(3,)#4A((N#G,(@.)%,/(G.6(@."6A(
Š SAP AG
TERP10
15-31
! "#$%&!'(&!)&*$)'!)&%+#'%!,-'($+'!%./-01!'(&23!45-'!'(&!645!70.#89&)3
© SAP AG
TERP10
15-32
!"#$%&'()%*+',-"./"% 1.
Business analysis-objects (product line, net sales, sales volumes, and so on) are called __________ in !"#$%&. '())$(*$+,-$.)/*0$+1$2134)-+-$+,-$5-*+-*2-$
2.
The central data containers that form the basis for reports and analyses in !"#$%&$are called _________. '())$(*$+,-$.)/*0$+1$2134)-+-$+,-$5-*+-*2-
3.
_________ is the super-ordinate term for an object that you can use to create reports in Business Explorer (BEx). '())$(*$+,-$.)/*0$+1$2134)-+-$+,-$5-*+-*2-
4.
The Query Designer is divided into #01%subareas. 6-+-73(*-$8,-+,-7$+,(5$5+/+-3-*+$(5$+79-$17$:/)5-;
5.
There are 2'()%ways of restricting characteristics. 6-+-73(*-$8,-+,-7$+,(5$5+/+-3-*+$(5$+79-$17$:/)5-;
Š SAP AG
TERP10
15-33
© SAP AG
TERP10
15-34
!"#$%&#' 1.
Business analysis-objects (product line, net sales, sales volumes, and so on) are called! "#$%&'()*+, in !"#$%&. ()%#%'*"+,-./%01#'02"'.%'34543%3'4"1,'0)2&201%&4#140#'2"3'6%7'+489&%#:' ;)2&201%&4#140#'02"'.%'+9&1)%&'34543%3'4"1,'9"41#<'14=%'0)2&201%&4#140#<'2"3'1%0)"402>' 0)2&201%&4#140#:'
2.
The central data containers that form the basis for reports and analyses in !"#$%&$are called "#$%-.'),/ ()%7'0,"124"'6%7'+489&%#'?#2>%#'5,>9=%#<'4"0,=4"8',&3%&#<'20192>'0,#1#<'2"3'#,',"@' 2"3'2'>4"6'1,'1)%'0)2&201%&4#140#'?=2#1%&'3212',+'1)%'012!34!#7#1%='#90)'2#'0,#1' 0%"1%&#<'09#1,=%&#<'=21%&42>#<'2"3'#,',"@:'' '
3.
InfoProvider is the super-ordinate term for an object that you can use to create reports in Business Explorer (BEx). *"+,A&,543%&#'2&%',./%01#',&'54%$#'1)21'2&%'&%>%52"1'1,'&%B,&14"8:'
4.
The Query Designer is divided into #4C'subareas. '()(*+,-($./()/(*$)/,0$0)1)(+(-)$,0$)*2($3*$4150(6 56.)7' D:!E4&%01,&7'1&%%',+'1)%'#%>%01%3'*"+,A&,543%&. F:';,>9="#' G:'H,$#' I:'J&%%';)2&201%&4#140#' K:'J4>1%&' L:''A&%54%$'' '
5.
There are +,9&'ways of restricting characteristics. '()(*+,-($./()/(*$)/,0$0)1)(+(-)$,0$)*2($3*$4150(6 89:,)' ()%&%'2&%'1$,'$27#',+'&%#1&4014"8'0)2&201%&4#140#M' D:'N7'#%>%014"8'2'0)2&201%&4#140'+&,='1)%'*"+,A&,543%&'' F:'O,9'02"'2>#,'&%#1&401'2'0)2&201%&4#140'1)21'7,9')25%'2>&%237'4"0>93%3'4"'1)%' 3%+4"414,":''
Š SAP AG
TERP10
15-35
© SAP AG
TERP10
15-36
!"#$%&'()*+,-.$/*0'*12+,$!&*1030+-1$4'&'2151&*
>9&*1&*-. ! 67107+18$9:$*;1$:<&,*+9&-$'&=$,9539&1&*-$9:$*;1$ /!4$'33(+,'*+9&-
!
SAP AG 2006
© SAP AG
TERP10
16-1
!"#$%&'()*+,-.$/!0$.$1&+*$2345,*+65-
%*$*95$,:&,(?-+:&$:<$*9+-$?&+*B$):?$C+(($35$'3(5$*:. ! !78('+&$*95$,:;8:&5&*-$:<$/!0$'&=$*95+>$ ;'+&$<5'*?>5! !78('+&$*95$8:-+*+:&+&@$:<$/!0$'&=$+*A-$?-5$ :<$='*'$<:>$'&'()*+,$8?>8:-5-
SAP AG 2004
© SAP AG
!
TERP10
16-2