There is a limit of 225 for charts in reports/dashboards and we would need to increase this number
There is a property named "OnDemand.MaxTotalChartSelected.Limit" that will help increase the limit. Please perform the following steps:
1.- Navigate to /opt/CA/MySql/bin directory in CAPC
2.- Change to "mysql" user and access the db:
[[email protected] bin]# su mysql
bash-4.2$ ./mysql -uroot -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1520
Server version: 5.7.31-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
3.- Change the db to use netqosportal:
mysql> use netqosportal;
4.- Run the following query to add the attribute "OnDemand.MaxTotalChartSelected.Limit" and the new value (eg: 270):
mysql> replace into netqosportal.general values ('OnDemand.MaxTotalChartSelected.Limit', '270');
Query OK, 1 row affected (0.00 sec)
5.- Wait for some minutes and see if the attribute is now visible in:
This should have increased the chart limit.
DX PM and present more than 225 charts