Partitioning: can it change dynamically?

[former_member656292]

Hey Partitioning Experts!

I am looking if this feature is possible?

I have got a cube (new-Not yet Loaded) in which I want to define Partitioning (Can be Physical/Logical). The partitioning should be in such a way that one partition will have data for last 24 months (say) and the other will hold all data prior to that. When new month data flows in the Partitioning should also dynamically shift. I was wondering if it is possible to achive and how?

Appreciate your suggestions!

Thanks

Meyps

[Former Member · Accepted solution]

hi,

hope if u r in BI7, then by using the repartioning technique you can do it manually on every month.

Ramesh

[former_member656292]

Hello Experts,

Also I do not have the luxury of using NLS. Rather, I want to simulate NLS within BI itself (without using additional Hardware or sftware).

Thanks

Meyps

[Former Member]

hi,

is the reporting issue in report retrival time? so that u prefer partitioning.

build effective aggregates and multiproviders over the cube that could solve the issue to some extent.

can you think of any ABAP programs that could do the nedful to you.

Ramesh

[former_member656292]

Hi Ramesh!

Thanks for your inputs.

I did consider that option. But the practical difficullty in that is.

SAP recommends to take a complete back up before doing this that can be used to restore. Considering the current client's environment and size, I don't think I will be able to use this option.

Any other updates other than re-partitioning is appreciated.

Thanks

Meyps.