Hi guys!
I created a dummy dashboard with 20 queries to see the functionalities (all queries linked to a report in PPM), as i noticed that the queries were getting slow at the first execution i used the below ppm commands to catch this queries in the cache.
call runppmadmin -language %PPM_CONF_LANGUAGE% -user %PPM_CONF_USER% -password %PPM_CONF_PASSWD% -client %PPM_CLIENT% -protocolfile "%PPM_CUSTOM_DIR%\log\%PROTOCOLFILE_EXTENSION%" -clearcache
call runppmadmin -language %PPM_CONF_LANGUAGE% -user %PPM_CONF_USER% -password %PPM_CONF_PASSWD% -client %PPM_CLIENT% -protocolfile "%PPM_CUSTOM_DIR%\log\%PROTOCOLFILE_EXTENSION%" -fillcache
So far no problem, but then i added one dynamic filter and every time i select a filter value all the queries are re-calculated, and of course it takes years. Is there any chance to catch the filters added (and their queries) in the cache also?
the filter at the _conf.xml file is the following:
<filterlist>
<filter name="P2_LAND_BUKRS" type="dynamic" rowcount="12" displaytext_static="favoritedescription" nofilter_entry="true">
<description language="en" name="Country" />
</filter>
</filterlist>
Thanks and best regards,
Facundo