BOD310

Full text

(1)Material number: 50119299. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Version: 97.

(2) This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK).



(5) ©SAP AG. BOD310. 1-1. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK).










(15) • iPhone. • iPad. ©SAP AG. BOD310. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). (*) supported mobile devices in Design Studio 1.1:. 1-11.


































(49)  Make sure that you have installed SAP BusinessObjects Analysis, edition for Microsoft Office and SAP BusinessObjects Design Studio on your machine.  Make sure that you use both tools in either the local mode or with a BI platform. Otherwise you cannot insert an exported data source.  The edition for Microsoft Office enables you to create data sources using methods that are not available in the design studio. For example, you can use calculations, conditional formatting and exceptions to change a data source. You may then want to use this changed data source in the design studio.. ©SAP AG. BOD310. 2-11. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK).  To use a data source created in SAP Business Objects Analysis, edition for Microsoft Office, the following prerequisites have to be fulfilled:.







(56)  Choose Execute Locally. The application is displayed in a separate Web browser window, using a local Web server embedded within the design tool. This allows you to check the changes you made to the application before saving.  Choose Execute on BI Platform. The application is displayed in a separate Web browser window, using the document link of the application and the current session of the BI platform. You do not have to log the session to the BI platform when executing the application on the BI platform. The analysis application is executed with the credentials you provided when logging on to the design tool.  Choose Send to iPad (using QR code ®). The dialog box "QR Code ®" is displayed with the URL of the current application encoded. Scan the QR code with an iPad (iPad 2 or higher), using one of the various QR code scanner apps.  If you click on the QR code a new Web browser window with the document link opens, but without the current session of the BI platform. You have to log on to the BI platform. This is useful when you want to execute the application with different credentials, for example, to check access rights or personalized result sets.  To copy the document link to the clipboard you can press CTRL + C. You can paste the URL into an e-mail, send the e-mail and the URL can be opened on an iPad. ©SAP AG. BOD310. 2-18. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). In the design tool, there are several ways to execute the application:.






















(78)  Specifies the image that is displayed.  There are several possible locations where you can store the images and icons that you want to use in your application:  In BI Platform Server or MIME Repository (depending on the deployment option)  in the application directory <userhome>\Analysisworkspace\com.sap.ip.bi.zen\repository\MyApplication\MyIma ge.jpg (for local mode)  Internet or intranet. ©SAP AG. BOD310. 3-6. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK).  Image location:.




(82)  font size  font color  weight (bold)  style (italic)  text decoration (underline)  text alignment (center)  text decoration (underline)  This property provides advanced options for text formatting. You can type in the CSS style code directly. Alternatively, you can use any external CSS style editor (such as cssmate or any other) to generate code for the CSS attributes you want to use. Copy this code into the CSS style editor of the design tool.  Restriction:  Only CSS attributes listed above are supported for both desktop browser and iPad applications. If you use any other CSS attributes in the external CSS style editor, run the application on your target device, to check whether the text is displayed as desired and defined by the attributes. ©SAP AG. BOD310. 3-10. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK).  CSS-Style: Opens the CSS style editor of the design tool. You can specify one of the following CSS attributes:.


(84)  The pages are shown in the Outline view .  If you drag and drop a pagebook component in the layout editor, the system automatically creates two pages for the pagebook. If you want to add further pages to the pagebook, use the context menu of the pagebook in the Outline view and click Create Child > Page.. ©SAP AG. BOD310. 3-12. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK).  Note:.

(85)  The popup can only be nested in the root layout and not within another container component.  The popup can only be positioned relative to the root layout.  The popup component is initially invisible. It is displayed (or closed) when the user interacts in the application either with another visible component (for example, a button) or a script (for example, at startup).. ©SAP AG. BOD310. 3-13. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK).  Restriction:.


(87) ©SAP AG. BOD310. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). In addition to the 4 Themes above there is also a „Platinum“ Theme available.. 3-15.





(92) This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK).  Additional Information to ECMA:  http://www.ecma-international.org/publications/files/ECMA-ST/Ecma-262.pdf  Additional Information to JSON:  http://de.wikipedia.org/wiki/JavaScript_Object_Notation. ©SAP AG. BOD310. 4-4.



(95)  Call statements execute an API method of an object and have the following format: <ComponentVariable>.<method>(<arguments>); • <ComponentVariable> is the name of a data source alias or a component in your application, for example, DS_1 or Button_1. • <method> is an operation that is applied to the object specified on the left of the period. The available methods depend on component type. DataSourceAlias objects, for example, provide methods to filter data, and visual components provide methods to modify visibility, enablement, etc. • <arguments> is a comma-separated list of expressions. The passed expressions must match the requirements of the method. • Each statement ends with a semicolon (";") Syntax of conditional execution statements  Conditional execution statements have one of the following formats:  if (<condition>) { <sequence of statements to execute when condition is met> } or  if (<condition>) { <sequence of statements to execute when condition is met> } else { <sequence of statements to execute when condition is NOT met> }  <condition> is a boolean expression - one of the following: • true or false as value literals (constants) • a method call statement returning a boolean value • a comparison for equality in the form a == b or • a comparsion for inequality in the form a != b • multiple conditions combined with && and ||, parentheses are optional. ©SAP AG. BOD310. 4-7. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Syntax of call statements.









(104)  Local script variables are script variables that can be used only in the script in which they were defined, but not in other scripts. To define a local script variable, open a script with the Script Editor and add a line of the following format:  var <variable> = <expression>;  The type of the script variable is automatically determined by the type of the expression.  Global script variables  Global script variables are script variables that can be used in any script of your application. To define a global script variable, open the Edit Global Script Variable dialog box. You can insert a new global script variable and define its name, type, and default value. In addition you can decide if the global script variable is a URL parameter. If you decide to make it a URL parameter, then you can set the value of this global script variable by adding the global script variable and its value as a URL parameter to the applications URL.. ©SAP AG. BOD310. 4-16. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK).  Local script variables.














(118) ©SAP AG. BOD310. 5-8. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Enables smooth scrolling experience. Using this property is recommended when creating mobile applications and/or applications with low data volume. If you do not activate pixelbased scrolling, then row-based/column-based scrolling will be applied by default. Note: This property is mandatory for setting the following properties of row and column limits: For iPad applications, SAP recommends that you limit the total number of cells (the product of rows*columns) to 500, to improve performance and user experience..



(121) Name. BOD310 SAP BusinessObjects Design Studio. Version:. 1.1. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Student Exercise Manual.

(122) Remote Desktop Alias. given by your instructor. Remote Desktop Username. train-xx. Remote Desktop Password. Initial. SAP BusinessObjects Server. wdflbmt2268. SAP BusinessObjects Username. see BW system. SAP BusinessObjects Password. see BW system. BW System / Client. RWB / 800. BW Username. userxx. BW Password. INITIAL. 2. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Please fill in the details given by the instructor and use these for all exercises.

(123) BOD310 Exercise Manual. TABLE OF CONTENTS. 3 . 1. COURSE SETUP:. 4 . 1.1 Preparation . 4 . 2. EXERCISES. 5 . 2.1.1 . Exercise 1: Introducing Data Sources, Crosstab, and Chart . 5 . 2.1.2 . Solution Help 1 . 7 . 2.2.1 . Exercise 2: Introducing Container (Grid Layout) . 15 . 2.2.2 . Solution Help 2 . 18 . 2.3.1 . Exercise 3: Introducing Container (Tabstrip), Filter Capabilities, Dimension Filter and Listbox, Radio Button Group, Text, and simple Scripting 20 . 2.3.2 . Solution Help 3 . 26 . 2.4.1 . Exercise 4: Introducing Pagebook Component, Filtering Capabilities and more complex Scripting Language . 28 . 2.4.2 . Solution Help 4 . 33 . 2.5.1 . Exercise 5: Using Variables and Filter Pane, setting Filters . 35 . 2.5.2 . Solution Help 5 . 41 . 2.6.1 . Exercise 6: Jump from one application to another application . 44 . 2.6.2 . Solution Help 6 . 48 . 2.7.1 . Exercise 7: Using CSS . 49 . 2.7.2 . Solution Help 7 . 51 . 2.8.1 . OPTIONAL Exercise 8: Using Images . 52 . 2.8.2 . OPTIONAL Solution Help 8 . 55 . 2.9.1 . OPTIONAL Exercise 9: Building an iPAD application leveraging SAP pre‐delivered iPad template . 57 . 2.9.2 . OPTIONAL Solution 9 . 59 . This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Table of Contents. 3.

(124) 1.1. Pre eparation. In order to avoid confliccts with the Content C Assistance e: Start  Co ontrol Panel  Regional and Language  Keyboard ds and Langu uages  Change Ke eyboard  Advanced A Se ettings: in the area a “Hot keys for fo input languages” make sure e that there iss nowhere th he setting “Ctrl+Spacce”, if yes, Ch hange Key Sequence S into sometthing else (e..g. “Ctrl+Shift+ +Page_Dow wn”). 4. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 1. Cou urse se etup:.

(125) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 2. Exe ercises s 2.1.1 Exercise 1: Introducing Da ata Sourc ces, Cros sstab, an nd Chart Objective e In the follow wing exerciise you will learn how tto use syste ems and data sources in the application ns with SAP P BusinessO Objects Dessign Studio. Data sourc ces are usedd as an d components. abstraction n between the source systems s and Exercise rresult stabs and 1 Chart with h data from SAP BW syystem. Your appliccation displays 2 Cross. Exercise D Description n 1. Crea ate a new application a U##_APP_1 U 11 (U##_AP PP_11).. Yourr application ns should be b saved on n the BI Plattform to the target foldeer Pub blic Folders s > BI Train ning > Userr Area > Us ser##. For tthe Data So ources, use the connecction RWB System Co onnection.. 5.

(126) DS_ _1 and use the t BEx Que ery P_ORDE ERS_011. Edit the Initial View V acco ording to the e screen.. 3. Add the second d Data. Sourrce DS_2 by b copying Data a Source DS S_1. For Data Sourcce DS_2 ediit Initia al View: acccording to the sscreen. For tthe characteristic Sold d to party choose e the hiera archy Custo omer Hierrarchy by Region R (P_C CUSTOMER R_HIER). Onlyy the measu ure Inco oming Orde ers EUR shou uld be seleccted. 4. From m the Analyytic Compon nents add 2 Crosstabs s and 1 Cha art into the application.. Assign the Data a Sources to o the comp onents: DS_ _1  CROS SSTAB_1 an nd CHART_ _1 DS_ _2  CROS SSTAB_2 5. Spec cify the size e and the po ositioning off the compo onents.. For tthat, you ca an use the Layout L prop perties of the e components and thee Align and Distribute D funcctions of the e toolbar. 6. Save e your application.. 7. Exec cute your application on o the BI Pla atform.. 6. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 2. Add the first Da ata Source.

(127) BOD310 E Exercise Manual M. 1. To op pen SAP Business Objeccts Design Studio S naviga ate to:. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). H 1 2.1.2 Solution Help Start  All Program ms . 2. If needed fill in th he correct Web S Service URL http://w /wdflbmt22 268:8080/.... 3. A poppup with the e Welcome Page appears. With G Getting Starrted you can watch h most recen nt tutorials. With R Recently-Ussed Analysis Appliccation you can c directly open the applicattion which worked on. you w With U Useful Linkss you can open the related public resources. With C Create New w you can create e the new application directly from welccome page... 4. If the popup “Log gon to SAP Business Objectss BI Platfo orm” (2.) did not appearr, go to Tools  Prreferences: Set th he Preferred d Startup Mode to “SAP Bu usiness Objec cts BI Platfform”, click on OK K, and Resttart.. 7.

(128) to create e a new app plication.. 6. Your aapplicationss should be saved d on the BI Platform P to the target folder c Folders > BI Public Training > User Area > User# ##. Enter the techniccal Name U##_A APP_11 an nd the description U##_ _APP_11 fo or your a application. As Ta arget Device e choose “Desk ktop Brows ser”.. 7. Selecct the templa ate Blank and co onfirm by clicking. .. 8. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 5. Click oon.

(129) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 8. How tto Navigate e in the Design Studio o:. After open ning Design n Studio, clo osing the w welcome pag ge and crea ating a new,, blank, app plication, you u see the screen above. Fo or these exe ercises the framed box xes are esse ential. The ffollowing de escription will w help you ffamiliarize yourself y with the interfa ace. . Layo out Editor – blank space in the ce enter of the interface.  . Com mponents – upper left box b.  . C Consists off analytic, ba asic and co ontainer com mponents. These T are u ser interfac ce elementss w which you can c drag to the layout e editor to cre eate the con ntent of youur applicatio on.. Outline – lowerr left box.  . D Displays co omponents and a contentt of your ap pplication.. L List of comp ponents and d data sourrce aliases used u in your applicatioon.. Prop perties – rig ght box. . L List of properties availa able for sele ected comp ponents.. 9.

(130) DS_1 1 and use th he BEx Queryy P_ORDERS_011.. or. 10. Brow wse and sele ect the. conne ection B System Connection C RWB. 11. Brows se and selecct a Data. Source e: search h for a P_ORDERS and choose the queryy P_OR RDERS_011.. 12. Edit th he Initial Vie ew. accord ding to the screen. s. 10. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 9. Add tthe first Datta Source.

(131) This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). BOD310 E Exercise Manual M. 13. Creatte the secon nd Data. Sourcce DS_2 byy copying and p pasting Data a Source DS_1.. 14. For Data Source DS_2 edit. Initial View: acco ording to the e screen. For th he characterristic Sold to parrty choose the hierarrchy Custom mer Hierarchy by Re egion (P_CU USTOMER_ _HIER). Only tthe measure e Incoming g Orderrs EUR sho ould be selectted.. 11.

(132) Com mponents ad dd 2 Cros sstabs and 1 Chart into tthe applicattion. 16. Assig gn the Data a Sources to o the compo onents:. DS_1 1  CROSSTAB_1 an nd CHART_ _1 DS_2 2  CROSSTAB_2 Therre are severral ways to assign a da ata source to a compon nent:.  . W Work in the e Outline vie ew: Drag th he data sourrce from the e Data Sou urces folderr and drop itt onto tthe corresponding com mponent in tthe Layout folder. D Drag the da ata source from f the Da ata Sources s folder and d drop it onto to the corres sponding ccomponent in the desig gn area of tthe tool.. Note: If you have e added a data d source by clicking the Data Source S propperty of the componentt, you do not need to asssign the da ata source tto the comp ponent in a further stepp. In this cas se the syste em assign ns the data source automatically tto the comp ponent. You h have assigned a data source s to a ccomponent. The comp ponent displlays the datta of the datta source e in the layo out editor.. 12. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 15. From m the Analyttic.

(133) 17. Speciify the size and the. positioning of the e comp ponents.. Chang ging the layyout propertties and doccking behav vior: You ccreate the la ayout of an application by inserting g componen nts in the edditor and ch hanging the layoutt properties of the components. Yo ou can change the layout propertiies of comp ponents eith her in the Prroperties view v (where you can ed dit all properties) by entering the vvalues manu ually or in th he layoutt editor by dragging d the e borders off a component. The folllowing figu re shows a button compo onent in the e editor:. The re ed rectangle e shows the e size of the e componen nt. It contain ns eight redd handles fo or resizing. In I this figure you see tw wo (out of a possible fo ur) docking visualizers s that show the distance between the compo onent and the t top bord der and left border of th he applicatio on. Dockingg visualizers s are displa ayed as an arrow with a number if the compo onent is bou und to a borrder (numbeer is display yed by the releva ant propertyy). A docking visualizerr displayed as an empty circle meaans that the e componen nt is not bo ound to a bo order ("auto o" is displayyed by the re elevant property). The number an nd the emptyy circle are interacttive. Clickin ng the numb ber changes s the display y to "auto" aand clicking g on the em mpty circle changes th he display to o a number that repres sents the dis stance to thhe containerr border. When n changing the t layout properties, p kkeep the following points in mind: There e are three properties p th hat specify the position n and size of o a componnent in an application: a  W Width, distance to left margin and d distance to right r margin n along the horizontal axis a  He eight, distan nce to top margin m and distance to bottom margin along tthe vertical axis To en nable dynam mic/relative resizing of tthe compon nents with changing c Weeb browserr windows, one o of these three prope erties of each axis is a lways set to o auto. It is not possiblee to set all three t prope erties to autto.. 13. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). BOD310 E Exercise Manual M.

(134) By highlig ghting severral components you will be able to edit prope erties of the ese highlighte ed compone ents in one step via th he propertie es pane.. The sizing g and positiioning is enormoussly supporte ed by using the Align and Distribute functions of the toolb bar. 18. Save your applic cation.. 19. Execu ute your application on n. the BI Platform.. 14. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Note e:.

(135) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 2 Introducing Co ontainer (Grid Lay yout) 2.2.1 Exercise 2: Objective ercise you will learn how to us se containe ers for betttter layout of the In the folllowing exe application ns with SAP P BusinessObjects De esign Studio o. Containe ers can helpp you to orrganize content and handle dyynamic interactions. Exercise rresult Your appliccation displays data fro om SAP BW W system us sing 2 Crosstabs and 2 Charts embedded d in a Grid Layout L so th hat the size and the pos sition of the e componennts automatically fit to the sizze and reso olution of the screen re espectively device. d. 15.

(136) 1. Crea ate a new application a U##_APP_1 U 12 (U##_AP PP_12).. For tthe Data So ources, use the connecction RWB System Co onnection. 2. Add the first Da ata Source. DS_ _1 by using the BEx Que ery P_ORDE ERS_011. Edit the Initial View V acco ording to the e screen.. 3. Add the second d Data. Sourrce DS_2 by b using the BEx Query P_O ORDERS_01 12. Edit the Initial View V acco ording to the e screen.. 16. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Exercise D Description n.

(137) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 4. From m the Conta ainer. Com mponents ad dd a Grid Layo out. The Grid Layou ut should have e 2 rows and 2 columns, should d cover the whole screen and should resizze automatically. 5. From m the Analyytic. Com mponents ad dd 2 Cros sstabs and d 2 Charts into the application and bind them to the e cells of the G Grid Layoutt. Change the layout settings s of th hese compo onents so that they will ressize auto omatically with w the Grid d Layo out. For tthat, you ca an use the Layo out propertie es of the components or the Maxximize function from the e toolb bar.. 6. Assign the Data a Sources to o. the ccomponentss: DS_ _1  CROS SSTAB_1 and CHART_1 DS_ _2  CROS SSTAB_2 and Chart_2 7. For tthe charts use u the chart types acccording to th he Exercise e result dispplay above.. 8. Save e your application.. 9. Exec cute your application on o the BI Pla atform.. 17.

(138) Ad 4). he propertie es Row Heig ght and Colu lumn Width represent Note : Th proportio ons ! Ad 5) Define the e layout setttings for all analytic compone ents. Use multiple select to o do that task quickkly. You also can use the e Maximize function frrom the too olbar.. 18. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). H 2 2.2.2 Solution Help.

(139) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Ad 7) e settings fo or CHART_ _1 Define the In the Pro operties cho oose . C Chart Type: Area. . S Swap Axis: True T. nal Propertie es dialog ch hoose View w > Additiona al Propertiees from the menu. To open tthe Addition Change th he settings / colors acc cording to yyour needs. 19.

(140) Objective In the follow wing exerciise you will learn how tto use the container c co omponent T Tab Strips and filtering capabilities to o allow user changes o n data. Filte er and otherr componennts which alllow to change da ata drilldown n and selecttions can in ncrease the runtime cap pabilities givven to end users. Exercise rresult Your Application is se eparated in 2 Tab stripss “Divisions” and “Top 10 Customeers”. In addition it contains a header te ext and a bu utton that ca alls the variable screenn.. n of Tab 1 “Division”: “ Description  Data o of the first Data D Source e, Query “P P_ORDERS S_011”, is presented inn a crosstab b and a Colum mn-Chart  The crosstab is “selectable” “ ”, transfers the selecte ed division to the secoond Data Source, S presen nted on the second tab b and activa ates the sec cond tab. 20. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 3 Introducing Co ontainer (Tabstrip p), Filterr Capabilities, 2.3.1 Exercise 3: D Dimension n Filter and a Listb box, Radiio Button n Group, Text, an nd siimple Sc cripting.

(141) This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). BOD310 E Exercise Manual M. Description n of Tab 2 “Top “ 10 Cus stomers”: . Data o of Query “P_ _ORDERS_ _012” is pre esented in a crosstab and a a Colum mn-Chart. . There is a naviga ation panel that t contain ns the follow wing 3 eleme ents . wing the dim mension Division of P_O ORDERS_0012, a Dimension Filter show. . owing autom matically the e list of all key k figures of o P_ORDE ERS_012 a Listbox sho. . B Grou up with the 4 values EUR, E USD,, JPY, AUD D to be a manual filled Radio Button assed as va ariable value e to the Datta Sources pa. 21.

(142) 1. Create e a new application in the BI Platfform server with the na ame U##_A APP_13 e the Data Source 2. Create DS_1 for Query P_OR RDERS_011 1 and chang ge the Initial View accord ding to the screen. 3. Create e the Data Source DS_2 for Query RDERS_012 2 and P_OR chang ge the Initial View accord ding to the screen. 22. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Exercise D Description n.

(143) 4. Create e a Title texxt element “Order “ Anal ysis” using the Style “H Heading 1” e a button and a change e its text to: “show varia able screen” 5. Create e the Tab Strip S 6. Define Comp ponent with the follow wing elemen nts Tab 1: Crossstab + Chartt showing Data S Source DS_ _1 2: Tab 2 Crossstab, Chart showing s Data S Source DS_ _2 and Panel with Dimen nsion Filter, Listbox and d Radio obuttongroup For the Panel use the CSS Style otted; border-style: do O  In the end your Outline d look like the t one on should the rig ght.  For po ositioning questions take a look at the e final result at the beginning of the exxercise e the properties of the Dimension Filter element so that it shows thee dimension n Division of o 7. Define Datassource DS_2 2. 8. Manually fill in the values he Radio Bu utton into th Group p. 9. Define e the Scriptt on for the Button B to op pen the variable dialog g f crossta b and defin ne the scriptt that passees the actua al selected value v as 10. Enable the selecction of the first S DS_2 2 and activa ates the sec cond tab. a filterr for Data Source. 23. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). BOD310 E Exercise Manual M.

(144) 12. Define the script that pushes the selected value of the Radio Button Group to the variable 0P_CURR. 24. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 11. Define the script that fills the Listbox component with the Key Figures from Data Source DS_2. Choose a suitable event when the script should be executed. Also define the filtering on DS_2 if one of the entries is selected..

(145) OPTIO ONAL STEPS 13. Create e a Button on o the seco ond Tab wh ich can be used u to hide e / show thee whole nav vigation are ea.. “ Orders” O is se elected the chart should be enhannced with information in n which 14. If the key figure “Incoming ne of the otther both ke ncy the valu ues are pres sented. If on ey figures iss selected th his extra texxt curren should d not be vissible.. 25. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). BOD310 E Exercise Manual M.

(146) Ad 4 / 5). Ad 7). Ad 9) S of BUTTON_1: Script for event “on Select” ATION.open nPromptDi ialog(400 0, 600); APPLICA. 26. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). H 3 2.3.2 Solution Help.

(147) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Ad 10) he propertyy of CROSS STAB_1 to: Change th. S of CROSSTAB_ _1: Script for event “on Select” "0DIVISIO ON", CROS SSTAB_1.g getSelect tedMember r("0DIVISION")); DS_2.setFilter(" TABSTRIP_1.setSe electedTa abIndex(1 1); Ad 11) S of APPLICATI A ON: Script for event “on Startup” stbox // fill the key figures into lis X_1.setIte ems(DS_2. .getMembe erList("0 00O2STASF FITA16AOA ACV6NCZ29", LISTBOX MemberP Presentati ion.INTER RNAL_KEY, , MemberD Display.T TEXT, 5)) ; // proc cess the script s of f LISTBOX X_1 LISTBOX X_1.onSele ect(); // proc cess the script s of f RADIOBU UTTON_1 RADIOBU UTTONGROUP P_1.onSel lect(); Script for event “on Select” S of LIISTBOX_1: DS_2.setFilter(" "00O2STAS SFITA16AO OACV6NCZ2 29", LIST TBOX_1.ge etSelectedValue()) ); Ad 12) S of RADIOBUTT R TONGROUP P_1: Script for event “on Select” ATION.setV VariableV Value("0P P_CURR", APPLICA RADIOBU UTTONGROUP P_1.getSe electedVa alue());. 27.

(148) Objective In the follow wing exerciise you will learn differe ent options of using the Pagebookk component. Furthermore you will learn how to o increase tthe user exp perience with different navigation options. In addition yo ou will learn to use advvanced scrip pting functio ons to enabble dynamic drilldown in n the crossttab Exercise rresult This Appliccation consists of two pages. p Page 1 shows 2 Tab Strips. Tab Strip 1 shows an Order Overview where e Year and Quarter are e presentedd as cascad ding prompts. In n addition a Filter Pane el is used fo or further na avigation op ptions.. 28. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 4 Introducing Pa agebook Compon nent, Filte ering 2.4.1 Exercise 4: C Capabilities and more m com mplex Sc cripting Language L e.

(149) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Tab Strip 2 on Page 1 shows a more m detaile ed view whe ere the selection is donne by a time e period defined by a be egin and an n end date.. Page 2 sho ows a crossstab where the user sh hould be able to select the displayyed drill dow wn with a list of che eckboxes.. 29.

(150) If you want w to conc centrate on the scriptin ng part of this exercise you can us se the Appliccation U00_Ap pp_14_starrt (in Publicc Folders > Design Studio Samplee) as a temp plate for thiss exercise e. In that ca ase you can n directly jump to step p 7 and thenn only perform the step ps marked d with the “F Fast-Track” Icon  Ope en the App U00_App_ _14_start an nd save it as your appl ication U##_ _APP_14. e the Data Source 1. Create DS_1 for Query P_OR RDERS_014 4. You d do not need to change the initial view.. 2. Create e the Data Source DS_2 for Query P_OR RDERS_015 5. You d do not need to change the initial view. urce  This Data Sou d have the property should Load in Script = True. 30. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Exercis se Fast-Tra ack:.

(151) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 3. Create e the Data Source DS_3 for Query View V P_OR RDERS_VIE EW_011. You d do not need to change the initial view.. 4. Add a Text Com mponent for the He eadline “Sa ales Analyysis”. 5. Add a Pagebookk compo onent that uses u the whole e size below w the headline. you ur outline wiill look like that. 6. On thee first page add a Tabsttrip Compon nent with the following elem ments Tab 1: 2 Dropdownboxe es to filter Year a and Quarter with describing text fie elds Add a Crosstab + Filterp panel All the ese elements are related to DS_1. Tab 2 2: Add 2 Date Field ds with desc cribing text ffields add a button “sub bmit” add a crosstab All the ese elements are relate ed to DS_2  In tthe end you ur Outline should look llike shown above  For positioning questions s take a lookk at the fina al result at the beginninng of the ex xercise. 31.

(152) 7. Define e the script that fills the e Dropdown n Boxes for Year and Quarter Q withh the members from Data S Source DS_ _1 e the script for the Dropdown Yea ar. This shou uld filter the e DS_1 and refresh the e entries 8. Define in the Dropdown Box Quarte er. It’s also important th hat existing filters on Q Quarters are e removved if a new w Year is se elected. e the script for the Dropdown Boxx Quarter. This should filter f DS_1. 9. Define e the properites of the Filter Pane el for DS_1 that t only the e dimensionns “Sales Organization O n”, 10. Define “Distriibution Cha anel”, “Divisiion”, “Materrial”, “Counttry”, “Region n”, “Sold to party” and the “Key Figures” are avvailable. The next steps describe the 2nd Tab on tthe 1st Page e: 11. The C Crosstab sho ould be initiially hidden . Define the e properties s accordingl y. e the script for the Buttton that sen nds the date e range from m the 2 Datee Fields as a filter 12. Define to DS_ _2. In addittion the cros sstab shoul d be set to “visible”. Keep in mind tha at DS_2 is not n loaded in nitially at the start of the applicatioon so do no ot forget to do that in the script. s 2 Page: The next steps describe the 2nd 13. On the e 2nd page define d a crossttab showing g DS_3 Add a Grid Layou ut with 5 rows ffor easy possitioning of the ne ext elementts. Row 1 1: Add a Text Item “Drill “ Down”. Rows 2 – 5: Add 4 Checkboxe es  Saales Organiization (*)  Distribution Channel C  Division  M Material. (**) Checkbox x Sales Org ganization sshould be se elected by default d.  For positioning questions take a look at the final re esult at the beginning of the exercise 14. Define e the script for each Ch heckbox tha at when the e box is checked the coorresponding dimen nsion should d be taken onto o the row w axis, if it is unchecke ed the dime nsion should be removved from the e row axis.. 32. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). The next steps describe the 1st Tab on t he 1st Page e:.

(153) BOD310 Exercise Manual. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 2.4.2 Solution Help 4 Ad 7) Additional script for event “on Startup” of APPLICATION: //fill the Years and Quater Dropdown with values from DS_1 and add an "ALL" entry DD_YEAR.setItems(DS_1.getMemberList("0CALYEAR", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 10, "ALL")); DD_QUARTER.setItems(DS_1.getMemberList("0CALQUARTER", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 50, "ALL"));. Ad 8) Script for event “onClick” of DD_YEAR: //set Filter on selected Year for DS_1 DS_1.setFilter("0CALYEAR",DD_YEAR.getSelectedValue()); //remove the filter on Quarters in case they exist for DS_1 DS_1.clearFilter("0CALQUARTER"); //refresh the list of Quarters in the Dropdown Box DD_QUARTER.setItems(DS_1.getMemberList("0CALQUARTER", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 50, "ALL"));. Ad 9) Script for event “onClick” of DD_QUARTER: //set Filter on selected Quarter for DS_1 DS_1.setFilter("0CALQUARTER",DD_QUARTER.getSelectedValue()); Ad 12) Script for event “onClick” of BUTTON_1 (Submit): //load DS_2 DS_2.loadDataSource(); //set Filter for DateRange on DS_2 DS_2.setFilter("0CALDAY", {"low": DF_FROM.getDate(), "high": DF_TO.getDate()}); //set Crosstab 2 visible CROSSTAB_2.setVisible(true);. 33.

(154) Script for event “onClick” of CB_SALESORG: if (CB_SALESORG.isChecked()){DS_3.moveDimensionToRows("0SALESORG");} if (CB_SALESORG.isChecked() == false){DS_3.removeDimension("0SALESORG");} Script for event “onClick” of CB_DISTRCHAN: if (CB_DISTRCHAN.isChecked()){DS_3.moveDimensionToRows("0DISTR_CHAN");} if (CB_DISTRCHAN.isChecked() == false){DS_3.removeDimension("0DISTR_CHAN");} Script for event “onClick” of CB_DIVISION: if (CB_DIVISION.isChecked()){DS_3.moveDimensionToRows("0DIVISION");} if (CB_DIVISION.isChecked() == false){DS_3.removeDimension("0DIVISION");} Script for event “onClick” of CB_MATERIAL: if (CB_MATERIAL.isChecked()){DS_3.moveDimensionToRows("0MATERIAL");} if (CB_MATERIAL.isChecked() == false){DS_3.removeDimension("0MATERIAL");}. 34. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Ad 14).

(155) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 5 Using Variable es and Fiilter Pane e, setting g Filters 2.5.1 Exercise 5: Objective owing exerccise you will learn diffe erent option ns to design a sophistticated dashboard In the follo like applica ation. More complex sc cripting and d charting ca apabilities are a used forr that applic cation. Exercise rresult The Dashb boards startts with a Po opup where a customerr is selected d. For the seelected cus stomer the data is visualized in . An ove erview line with w 3 differrent KPIs, tw wo of them are also en nriched withh a icon sho owing a positivve or negative symbol.. . a charrt always dissplays the last 5 years no matter ifi there is da ata or not. . a foote er showing some basic c metadata like “last da ata update” or “current user” but it also has a “more inforrmation” icon which ope ens up anotther popup with more m metadata in n it. 35.

(156) If you want w to conc centrate on the scriptin ng part of this exercise you can us se the Appliccation U00_Ap pp_15_starrt (in Publicc Folders > Design Studio Samplee) as a temp plate for thiss exercise e. In that ca ase you can n directly jump to step p 9 and thenn only perform the step ps marked d with the “F Fast-Track” Icon  Ope en the App U00_App_ _15_start an nd save it as your appl ication U##_ _APP_15. 1. Create e a new application U# ##_APP_15 5 e the Data Source 2. Create DS_1 for Query P_OR RDERS_013 3 and chang ge the Initial View accord ding to the screen. 3. Create e the Data Source DS_2 for Query RDERS_013 3 and P_OR chang ge the Initial View accord ding to the screen  Re estrict the dimension d Calen nder Year to the selection 2005 – 2010 hoose the Member M  Ch Acces ss Mode = Master Data. 36. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Exercis se Fast-Tra ack:.

(157) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). G 4. Createe the Headline with a Grid compo onent conta aining  Im mage  Heeadline  Drropdown forr customer selection  Raadio Button Group for choosing c th he cu urrency US SD and EUR Use im mage: Root F Folder/Imag ges/logo.png  In tthe end you ur Outline should look like th he one on th he right.. 5. Createe the Overvview Line with a Grid compo onent with 5 Columns and 1 Row In Collumns 1, 3, 5 add a panel. In eacch of these panels add a grid with 1 Colum mn and 7 Ro ows In Row ws 2,4,6 ad dd a Text co omponent the lasst panel hass only 2 tex xt fields Add a an image co omponent within w panel colum mns 3 and 5  Jusst create an nd rename the t eleme ents. The te exts will be replaced r later o on in scriptss.  In tthe end you ur Outline should look like th he one on th he right.  For positioning questions s take a lookk at the final result at the beginning of the e exercise. 37.

(158) Add a Panel with h a Column Combinatio on - Chart and the Text T field “Trend (absolute)” Use D DS_2 for the e Chart as a Data Sourcce  In tthe end you ur Outline should look like th he one on th he right.  For positioning questions s take a lookk at the final result at the beginning of the e exercise er Area with a Panel 7. Createe the Foote holdin ng a Grid co omponent with w 5 Colum mns and 2 Rows. R Add a text compo onent in columns 1,3,5 5 in eacch row.  Jusst create an nd rename the t eleme ents. The te exts will be replaces r later o on in scriptss. Add a an image on n the right side of the footerr area. Use im mage: Root F Folder/Imag ges/info.png g  In tthe end you ur Outline should look like th he one on th he right.  For positioning questions s take a lookk at the final result at the beginning of the e exercise Here is a closer view v for the e Footer are ea. 38. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 6. Createe the Chartt Area.

(159) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 8. Createe the initial selection popup and the ad dditional info ormation po opup. Hide both o on the outlin ne. The in nitial selection popup contains c a describing text an nd a list box x with all custom mers in. The a additional infformation popup p contains 7 text fie elds that ca an be organ nized in a grrid compone ent. The te exts will be replaced la ater on in scriptss. The popu up should close autom matically and d use an en ntry effect. ur Outline should look  In tthe end you like th he one on th he right.  For positioning questions s take a lookk at the final result at the beginning of the e exercise. 9. Createe the startu up script for your appliccation. The following f ac ctions shall be included d:  Fiill the Dropd downbox DD D_SOLDTO O in the Hea adline with 100 1 custom mers and sort them  Fiill in text fiellds in the fo ooter area w with the information sho own in the ffinal result (see  . sttep 7 for dettails) Fiill the Listbo ox in the inittial selection omers and ssort them n popup witth 100 custo Display the popup p for the initial sele ection. 10. Definee the on Se elect event of o the Listbo ox from the initial selec ction popup . The follow wing action ns shall be included:  Close the inittial selection popup  Seet the seleccted value of o the dropd own box in the headerr to the seleected custom mer  Exxecute the script s that is s maintaine ed for the drropdown box elect event of o the dropd down box in n the headlin ne. The folloowing actions shall 11. Definee the on Se be inccluded: Fiill text fieldss for order volume v (1st panel) acc cording to th he exercise result “O Order Volum me in 1 $” where w the sccaling factorr and the cu urrency are read out off DS_1 “F Formatted value” v of Inc coming Orde ers out of DS_1 D “W World Rankiing: 20” whe ere the num mber is read d out of DS_ _1  Fiill text fieldss for order volume v (2nd d panel) acc cording to th he exercise result “S Sales Volum me in 1 $” where w the sccaling factorr and the cu urrency are read out of DS_1 “F Formatted value” v of Sales Volume e out of DS_ _1 “W World Rankiing: 20” whe ere the num mber is read d out of DS_ _1  Generate the e icon for Sales S Volum me dependin ng on Condition in Queery on “Root Folder/Images s/good.png”” if conditional value = 1 then use ico if conditional value is no ot 1 then use e icon “Roo ot Folder/Images/bad.ppng”  caalculate the invoiced qu uote, show it and gene erate the ico on for it invoiced quotte = invoice ed quantity / order entrry quantity uote >= 95 use u icon “R oot Folder/IImages/goo od.png if invoiced qu if invoiced qu uote < 95 us se icon “Roo ot Folder/Im mages/bad.p png”  Fiilter DS_2 on o the selec cted custom mer. . 39.

(160) “0P_C CURR”. 13. Definee the on Se elect event of o the additi onal inform mation icon. The icon shhould open up the additio onal informa ation pop up and fill the e text icons s in it. All the e informatioon should be read from D DS_1. See details belo ow:. 40. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). he sends the e selected vvalue of the e Radio Buttton Group to the variab ble 12. Definee a script th.

(161) 2.5.2 Solution Help 5 Ad 3) To restrict Calendar Year use the “Filter by InputString” option and type in: 2005 - 2010 Ad 9) Script for onStartup of APPLICATION: //fill dropdown box DD_SOLD_TO with customers DD_SOLDTO.setItems(DS_1.getMemberList("T_SOLD_TO", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 100, "All")); DD_SOLDTO.sort(); //fill the system information in the footer area TX_USER.setText("Current User : " + DS_1.getInfo().user); TX_DATE.setText("Today's Date : " + APPLICATION.getInfo().dateNow); TX_APPNAME.setText("Application Name : " + APPLICATION.getInfo().name); TX_SYSTEM.setText("System : " + DS_1.getInfo().system); TX_LASTUPDATE.setText("Last Data Update : " + DS_1.getInfo().lastDataUpdate); TX_LASTREFRESH.setText("Last Refreshed at : " + DS_1.getInfo().lastRefreshedAt); //fill the listbox of initial selection popup with customers LB_CUSTOMER.setItems(DS_1.getMemberList("T_SOLD_TO", MemberPresentation.INTERNAL_KEY, MemberDisplay.TEXT, 100)); LB_CUSTOMER.sort(true); //display popup for initial selection POPUP_INITIAL_SELECTION.show(); Ad 10) Script for onSelect of LB_CUSTOMER: //close the popup after the user selects the sold-to-party POPUP_INITIAL_SELECTION.hide(); //set the dropdown-box to the selected sold-to-party DD_SOLDTO.setSelectedValue(LB_CUSTOMER.getSelectedValue()); //write data information to the panel, not using the listbox but using the dropdown DD_SOLDTO.onSelect();. 41. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). BOD310 Exercise Manual.

(162) //write information into the overview panels //Fill text fields for order volume TX_ORDERS_TITLE.setText("Order Volume in " + DS_1.getData("00O2STASFITA16AOBN6ILVY4H", {}).scalingFactor + " " + DS_1.getData("00O2STASFITA16AOBN6ILVY4H", {"T_SOLD_TO": DD_SOLDTO.getSelectedValue()}).unitOfMeasure); TX_ORDERS_VOLUME.setText(DS_1.getData("00O2STASFITA16AOBN6ILVY4H", {"T_SOLD_TO": DD_SOLDTO.getSelectedValue()}).formattedValue); TX_ORDERS_RANKING.setText("World Ranking: " + DS_1.getDataAsString("00O2STASFITA16AQ20Y6IUGZL", {"T_SOLD_TO": DD_SOLDTO.getSelectedValue()})); //Fill text fields for sales volume TX_SALES_TITLE.setText("Sales Volume in " + DS_1.getData("00O2STASFITA16AQ20Y6IUTMP", {}).scalingFactor + " " + DS_1.getData("00O2STASFITA16AQ20Y6IUTMP", {"T_SOLD_TO": DD_SOLDTO.getSelectedValue()}).unitOfMeasure); TX_SALES_VOLUME.setText(DS_1.getData("00O2STASFITA16AQ20Y6IUTMP", {"T_SOLD_TO": DD_SOLDTO.getSelectedValue()}).formattedValue); TX_SALES_RANKING.setText("World Ranking: " + DS_1.getDataAsString("00O2STASFITA16AQ20Y6IUZY9", {"T_SOLD_TO": DD_SOLDTO.getSelectedValue()})); //Fill text fields for invoiced quote TX_SALES_TITLE.setText("Sales Volume in " + DS_1.getData("00O2STASFITA16AQ20Y6IUTMP", {}).scalingFactor + " " + DS_1.getData("00O2STASFITA16AQ20Y6IUTMP", {"T_SOLD_TO": DD_SOLDTO.getSelectedValue()}).unitOfMeasure); TX_SALES_VOLUME.setText(DS_1.getData("00O2STASFITA16AQ20Y6IUTMP", {"T_SOLD_TO": DD_SOLDTO.getSelectedValue()}).formattedValue); TX_SALES_RANKING.setText("World Ranking: " + DS_1.getDataAsString("00O2STASFITA16AQ20Y6IUZY9", {"T_SOLD_TO": DD_SOLDTO.getSelectedValue()})); // use local variable for calculating and storing the conditional formatted value var v_cond_form_val = DS_1.getConditionalFormatValueExt("00O2STASFITA16AQ20Y6IUTMP", {"T_SOLD_TO":DD_SOLDTO.getSelectedValue()}); //set image for the sales volume if (v_cond_form_val == 1) {IM_SALES.setImage("Root Folder/Images/good.png");} else {IM_SALES.setImage("Root Folder/Images/bad.png");} // calculate invoiced quote and generate the icon for it and write it to text field var v_invoiced_volume = DS_1.getData("00O2STASFITA16AQ20Y6IVCLD", {"T_SOLD_TO": DD_SOLDTO.getSelectedValue()}); var v_ordered_volume = DS_1.getData("00O2STASFITA16AOBN6ILWARL", {"T_SOLD_TO": DD_SOLDTO.getSelectedValue()}); var v_invoiced_quote = ((v_invoiced_volume.value / v_ordered_volume.value) * 100); TX_INVOICED_QUOTE.setText(Convert.floatToString(v_invoiced_quote, "0.00") + " %");. 42. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Ad 11) Script for onSelect of DD_SOLDTO:.

(163) BOD310 Exercise Manual. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). //set image for the quote if ((v_invoiced_quote >= 95)) {IM_QUOTE.setImage("Root Folder/Images/good.png");} else {IM_QUOTE.setImage("Root Folder/Images/bad.png");} //filter DS_2 with selected customer DS_2.setFilter("T_SOLD_TO", DD_SOLDTO.getSelectedValue()); Ad 12) Script for onSelect of RB_CURRENCY: //change currency according to selection APPLICATION.setVariableValue("0P_CURR", RB_CURRENCY.getSelectedValue()); //re-write all information with the new currency DD_SOLDTO.onSelect(); Ad 13) Script for onSelect of IMAGE_2: //fill information TX_CREATED.setText(" Created by : " + DS_1.getInfo().createdBy); TX_DSNAME.setText(" Data Source Name : " + DS_1.getInfo().dataSourceName); TX_INFOPROVIDER.setText(" InfoProvider : " + DS_1.getInfo().infoProviderDescription); TX_INFOPROVIDERTECNAME.setText(" InfoProvider Tech. Name : " + DS_1.getInfo().infoProviderTechnicalName); TX_QUERYNAME.setText(" Query Name : " + DS_1.getInfo().queryDescription); TX_LASTCHANGEDBY.setText(" Last Changed by : " + DS_1.getInfo().lastChangedBy); TX_LASTCHANGEDAT.setText(" Last Changed at : " + DS_1.getInfo().lastChangedAt); //show popup POPUP_INFO.show();. 43.

(164) Objective w learn how w to jump frrom one app plication to another. Seelected valu ues will In this exerrcise you will be transferrred via URL-Paramete ers. Result Exercise R Sender Ap pplication. Receive er Application. In the send der applicattion the use er selects a county and then clicks s on a line oof the crossttab. These two values (country and division) will be transferrred to the receiver r appplication wh hich shows morre detailed data d on cus stomer leve l.. 44. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 6 Jump from one e applica ation to another a a applicatiion 2.6.1 Exercise 6:.

(165) BOD310 E Exercise Manual M. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). Exercise D Description n 1. Creatte a new ap pplication U# ##_APP_16 6_FROM 2. Creatte the Data Source DS_1 for Query P_OR RDERS_011 and chang ge the Initia al View accorrding to the screen. 3. Add a Text Box “Jump p From App plication” Add a Dropdown n Box Add a Crosstab  In tthe end you ur Outline should d look like the t one on the rig ght.. . . 4. Define an “on Startup” Scrip pt for the Ap pplication th hat fills the Dropdown D B Box with the e members of dimen nsion Country of Data Source DS_ _1 elect” Scriptt for the Dro opdown Box x that filters DS_1 5. Define an “on Se. 45.

(166) 7. Creatte the Data Source DS_1 for Query P_OR RDERS_013 3 and chang ge the Initia al View accorrding to the screen. 8. Add a Text Field “Jump p To Application” Add 2 Text Fields to displa ay the transsferred filter vvalues Add a Crosstab  In tthe end you ur Outline should d look like the t one on the rig ght. 9. Define 2 global script s variab bles that ca an be used as UR RL Parametters. 46. . Xd division. . Xccountry. . This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). 6. Creatte a new ap pplication U# ##_APP_16 6_TO.

(167) 10. Define an “on Startup” Script for the Application that use the 2 URL parameter as filter values and display them in the text fields. 11. Start the BI Launch Pad and find out the unique identifier CUID for your “U##_APP_16_TO” application 12. Open your U##_APP_16_FROM application and enable the selection of the crosstab. Define an “on Select” event that opens a new browser window and with the U##_APP_16_TO application in. You need the OpenDocument syntax for that and the CUID of the target application. You must run your application on the server to be able to jump to the target. The jump will not work when you execute the application locally.. 47. This material is for the Exclusive Use of Registered Students in SAP Virtual Classroom Deliveries (UK). BOD310 Exercise Manual.

No results found