cancel
Showing results for 
Search instead for 
Did you mean: 

how to find a cube has got partitioning on oracle db

Former Member
0 Kudos
80


Hi Gurus,

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

Regards.

Accepted Solutions (1)

Accepted Solutions (1)

former_member199945
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

Check Below Thread also

Size of infocube

Former Member
0 Kudos


Hi Seshu,

Doesn't have access to se37 tcode in production.

Regards,

Rajesh.

former_member199945
Active Contributor
0 Kudos

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

Answers (1)

Answers (1)

RamanKorrapati
Active Contributor
0 Kudos

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
0 Kudos

Hi Raman,

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

Regards.

RamanKorrapati
Active Contributor
0 Kudos

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
0 Kudos

Hi Raman,

I dont have access to se37 as well.

Regards.

RamanKorrapati
Active Contributor
0 Kudos

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.