Skip to Content

COMPRESSION :

-Every cube will have two fact tables /F & /E  and have same structure. 

  Before run the query i compress the cube it deletes the request id information and maintain is zero  the data will goes to F to E table.  Then report come for both the tables.

Steps for Compression :

Goto Cube–>Manage–>Collapse tab
and select latest request id click release in the request tab there is green mark in compression, after compression we cant delete the request.

* When we create cube it creates 2 fact tables F & E, Structure of E & F tables will be same
* Whenever we load data to cube, data will be loaded to F table
* Whenever we do compression  it deletes the  request id information & aggregates the records based on characteristic value combination  and put the data     into E table
* After Compression data will move from F table to E table

F table :

Figure1.jpg

E Table :

/wp-content/uploads/2013/08/f2_260638.jpg

* When do reporting on the Info cube data come from F table & E table
* Once the compression is done in the info cube we cannot delete the data based on request number.
* When we specify a request to compress, the specified request & all the requests below it will get compressed
* When you do compression in collapse tab there is checkbox   – zero elimination, if you select this check box, after aggregating the records if there is any key figure value with ‘zero’ it will delete those records.

Regards,

Prasad.

To report this post you need to login first.

3 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply