Skip to content

Add support for connections having pivot caches associated

snippet requested to merge topic/3.2/connection-caches into branch/3.2

In testing metadata.xml support I would run into files like this which did not have pivot tables, but did have pivot caches. It turns out the cache is associated with the connection object (looks like this in the xml - <cacheSource type="external" connectionId="1" /> whereas a cache associated with a table would look like

    <cacheSource type="worksheet">
        <worksheetSource name="Table4" />
    </cacheSource>

This merge aims to add support to the Connection object to track caches associated with it.

Understanding how pivots are glued together was a bit of a nightmare so this might not be an optimal implementation but I figured better to have something that works and can be iterated on.

Known issues:

  • pivotCacheDefinition has both an attribute and a child element called tupleCache but the implementation only tracks the child, not sure how to handle that but slightly mangled documents are produced if the attribute is missing and a cache is present.

--HG-- branch : 3.2

Merge request reports