`
blueoxygen
  • 浏览: 1193495 次
  • 性别: Icon_minigender_1
社区版块
存档分类
最新评论
文章列表
In my previous blog http://sap.iteye.com/blog/1263970, I introduced the apporach of capturing MDX statements from RSTT trace. But in some cases, this could be very time-consuming and complex. There is a new tool from SAP to make our life eaiser. Please check note 1406664 to install this tool.
When there is drill down of WebI which is built against  BEx Query, it is better to always check "Query Drill Down" option to minimize the data to be transfered and processed in WebI.   Please check these this if you don't know this option: http://www.msatish.com/sap-businessobjects-web- ...
Fast update by report SAP_RSADMIN_MAINTAIN
http://wiki.sdn.sap.com/wiki/display/BI/BW+Table+Types+(MD+tbl,+SID+tbl,+DIM+tbl,+etc)
注:由于时间有限,我并没有深入去了解Oracle的产品。本文中一些结论只是根绝经验的推测和猜测。 Oracle Essbass可能是很特别的一个产品。因为我们知道本身Essbass就是当年Hyperion收购来的,而后经过Hyperion的多年整合和开发又被Oracle一同收入囊中,这必然出现整合的问题,所以也就产生了最开始我看到此ORACLE BI产品时的疑问。   毫无疑问Essbass是伟大的产品,它被评为过去10年最具影响力的技术创新之一。但是我们也知道它的强大在于Essbase最初是多维度数据库管理系统而问世,即MDBMS。只有MDBMS当然不够完善,于是最初的Arbor软件 ...
注:由于时间有限,我并没有深入去了解Oracle的产品。本文中一些结论只是根绝经验的推测和猜测。   Oracle BI产品里一个重要部分便是BI Publisher。http://www.youtube.com/watch?v=BnhpNd5qz6o&feature=related这是一个与Crystal Report几乎功能一样的产品。我相信在11g里一定有很大的改善,这里有一个共5部分组成的视频。http://www.youtube.com/watch?v=X31ipkXn7Sw 不过众所周知,CrystalDecision的Crystal Report几乎成为了业内高度格式 ...
注:由于时间有限,我并没有深入去了解Oracle的产品。本文中一些结论只是根绝经验的推测和猜测。   根据Gartner最近发布的报告,SAP是BI市场份额第一的厂商,紧随其后的是Oracle。于是最近想了解下这个虎视眈眈第一把交椅的 ...
With SAP ECC6 EHP5, there is a new function enhancement with enable SAP BusinessObjects BI to report against data in SAP ECC as BEx Query. Certainly Crystal Report can consume SAP ECC data for ages but it is not working like report off a BEx query. If the customer has no BW system in place but would ...
Basically there are two possible solutions:1) system environment variable -> SAPLOGON_INI_FILEhttp://forums.sdn.sap.com/thread.jspa?threadID=14655082) corrupted saplogon.ini -> Note 1219265
As long as we are still on BW+XI 3.x+IK, we need to take account of this. Once we move to BI 4.0, we are good since we get rid of universe.   http://wiki.sdn.sap.com/wiki/display/BOBJ/Impact+of+a+BEx+query+change+to+universes+and+WebI+documents
Really cool! There is a video demo.   http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26747
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/004eccb2-801a-2e10-aca4-c52a16ad783a
We know WEBI reports off BEx Query, wo can capture SOFA and MDX log as per my bloghttp://sap.iteye.com/blog/1211795   But this is also possible from BW side via RSTT trace. Please look at this article. http://bhargavgandhi.blogspot.com/2011/07/capturing-mdx-statement-in-sap-bw-for.html
KB 1590525    
如果BW query是Multi-structure结构,那么建立的universe有如下规则: 对于characteristic structure,universe建立一个structure object 对于keyfigure structure, universe为每一个keyfigure建立一个object       
Global site tag (gtag.js) - Google Analytics