如何用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:表名无效”