Performacne Tuning

Performance Tuning
Info Cube Partitioning
           is the concept can be used for the info Cube which are using Time Dimension Info Objects as "0CALMONTH" , "0FISCYEAR". These two predefined time dimension info Objects will supports for Partitioning.
           While getting the business data based on date , if we apply partitions getting the data from partition is much faster than complete data in single info Cube area.

Navigations : if any info cube is added with Time Dimension Info Objects using above info Objects ( "0CALMONTH" , "0FISCYEAR" ),  then save the cube and activate .
After activation -> Click on Extras menu -> DB Performance -> Partitioning -> select
"0CALMONTH" radiobutton / 0FISCPER -> Click on Continue -> enter From ( 2000.01 ) and TO date ( 2012.12 ) -> specify number of partitions ( 4 ) -> continue -> save and again activate.

-> Indexing ( if we delete the index before loading the data increases performance of loading).
If we create index then after loading reporting efficiency increases.

Navigations...
 Right click on info Cube -> Click on "manage" -> Click on "performance" -> Click on "Create index" / "Delete" index based on report requisition or loading requisition -> click on "Start" -> keep refresh -> click on Close.
DB Statistics
    DB Statistics : is another performance tuning option  used to create complete summary log of the info cube such as what type of data, type of columns and type of validations etc. Using these information reporting becomes easy with summary data.

 Right click on info Cube -> Click on "manage" -> Click on "performance" -> Click on "Create database Statistics" -> Click on "Start" -> Keep Refresh -> Close the screen.

Info Cube Compression
is another performance tuning option to remove 0 records from F fact table into E Fact table after compression. Only F fact table data will be used in reporting.  because of Unwanted data is moved into E Fact table data retrieval of main data from F Fact table becomes faster.

 Right click on info Cube -> Click on "manage" -> Click on Collapse tab ->  select the check box with 0 elimination  -> Click on "Release"  -> keep refresh.


Index :   will create a file with extension as .idx in BI Server system  under OS Environment.