欢迎来到天天文库
浏览记录
ID:30527611
大小:3.49 MB
页数:48页
时间:2018-12-31
《WebI报表设计高级功能 参赛课件》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、WebI报表设计高级功能(BW320)SAPBO顾问2010年09月09日参赛选手:*****议程复习WebI报表设计基础课程高级报表查询技术使用计算上下文利用字符和时间函数创建公式使用IF逻辑高级报表展现技术使用超链接实践练习,测试WebIntelligence定位SAPBI模块报表解决方案的一部分快速获取信息以帮助决策即席查询(ad-hocquery)©SAP2008/Page3WebIntelligence数据读取流程©SAP2008/Page4习题Whatisauniverse?Listtheobjecttypesusedinauniverse,andthekindofdatare
2、turnedbyeachtype?Whatisthedifferencebetweenaqueryfilterandareportfilter?WhatarethethreecomponentsthatmakeupaWebIntelligencedocument?Whatarethedifferencesbetweenapplyingbreaksandsectionstoareport?WhatisaScopeofAnalysisforaquery?©SAPPHIRE2008OR4238/Page5习题答案:1.Whatisauniverse?Answer:AuniverseistheBu
3、sinessObjectssemanticlayerthatmapstodatainadatabaseandisusedforcreatingqueriesinWebIntelligence.2.ListtheobjecttypesusedinaBusinessObjectsuniverse,andthekindofdatareturnedbyeachtype.Answer:Dimensionobjects:Character-typedata,dates,andnon-aggregatednumericdata,forexampletelephonenumbers.Dimensionsa
4、rethekeyelementsofaquery.Measureobjects:Numeric-orfact-typedataDetailobjects:Character-ordate-typedata(supplementaryinformation)©SAPPHIRE2008OR4238/Page6习题答案:3.Whatisthedifferencebetweenaqueryfilterandareportfilter?Answer:AqueryfilteriscreatedintheQuerypaneltolimitthedataretrievedfromthedatabase;a
5、reportfilteriscreatedintheWebIntelligenceRichClientwindowandallowsyoutorestrictthedatashowninthereportsimplybyhidingthedatayouarenotinterestedin.4.WhatarethethreecomponentsthatmakeupaWebIntelligencedocument?Answer:Reports,blocks(tablesandcharts),andthemicrocubeofdata©SAPPHIRE2008OR4238/Page7习题答案:5
6、.Whatarethedifferencesbetweenapplyingbreaksandsectionstoareport?Answer:Thedifferenceisthatthegroupedvalueappearsasaheaderoutsidetheblockinsteadofremainingwithintheblock.Abreakonlygroupswithinablock,whereassectioninggroupstheentirereport.©SAPPHIRE2008OR4238/Page8习题答案:6.WhatisaScopeofAnalysisforaque
7、ry?Answer:Thescopeofanalysisforaqueryisextralevelsofdatainanobject'shierarchythatyoucanretrievefromthedatabasetogivemoredetaileddatareturnedbyeachoftheobjects.Thisextradatadoesnotappearintheinitialdocumentresults
此文档下载收益归作者所有