search

rpbouman / phase

Pentaho Analysis Editor
Apache License 2.0
24 stars 12 forks source link

Can't create calculated measures #3

Closed xerxes42 closed 9 years ago

xerxes42 commented 9 years ago

When adding a calculated measure in Phase it doesn't set the dimension it belongs to so I can't load the cube. The source looks like this: <CalculatedMember name="minutesCalled" caption="Minutes Called" formula="[Measures].[callLasted] / 60"/>

When I open the schema in Schema Workbench and set dimension to Measures it works fine: <CalculatedMember name="minutesCalled" caption="Minutes Called" formula="[Measures].[callLasted] / 60" dimension="Measures"/>

I'm running Phase downloaded on 28/11 (couldn't find a version number) and Pentaho BI CE 5.2.0.0-209.

Brgds Olof Mattsson

rpbouman commented 9 years ago

Thank you for your report. I made a fix for this issue (https://github.com/rpbouman/phase/commit/8bdc15e25d3ddbcd4d742d999f1c54ce98ab9f28) This should work for Calculated Members in cubes, but not yet for Virtual Cubes (support will be added as virtual cube editing is being fleshed out).

I updated the phase.zip so you can test it. To install, simply remove the old phase directory beneath pentaho-solutions/system, and unzip phase.zip into that directory to get an updated phase directory. You do not need to restart the bi server (although it can't hurt) - refreshing puc in the browser (shift + F5) should be enough (if not, try clearing your browser cache).

Please report the result back to this issue so I can either close it (of if necessary do more work on it).

xerxes42 commented 9 years ago

Thanks for the quick response. Works after updating Phase to the latest .zip file.

rpbouman commented 9 years ago

Thank you for confirming. Closing this issue now. Feel free to open a new issue if you run into more problems. Kind regards, Roland.