Cognos Analytics

 View Only
  • 1.  11.0.13 Dashboard limitation at 3,000 records?

    Posted Mon November 11, 2019 04:43 PM
    ​We have Analytics 11.0.13 on prem. I created a dataset that has about 115,000 records. It loads without any issues and within reasonable time. However, when I try to create a dashboard from it, on my main sales measure I get a message that says "Your data was clipped at 3000 items. Apply a filter to show less". My measure then shows an incorrect number. I also noticed that not all visualizations will have incorrect data.

    Is this a hard limit on the 11.0.13 dashboard or am I doing something incorrectly?

    Any ideas are welcome. Thanks!


    ------------------------------
    Adrienne Beronilla
    Senior Financial Systems Analyst
    Franklin Templeton
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: 11.0.13 Dashboard limitation at 3,000 records?

    Posted Tue November 12, 2019 09:38 PM

    Hi Adrienne,

    Could you provide more information?  I wish to try it out.

    1. Which visualization type are you using when it​ it is giving you "incorrect data"?   Could you describe what did you put on the viz slots panel? ie:  How is the measure/identifier/attribute mapped to the length/bar/color/filter/etc slots?

    2. Which visualization type(s) give you correct data? How is the slot mapped?

    3. Is it possible to share screenshot?

    Thanks,

    Kian



    ------------------------------
    KIAN GOH
    ------------------------------



  • 3.  RE: 11.0.13 Dashboard limitation at 3,000 records?

    Posted Wed November 13, 2019 07:28 AM
    @Adrienne Beronilla 3000 rows is a limit for dashboards. It's documented here. Could you provide more details on your use case  for dashboards and the need for more than 3000 rows. I would like to feed this back to our team.

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 4.  RE: 11.0.13 Dashboard limitation at 3,000 records?

    Posted Wed November 13, 2019 11:12 AM
    ​Thanks @DENNY NAREZNY that article helped. I am guessing due to some ​setting of the measure, instead of a summary number, I am getting individual data points. The limitation is on the number of data points and not on the number of rows loaded into the dashboard altogether. It seems that I misunderstood the error message.

    Thank you!

    ------------------------------
    Adrienne Beronilla
    Senior Financial Systems Analyst
    Franklin Templeton
    ------------------------------



  • 5.  RE: 11.0.13 Dashboard limitation at 3,000 records?

    Posted Wed November 13, 2019 11:33 AM
    Edited by System Fri January 20, 2023 04:31 PM
    @DENNY NAREZNY​, Just to confirm, the numeric value of 3,000 is related to data points in the visualizations?  Also, are you able to provide information related to if there is a maximum number of rows in a dataset?

    Thanks,
    Jen

    ------------------------------
    Jenifer Broughton
    ------------------------------



  • 6.  RE: 11.0.13 Dashboard limitation at 3,000 records?

    Posted Wed November 13, 2019 12:02 PM
    ​Looking through my dataset I think I know where I went wrong. I was trying to achieve the same measure setting as in Transformer: Time State Rollup -> Current Period or First/Last Period. What I did was to set the measure in the Dashboard to Aggregate -> None from Total.

    What I am trying to do is to make sure that in the dashboard the ending balance does not get summed for each day. This is different from the sales, which can be summed meaningfully for a time period. I was trying to set up a high level table that shows starting balance for the month/year then the sales and then the ending balance. In this case the starting and ending balances should be for the respective dates (first and last periods) while the sales should sum for the entire month/year.

    @DENNY NAREZNY  Can you please advise where I can achieve this setting for dashboard measures?

    Thank you for the help!




    ------------------------------
    Adrienne Beronilla
    Senior Financial Systems Analyst
    Franklin Templeton
    ------------------------------



  • 7.  RE: 11.0.13 Dashboard limitation at 3,000 records?

    Posted Mon November 18, 2019 09:56 AM

    @Adrienne Beronilla You would need to used Column Dependencies in Data Modules to handle multi-grain facts. This feature was introduced in Cognos Analytics 11.1.1. A demo of this can be found on our Youtube channel located here

    Alternatively, Framework Manager has Determinants to handle multi-grain



    ------------------------------
    DENNY NAREZNY
    ------------------------------