ReportServer Forum

nikolajoder

Member

Registered: 2020-01-10

OLAP Cache

Is OLAP Cache cleared automatically? If yes, how often? If no, can it be automated?

eduardo

Administrator

Registered: 2016-11-01

Website

Re: OLAP Cache

Hi nikolajoder,

OLAP cache is not cleared automatically, but this is planned for the future (ticket RS-3473) . In the OLAP datasource you have a button for clearing it manually. You can clear it by script by calling net.datenwerke.rs.saiku.service.saiku.OlapUtilService.flushCache(MondrianDatasource) for a given datasource.

Since you can schedule the script to run periodically, this can also be done for clearing cache periodically.

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: OLAP Cache

Hi nikolajoder,

please note that the above only applies for Mondrian datasources. If you use XMLA e.g. with Microsoft Analysis Services, you have the following parameters for clearing cache periodically: (cache timeout, size, mode, etc.)

type=OLAP
name=Reporting
driver=org.olap4j.driver.xmla.XmlaOlap4jDriver
Cache=org.olap4j.driver.xmla.cache.XmlaOlap4jNamedMemoryCache
Cache.Name=ConnectionCache
Cache.Mode=LFU
Cache.Timeout=600
Cache.Size=1000

Regards,
Eduardo

nikolajoder

Member

Registered: 2020-01-10

Re: OLAP Cache

Thank you Eduardo.

Last edited by nikolajoder (2020-01-13 11:39:51)