Loading...

IBM Cognos BI Tuning

The way that you use and configure IBM Cognos BI can influence its performance. For instance, you can design models and reports with performance in mind, configure IBM Cognos BI dispatchers and services for performance, and schedule jobs to make the best use of system resources.
IBM Cognos BI Tuning

Designing Models and Reports for Performance

Designing and creating models in Framework Manager is an essential step in the IBM Cognos BI workflow. A model specifies, structures, adds to, and manages the metadata used to create reports. For best IBM Cognos BI performance, a modeler can design models that specify default prompting, and that set the query processing type.

Specifying Default Prompting

To improve query performance, models can include reports that prompt a user for a descriptive name and perform filtering on a code or key value. We can modify a model to make sure that queries sent to the data source are efficient, well formed, and secure. To ensure optimal performance, the Framework Manager modeler can
  • specify the rules governing query generation  
  • restrict user access to specific rows or columns of data
  • model data relationships to hide the complexity of data from report authors
Setting Query Processing Type

For relational metadata, We can develop performance by selecting the right type of query processing. There are two types of query processing:
  • limited local
The database server does as much of the SQL processing and execution as possible. However, some reports or report sections use local SQL processing
  • database only
The database server does all the SQL processing and execution. An error emerge if any reports or report sections require local SQL processing.

Although the database server can usually run the SQL and run reports much faster, local processing is sometimes necessary. For example, choose limited local processing if you want to create cross database joins or if you want report authors to use unsupported SQL99 functions. Some complex queries, such as a query that must generate an At clause to avoid double-counting, require limited local processing. In this case, the query automatically uses limited local processing even if the package was published with database only processing.

virtualnuggets 4002139206671978941

Post a Comment

  1. Thanks for posting unique article!!!!!.
    IBM Cognos

    ReplyDelete
  2. Cognos is a frontend to publish, find, manage, organize, and view organization’s business intelligence data. This is great blog for beginner to learn about Cognos. Thanks a lot admin to sharing this wonderful blog on Cognos. Also Learn Cognos from the best Cognos Online Training in India at CatchExperts.com

    ReplyDelete
  3. Interesting information. This is just the kind of information that i had been looking for, i would regularly watch out for the new posts, Thanks once again, Regards online cognos testing training

    ReplyDelete
  4. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in IBM COGNOS, kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on IBM COGNOS We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Saurabh Srivastava
    MaxMunus
    E-mail: saurabh@maxmunus.com
    Skype id: saurabhmaxmunus
    Ph:+91 8553576305 / 080 - 41103383
    http://www.maxmunus.com/


    ReplyDelete

emo-but-icon

Home item

Blog Archive

Popular Posts

Random Posts

Flickr Photo