Hello everybody.
I'm evaluating pentaho BI suite and the key point I'm searching for is the capability to bulit reports through an advanced console like Pentaho User Console and to make the same kpis shown on reports available through XMLA service. We succeded in builting a simple report on a Pentaho Data Source and to share Measures both on a Pentaho Report and on XMLA services. But we could not add caluculated mdx member to the data source through Pentaho User Console, and using only simple measures (directly column mapping) is too simple for our calculation. So I tried to add a calculated mdx member using Mondrian Schema Workbench to the same Data Source but the calculated member is not shown by Pentaho Reporting. So the question is: is it possible with Pentaho BI suite to centralize an MDX-formula-filed in one Data Source or Report so that this MDX-formula-field is available BOTH on Pentaho Reporting Suite AND the XMLA servlet? I think no, but if someone could suggest some way to do it....