如何用PL/SQL Developer 查询BW后台Oracle 中以/BI0/*、/BIC/*开头的数据表数据
如何用PL/SQL Developer 查询BW后台Oracle 中以/BI0/*、/BIC/*开头的数据表数据
1、BW 中的数据表：
BW中的对象对应后台自动生成的数据表是以 /BI0/* 、/BIC/* 开头：
详见以下：
These are the tables which are available bw including F & E Table.
T = /BIC/T* or BI0/T* = Text Table
M = /BIC/M* or BI0/M* = Master Data Table View
P = /BIC/P* or BI0/P* = attributes that are not time-dependent.
Q = /BIC/Q* or /BI0/Q* = attributes that are time-dependent.
S = /BIC/S* or /BI0/S* = SID (Surrogate ID) Table
X = /BIC/X* or /BI0/X* = Generated when at least one time-INDEPENDENT attribute is defined as a Navigational Attribute.
Y = /BIC/Y* or /BI0/Y* = Generated when at least one time-DEPENDENT attribute is defined as a Navigational Attribute.
H = /BIC/H* or /BI0/H* = Hierarchy Table
I = /BIC/I* or /BI0/I* = Inclusion Table (for hierarchy)
K = /BIC/K* or /BI0/K* = Hierarchy SID Table
D = DIMENSION TABLES
F = Fact Table
E = Fact Table (Contains value after Compression of F Table)
When patitioning the cube the table is divided into F & E table, after partitioning the data moves from F table to E table.
2、用户现在提出这样的需求，想用其他的BI分析工具来分析BW中的一些数据。即想用BW的一张物理表直接做远程数据源（不用
JCO调用RFC的方式），所以我们只好到后台去找BW的最底层数据表。
通过PL/SQL Developer，我们可以看到那些数据表（用SAPSR3用户登录）
3、现在用PL/SQL Developer去连接 BW 对应的 Oracle 数据库
执行SQL 语句
eg：SELECT * FROM "/BIC/OHZFIGL"
注意两项：
（1）表名应该全大写（区分大小写）
（2）表名应该用双引号括起来，否则提示“ORA-00903:表名无效”
