table which stores the info..of Partitioning

[Former Member]

HI all,

I wud like to know is there any table which stores the data, once the cube has partitioned..? means partitioning information..

Thanks in advance.

Sans

[Former Member · Accepted solution]

Hi

Goto tcode SE11>TYPE NAME OF THE CUBE/BIC/E OR F<infocube name>>MENU BAR>UTILITIES>DATABASE UTILITY>click on storage parameter button. it will display the list of tables.hope it helps

Regards

Kanth.

[Former Member · Accepted solution]

hi

look in F <infocube name>table

[Former Member]

hi

once you compress the cube go to se16/se11 and give the infocube name like /bic/efacttable..and click the tools database utility click storage parameters you will get the details of partionied data stored --psapXXXX okay

hope this helps.

neelkamal

[Former Member]

What info are you looking for?

Some of the RS tables others have mentioned hold some data, DB02 can give you some. There are also several DB views you may be able to access (I'm assuming this is an Oracle DB) that will provide number of rows in each partition, distinct valu counts, etc.

[Former Member]

Hi Sans,

Use the table RSTSODSPART and RSDD_MIGRAT_PART.

Hope this helps.

Bye

Dinesh

(Do not forget to assign points!!)

[Former Member]

HI,

Will RSDCUBE table contains the details about the partitions..?

Regards-

Sans.

[Former Member]

Hi,

Try RSDCUBE table.

Best regards,

Eugene