WebI报表设计高级功能行业信息

1、webi报表设计高级功能（bw320） sap bo顾问顾问 2010年年09月月09日日议 程n复习webi报表设计基础课程n高级报表查询技术n使用计算上下文n利用字符和时间函数创建公式n使用if逻辑n高级报表展现技术n使用超链接n实践练习，测试实践练习，测试 sapphire 2008 or 4238/ page 2web intelligence定位nsap bi模块报表解决方案的一部分n快速获取信息以帮助决策n即席查询（ad-hoc query） sapphire 2008 or 4238/ page 3web intelligence数据读取流程 sapphire 2008 or 4

2、238/ page 4习题1.what is a universe?2.list the object types used in a universe, and the kind of data returned by each type？3.what is the difference between a query filter and a report filter? 4.what are the three components that make up a web intelligence document?5.what are the differences between ap

3、plying breaks and sections to a report?6.what is a scope of analysis for a query? sapphire 2008 or 4238/ page 5习题答案：1. what is a universe?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 intelligenc

4、e.2. list the object types used in a 2. list the object types used in a businessobjectsbusinessobjects universe, and the kind of data universe, and the kind of data returned by each type.returned by each type.answer: dimension objects: character-type data, dates, and non-aggregated numeric data, for

5、 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 6习题答案：3. what is the difference between a query filter and a report filter?3. what is

6、 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 report simply by hidin

7、g the data you are not interested in.4. what are the three components that make up a web intelligence document?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习题答案：5. what ar

8、e the differences between applying breaks and sections to a report?5. what are the differences between applying breaks and sections to 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 bl

9、ock, whereas sectioning groups the entire report. sapphire 2008 or 4238/ page 8习题答案：6. what is a scope of analysis for a query?6. what is a scope of analysis for a query?answer:the scope of analysis for a query is extra levels of data in an objects hierarchy that you can retrieve from the database t

10、o 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 provider, so you can pull this data into the report to allow you to access more detail at any time. sapphire 2008 or 4238/ pa

11、ge 9议 程n复习webi报表设计基础课程n高级报表查询技术n使用计算上下文n利用字符和时间函数创建公式n使用if逻辑n高级报表展现技术n使用超链接n实践练习，测验实践练习，测验 sapphire 2008 or 4238/ page 10web intelligence组合查询n使用两个查询n使用集合函数对结果进行合并，作为webi报表的数据源 sapphire 2008 or 4238/ page 11web intelligence合并查询的优缺点优点优点n逻辑更清晰n可以实现一次查询无法完成的功能缺点缺点n对性能有影响 sapphire 2008 or 4238/ page 12we

12、b intelligence查询过滤器 子查询n一个过滤的操作数事先未知，依赖于另一个过滤n假设场景：销售经理需要知道大于chicago 33rd仓库的销售额的那些仓库，并且列车仓库名和它们的销售额？ sapphire 2008 or 4238/ page 13web intelligence使用多个查询一个webi文档可以基于多个查询（数据源），可以有多个块n一个查询投射到多个块n基于一个universe的多个查询n基于不同universe的多个查询 sapphire 2008 or 4238/ page 14web intelligence使用多个查询n一个数据块使用多个查询的数据时，得到

13、的数据不准确n融合数据以解决问题 sapphire 2008 or 4238/ page 15web intelligence合并多数据源的数据 sapphire 2008 or 4238/ page 16web intelligence数据融合: 维度的融合 sapphire 2008 or 4238/ page 17议 程n复习webi报表设计基础课程n高级报表查询技术n使用计算上下文n利用字符和时间函数创建公式n使用if逻辑n高级报表展现技术n使用超链接n实践练习，测验实践练习，测验 sapphire 2008 or 4238/ page 18web intelligence计算上下文概

14、念 sapphire 2008 or 4238/ page 19states best year amount=max(sales revenue)web intelligence输入计算上下文输入上下文直接包含在计算公式中的维度对象决定计算聚合的层次 sapphire 2008 or 4238/ page 20states best year amount=max(sales revenue in(year ; state)web intelligence输入计算上下文输入上下文直接包含在计算公式中的维度对象决定计算聚合的层次 sapphire 2008 or 4238/ page 21we

15、b intelligence输入计算上下文 sapphire 2008 or 4238/ page 22=average(sales revenue)=average(sales revenue) in blockweb intelligence输出计算上下文输出上下文写在计算公式之外从计算好的结果中选择 sapphire 2008 or 4238/ page 23web intelligence输出计算上下文 sapphire 2008 or 4238/ page 24议 程n复习webi报表设计基础课程n高级报表查询技术n使用计算上下文n利用字符和时间函数创建公式n使用if逻辑n高级报表展

16、现技术n使用超链接n实践练习，测验实践练习，测验 sapphire 2008 or 4238/ page 25web intelligence变量n字符串函数nreplace - used to replace a specified string with another string.nright - used to extract a given number of characters from the right.nleft - used to extract a given number of characters from the left.nsubstr - used to e

17、xtract a string of variable length and position.nlength - used to identify the length of a string.npos - used to identify the position of a character in a string.nmatch - used to determine whether a character string matches a particular pattern.n可以使用通配符n? 任意一个字符n* 任意多个字符 sapphire 2008 or 4238/ page

18、26web intelligence变量n日期函数ntodate: changes the data type of a value to datencurrentdate: gives the date todayndaysbetween: calculates the number of days between two dates lace - used to replace a specified string with another stringnlastexecutiondate(string data_provider)nformatdate(lastexecutiondate

19、() ; mmmm dd, yyyy) sapphire 2008 or 4238/ page 27议 程n复习webi报表设计基础课程n高级报表查询技术n使用计算上下文n利用字符和时间函数创建公式n使用if逻辑n高级报表展现技术n使用超链接n实践练习，测验实践练习，测验 sapphire 2008 or 4238/ page 28web intelligenceif逻辑if(条件;条件为真表达式;条件为假表达式)例子：=if(quarter inlist(q1;q2); years first half; years second half)=ifquarter inlist(q1;q2)

20、then years first half else years second half sapphire 2008 or 4238/ page 29web intelligenceif逻辑应用场景：分组n=ifquarter inlist(q1;q2) then years first half else years second half sapphire 2008 or 4238/ page 30web intelligenceif逻辑应用场景：基于条件的计算n=ifstate=california then sales revenue*1.05 elseif state inlist

21、(dc ; florida ; illinois ; new york ; texas ) then sales revenue*1.15 sapphire 2008 or 4238/ page 31议 程n复习webi报表设计基础课程n高级报表查询技术n使用计算上下文n利用字符和时间函数创建公式n使用if逻辑n其他报表展现技术n使用超链接n实践练习，测验实践练习，测验 sapphire 2008 or 4238/ page 32web intelligencematch（）函数=if match(store name ; *sundance) then sundance elseif mat

22、ch(store name; *magnolia) then magnolia else un- branded sapphire 2008 or 4238/ page 33web intelligencerunning聚合函数runningsum, runningaverage, runningcount, runningmin=runningsum(sales revenue) sapphire 2008 or 4238/ page 34web intelligencenofiltern覆盖报表使用的过滤或排序n可用于计算未分类部分的值=sum(sales revenue)=nofilte

23、r(sum(sales revenue)-sum(sales revenue)=nofilter(sum(sales revenue) sapphire 2008 or 4238/ page 35议 程n复习webi报表设计基础课程n高级报表查询技术n使用计算上下文n利用字符和时间函数创建公式n使用if逻辑n高级报表展现技术n使用超链接n实践练习，测验实践练习，测验 sapphire 2008 or 4238/ page 36web intelligence超链接n给数据加上超级链接n将当前数据作为超级链接的参数n使用opendoc连接到另一个文档=a href=+http:/:8080/op

24、endocument/opendoc/opendocument.jsp?+&stype=wid+&sdocname=detailed+sales+report+&lssenter+state:=+replace(state ;%20) + +state+“http:/ :/:8080/opendocument/opendoc/opendocument.jsp?idocid=1234 sapphire 2008 or 4238/ page 37议 程n复习webi报表设计基础课程n高级报表查询技术n使用计算上下文n利用字符和时间函数创建公式n使用if逻辑n高级报表展现技术

25、n使用超链接n实践练习，测验 sapphire 2008 or 4238/ page 38测验1n使用efasion的示例universe，根据如下的维度和计量，创建如下格式的报表：n目的: 练习交叉表，报表拆分和函数的使用，报表的格式化 sapphire 2008 or 4238/ page 39测验2n使用efasion的示例universe，根据如下的维度和计量，创建如下格式的报表：n目的: 练习报表警报的 高亮显示 sapphire 2008 or 4238/ page 40测验3n使用efasion的示例universe，根据如下的维度和计量，创建如下格式的报表：n目的: 练习报表的

26、表与图的组合使用，报表节以及基于节的汇总 sapphire 2008 or 4238/ page 41测验4n使用efasion的示例universe，根据如下的维度和计量，创建如下格式的报表：ndocumentauthor()函数以显示作者nuserresponse()以显示报表用户输入的报表过滤参数n变量variable plus = 20%的的quantity soldn变量变量variable total =quantity sold与与plus变量之和n目的: 练习表头数据的显示，以及公式变量的使用 sapphire 2008 or 4238/ page 42测验5in a single document, build 2 queries using the following objects: store name and sales revenue (efashion universe in root folder) store name and quantity sold （a excel data fr