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

Precalculated data vs. precalculated templates

What are the pros/cons of Precalculated data vs. precalculated templates and when is it best to use one over the other?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 17, 2005 at 11:31 PM

    Hi,

    pre-calculated value sets -

    1. when analyzing target groups since you can specify a fixed value.

    2. when complex selections are involved such as with a Top n inquiry, used to strongly improve query performance.

    3. In place of variables that are filled from a query event (replaced from a query event).

    pre-calculated Web template -

    The Reporting Agent allows you to pre-calculate Web templates, that is, HTML documents with BW-specific placeholders, in the background. In the Web browser, if you call up a Web report that is structured on the basis of a pre-calculated Web template, you can access pre-calculated data without having to execute an OLAP query. This means that access time is considerably reduced as is the workload on the application server.

    Hope this helps

    AP

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 18, 2005 at 02:19 AM

    I am not referring to the precalculated value sets, I am referring to the options of of calculate data or calculate HTML for web browser on the parameter tab for precalculated web templates.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Pre-calculated template supports limited navigations ie you will be able able to use a drop-down box for any filter values, Pre-calculated data doesn't support any navigation. Pre-calculated templates are build when the reporting agent package is run, but for the pre-calc data option the template ie the HTML is build when the user access the templates.

      If you use the download scheduler to download as HTML files the pre-calculated template option should be used else MS Excel.

      Thanks.

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.