search

mysticfall / pivot4j

Pivot4J provides a common API for OLAP servers which can be used to build an analytical service frontend with pivot style GUI.
Other
128 stars 101 forks source link

Dynamic Schema Processor in Analysis #120

Closed ghost closed 10 years ago

ghost commented 10 years ago

How can I add the Dynamic Schema Processor class override in the Analysis Application? Seems like it could be added in the datasource section of the pivot4j-config.xml file as a property.

Thanks for a wonderful product! John

mysticfall commented 10 years ago

Hi John,

Yes, you're right in assuming that editing pivot4j-config.xml to override the Dynamic Schema Processor.

According to this documentation, it should be done by providing DynamicSchemaProcessor property as follows :

(in pivot4j-config.xml)

<properties>
    <property name="Catalog">file:${webRoot}${FS}FoodMart.xml</property>
    <property name="Jdbc">jdbc:derby:${webRoot}${FS}foodmart</property>
    <property name="JdbcDrivers">org.apache.derby.jdbc.EmbeddedDriver</property>
    <property name="JdbcUser">sa</property>
    <property name="DynamicSchemaProcessor">com.acme.MyCustomDynamicSchemaProcessor</property>
</properties>

I haven't done it myself, so if it does not work, please let me know.

Thanks!

mysticfall commented 10 years ago

I'll tag and close this issue for now. If you need further assistence, please consider visiting our mailing list.