You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Chris Howe (JIRA)" <ji...@apache.org> on 2007/01/22 08:15:29 UTC
[jira] Created: (OFBIZ-641) Integrate Mondrian OLAP
Integrate Mondrian OLAP
-----------------------
Key: OFBIZ-641
URL: https://issues.apache.org/jira/browse/OFBIZ-641
Project: Apache OFBiz (The Open for Business Project)
Issue Type: New Feature
Reporter: Chris Howe
Priority: Minor
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.
-
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
RE: [jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
Posted by Chris Howe <cj...@yahoo.com>.
Hey David G,
Can you attach those to OFBIZ-641? I think they got lopped off the
mailing list.
Thanks!
--- David Garrett <dg...@communication.concepts.cc> wrote:
> Chris,
>
> Very nice work! Thanks for the effort.
>
> I have run into a problem and I am not sure if it is in your
> implementation
> or with Jpivot. I was hoping you could point me in the right
> direction.
>
> I have been able to reproduce my problem in the Foodmart example and
> have
> attached updated files, screen shots and error reports.
>
> The problem I have relates to the use of the "ordinalColumn" and the
> "nameColumn" attributes that can be used in a dimension. As you can
> see
> below, I have "enhanced" the Time dimension by adding the Day level
> plus
> added the ordinalColumn/nameColumn attributes.
>
> In the Warehouse cube...
> I can drill down to the month level BUT I can not drill down to day
> (mth-drill-fail.jpg). If the ordinalColumn/nameColumn attributes are
> removed
> I can drill down to the day level (mth-drill-ok.jpg).
>
> <Dimension name="Time" type="TimeDimension">
> <Hierarchy hasAll="false" primaryKey="time_id">
> <Table name="time_by_day"/>
> <Level name="Year" column="the_year" type="Numeric"
> uniqueMembers="true" levelType="TimeYears"/>
> <Level name="Quarter" column="quarter" uniqueMembers="false"
> levelType="TimeQuarters"/>
> <Level name="Month" column="month_of_year"
> uniqueMembers="false"
> type="Numeric" levelType="TimeMonths" ordinalColumn="month_of_year"
> nameColumn="the_month"/>
> <Level name="Day" column="day_of_month" uniqueMembers="false"
> type="Numeric" levelType="TimeDays"/>
> </Hierarchy>
> </Dimension>
>
> Do you have any suggestions as to what is going wrong?
>
> Thanks
> David G
>
>
> Notes:
> 1. The revised FoodMart.zip is attached.
> 2. Is there a simple solution to the drillPositionButton which is not
> displaying the correct string ... mondrian.rolap.RolapResult@d085f8
> 3. part of Error
> select {[Measures].[Store Invoice]} ON COLUMNS,
> {[Time].[1997].[Q1].[February]} ON ROWS
> from [Warehouse]
>
> [RolapSchemaReader]: 60: role: mondrian.olap.Role@20e54a
> [RolapSchemaReader]: 61: schema: mondrian.rolap.RolapSchema@2bcacba
> 2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
> Util.java:439:DEBUG] Util.lookupCompound: parent.name=Warehouse,
> category=unknown, names=[Measures].[Store Invoice]
> 2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
> RolapCube.java:1808:DEBUG] RolapCube.lookupChild: name=Warehouse,
> childname=Measures returning elementname=Measures
> 2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
> HierarchyBase.java:137:DEBUG] HierarchyBase.lookupChild:
> name=Measures,
> childname=Store Invoice returning elementname=Store Invoice
> 2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
> DimensionBase.java:126:DEBUG] DimensionBase.lookupChild:
> name=Measures,
> childname=Store Invoice returning elementname=Store Invoice
> 2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
> Util.java:493:DEBUG] Util.lookupCompound: found child.name=Store
> Invoice,
> child.class=mondrian.rolap.RolapStoredMeasure
> [RolapSchemaReader]: 60: role: mondrian.olap.Role@10725b4
> [RolapSchemaReader]: 61: schema: mondrian.rolap.RolapSchema@2bcacba
> 2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
> Util.java:439:DEBUG] Util.lookupCompound: parent.name=Warehouse,
> category=unknown, names=[Time].[1997].[Q1].[February]
> 2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
> RolapCube.java:1808:DEBUG] RolapCube.lookupChild: name=Warehouse,
> childname=Time, status=hierUsage == shared returning elementname=Time
> 2007-02-26 22:29:24,554 (http-0.0.0.0-8443-Processor4) [
> HierarchyBase.java:137:DEBUG] HierarchyBase.lookupChild: name=Time,
> childname=1997 returning elementname=1997
> 2007-02-26 22:29:24,554 (http-0.0.0.0-8443-Processor4) [
> DimensionBase.java:126:DEBUG] DimensionBase.lookupChild: name=Time,
> childname=1997 returning elementname=1997
> 2007-02-26 22:29:24,554 (http-0.0.0.0-8443-Processor4) [
> RolapSchemaReader.java:238:DEBUG] looking for child "Q1" of
> [Time].[1997]
> 2007-02-26 22:29:24,554 (http-0.0.0.0-8443-Processor4) [
> RolapSchemaReader.java:238:DEBUG] looking for child "February" of
> [Time].[1997].[Q1]
> 2007-02-26 22:29:24,574 (http-0.0.0.0-8443-Processor4) [
> RolapSchemaReader.java:258:DEBUG] NumberFormatException in
> lookupMemberChildByName for parent = "[Time].[1997].[Q1]",
> childName="February", exception: For input string: "February"
> 2007-02-26 22:29:24,574 (http-0.0.0.0-8443-Processor4) [
> Util.java:474:DEBUG] Util.lookupCompound: parent.name=Q1 has no child
> with
> name=February
> 2007-02-26 22:29:24,574 (http-0.0.0.0-8443-Processor4) [
> Util.java:439:DEBUG] Util.lookupCompound: parent.name=Warehouse,
> category=member, names=[Time].[1997].[Q1]
>
>
>
>
> -----Original Message-----
> From: Chris Howe (JIRA) [mailto:jira@apache.org]
> Sent: Monday, 19 February 2007 9:21 AM
> To: dev@ofbiz.apache.org
> Subject: [jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
>
>
> [
>
https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plug
> in.system.issuetabpanels:all-tabpanel ]
>
> Chris Howe updated OFBIZ-641:
> -----------------------------
>
> Attachment: datawarehouse1.patch
>
> datawarehouse1.patch
>
> cleans up some superfluous Debug statements and makes it relative to
> datawarehouse.home
>
> > 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, freemrkrTransform.patch, 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.
>
>
RE: [jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
Posted by David Garrett <dg...@communication.concepts.cc>.
Chris,
Very nice work! Thanks for the effort.
I have run into a problem and I am not sure if it is in your implementation
or with Jpivot. I was hoping you could point me in the right direction.
I have been able to reproduce my problem in the Foodmart example and have
attached updated files, screen shots and error reports.
The problem I have relates to the use of the "ordinalColumn" and the
"nameColumn" attributes that can be used in a dimension. As you can see
below, I have "enhanced" the Time dimension by adding the Day level plus
added the ordinalColumn/nameColumn attributes.
In the Warehouse cube...
I can drill down to the month level BUT I can not drill down to day
(mth-drill-fail.jpg). If the ordinalColumn/nameColumn attributes are removed
I can drill down to the day level (mth-drill-ok.jpg).
<Dimension name="Time" type="TimeDimension">
<Hierarchy hasAll="false" primaryKey="time_id">
<Table name="time_by_day"/>
<Level name="Year" column="the_year" type="Numeric"
uniqueMembers="true" levelType="TimeYears"/>
<Level name="Quarter" column="quarter" uniqueMembers="false"
levelType="TimeQuarters"/>
<Level name="Month" column="month_of_year" uniqueMembers="false"
type="Numeric" levelType="TimeMonths" ordinalColumn="month_of_year"
nameColumn="the_month"/>
<Level name="Day" column="day_of_month" uniqueMembers="false"
type="Numeric" levelType="TimeDays"/>
</Hierarchy>
</Dimension>
Do you have any suggestions as to what is going wrong?
Thanks
David G
Notes:
1. The revised FoodMart.zip is attached.
2. Is there a simple solution to the drillPositionButton which is not
displaying the correct string ... mondrian.rolap.RolapResult@d085f8
3. part of Error
select {[Measures].[Store Invoice]} ON COLUMNS,
{[Time].[1997].[Q1].[February]} ON ROWS
from [Warehouse]
[RolapSchemaReader]: 60: role: mondrian.olap.Role@20e54a
[RolapSchemaReader]: 61: schema: mondrian.rolap.RolapSchema@2bcacba
2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
Util.java:439:DEBUG] Util.lookupCompound: parent.name=Warehouse,
category=unknown, names=[Measures].[Store Invoice]
2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
RolapCube.java:1808:DEBUG] RolapCube.lookupChild: name=Warehouse,
childname=Measures returning elementname=Measures
2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
HierarchyBase.java:137:DEBUG] HierarchyBase.lookupChild: name=Measures,
childname=Store Invoice returning elementname=Store Invoice
2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
DimensionBase.java:126:DEBUG] DimensionBase.lookupChild: name=Measures,
childname=Store Invoice returning elementname=Store Invoice
2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
Util.java:493:DEBUG] Util.lookupCompound: found child.name=Store Invoice,
child.class=mondrian.rolap.RolapStoredMeasure
[RolapSchemaReader]: 60: role: mondrian.olap.Role@10725b4
[RolapSchemaReader]: 61: schema: mondrian.rolap.RolapSchema@2bcacba
2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
Util.java:439:DEBUG] Util.lookupCompound: parent.name=Warehouse,
category=unknown, names=[Time].[1997].[Q1].[February]
2007-02-26 22:29:24,544 (http-0.0.0.0-8443-Processor4) [
RolapCube.java:1808:DEBUG] RolapCube.lookupChild: name=Warehouse,
childname=Time, status=hierUsage == shared returning elementname=Time
2007-02-26 22:29:24,554 (http-0.0.0.0-8443-Processor4) [
HierarchyBase.java:137:DEBUG] HierarchyBase.lookupChild: name=Time,
childname=1997 returning elementname=1997
2007-02-26 22:29:24,554 (http-0.0.0.0-8443-Processor4) [
DimensionBase.java:126:DEBUG] DimensionBase.lookupChild: name=Time,
childname=1997 returning elementname=1997
2007-02-26 22:29:24,554 (http-0.0.0.0-8443-Processor4) [
RolapSchemaReader.java:238:DEBUG] looking for child "Q1" of [Time].[1997]
2007-02-26 22:29:24,554 (http-0.0.0.0-8443-Processor4) [
RolapSchemaReader.java:238:DEBUG] looking for child "February" of
[Time].[1997].[Q1]
2007-02-26 22:29:24,574 (http-0.0.0.0-8443-Processor4) [
RolapSchemaReader.java:258:DEBUG] NumberFormatException in
lookupMemberChildByName for parent = "[Time].[1997].[Q1]",
childName="February", exception: For input string: "February"
2007-02-26 22:29:24,574 (http-0.0.0.0-8443-Processor4) [
Util.java:474:DEBUG] Util.lookupCompound: parent.name=Q1 has no child with
name=February
2007-02-26 22:29:24,574 (http-0.0.0.0-8443-Processor4) [
Util.java:439:DEBUG] Util.lookupCompound: parent.name=Warehouse,
category=member, names=[Time].[1997].[Q1]
-----Original Message-----
From: Chris Howe (JIRA) [mailto:jira@apache.org]
Sent: Monday, 19 February 2007 9:21 AM
To: dev@ofbiz.apache.org
Subject: [jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
[
https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plug
in.system.issuetabpanels:all-tabpanel ]
Chris Howe updated OFBIZ-641:
-----------------------------
Attachment: datawarehouse1.patch
datawarehouse1.patch
cleans up some superfluous Debug statements and makes it relative to
datawarehouse.home
> 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, freemrkrTransform.patch, 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.
[jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "David Garrett (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David Garrett updated OFBIZ-641:
--------------------------------
Attachment: FoodMart2-drill-fail.zip
mth-drill-ok.jpg
mth-drill-fail.jpg
Files demonstrating drilldown problem when Dimension->Level has ordinalColumn, nameColumn
> 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.
[jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Chris Howe (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Howe updated OFBIZ-641:
-----------------------------
Attachment: datawarehouse1.patch
datawarehouse1.patch
cleans up some superfluous Debug statements and makes it relative to datawarehouse.home
> 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, freemrkrTransform.patch, 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.
[jira] Commented: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Chris Howe (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12474030 ]
Chris Howe commented on OFBIZ-641:
----------------------------------
I think what's provided here and the sf datawarehouse project should allow anyone interested in Business Intelligence inside Ofbiz to look down a Mondrian path as far as they could (stretching a Robert Frost - Road Not Taken analogy).
I think I'll hold off on doing any further work on this feature until there is feedback from those that have expressed they have been ( or wanting to) actively pursue Business Intelligence inside OFBiz (namely Oleg, Kirill, Jacopo, David and Si). Of course if there is anyone else who has time/expertise to offer, I would greatly appreciate that as well and consider refocusing my priorities to this. However, there is little sense in building on generic work that might be discarded when there is more tedious work to do :)
> 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, freemrkrTransform.patch, 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.
[jira] Commented: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Chris Howe (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12470858 ]
Chris Howe commented on OFBIZ-641:
----------------------------------
I'm probably looking at the last week of Feb, first week of March to looking at this seriously again. I wanted to review the recent Shark stuff and compare it again with the Pentaho project. I think we can piggy back off a lot of their efforts a lot easier than starting from scratch. Their gauges and some of their Google Maps integrations are very powerful looking.
Have you tried the OpenI walk through on docs.ofbiz.org?
Do you see that much benefit in designing it anew from inside OFBiz? To utilize an OLAP natively inside OFBiz would, I think, require quite an extension to the entity engine. That seems like quite a bit of work. But this topic is rather new to me and I've shared about every shred that I've picked up along the way. So, I'm very interested in other's ideas this.
> 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
>
> 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.
[jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Chris Howe (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Howe updated OFBIZ-641:
-----------------------------
Attachment: screenshot-1.jpg
Screenshot of a MDX query off a FoodMart database (generic sample database that has a cube schema already made) from the OFBiz Datawarehouse Component http://sourceforge.net/projects/datawarehouse/ created by Kirill Kuznetsov and Oleg Kozyrev
> 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: screenshot-1.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.
[jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Chris Howe (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Howe updated OFBIZ-641:
-----------------------------
Attachment: datawarehouse1.patch
datawarehouse1.patch
patch that needs to be applied to http://sourceforge.net/projects/datawarehouse/
head svn checkout to bring up to date with current OFBiz and to align some of the things with an OOTB database user. This is setup for mysql using the FoodMart database
> 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: datawarehouse1.patch, freemrkrTransform.patch, 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.
[jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Chris Howe (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Howe updated OFBIZ-641:
-----------------------------
Attachment: freemrkrTransform.patch
freemrkrTransform.patch
Adds a freemarker transform needed for the datawarehouse component.
http://sourceforge.net/projects/datawarehouse/
> 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: freemrkrTransform.patch, 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.
[jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Chris Howe (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Howe updated OFBIZ-641:
-----------------------------
Attachment: create-foodmart-mysql.zip
foodmart sql datbase
> 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, freemrkrTransform.patch, 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.
[jira] Commented: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Chris Howe (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12470979 ]
Chris Howe commented on OFBIZ-641:
----------------------------------
You'll like this then...
Mondrian is used predominately as a "ROLAP", where it's taking a star schema from disk and represents a OLAP schema in cache :-) . Thus, benefiting as much as it can from the great performance gains of an OLAP, while keeping the simplicity of a RDBMS
http://mondrian.pentaho.org/documentation/aggregate_tables.php#Introduction
There would certainly be some values that we would want to denormalize, so the org.ofbiz.database and supporting services would be needed as well. Most of the creation of the simple/complex/undefined reports are done by creating elaborate cube definitions so that you're not having to be omniscient on what future reports are needed.
> 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
>
> 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.
[jira] Commented: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12470938 ]
Jacopo Cappellato commented on OFBIZ-641:
-----------------------------------------
Chris,
you can find some of my opinions about this subject here:
http://docs.ofbiz.org/display/~jacopoc/My+Misc+Notes+about+new+OFBiz+features
I'm sorry, no, I had no time to play with OpenI
However the solution I'm thinking of is based on a relational database (star schema) and not on OLAP (cubes).
> 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
>
> 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.
[jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Chris Howe (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Howe updated OFBIZ-641:
-----------------------------
Attachment: screenshot-2.jpg
screenshot demonstrating drill down working
> 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: 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.
[jira] Commented: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12470851 ]
Jacopo Cappellato commented on OFBIZ-641:
-----------------------------------------
Chris,
what is the current status of this effort?
I'm asking this because I'm seriously considering the possibility to start the design/implementation of some base services and artifacts to provide a framework for datawarehouse analysis completely based on OFBiz (i.e. a new entity group org.ofbiz.datawarehouse, new entity defs for new , minilang services for ETL, supporting tools and a few simple examples of screen/form based reports based on the datawarehouse entities); maybe we should consider this as something that could partially happen at the upcoming developers conference (but my schedule is still a total mess).
Jacopo
> 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
>
> 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.
[jira] Commented: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "David Garrett (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Updated: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Marco Risaliti (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Marco Risaliti updated OFBIZ-641:
---------------------------------
Component/s: framework
Fix Version/s: SVN trunk
Affects Version/s: SVN trunk
> Integrate Mondrian OLAP
> -----------------------
>
> Key: OFBIZ-641
> URL: https://issues.apache.org/jira/browse/OFBIZ-641
> Project: OFBiz
> Issue Type: New Feature
> Components: framework
> Affects Versions: SVN trunk
> Reporter: Chris Howe
> Priority: Minor
> Fix For: SVN trunk
>
> 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.
[jira] Commented: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "tlemsani (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12494288 ]
tlemsani commented on OFBIZ-641:
--------------------------------
hi,
i've been working on mondrian's integration in Ofbiz for 2 mounths, i was very happy to find this issue.
i can't reach to apply your patch easily, i think that datawarehouse componenent on sourceforge is some kind diffirent from your local version
i'll prepare new patch during this mounth
> 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.
[jira] Commented: (OFBIZ-641) Integrate Mondrian OLAP
Posted by "Chris Howe (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-641?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12476399 ]
Chris Howe commented on OFBIZ-641:
----------------------------------
First, let me defer thanks to Kirill Kuznetsov and Oleg Kozyrev and the OFBiz community at large. All I did was follow the errors log with a recent SVN.
2. I haven't looked into very much of the implementation myself. Just wanted to get it up and running to the point that the initial MDX shows up correctly. So, I'm not exactly sure what Kirill and Oleg were trying to demonstrate with that box, it may just be a place holder for now.
3
Should be
select {[Measures].[Store Invoice]} ON COLUMNS, {[Time].[1997].[Q1].[2]} ON ROWS from [Warehouse]
February is a name and not actually the Column being used...i think... more can be read about it here:
http://mondrian.pentaho.org/documentation/schema.php#Level_Order_and_Display
I'll probably have some more time to look at this over the weekend, so if you have anything to add or more questions, keep them coming.
> 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.