How to find the Info cube table name

[Former Member]

Hello Exprts,

I have one question in Infocube.

I have Infocube. I tried to check the data in infocube.

In the report data is displaying, where as in the cube data is not displaying.

So thats why i tried to check the infocube table name /BIC/ some thing.

How to find the Info cube table name. Please give me reply.

thanks,

SN.

[Former Member]

hi all,

how i can know the table name of an infocube in that scenario.

i know how to find fact table name but does not show all the infoobjects.

thanks in advance.

[Former Member]

Hi

You may use T-code's like SE16/SE11 and search for Cube contents with the following naming convention.

Table Name : /BIX/Y<InfoCube Technical Name>

where X=C for Customer Defined

X=0 for SAP Defined

Where Y= F>>> F Table (Uncompressed Data) - /BIC/F<InfoCube Technical Name>

Y= E>>> E-Table (Compressed Data) - /BIC/E<InfoCube Technical Name>

Y= P>>> P-Table (Dimension Table - Data Package) - /BIC/P<InfoCube Technical Name>

Y= T>>> T-Table (Dimension Table - Time) - /BIC/T<InfoCube Technical Name>

Y= U>>> U-Table (Dimension Table - Unit) - /BIC/U<InfoCube Technical Name>

Hope this helps,

Regards

Sai

[Former Member]

you can use /bic/finfocube name for normal data

and if you want to see data after compression then use /bic/einfocubename

If still u are not able to see u can check whethet infoobject are authorisation relevant or not,and if they are u can untick them

[Former Member]

I think yours one or more InfoObject in the Infocube have Authorization Relevant that's why you can't see the data.

Regards,

Sushant

[former_member360228]

Hi,

Use the t-code LISTCUBE to get the details.

Regards,

Arminder Singh

[venu_gopal10]

HI SN,

The table name for custom infocubes will be /BIC/F<infocube name> or /BIC/F* for F fact table. similarly /BIC/E<infocube name> or or /BIC/E* for E fact table.

You can aslo check all the tables for a infocube by going to TCODE SE11(Data Dictionary) type /BIC/<dimensoin names> for dimension tables and for F and E table as said above.

Regards,

Venu.

[Former Member]

Hi,

Please check this thread will help you.

Br.

Alok

[Former Member]

Hi

Right Click on the Infocube --> Manage --> Contents tab --> Fact Table.. here you can find the table name and its contents.

Hope this helps.

Regards

Rajender Muthineni