In 3..x remodeling of infocube is not allowed (After data load you cant remodeling in 3.x)
From 7.x remodeling is allowed .
remodeling of dso is allowed in 7.3.
If any time master data attribute data is changed , the changes are not affected to the reports . to make the changes available for reporting run Attribute Change Run.
Ex. In some material data
MAT ID / MAT NAME
Ist data M11 / HDD ---------> A (Active version , it is available for reporting )
data changed M11 / Desktop HDD -----> M (This modified masterdata is not avalble for reporting)
So we have to use this Attribute change run for changing M version data to A version data.
Process For PSA DATA DELETION :
Go to RSA1 ----> Select Data Source ----> right click --->manage ----> select the request ----> Delete. (manually you can delete like this)
But basically this is done by process chain only.
Process for CHANGE LOG DATA DELETION:
Select DSO ----> Right click ----> Manage ----> environment (menu) ----> delete change log data ----> select Older then days -----> start.
Even After Data deletion , still it will be there in the DB Table , The Basis use to run Transaction codes , which clear the DB table.
SELECTIVE DELETION :
Using this w e can delete the records selecting from a single request or from multiple request or even from all request.
Go to RSA1 ----> Right Click ---> InfoCube ---> Contents ----> Delete Selections -----> deletion selections select column ----> select request.
Note: you have to select the required request and required column without request it can delete from all requests.
If i delete any request all the data loaded through that request is deleted.
There are 2 type of Indexes :
Primary Index ---- maintained by the system.
Secondary index ---- maintained by the user.
Again the primary and secondary indexes are divided into B-Tree indexes and bitmap indexes.
B-Tree indexes are created on high cardinality tables .
Bitmap Indexes are created on low cardinality tables .
Indexes on InfoCube Improves the query performance, but it reduces data loading performance since for every record inserted , it has to check the existing index and should create a new index , to avoid this
Drop the index before every data load.
maintain Index after every data load.
NOTE : All this are automated by Process chain.
While reading data from a dimension table , the query is taking processing time , now i want to reduce this.
Sales order Dimension ------------- Sales Order NO.
Purchas Dimension --------------- PO. no
If the size of Dimension table is almost to the size of the fact table , more then that also.
SE38 -------> sap_infocube_designs ----> (in this program dimension and fact table ratios) execute.
RSRV -----> you can see the relation.
Database ----> Data Base statment.
If any Dimension is taking high DataBase real time, then make that Dimension as line item , but to make any dimension as line item Dimension , the Dimension should have an one characteristic , if more then we cant make as line item dimensions.
If we make any Dimension as line Item Dimension.