SAP BW Query Performance Check List
Walkthrough Checklist for Query Performance1. If exclusions exist, make sure they exist in the global filter area. Try to remove exclusions by subtracting out inclusions.2. Use Constant Selection to ignore filters in order to move more filters to the global filter area. (Use ABAPer to test and validate that this ensures better code)3. Within structures, make sure the filter order exists with the highest level filter first.4. Check code for all exit variables used in a report.5. Move Time restric
2007年金科玉言
2007年金科玉言 --------------- 01、试金可以用火,试女人可以用金,试男人可以用女人。 02 、 男人要有钱,和谁都有缘。 03、亲人之间,谈到钱就伤感情;情人之间,谈到感情就伤钱。 04、我们产生一点小分歧:她希望我把粪土变黄金,我希望她视黄金如粪土! 05、当年是不上大学一辈子受穷,而现在是上了大学马上就受穷。 06、过去:一流学生出国,二流学生考研,三流学生就业。 现在:一流学生就业,二流学生出国,三流学生考研 07、顾客不是上帝,顾客只是上当。 08、在网上碰上一群流氓并不可怕,可怕的是碰上了一堆流氓软件。
SAP BW Certification questions
Hello Everone, Here are some general questions that I have gathered. These are NOT Copyrighted Material. If there is a problem with these please let me know, and also note that these have been compiled from various sources so the grammer is not all that great. IF YOU FIND any of the answers to be wrong please do let me know. I have many more if needed.1. What are the extractor types?• Application Specifico BW Content FI, HR, CO, SAP CRM, LO Cockpito Customer-Generated ExtractorsLIS, FI-SL,
SAP BW Certification Exam - My Experience
SAP BW Certification Exam - My Experience My SAP BW Certification Experience - The exam contains 80 questions and the time allotted for this 3 hours. Time duration is more than enough for 80 questions. The only thing you should have is Patience because you really get tired after reading all this questions and the respective 5 options for each question and that too confusing ones. I really got impatient when I was nearing 64, 65th question. And I think this is the reason I did very badl
爱上羽毛球,是爱上了一种生活方式
今天偶然看到这句话,觉得不错,记录如下:老婆是现实中的最亲的女人,羽毛球就是精神和身体上的情人,而音乐和书籍的世界则是自己心灵的后花园。爱上羽毛球,是爱上了一种生活方式,一种超越工作和俗世的境界。[@more@]
BW InfoProviders
1、 InfoProviders are objects for which you can create and execute queries in SAP BW. These includeobjects that physically store data – the data targets, such as InfoCubes, operational data store objects(ODS objects), and InfoObjects (characteristics with attributes or texts). They also include objectsthat do not contain any actual data, such as, InfoSets, RemoteCubes and MultiProviders.InfoProviders are the objects or views relevant to reporting.2、 Data targets are SAP BW objects that have t
BW Tips & Tricks
In your normal course of work in BW you would find yourself "stuck" in certain situations unable to decide how you would move forward. Some of these situations could be because certain functions are not available in the system. Most of these situations can be easily overcome if you know some "handy" tricks. I shall discuss some of the tips and tricks which should be useful to know for a BW consultant.ROOSOURCE issue:Enhancements are a never ending part in a project. There wou
“空军一号”座驾一览
空军一号简介 “空军一号”(Air Force One)作为美国总统的专机,有6层楼高,比篮球场还长。这架蓝白相间的波音747飞机已成为美国的权力象征,也成为美国霸权地位的国际图腾。 军事专家认为,美国的“空军一号”堪称世界上最精密、最具毁灭力的航空器。它的电子对抗系统可以干扰敌方雷达,迷惑导弹的瞄准系统,使其无法锁定目标。据英国《简氏防务周刊》介绍,“空军一号”还配备有一套定向武器系统,可以确定来袭导弹的方位,并发射激光或红外线光束,破坏导弹的制导系统。“空军一号”的探测设备也十分完备,能够与天基和陆基
“陆军一号”座驾一览
“陆军一号”历届美国总统座驾一览[图]! Y; ^; M4 u/ c* K: r0 z: a- e, v6 y( U0 ~$ @. S9 }% K7 j第一个有幸乘坐汽车的美国总统是第二十五任总统威廉·麦金莱。但是美国政府拥有第一辆汽车是在麦金莱之后的西奥多·罗斯福政府时期。其座驾1939Lincoln K Model(Brunn)—绰号:Sunshine Special ; V7 j7 O; Y7 X/ U: _" Z5 e- Z; A9 I7 i6 z$ ]) v3 Y0 |! s) F- 7 $ o艾森豪维尔总统乘坐的Ray Deitrich制造的1950 Lincoln Cosmopolitan[林肯] / D+ C4 U' U/ v o艾森豪维尔总统还拥有一辆克莱斯勒皇冠特大轿车 3 |: w$ T3 O) }( _4 F-
Getting started with SAP BW
Getting started with SAP BW (BI)by Gili As this is the first post in this blog, I would like (with your permission) to start with a personal note. I have been with Business Intelligence since year 2000. I worked on a plethora of tools, but never met a fascinating and complex tool like SAP Business Intelligence (aka SAP BW). After almost two years of working with BW on a daily basis, I can surely admit that moving into SAP BW was the wisest professional decision I made to date.Why you should cons
BW--Create Data Warehousing: Step by Step(摘自SAP Library)
Data Warehousing: Step by StepPurposeTo build a data warehouse, you have to execute certain process steps. Process Flow 1. Data modeling ○ Creating InfoObjects: Characteristics○ Creating InfoObjects: Key Figures○ Creating DataStore objects○ And/or creating InfoCubes○ And/or creating InfoSets○ And/or creating MultiProviders○ Or creating VirtualProviders 2. Metadata and Document Management○ Installing BI Content○ Creating document
一些关于DTP的一些链接
转: BW--一些关于DTP的一些链接 The goal of this blog is to bundle the information related to the Data Transfer Process (DTP). The documents listed below are describing the different DTP features and "data flow" capabilities in detail. The general definition of a DTP is: A Data Transfer Process transports data from one data source to one data target. Please find the different links to the documents below: Blog: The "normal" Data Transfer Process... Link Blog: The "Onl
熬夜小贴士
熬夜小贴士(男士学着点) 要在熬夜之后第二天依旧亮丽动人,可是一门很大的学问。不过,只要你把握以下几个小秘方,包你随时亮丽动人唷! 要在熬夜之后第二天依旧亮丽动人,可是一门很大的学问。不过,只要你把握以下几个小秘方,包你随时亮丽动人唷! 1.不管你多晚回家,睡前或起床后利用5至10分钟敷一下脸(最好使用保湿面膜),来补充缺水的肌肤; 2.起床后洗脸利用冷、热水交替刺激脸部血液循环; 3.涂抹保养品时,先按摩脸部5分钟; 4.早上起床后先喝一杯枸杞茶,有补气养身之效; 5.做个简易柔软操,精神百倍;
SAP Consultant Certification
SAP Consultant Certification Solution Consultant SAP NetWeaver 2004s – Business IntelligenceSoftware components: SAP NetWeaver 2004s Business IntelligenceCertification exam is included in course TBW45 and is also in separat certification events at many locations.Certification ID (Booking code): C_TBW45_04SCertification duration: 3 hoursNumber of certification questions: 80 Required certificates for participation in this certification test: NoneConsultant Academy courses for certification prepar
SAP BW 基础知识
SAP BW 基础知识(转)BW是business information warehouse的简称.SAP BW可以提供可信的数据和信息,以便管理人员和业务人员等在此基础上做快速的决定SAP BW提供了整合的,耆?С諻EB的策略管理解决方案.SAP BW整和了整个mySAP商业平台.包括供应链分析,客户信息分析和电子商务交易分析.SAP BW架构BW 包括三层架构上层 Business Explorer是终端用户使用的获取报告的环境,是BW的表达和分析层.中层 Business Information Warehouse Server有2个主要功能. 一是数据仓库管理,用来从R/3 OLTP应用中提取数据. 二是数据存储和表示,由InfoCubes以及data
BW有用的一些表(转)
关于BW Queries/Workbooks/Web templates很有用的一些表 (COME FROM http://www.sapclub.org) 不知道兄弟们在做项目时是否遇到过这样的苦恼?客户或者负责管理主数据和数据字典的同事可能追着向你要所有Query,Workbook,Web template及其相关info provider的清单。这时你不得不挤出时间,冲进Metadata Repository猛干一通ctrl+c和ctrl+v的无聊事情。相信下面这些表,一定能够帮你省下很多宝贵的时间。。。QueriesRSZELTDIR Directory of the reporting component elementsRSZELTTXT Texts of reporting component elem
SAP bw work
SAP Business Intelligence (BW) consultant Job Descriptions General DescriptionYou will be a part of our global IT team and in interaction with our customers it will be your task to ensure optimal usage of SAP BW area seen in relation to business needs. Flair for business and the ability to see business processes as a whole will therefore be an advantage. You will be a part of a group including highly qualified IT experts, who work together in a good and collegial atmosphere. Our status as a glob
BW前期发展之路
《SAP BW Professional》序言-叙说BW历史商业数据电子化处理后不久,便开始有人尝试把这些复杂而琐碎的数据用于决策支持。概念模型一个接一个地被设计出来,相应地信息系统工具也被不断开发出来。但直到九十年代初期,这种尝试都不尽如人意,大多以失败告终。有的概念和设计是可行的,但实施起来却困难重重。随着社会和经济的发展,把运营数据用于管理和决策的需求愈加迫切。公司运营全球化背景下,把运营信息转化为管理决策的需求达到了一个新层次。对一家公司而言,能够跨地域,跨业务,跨部门地成功进行战略管理,已然成为公司的核心竞
数据仓库建模思想在商务智能领域的应用(转)
随着企业信息化程度的不断提高,各类应用系统同时并存并支撑着企业的业务应用。越来越多企业的信息化主管在开发企业应用时已经考虑到数据集成和将来对数据的整体有效利用,因此,在实施了ERP解决方案之后,很多企业选择实施数据仓库产品来避免信息孤岛,实现应用的内部联系和信息的共享。 实施数据仓库的企业,用何种标准去衡量本企业的数据仓库建模是成功的呢?也许很多负责企业信息化建设的主管自己也不是很清楚。原因是:起初企业决定要实施数据仓库的初衷大都因为一些跨模块的报表开发不能够实现,企业实施了ERP之后,财务报表,销售
SAP BW相关案例NO1.高教出版社
高教出版社作为我国最大的出版社,是国内各级、各类教育教材建设的基地,可以说,无论是其800 人的企业规模,还是高达年16 亿的码洋,都是我国出版行业的排头兵。其实,高教出版社信息化建设从十年前就开 始了。从财务系统开始,信息部员工逐渐编写了涵盖编辑、生产、发行、财务等业务所有流程的系统。但是,到了2002 年,伴随业务的发展,系统到了不得不抛弃的地步。首先,由于系统是各个时期编写的,因此,形成了一个个信息孤岛。发行由于与钱紧密挂钩,因此与财务系统相连。编辑、出版这两条线也互相沟通。但这两套系统之间并无关系。数