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

Measure whitout aggregation ? #176

Closed viktornikolovski closed 9 years ago

viktornikolovski commented 9 years ago

How can i create measure whitout aggregation, like price measure that is not aggregate data at all ? The values of that measure makes sense only when I drill down in dimension. I need to keep the ability to drill down but not aggregate the values of that measure.

Or is there a way, to hide the aggregate at the highest level of the hierarchy ?

mysticfall commented 9 years ago

If I understood your question correctly, it seems that you want to change the way the OLAP engine aggregates measures, not how Pivot4J aggregates them using the non-MDX aggregation feature (which you configure from the toolbar to enable).

In that case, I believe you'll need to refer to the documentation of the OLAP engine you use. If it's Mondrian, you might want to check the manual on the schema format, or ask it on the Pentaho forum.

I'd like to help you with more specific information, but I'm not very knowledgeable about Mondrian myself. Sorry I couldn't be much help this time.

viktornikolovski commented 9 years ago

Thank you for your consideration, I will ask Pentaho about this problem :)