dimension table and fact table exists data physically
can anyone plz tell me weather dimension table and fact table exists data physically or not/
LISTCUBE(TCODE) or the infocube contents disply the data of the cube i.e complete data after combining a true picture of Fact ,Dimension and SID tables.
Fact table structure would be like DIM Id's along with Key Figures
DIM ID1 DIMID2 DIMID 3 KF1 KF2 KF3
If you want to see the data in fact table alone go to SE16-->ENTER the table name as /BIC/F<Infocube name>.