摘要：
Listed below are some of the tables commonly used in SAP BI ( NW 2004) - however the same has not been tested in NW2004s and please make corrections if required. Some of this material has gone through a lot of eyeballs before making it to the final list and could contain some older references / ... 阅读全文
摘要：
在“转换”中，最重要的有三种类型的例程，开始例程，转换例程及结束例程；此外还有专家例程，反向例程。开始例程：开始例程在每个数据包开始进行转换时运行。开始例程没有返回的值，它直接对数据包进行计算、修改或删除等操作，将操作的结果直接保存在数据包中进行后续的转换步骤。当然，开始例程也可以访问和操作SAPBI 系统中的其他数据库表。转换例程：则是在每笔数据传输过程中，对数据进行的一个转换，例如数据根据条件进行的匹配转换。当在每个字段的详细规则中，选择例程的规则类型就会弹出对话框来贴些转换例程。结束例程：结束例程对经过转换规则转换后的数据进行操作，它操作的是一个与目标对象字段结构一致的表结构。与开始例程 阅读全文
摘要：
用来查看PSA表的话，可以查看RSTSODS表。这样的话还可以看到不同的PSA版本。如果需要用老版本抽取，还可以自建一般数据源去抽取。 阅读全文
摘要：
Here are 7 steps to create such a solution:1. Create queries you would like to join.2. Open one of the queries in BEx Analyzer and save it as a workbook.3. Create two additionalsheets in the workbook, and give them names (e.g., query2, results)4. Edit the query2 tab by adding design items: click BEx 阅读全文
摘要：
Permitted charctrs for char. values in the Business Information WarehouseMessage no. BRAIN063Problem descriptionNo small letters are permitted for characteristic values (in the InfoObject maintenance). It depends, however, on the language being used as to whether a character is capitalized.It is gua 阅读全文
摘要：
用户的开发Key存储在DEVACCESS表中，如果由于审计需要删除一些用户的开发Key，而系统有限制SM30, SE16 or SE16N 等事务码的使用，你就可以通过一个小程序去删除开发Key。代码如下：REPORT ZBCDEVACCESS.* ===================================================================* TITLE: Delete Record from Table DEVACCESS* DESCRIPTION: This program deletes the SSCR Developer Keys from 阅读全文
摘要：
Namings for Cube:/BI<C OR DIGIT>/<TABLE CODE><INFOCUBE><DIMENSION><C or digit>: C = Customer-defined InfoCubeDigit = SAP-defined InfoCube<table code>: D = Dimension tableE = Compressed fact table(partitioned by Year/Month etc.) /BI*/E<cube_name>F = Uncompres 阅读全文
摘要：
Use transaction BDLS to covert logical systems name. 阅读全文
摘要：
Finding how much DB% a cube is occupying1)go to se11 type psa table name /bic/b********** and display the table.now u have tab technical setting at top click itand it will display the table space and the sizefor cube/bib/d********2)If you are maintaining the Statistics. You can check the reports of 阅读全文
摘要：
Use the report RMCSBWCC to display a log for the changed extract structure in the target system, to see if any of the above problems exist. An additional switch deletes all update logs for the application of the selected extractor.Please also note that you must reactivate the transfer structures whe 阅读全文