webi報(bào)表設(shè)計(jì)高級(jí)功能

1、WebI報(bào)表設(shè)計(jì)高級(jí)功能（BW320） SAP BO顧問 2010年09月09日議 程復(fù)習(xí)WebI報(bào)表設(shè)計(jì)基礎(chǔ)課程高級(jí)報(bào)表查詢技術(shù)使用計(jì)算上下文利用字符和時(shí)間函數(shù)創(chuàng)建公式使用IF邏輯高級(jí)報(bào)表展現(xiàn)技術(shù)使用超鏈接實(shí)踐練習(xí)，測(cè)試Web Intelligence定位SAP BI模塊報(bào)表解決方案的一部分快速獲取信息以幫助決策即席查詢（ad-hoc query） SAP 2008 / Page 3Web Intelligence數(shù)據(jù)讀取流程 SAP 2008 / Page 4習(xí)題What is a universe?List the object types used in a universe, and

2、 the kind of data returned by each type？What is the difference between a query filter and a report filter? What are the three components that make up a Web Intelligence document?What are the differences between applying breaks and sections to a report?What is a Scope of Analysis for a query? SAPPHIR

3、E 2008 OR 4238/ Page 5習(xí)題答案：1. What is a universe?Answer: A universe is the BusinessObjects semantic layer that maps to data in a database and is used for creating queries in Web Intelligence.2. List the object types used in a BusinessObjects universe, and the kind of data returned by each type.Answe

4、r: Dimension objects: Character-type data, dates, and non-aggregated numeric data, for example telephone numbers. Dimensions are the key elements of a query.Measure objects: Numeric- or fact-type dataDetail objects: Character- or date-type data (supplementary information) SAPPHIRE 2008 OR 4238/ Page

5、 6習(xí)題答案：3. What is the difference between a query filter and a report filter?Answer: A query filter is created in the Query panel to limit the data retrieved from the database; a report filter is created in the Web Intelligence Rich Client window and allows you to restrict the data shown in the repor

6、t simply by hiding the data you are not interested in.4. What are the three components that make up a Web Intelligence document?Answer: Reports, blocks (tables and charts), and the microcube of data SAPPHIRE 2008 OR 4238/ Page 7習(xí)題答案：5. What are the differences between applying breaks and sections to

7、 a report?Answer:The difference is that the grouped value appears as a header outside the block instead of remaining within the block. A break only groups within a block, whereas sectioning groups the entire report. SAPPHIRE 2008 OR 4238/ Page 8習(xí)題答案：6. What is a Scope of Analysis for a query?Answer:

8、The scope of analysis for a query is extra levels of data in an objects hierarchy that you can retrieve from the database to give more detailed data returned by each of the objects. This extra data does not appear in the initial document results, but it remains available in the data cube, or data pr

9、ovider, so you can pull this data into the report to allow you to access more detail at any time. SAPPHIRE 2008 OR 4238/ Page 9議 程復(fù)習(xí)WebI報(bào)表設(shè)計(jì)基礎(chǔ)課程高級(jí)報(bào)表查詢技術(shù)使用計(jì)算上下文利用字符和時(shí)間函數(shù)創(chuàng)建公式使用IF邏輯高級(jí)報(bào)表展現(xiàn)技術(shù)使用超鏈接實(shí)踐練習(xí)，測(cè)驗(yàn)Web Intelligence組合查詢 SAP 2008 / Page 11使用兩個(gè)查詢使用集合函數(shù)對(duì)結(jié)果進(jìn)行合并，作為WebI報(bào)表的數(shù)據(jù)源Web Intelligence合并查詢的優(yōu)缺點(diǎn)優(yōu)點(diǎn)邏輯更清晰

10、可以實(shí)現(xiàn)一次查詢無法完成的功能缺點(diǎn)對(duì)性能有影響Web Intelligence查詢過濾器 子查詢 SAP 2008 / Page 13一個(gè)過濾的操作數(shù)事先未知，依賴于另一個(gè)過濾假設(shè)場(chǎng)景：銷售經(jīng)理需要知道大于Chicago 33rd倉庫的銷售額的那些倉庫，并且列車倉庫名和它們的銷售額？Web Intelligence使用多個(gè)查詢 SAP 2008 / Page 14一個(gè)WebI文檔可以基于多個(gè)查詢（數(shù)據(jù)源），可以有多個(gè)塊一個(gè)查詢投射到多個(gè)塊基于一個(gè)universe的多個(gè)查詢基于不同universe的多個(gè)查詢Web Intelligence使用多個(gè)查詢 SAP 2008 / Page 15一個(gè)數(shù)據(jù)

11、塊使用多個(gè)查詢的數(shù)據(jù)時(shí)，得到的數(shù)據(jù)不準(zhǔn)確融合數(shù)據(jù)以解決問題Web Intelligence合并多數(shù)據(jù)源的數(shù)據(jù)Web Intelligence數(shù)據(jù)融合: 維度的融合 SAP 2008 / Page 17議 程復(fù)習(xí)WebI報(bào)表設(shè)計(jì)基礎(chǔ)課程高級(jí)報(bào)表查詢技術(shù)使用計(jì)算上下文利用字符和時(shí)間函數(shù)創(chuàng)建公式使用IF邏輯高級(jí)報(bào)表展現(xiàn)技術(shù)使用超鏈接實(shí)踐練習(xí)，測(cè)驗(yàn) SAPPHIRE 2008 OR 4238/ Page 19Web Intelligence計(jì)算上下文概念 SAPPHIRE 2008 OR 4238/ Page 20States best year amount=max(Sales revenue)We

12、b Intelligence輸入計(jì)算上下文輸入上下文直接包含在計(jì)算公式中的維度對(duì)象決定計(jì)算聚合的層次 SAPPHIRE 2008 OR 4238/ Page 21States best year amount=max(Sales revenue In(Year ; State)Web Intelligence輸入計(jì)算上下文輸入上下文直接包含在計(jì)算公式中的維度對(duì)象決定計(jì)算聚合的層次 SAPPHIRE 2008 OR 4238/ Page 22Web Intelligence輸入計(jì)算上下文 SAPPHIRE 2008 OR 4238/ Page 23=Average(Sales revenue)=

13、Average(Sales revenue) In BlockWeb Intelligence輸出計(jì)算上下文輸出上下文寫在計(jì)算公式之外從計(jì)算好的結(jié)果中選擇 SAPPHIRE 2008 OR 4238/ Page 24Web Intelligence輸出計(jì)算上下文議 程復(fù)習(xí)WebI報(bào)表設(shè)計(jì)基礎(chǔ)課程高級(jí)報(bào)表查詢技術(shù)使用計(jì)算上下文利用字符和時(shí)間函數(shù)創(chuàng)建公式使用IF邏輯高級(jí)報(bào)表展現(xiàn)技術(shù)使用超鏈接實(shí)踐練習(xí)，測(cè)驗(yàn)Web Intelligence變量 SAP 2008 / Page 26字符串函數(shù)Replace - used to replace a specified string with anothe

14、r string.Right - used to extract a given number of characters from the right.Left - used to extract a given number of characters from the left.SubStr - used to extract a string of variable length and position.Length - used to identify the length of a string.Pos - used to identify the position of a c

15、haracter in a string.Match - used to determine whether a character string matches a particular pattern.可以使用通配符? 任意一個(gè)字符* 任意多個(gè)字符Web Intelligence變量 SAP 2008 / Page 27日期函數(shù)ToDate: changes the data type of a value to dateCurrentDate: gives the date todayDaysBetween: calculates the number of days between t

16、wo dates lace - used to replace a specified string with another stringLastExecutionDate(string data_provider)FormatDate(LastExecutionDate() ; Mmmm dd, yyyy)議 程復(fù)習(xí)WebI報(bào)表設(shè)計(jì)基礎(chǔ)課程高級(jí)報(bào)表查詢技術(shù)使用計(jì)算上下文利用字符和時(shí)間函數(shù)創(chuàng)建公式使用IF邏輯高級(jí)報(bào)表展現(xiàn)技術(shù)使用超鏈接實(shí)踐練習(xí)，測(cè)驗(yàn)Web IntelligenceIf邏輯 SAP 2008 / Page 29If(條件;條件為真表達(dá)式;條件為假表達(dá)式)例子：=If(Quart

17、er InList(Q1;Q2); Years First Half; Years Second Half)=IfQuarter InList(Q1;Q2) Then Years First Half Else Years Second HalfWeb IntelligenceIf邏輯 SAP 2008 / Page 30應(yīng)用場(chǎng)景：分組=IfQuarter InList(Q1;Q2) Then Years First Half Else Years Second HalfWeb IntelligenceIf邏輯 SAP 2008 / Page 31應(yīng)用場(chǎng)景：基于條件的計(jì)算=IfState=Ca

18、lifornia Then Sales revenue*1.05 ElseIf State InList (DC ; Florida ; Illinois ; New York ; Texas ) Then Sales revenue*1.15議 程復(fù)習(xí)WebI報(bào)表設(shè)計(jì)基礎(chǔ)課程高級(jí)報(bào)表查詢技術(shù)使用計(jì)算上下文利用字符和時(shí)間函數(shù)創(chuàng)建公式使用IF邏輯其他報(bào)表展現(xiàn)技術(shù)使用超鏈接實(shí)踐練習(xí)，測(cè)驗(yàn)Web IntelligenceMatch（）函數(shù) SAP 2008 / Page 33=If Match(Store name ; *Sundance) Then Sundance ElseIf Match(St

19、ore name; *Magnolia) Then Magnolia Else Un- BrandedWeb IntelligenceRunning聚合函數(shù) SAP 2008 / Page 34RunningSum, RunningAverage, RunningCount, RunningMin=RunningSum(Sales revenue)Web IntelligenceNoFilter SAP 2008 / Page 35覆蓋報(bào)表使用的過濾或排序可用于計(jì)算未分類部分的值=Sum(Sales revenue)=NoFilter(Sum(Sales revenue)-Sum(Sales

20、revenue)=NoFilter(Sum(Sales revenue)議 程復(fù)習(xí)WebI報(bào)表設(shè)計(jì)基礎(chǔ)課程高級(jí)報(bào)表查詢技術(shù)使用計(jì)算上下文利用字符和時(shí)間函數(shù)創(chuàng)建公式使用IF邏輯高級(jí)報(bào)表展現(xiàn)技術(shù)使用超鏈接實(shí)踐練習(xí)，測(cè)驗(yàn)Web Intelligence超鏈接 SAP 2008 / Page 37給數(shù)據(jù)加上超級(jí)鏈接將當(dāng)前數(shù)據(jù)作為超級(jí)鏈接的參數(shù)使用opendoc連接到另一個(gè)文檔=a href=+http:/:8080/OpenDocument/opendoc/openDocument.jsp?+&sType=wid+&sDocName=Detailed+Sales+Report+&lsSEnter+St

21、ate:=+Replace(State ;%20) + +State+“http:/ :/:8080/OpenDocument/opendoc/openDocument.jsp?iDocID=1234議 程復(fù)習(xí)WebI報(bào)表設(shè)計(jì)基礎(chǔ)課程高級(jí)報(bào)表查詢技術(shù)使用計(jì)算上下文利用字符和時(shí)間函數(shù)創(chuàng)建公式使用IF邏輯高級(jí)報(bào)表展現(xiàn)技術(shù)使用超鏈接實(shí)踐練習(xí)，測(cè)驗(yàn)測(cè)驗(yàn)1 SAPPHIRE 2008 OR 4238/ Page 39使用eFasion的示例Universe，根據(jù)如下的維度和計(jì)量，創(chuàng)建如下格式的報(bào)表：目的: 練習(xí)交叉表，報(bào)表拆分和函數(shù)的使用，報(bào)表的格式化 SAPPHIRE 2008 OR 4238/ Pa

22、ge 40測(cè)驗(yàn)2使用eFasion的示例Universe，根據(jù)如下的維度和計(jì)量，創(chuàng)建如下格式的報(bào)表：目的: 練習(xí)報(bào)表警報(bào)的 高亮顯示 SAPPHIRE 2008 OR 4238/ Page 41測(cè)驗(yàn)3使用eFasion的示例Universe，根據(jù)如下的維度和計(jì)量，創(chuàng)建如下格式的報(bào)表：目的: 練習(xí)報(bào)表的表與圖的組合使用，報(bào)表節(jié)以及基于節(jié)的匯總 SAPPHIRE 2008 OR 4238/ Page 42測(cè)驗(yàn)4使用eFasion的示例Universe，根據(jù)如下的維度和計(jì)量，創(chuàng)建如下格式的報(bào)表：DocumentAuthor()函數(shù)以顯示作者UserResponse()以顯示報(bào)表用戶輸入的報(bào)表過濾參數(shù)變量Variable PLUS = 20%的Quantity Sold變量variable TOTAL =Quantity Sold與PLUS變量之和目的: 練習(xí)表頭數(shù)據(jù)的顯示，以及公式變量的使用測(cè)驗(yàn)5In a single document, build 2 queries using the following objects: Store name and Sales revenue (eFashion universe in root folder) St