Why fields of a cube table are different from the cube characteristics?

[Former Member]

We've got a custom infocube called ZPUR_C01. Now we are trying to define purchasing doc number and Item number of purchasing document in a code.

When editing the cube, we can see the technical names are 0OI_EBELN and 0OI_EBELP respectively for the above two characteristics in the cube. But when using SE11 to check the cube table /BIC/FZPUR_C01, find there is no any field for purchasing doc number and Item number of purchasing document and most of them seem to show only key figures, why?

Thanks

[Former Member · Accepted solution]

Hi,

Techinaccly all dimension ids become the part of Primary key in F or E Tables of the cube.So you can not see (in the table /BIC/FZPUR_C01) directly the fields 0OI_EBELN and 0OI_EBELP .But you can see the Dimension id of both (if they belong to single dimensions) or 2 dimension ids respectively( if they belong to different dimensions).

And againn the dimesion tables are mapped to SID tables.

1) So find the SID from Stable for your PO.

2) Find the Dimension for the above SID from Dimesion table.

3) find out the records from Fact table with the above dimesion.

With rgds,

Anil Kumar Sharma .P

[edwin_harpino]

hi Kevin,

the reason is infocube has star schema, not flat/transparent table like ods, /bic/f[cubename] is fact table where keyfigures are stored, in fact table there are dimension id link to dimension tables, in dimension table there is SID and SID then link to master data table, use transaction LISTSCHEMA to see all the infocube tables. (for line item dimension - one characteristic in dimension, no dimension id but sid exist in fact table),

check bw multidimensional data modeling for detail

http://help.sap.com/bp_biv235/BI_EN/documentation/Multi-dimensional_modeling_EN.doc

if you aim to read infocube data, you may need

function module RSDRI_INFOPROV_READ

or OLAP BAPI

http://help.sap.com/saphelp_bw33/helpdata/en/64/9b8f3c855f0454e10000000a11405a/frameset.htm

check abap bw query

/people/durairaj.athavanraja/blog/2005/04/03/execute-bw-query-using-abap-part-i

/people/durairaj.athavanraja/blog/2005/04/03/execute-bw-query-using-abap-part-ii

/people/durairaj.athavanraja/blog/2005/12/05/execute-bw-query-using-abap-part-iii

hope this helps.