Skip to Content
author's profile photo Former Member
Former Member

what is BI Accelarators what is the use of it.

what is BI Accelarators what is the use of it.plz explain me clearly .dont give links just explain.i will give full points.

Thanks & regards

chaitanya kumar.A

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2008 at 07:48 AM

    B.I Accelerator

    BI accelerator is a seperate hardware which when attached to BW server creates an index on data of infocube and stores in compressed format.Different technologies are used for compression and horizontal pratitioning of data.

    BI Accelerator can benefit businesses that have high volumes of data. The read

    performance of BI queries is greatly improved using BI Accelerator. This new

    tool enables quick access to any data with a low amount of administrative effort

    and is especially useful for sophisticated scenarios with unpredictable query types,

    high data volume and high frequency of queries.

    BI Accelerator is also useful when aggregates or database indexes are not

    sufficient, or when these methods become too complex or too costly to maintain.

    For example, it may not be practical or cost effective to create and maintain all the

    aggregates that are needed to support performance for all queries for an InfoCube.

    BI Accelerator Pre requistics

    -->BIAccelerator must run on a Suse Linux Enterprise Server 9.

    -->An RFC Destination must be created between the BI System and BIA.

    -->BI InfoCubes that contain non-cumulative key figures are not supported by BI Accelerator at this time.

    -->BI Accelerator requires SAP Netweaver 2004s SP4 or higher.

    BI Accelerator so fast Becoz

    There are two major components in the BI Accelerator architecture that contribute

    to the high performance:

    . BI Accelerator Engine

    . BI Accelerator Indexes

    The BI accelerator is fast enough to aggregate BIA indexes during run time.

    A BI Accelerator index contains lists of Index names, join conditions, join paths, view attributes, semantic relations, and key figures.

    BI Accelerator indexes are independent indexes that store meta data, as well as, execute queries.

    BI Accelerator is a very robust and stable environment that uses simple algorithms versus volatile DB optimizations.

    BI Accelerator is also model-driven:

    integrates NetWeaver BI with the TREX search engine, BIA indexes are a special case of the ESA business object, distinctive SAP technology is leveraged.

    To use a BI accelerator index for an InfoCube when you execute a query, you first

    have to activate it and then fill it with data The system performs the following steps

    in order to create an index

    • Create

    • Index

    • Prepare optimize

    • Commit optimize

    Advantage Of B.I Accelerator

    Advantage of this is that whenever a query is execcuted,Data is fetched from BI accelerator instead of reading of reading frm database reads.

    Thus DB read time is 0 in total query run time leading to improved query performance and stable query response time.

    • Increased end-user satisfaction with consistently high query performance.

    • Significant reduction in the total cost of ownership: low maintenance, high scalability.

    • The performance gain using BI Accelerator can be very great, boosting the response time by a factor of 10-100

    Check this presentation for more details:



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 22, 2008 at 07:53 AM

    Hi Chaitanya,

    The latest computer architectures make more intensive use of increasingly inexpensive memory resources,Search engines deliver fast responses by giving read access priority over index updates.But can an engine first conceived for text search be used to implement fast search for structured data in tables?

    Yes–SAP adapted its TREX search engine to implement.BIA

    BI Accelerator for high performance BIA new transparent approach based on TREXto boost BI query performance,Performance speedup factor between 10 and 100,Without changing the BI user experience (transparent to users)

    TREX and BI Accelerator

    TREX : Search and classification engine, mainly for unstructureddata��

    BI Accelerator is built using TREX technology (indexing, retrieving, compression ...) to handle structured data��Note: BI Accelerator and TREX are two different installations.

    1The BI Accelerator cannot be used for standard KMC functionality��A TREX installation cannot be used as a BI accelerator

    2.Inside info: technically there is a lot of commonality but TREX-BI Accelerator role switching is not supportedIndex

    BI Accelerator index: Structure containing replicated data and indexes (one index per table) that represents the BI star schema for theBI Accelerator��Indexing: Transfer of InfoCubedata to the BI Accelerator server and processing and compressing it into the BI Accelerator index.

    Which customers benefit most from the BIA?

    Ad-hoc queries and non-predictable query patterns

    For example:

    on-demand reporting for different user groups

    ad-hoc analysis to support operational business decisions

    High data volume Queries with access to millions or billions of records

    For example:

    data volume resulting from selling products/services to a large number of customers (e.g. billing data, POS data) or complex record keeping for compliance

    Challenging response time SLAs

    For example:

    service level agreements for call center operators

    Hope this helps,


    CSM Reddy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2008 at 12:19 PM

    BI accelartor is northing but a hard ware whic is connected to servers ,the main use accle is to improve the query performance , if we use accelarator there is no need to create any aggreates on the cube

    Edited by: Aravindan Pagadala on Feb 22, 2008 1:19 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 22, 2008 at 03:20 PM


    BI Accelerator = TREX + MAGIC +complicated hardware configuration

    BI Accelerator is used for high performance .

    It is very costly.

    TREX=Text Retrieval and information EXtraction

    BI Accelerator is improves performance by indexing, retrieving, compression

    Add a comment
    10|10000 characters needed characters exceeded

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.