[ 
https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12476418
 ] 

David Garrett commented on OFBIZ-641:
-------------------------------------

Regarding the query ... Yes I agree the correct one is as you say 
select {[Measures].[Store Invoice]} ON COLUMNS, {[Time].[1997].[Q1].[2]} ON 
ROWS from [Warehouse] 

however, the following is generated from the JPivot
select {[Measures].[Store Invoice]} ON COLUMNS, {[Time].[1997].[Q1].[February]} 
ON ROWS from [Warehouse]

As I see it, the problem is either 
  1) in the JPivot OR 
  2) in the implementation of the JPivot used in this datawarehouse module.

Thanks Chris, there is no urgency but if you get a chance to point me in the 
direction of 1 or 2 that would be great.



> Integrate Mondrian OLAP
> -----------------------
>
>                 Key: OFBIZ-641
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-641
>             Project: OFBiz (The Open for Business Project)
>          Issue Type: New Feature
>            Reporter: Chris Howe
>            Priority: Minor
>         Attachments: create-foodmart-mysql.zip, datawarehouse1.patch, 
> datawarehouse1.patch, FoodMart2-drill-fail.zip, freemrkrTransform.patch, 
> mth-drill-fail.jpg, mth-drill-ok.jpg, screenshot-1.jpg, screenshot-2.jpg
>
>
> I'm currently working on integrating Mondrian OLAP using services and 
> simple-methods.  I plan on doing this in a simliar manner that the Trixbox 
> (Asterisk) issue was done.  I'm creating this issue now instead of when I 
> have something to add for collaboration reasons and so that I can play with 
> Mylar around this.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to