cancel
Showing results for 
Search instead for 
Did you mean: 

Request Compression in BI 7.0

sureshsharma_sharma
Participant
0 Kudos

For a large volume financial implementation what would be your Compression criteria?

How frequentlty would you compress?

Would you automate compression?

How would you trace information from an already compressed request?

How would you make your compression safe and foolproof?

I am dealing with above questions.

Any help would be great and really appreciable.

Regards and happy holidays,

Ram

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

My direct question is :

will compression result in dataload performance?

Former Member
0 Kudos

As far as I know the dataload should not get affected after compression ....

Regards

KrishnaK

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

what is the relation between indexing and compression interms of dataload performance?

Thanks

Former Member
0 Kudos

Hi Vaishali,

indexes are data structure sorted values containing pointer to records in table.

indexes are use to improve data reading performance ,

but decreases data writing performance

every compressed data is taken from E table, every uncompressed data is taken from F table: also for this reason you can lost in performance if you have a lot of uncompressed data because the system has to read two different set of data .

So it's gud to compress cube afeter loading data.

It improves Query perfomance .

Hope this helps.

Reg

Pra

former_member184494
Active Contributor
0 Kudos

Ram,

How frequentlty would you compress?

Depends on your data completeness , if the data is correct and does not require a reload at any time - then you can compress

Would you automate compression?

Same as above

How would you trace information from an already compressed request?

--What information do you want to trace ??

How would you make your compression safe and foolproof?

Compression is just moving records from one tble to another while removing a key - this process is sound and foolproof - is there anything more you expect from the same ??

Arun

sureshsharma_sharma
Participant
0 Kudos

Your replies would be helpful to me in establishing a compression strategy.

Guys who have been actually involved in compression would have better idea. I have done compression of an infocube myself.

When I was asking about tracing information i meant how would I be able trace a request if I have already compressed my data?

If you compress your infocube right after loading you need to have some mechanism to fix errors or reload erroneous request.

How are you handling compression? Immidiately after data load? Its true that when not all data is compressed you have to read data from two database table but is there a way around?

I dont think SAP designed this to copmpress requests immidiately after loading data.

Thanks all of you! Any more information will be highly appreciable.

Ram

Former Member
0 Kudos

HI Ram

Check the below link it explain in detail what is compression, where it can be used , what are the measure need to be taken!!!!

follow Ravikanth.PNV links and notes: it as sublinks u will get u r answer!!!!,

and every 1 is also grt !!!

all the best

shashi

Former Member
0 Kudos