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

Information Broadcasting

Dear All,

I have read the document about the broadcasting in BI 7.0... My question is what this use for? and if I want to speed up the large data query using precalculate query... is this the one that I have to use? else... What can I use to speed up when opening a large data query, except using aggregate or BI accelerator (if still need to speed up after aggregation)?

Thanks in advance

Regards,

Tienus S

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 22, 2008 at 08:08 AM

    Hi,

    Information broadcasting is used to send a report through mail to respective persons.

    Report can be sent in different ways like it can be send as link, PDF file, Excel file etc.. So depending upon your requirement you can choose and send mail daily. This is one of the tool for precalculated query.

    Assign points if it helps.

    Cheers,

    Malli.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 22, 2008 at 08:20 AM

    Hi,

    Information broadcasting allows you to make objects with business intelligence content available to a wide spectrum of users, according to your own requirements. It also offers functions to optimize performance and for exception reporting.

    Some scenarios where IB is useful,

    You can choose between distribution types, for example, broadcast e-mail or broadcast to portal. For both distribution types, there are conceptual scenarios and ad-hoc scenarios.

    Conceptual scenarios are created together with the IT team, consultants and power users from the various departments (knowledge workers and authors). Using the broadcast settings that were scheduled previously or triggered by a data change, the system automatically distributes the relevant BI content. Business end users (information consumers) have nothing to do with the distribution of conceptual scenarios.

    With ad-hoc scenarios, the infrastructure for the process is predefined and the process can be executed by business end users during data analysis. Employees that receive standard reports and use the data as an information source can distribute the reports ad-hoc using the BEx Broadcasting wizard.

    Some other ways to increase query performance:

    Use ST03N -> BW System load values to recognize the problem. Use the

    number given in table 'Reporting - InfoCubes:Share of total time (s)'

    to check if one of the columns %OLAP, %DB, %Frontend shows a high

    number in all InfoCubes.

    You need to run ST03N in expert mode to get these values

    Accordin to these parameters we can do some changes and settings to query so as to reduce thses runtimes if any shows high values.

    In this way we can increase query performance apart those menthods mentioned by u.

    Regards,

    Rajkandula

    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.