Skip to Content
author's profile photo Former Member
Former Member

Phys Partitioning steps in Netweaver 2004s

Dear SDN,

I am trying to do physical partition a cube in Sandbox.

Extras option has nothing as Partioning it shows clustering and DB archiving.

How to do this in 2004s.

Regards,

Rahul

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 09:44 AM

    Hi Rahul,

    Choose Extras -->DB Performance ---> Partitioning. The Determine Partitioning Conditions dialog box appears.

    Refer this link

    http://help.sap.com/saphelp_nw04s/helpdata/en/b9/60c041a2236a24e10000000a1550b0/frameset.htm

    Regards

    Karthik

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2007 at 05:57 PM

    You can only partition a dataset using one of the two partitioning criteria ‘calendar month’ (0CALMONTH) or ‘fiscal year/period (0FISCPER). At least one of the two InfoObjects must be contained in the InfoProvider.

    If you want to partition an InfoCube using the fiscal year/period (0FISCPER) characteristic, you have to set the fiscal year variant characteristic to constant.

    <b>Prerequisites -</b>

    When partitioning using 0FISCPER values, values are calculated within the partitioning interval that you specified in the InfoCube maintenance. To do this, the value for 0FISCVARNT must be known at the time of partitioning; it must be set to constant.

    <b>Procedure</b>

    1. The InfoCube maintenance is displayed. Set the value for the 0FISCVARNT characteristic to constant. Carry out the following steps:

    a. Choose the Time Characteristics tab page.

    b. In the context menu of the dimension folder, choose Object specific InfoObject properties.

    c. Specify a constant for the characteristic 0FISCVARNT. Choose Continue.

    2. Choose Extras--> DB Performance --> Partitioning. The Determine Partitioning Conditions dialog box appears. You can now select the 0FISCPER characteristic under Slctn. Choose Continue.

    3. The Value Range (Partitioning Condition) dialog box appears. Enter the required data.

    Hope it Helps

    Chetan

    @CP..

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.