partitioning

[Former Member]

hi experts,

1)can any one give idea about logical partioning& physical partioning

2)usually when huge volume of data present in the infocube we go for partioning

when we apply partioning either before applying aggregates & compression OR

after wards and when we go for logical &physical partitioning and how to do the

physical partitioning

3) where the PSA partioning will we used

pl provide in detail & if any blog are provide

thanks in advance

venu

[Former Member]

You can set the partitons upfront when creating the cube or even later on when appropriate.

Ravi Thothadri

[Former Member]

Venu,

1)can any one give idea about logical partioning& physical partioning

Logical partitioning refers to partitioning of data providers using time characteristics like month or year.

2)usually when huge volume of data present in the infocube we go for partioning

when we apply partioning either before applying aggregates & compression OR

after wards and when we go for logical &physical partitioning and how to do the

physical partitioning

We go for partitioning at the time of creating the cube

3) where the PSA partioning will we used

PSA is by default partitioned by request ID.

[Former Member]

Hi Venu,

look at this link:

http://help.sap.com/saphelp_bw31/helpdata/en/33/dc2038aa3bcd23e10000009b38f8cf/frameset.htm

About PSA partitioning:

"Using partitioning, you can separate the dataset of a PSA table into several smaller, physically independent, and redundancy-free units. This separation can mean improved performance when you update data from the PSA. In the BW Customizing Implementation Guide, you determine from which number of data records a partition is created, under Business Information Warehouse -> Connections to Other Systems -> Maintain Control Parameters for Data Transfer. Only data records from a complete request are stored in a partition. The specified value is a threshold value."

Hope it helps!

Bye,

Roberto

I can give you some useful doc, if you want...

[Former Member]

Hi Venu,

In bw, physical partitioning done on database level and logical partitioning done with multiprovider. take a look docs

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/ce7fb368-0601-0010-64ba-fad...

hope this helps.

Database (or Physical) Partitioning

-Database tables are cut into smaller chunks (partitions)

-One logical database table

-Transparent for user

-Available for the following database management systems

Range Partitioning: ORACLE, Informix, IBM DB2/390

Hash Partitioning: IBM DB2/UDB

Database (or Physical) Partitioning

*Benefits

-Parallel accesses to partitions

-Read smaller sets of data Fast

-Deletion of partitions (DROP PARTITION instead DELETE FROM WHERE)

*Automatically Partitioned Database Tables (for Range Partitioning)

-InfoCube F-Fact table: partitioned by request

-PSA table: partitioned by request ODS

-Change Log: similar to PSA table

*User Defined Partitioning Criteria (for Range Partitioning)

-InfoCube E-Fact table

-Partition Criteria:

Time characteristics like month or fiscal period

-Note: Both fact tables are extended by the SID of the chosen time characteristic

MultiProvider (or Logical)

-Partitioning Possible partitioning criteria: year, plan/actual, regions, business area

-Parallel sub-queries are started automatically to basic InfoCubes

thread

u can also have alook at this post by pizzaman, He explained in detail

and also this one

similarly there are lot more u can search for it.

Thanks

Regards