Cognos Analytics

 View Only
  • 1.  Disappointing performance Datasets with or without combining Datamodule

    Posted Thu August 06, 2020 08:37 AM
    I have a build a dashboard in reporting based on a package, but I was not satisfied with the performance.

    So I decided to base this report/dashboard on a datamodule to boost the performance.
    I created a Dataset per visual with aggregated data, so only filtering one some columns from the prompts would be applied.
    Currently there are 6 datasets, and 1 dataset has about 2500 rows and the others less than 1000 rows.
    These datasets are stored in a Datamodule. When I base the report on this Datamodule the performance is dissapointing.
    Even slower than using the package version which fires SQL statements to the database.

    Then this datamodule is combined with the organisation datamodule which contains all the facts and dimensions.
    The organisation datamodule is based on a dataserver connection. So the result is a datanodule with 1 linked table (from the organisation datamodule) joined to all the datasets.

    This linking is necessary because eventually the security filter should be applied, so users should only see customer data which they have autorisation for.
    But even without the security filter applied, the performance is less than only using the datasets.

    What can I try to have a better performance?

    ------------------------------
    Thomas van der Meer
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Disappointing performance Datasets with or without combining Datamodule

    Posted Thu August 06, 2020 02:54 PM
    • Can you check the usage and item used property list  and see if changing those property makes any difference?
    • Secondly, you can try to create Custom table for reporting/dashboarding need and see if that improves performance. 

    In general, I am seeing issues using Datasets in CA 11.1.6 to load in memory so you may want to see Server CPU and memory usage when you run reports against Dataset to fine tune them.

    Hope this helps.


    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 3.  RE: Disappointing performance Datasets with or without combining Datamodule

    IBM Champion
    Posted Fri August 07, 2020 02:42 AM
    Try to check properties on the tables, under advanced settings, you have a possibility to just include used columns instead of default (all columns), this will improve performance when you have tables with many columns, you can also make a table view with just the columns that you need.

    ------------------------------
    René Kent Nielsen
    Brand manager
    CogniTech A/S
    Herning
    ------------------------------



  • 4.  RE: Disappointing performance Datasets with or without combining Datamodule

    Posted Fri August 07, 2020 08:10 AM
    Hi René, Buddhi,
    I tried to change the usage properties, but that did not help.
    All the datasets have around 10 columns and are 25K in size. How does creating a custom table help while I created the datasets with minimal amount of columns just for this reason?
    It just does not make sense. I'm using Cognos 11.1.2. but that should not make all the difference.

    ------------------------------
    Thomas van der Meer
    ------------------------------



  • 5.  RE: Disappointing performance Datasets with or without combining Datamodule

    IBM Champion
    Posted Mon August 10, 2020 02:31 AM
    Edited by System Fri January 20, 2023 04:29 PM
    Hi Thomas,

    You are right making custom tables dosn´t help if the dataset already is shaped for the dashboard. From what you are writing, i don´t think the dataset is the problem.

    How does the organisation datamodule perform without using the dataset ? If performance is good, try add and join on dataset at a time.

    You could also check the query service, does it have memory enough allocated.



    ------------------------------
    René Kent Nielsen
    Brand manager
    CogniTech A/S
    Herning
    ------------------------------



  • 6.  RE: Disappointing performance Datasets with or without combining Datamodule

    Posted Fri August 07, 2020 09:16 AM

    Hi Thomas,
    11.1.2 is somewhat of an older version, but that shouldn't matter, because the major performance improvements for execution were made in 11.1.0. For loading datasets, major improvements were made in 11.1.7.
    What are the numbers that you're observing?
    What kind of machine is this running on ?

    We can do a webex if you'd like.
    // Henk



    ------------------------------
    HENK CAZEMIER
    ------------------------------



  • 7.  RE: Disappointing performance Datasets with or without combining Datamodule

    Posted Tue August 11, 2020 08:46 PM

    Hi @Thomas van der Meer, we're sorry to hear you're struggling with these performance issues.

    Henk and I work on the Cognos Analytics Development team at IBM.

    I have two recommendations:

    a) Take Henk up on his offer to jump on a video call to share your experience and observations. He may have some very valuable suggestions to offer.

    b) Log a ticket for IBM Support, if you have not done so already. We would like to have an opportunity to do a deeper investigation and see how we can solve this problem so others do not experience what you're experiencing.



    ------------------------------
    Brennan Fox

    Product Quality @ IBM Cognos Analytics
    ------------------------------