Skip to Content

Request Compression in BI 7.0

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2007 at 11:56 AM

    My direct question is :

    will compression result in dataload performance?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2007 at 08:01 PM
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2007 at 10:06 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 15, 2007 at 06:05 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Dec 15, 2007 at 06:47 AM

    Hi,

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

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.