WebI报表设计高级功能-PPT.ppt

WebI报表设计高级功能

议程复习WebI报表设计基础课程高级报表查询技术使用计算上下文利用字符和时间函数创建公式使用IF逻辑高级报表展现技术使用超链接实践练习，测试

WebIntelligence

定位SAPBI模块报表解决方案的一部分快速获取信息以帮助决策即席查询（ad-hocquery）3

WebIntelligence

数据读取流程4

习题Whatisauniverse?Listtheobjecttypesusedinauniverse,andthekindofdatareturnedbyeachtype？Whatisthedifferencebetweenaqueryfilterandareportfilter?WhatarethethreecomponentsthatmakeupaWebIntelligencedocument?Whatarethedifferencesbetweenapplyingbreaksandsectionstoareport?WhatisaScopeofAnalysisforaquery?5

习题答案：1.Whatisauniverse?Answer:AuniverseistheBusinessObjectssemanticlayerthatmapstodatainadatabaseandisusedforcreatingqueriesinWebIntelligence.2.ListtheobjecttypesusedinaBusinessObjectsuniverse,andthekindofdatareturnedbyeachtype.Answer:Dimensionobjects:Character-typedata,dates,andnon-aggregatednumericdata,forexampletelephonenumbers.Dimensionsarethekeyelementsofaquery.Measureobjects:Numeric-orfact-typedataDetailobjects:Character-ordate-typedata(supplementaryinformation)6

习题答案：3.Whatisthedifferencebetweenaqueryfilterandareportfilter?Answer:AqueryfilteriscreatedintheQuerypaneltolimitthedataretrievedfromthedatabase;areportfilteriscreatedintheWebIntelligenceRichClientwindowandallowsyoutorestrictthedatashowninthereportsimplybyhidingthedatayouarenotinterestedin.4.WhatarethethreecomponentsthatmakeupaWebIntelligencedocument?Answer:Reports,blocks(tablesandcharts),andthemicrocubeofdata7

大家应该也有点累了，稍作休息大家有疑问的，可以询问和交流8

习题答案：5.Whatarethedifferencesbetweenapplyingbreaksandsectionstoareport?Answer:Thedifferenceisthatthegroupedvalueappearsasaheaderoutsidetheblockinsteadofremainingwithintheblock.Abreakonlygroupswithinablock,whereassectioninggroupstheentirereport.9

习题答案：6.WhatisaScopeofAnalysisforaquery?Answer:Thescopeofanalysisforaquery