Mondrian generated Excel Pivots and field settings

[mrossi75]

Hi,
I am creating Pivot tables in Excel using a SimbaO2X data source connected to a Mondrian server.
In a normal Excel pivot you can click on a "value" field (Measure) and choose the type of aggregation that you want - sum, avg, count etc.

If instead you create a Pivot via the SimbaO2X/Mondrian the value fields have that option greyed out.

When you define Measure fields in the Mondrian schema you can only define one aggregator, for example

<Measure aggregator="min" formatString="Standard" column="positive" name="positive_min"/>

Is there any way to enable that setting in Excel?

I am thinking of something at the schema level, maybe a special way to define a group of Measures so that Excel understands that they are part of the same value field.

Many thanks,
Michele

[agho]

Michele,

Sorry I'm not offering a solution. Just wondering how you were able to get
Excel 2k7 + SimbaO2x to talk to Mondrian.

Been trying. Didn't think it was possible. Mind offering some pointers?

Cheers,
~A

[haubuchon]

I'd also like to know !
So far no luck ...
What connect string are you using ?

[krish_estalea]

Look into this thread
http://forums.pentaho.org/showthread.php?t=73803

also youtube video for Simba configuration for Excel7

Simba up to Mondrian: http://bit.ly/c6zYSS