1、WebI报表设计高级功能(BW320),SAP BO顾问 2010年09月09日,议 程,复习WebI报表设计基础课程高级报表查询技术使用计算上下文利用字符和时间函数创建公式使用IF逻辑高级报表展现技术使用超链接实践练习,测试,Web Intelligence定位,SAP BI模块报表解决方案的一部分快速获取信息以帮助决策即席查询(ad-hoc query),SAP 2008/Page 3,Web Intelligence数据读取流程,SAP 2008/Page 4,习题,What is a universe?List the object types used in a universe,a
2、nd 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?,SAPPHI
3、RE 2008 OR 4238/Page 5,习题答案:,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.Answer:
4、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 6,习题答案:,3.Wha
5、t 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 report simply by hid
6、ing 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,习题答案:,5.What are the differences between applying breaks and sections to a report?Answer:The
7、 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,习题答案:,6.What is a Scope of Analysis for a query?Answer:The scope of analysis
8、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 provider,so you can pull th
9、is data into the report to allow you to access more detail at any time.,SAPPHIRE 2008 OR 4238/Page 9,议 程,复习WebI报表设计基础课程高级报表查询技术使用计算上下文利用字符和时间函数创建公式使用IF逻辑高级报表展现技术使用超链接实践练习,测验,Web Intelligence组合查询,SAP 2008/Page 11,使用两个查询使用集合函数对结果进行合并,作为WebI报表的数据源,Web Intelligence合并查询的优缺点,优点逻辑更清晰可以实现一次查询无法完成的功能缺点对性能有影响
10、,Web Intelligence查询过滤器 子查询,SAP 2008/Page 13,一个过滤的操作数事先未知,依赖于另一个过滤假设场景:销售经理需要知道大于Chicago 33rd仓库的销售额的那些仓库,并且列车仓库名和它们的销售额?,Web Intelligence使用多个查询,SAP 2008/Page 14,一个WebI文档可以基于多个查询(数据源),可以有多个块一个查询投射到多个块基于一个universe的多个查询基于不同universe的多个查询,Web Intelligence使用多个查询,SAP 2008/Page 15,一个数据块使用多个查询的数据时,得到的数据不准确融合数
11、据以解决问题,Web Intelligence合并多数据源的数据,Web Intelligence数据融合:维度的融合,SAP 2008/Page 17,议 程,复习WebI报表设计基础课程高级报表查询技术使用计算上下文利用字符和时间函数创建公式使用IF逻辑高级报表展现技术使用超链接实践练习,测验,SAPPHIRE 2008 OR 4238/Page 19,Web Intelligence计算上下文概念,SAPPHIRE 2008 OR 4238/Page 20,States best year amount=max(Sales revenue),Web Intelligence输入计算上下文
12、,输入上下文直接包含在计算公式中的维度对象决定计算聚合的层次,SAPPHIRE 2008 OR 4238/Page 21,States best year amount=max(Sales revenue In(Year;State),Web Intelligence输入计算上下文,输入上下文直接包含在计算公式中的维度对象决定计算聚合的层次,SAPPHIRE 2008 OR 4238/Page 22,Web Intelligence输入计算上下文,SAPPHIRE 2008 OR 4238/Page 23,=Average(Sales revenue),=Average(Sales reven
13、ue)In Block,Web Intelligence输出计算上下文,输出上下文写在计算公式之外从计算好的结果中选择,SAPPHIRE 2008 OR 4238/Page 24,Web Intelligence输出计算上下文,议 程,复习WebI报表设计基础课程高级报表查询技术使用计算上下文利用字符和时间函数创建公式使用IF逻辑高级报表展现技术使用超链接实践练习,测验,Web Intelligence变量,SAP 2008/Page 26,字符串函数Replace-used to replace a specified string with another string.Right-use
14、d 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 character in a string.Match-u
15、sed to determine whether a character string matches a particular pattern.可以使用通配符?任意一个字符*任意多个字符,Web Intelligence变量,SAP 2008/Page 27,日期函数ToDate:changes the data type of a value to dateCurrentDate:gives the date todayDaysBetween:calculates the number of days between two dates lace-used to replace a spe
16、cified string with another stringLastExecutionDate(string data_provider)FormatDate(LastExecutionDate();Mmmm dd,yyyy),议 程,复习WebI报表设计基础课程高级报表查询技术使用计算上下文利用字符和时间函数创建公式使用IF逻辑高级报表展现技术使用超链接实践练习,测验,Web IntelligenceIf逻辑,SAP 2008/Page 29,If(条件;条件为真表达式;条件为假表达式)例子:=If(Quarter InList(Q1;Q2);Years First Half;Years Second Half)=IfQuarter InList(Q1;Q2)Then Years First Half Else Years Second Half,Web IntelligenceIf逻辑,SAP 2008/Page 30,应用场景:分组=IfQuarter InList(Q1;Q2)Then Years First Half Else Years Second Half,Web
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1