how to find a cube has got partitioning on oracle db

[Former Member]

Hi Gurus,

Can anybody say how to find out if a cube has got partitioning on oracle database.Thank you.

Regards.

[former_member199945 · Accepted solution]

Hi rajesh,

1. Check in RSRV  : transcation data folder --> test Of partitioning column for infocube  selct this and provide infocube name.

2 . use below F.M's :

SAP_DROP_EMPTY_FPARTITIONS

RSDU_CHECK_PKEY_FACTTAB_DB6

3.Select that Particular Infocube  and go to extras tab DB Performance --> partitioning : here check either 0calmonth /ofiscper is selected or not.

Regards,
Seshu.P

[former_member199945 · Accepted solution]

Check Below Thread also

Size of infocube

[Former Member · Accepted solution]

Hi Seshu,

Doesn't have access to se37 tcode in production.

Regards,

Rajesh.

[former_member199945 · Accepted solution]

have you checked in RSRV ? option for this also no authorization ?

[RamanKorrapati]

Hi Raj,

I thin you can find at SE14,

enter your F or E fact table name,edit, from menu Go to --> Storage parameters,  it may show all info such as compression/portioned/indexes .

Thanks

[Former Member]

Hi Raman,

We are not authorized for se14 tcode in production. Any other way please.

Regards.

[RamanKorrapati]

no idea why srikanth reply was not visible. i check the srikanth solution. looks its works for you.

see the FM - MSS_EXISTS_PARTITION_FUNCTION.

pass your cube name PART_TABNAME, execute it. if you have partitions you may get number >0, if not you may see 0 like below.

[Former Member]

Hi Raman,

I dont have access to se37 as well.

Regards.

[RamanKorrapati]

for SE38, if you have access then check suman reply on another thread. he suggested one program name to check at SE38 or SA38.

Take basis team help and check at SE37/SE38 by using related FM or program names.