How do you create a data mart
- right click and create the export data source for the ODS/cube
- in the target system replicate the data source
- create transfer rules and update rules
- create info package to load
{ 0 comments }
partition a cube which has data
No we cannot partition a cube which has data; the cube must be empty to do this; one work around is to make a copy of the cube A to cube B; export data from A to B using export data source; empty cube A; create partition on A; re-import data from B; delete cube B
{ 0 comments }
SAP BW table partition
SAP is using fact table partitioning to improve performance; you can partition only on OCALMONTH or OFTSCPER
{ 0 comments }
