How many tables are there in Infocube

[Former Member]

Hi Experts,

Apart form Facttable and Infocube is there any other table in the Infocube.

Can any one help on this it is very urgent.

Cheers

Vara

[Former Member]

Hi Vara Nese

when u can activate the infocube these table are created.

<c or digit >

C = customer -defined infocube

diigit = sapdefined infocube

<table code >

D = Dimension table

E = Compressed fact table

F = uncompressed fact table

<infocube>

The name of the infocube without leading digits(if any)

<Dimension> (only used for dimension tables)

P = package dimension

U = Unit dimension

T = Time dimension

0-9,A,B,C, = user defined dimension tables.

i hope this helpful to u,if any doubts or qurrys can u feel free to contact at mail

suresh4bw@yahoo.co.in.

it's

Suresh Burra

[Former Member]

Hi Vara Prasad Nese

when u can activate the infocube these table are created.

<c or digit >

C = customer -defined infocube

diigit = sapdefined infocube

<table code >

D = Dimension table

E = Compressed fact table

F = uncompressed fact table

<infocube>

The name of the infocube without leading digits(if any)

<Dimension> (only used for dimension tables)

P = package dimension

U = inot dimension

T = Time dimension

0-9,A,B,C, = user defined dimension tables.

i hope this helpful to u,if any doubts or qurrys can u feel free to contact at mail

suresh4bw@yahoo.co.in.

it's

Suresh Burra

[Former Member]

Hi all,

There is another alternative.

1. Go to the Infocube, Double click on the Infocube,

2. In the "Character"/"Time Character" Tab Strip,

3. Click on "Dimensions.." Button

In the "Define" Tab strip, you can see "Cube" name suffixed by Dimension 1, 2,... so on.

Note: No. of tables = No. of Dimensions assigned to the cube.

At the bottom, you can see other tables

Data Package : <CubeName>P

Time : <CubeName>T

Unit : <CubeName>U

Thanks,

Shyam

[Former Member]

Hi Vara,

How are you doing?

You can check the number of tables generated for a cube.

Go to SE11 transaction.

In the table name field, give <Cube Name>

Press F4.

In the popup screen, you will see the list of all related tables for the given cube.

Please refer to the below example. You can find the answer.

If your cube name is "TEST", it can have the below tables generated based on the number of dimensions it has.

Dimension related (Max 13):

/BIC/DTEST1

/BIC/DTEST2

/BIC/DTEST3

/BIC/DTEST4

/BIC/DTEST5

/BIC/DTEST6

/BIC/DTEST7

/BIC/DTEST8

/BIC/DTEST9

/BIC/DTESTA

/BIC/DTESTB

/BIC/DTESTC

/BIC/DTESTD

Predefined dimensions:

/BIC/DTESTP (Data Package dimension)

/BIC/DTESTT (Time dimension)

/BIC/DTESTU (Unit dimension)

Request related:

/BIC/ETEST ( E tbale for compressed data)

/BIC/FTEST ( F table for independent requests)

Get back to me if you still have any issue.

Regards,

Sashi

[Former Member]

CUBE CONSISTS OF FACT TABLE & its associated DIMENSION TABLES.

fact tables 2

1. Compreseed

2. Uncompressed

Dimension Tables u can have user defined 13 & system defined 3.

[Former Member]

Hi Experts,

I am sorry to say that in the previous question i have not mentioned infocube table names. Now i am rectifying it.

Apart form F table and E table is there any other table in Infocube.

Cheers

Vara

[Former Member]

Hi Prasad,

Try with transaction: <b>LISTSCHEMA</b>. input infocube name and execute. You can see all related tables to the perticular CUBE.

Hope it Helps

Srini

[former_member188975]

Hi Vara,

Apart from the F and the E table you will find the dimension tables as per the dimensions that you have created for the InfoCube. In the case of a line item dimension, the SID table of the InfoObject is directly linked to the cube (without creating an additional DIM table).

Hope this helps...

[Former Member]

Just to clarify some things Bhanu...when you create a query off of an Infocube the OLAP does a multidimensional analysis on your cube, correct? That is, it does a join on all the SID tables, dimension tables and so forth. Please confirm.