jpivot-devel Mailing List for JPivot - a JSP based OLAP client
Brought to you by:
avix
Menu
▾
▴
jpivot-devel — JPivot developers
You can subscribe to this list here.
| 2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(3) |
Jul
(9) |
Aug
(11) |
Sep
(14) |
Oct
(23) |
Nov
(2) |
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(2) |
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
(5) |
Oct
|
Nov
(4) |
Dec
|
| 2005 |
Jan
|
Feb
(1) |
Mar
|
Apr
(1) |
May
(2) |
Jun
(2) |
Jul
(1) |
Aug
(1) |
Sep
(9) |
Oct
(3) |
Nov
(3) |
Dec
(6) |
| 2006 |
Jan
(1) |
Feb
|
Mar
(1) |
Apr
(2) |
May
(1) |
Jun
(1) |
Jul
(2) |
Aug
(1) |
Sep
(1) |
Oct
|
Nov
(1) |
Dec
(3) |
| 2007 |
Jan
(2) |
Feb
(2) |
Mar
|
Apr
|
May
(2) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2008 |
Jan
|
Feb
|
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
|
From: Cynthia334 <ro...@gm...> - 2009-10-06 09:15:39
|
If you are struggling to choose the correct business intelligence solution? The OLAP Survey 6 is the world's largest and most comprehensive independent survey of BI products, offering valuable insight collected from 1,679 software implementation.You can also gain more information from a book on OLAP.The http://www.amazon.com/Multidimensional-Data-Modeling-Toolkit-Intelligence/dp/0981775306 book is available on Amazon & you can buy an e-book directly from the publisher by writing OLA...@gm.... -- View this message in context: http://www.nabble.com/The-OLAP-Survey-tp4408075p25765289.html Sent from the jpivot-devel mailing list archive at Nabble.com. |
|
From: Ashish P. <aas...@gm...> - 2009-10-05 08:17:44
|
I am trying to build a Mondrian Schema around a fact table and Dimension
table.
I have built a shared dimension for Dimension table and placed it outside
the cube in the schema definition.
Here is the beginning of my schema, where the relevant portions are shown:
<Schema name="my-service">
<Dimension name="Dim1" type="StandardDimension">
<Hierarchy hasAll="true" allMemberName="All" primaryKey="EMPLOYEE_NAME">
<Table name="EMPLOYEE" />
<Level name="Employee Last Name" column="EMPLOYEE_LNAME"
uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<Cube name="myFact">
<View alias="APPLICATION_VIEW">
<SQL dialect="generic">
<![CDATA[SELECT CITY, ZIP FROM EMPLOYEE_DETAILS WHERE EMP_STATE IN
('ACTIVE')]]>
</SQL>
</View>
<DimensionUsage name="Dim1" source="Dim1" foreignKey="EMPLOYEE_NAME" />
</Cube>
Table: EMPLOYEE
EMPLOYEE_NAME | EMPLOYEE_LNAME
ASHISH PANCHAL
Table: EMPLOYEE_DETAILS
EMPLOYEE_NAME | CITY | ZIP | STATE
ASHISH MUM 40064 ACTIVE
RAJ PUNE 2365 ACTIVE
So, while executing Analysis, i see count(Measure) as 2(Which is correct,as
2 records in fact matching)
and on drilling though (DrillThrough Table) i get only one row (which is
also correct as Shared Dimension joined with the fact table
So i am looking for a solution to contol/restrict the dimensions being shown
On DrillThrough Table.
--
View this message in context: http://www.nabble.com/contol-restrict-the-dimensions-being-shown-On-DrillThrough-Table.-tp25746792p25746792.html
Sent from the jpivot-devel mailing list archive at Nabble.com.
|
|
From: rkbirari <bir...@gm...> - 2008-08-01 12:37:08
|
Hello Friends,
I want to Integrated new JPivot 1.8 with my product which alredy develop in
JSP(JAVA).
and I already use JPivot in my application but I use old version I want
intgrated with new version
Previously I am not working with JPivot and it's Integration It aleredy done
some others persome
Please guild me to integreded step by step
in my application there is one folder src in -->there are 2 folders 1)conf
2)java-->com-->tonbeller-->jpivot-->mondrian-->MondrianModel.java(only one
file)
and
WEB-INF contains -->classes\com\tonbeller\jpivot\mondrian.class
and jfreereport.properties and oscache.properties
Please help me
--
View this message in context: http://www.nabble.com/I-want-Integrated--new-JPivot-1.8-with-my-product-tp18773501p18773501.html
Sent from the jpivot-devel mailing list archive at Nabble.com.
|
|
From: skaranam <kar...@ya...> - 2008-04-24 00:15:26
|
Folliowing are my Tables in mySQL Database
Table measurements
====================
id value
10001 10
10002 20
10003 30
10004 40
Table: Attribute Names
=============
id Name
----------------------------
10001 Signal Strength
10002 XXXXX
10003 YYYYY
10004 ZZZZZZ
I want to get a Pivot Table such as
All measurements Value
Signal Strength 10
XXXXX 20
YYYYY 30
ZZZZZZ 40
My Olap Schema is as follows
<Schema defaultRole="" name="MySchema">
<Cube name="Jddac">
<Table name="measurements"/>
<Dimension name="MeasurementID" foreignKey="id">
<Table name="attributeNames"/>
<Property name="ID" column="id" uniqueMembers="true"/>
</Dimension>
<Measure name="Value" column="value" aggregator="sum" formatString="#,###"/>
<Measure name="Id" column="id" aggregator="sum" formatString="#,###"/>
</Cube>
</Schema>
My MDX Query is as follows
SELECT {[Measures].[Value]} ON COLUMNS, {[MeasurementID].[ID]} ON ROWS FROM
Jddac
It is throwing anException like it
com.tonbeller.jpivot.olap.model.OlapException: 0
at com.tonbeller.jpivot.mondrian.MondrianModel.initia
lize(MondrianModel.java:550)
at com.tonbeller.jpivot.olap.model.OlapModelDecorator
.initialize(OlapModelDecorator.java:132)
at com.tonbeller.jpivot.tags.OlapModelProxy$MyState.i
nitialize(OlapModelProxy.java:77)
What is Am I doing wrong
--
View this message in context: http://www.nabble.com/Help-Required-MDX--Please-Anybody-there-tp16834881p16834881.html
Sent from the jpivot-devel mailing list archive at Nabble.com.
|
|
From: Julian H. <jh...@pe...> - 2008-03-08 05:02:36
|
Will, Re https://sourceforge.net/tracker/?func=detail&atid=414613&aid=1792393&group_i d=35302 I thought it was DISPLAY_INFO too, but now I'm not so sure. Mondrian seems to be forming DISPLAY_INFO correctly (XmlaHandler.java, line 1991), encoding the number of children into the lower two bytes. And JPivot seems to be decoding the number of children correctly (XMLA_Member.java, line 701). (By the way, I discovered this posting from Mosha about detecting leaves, and it mentions DISPLAY_INFO: http://www.sqljunkies.com/WebLog/mosha/archive/2006/04/29/leaves.aspx . Doesn't help much in this case, but it's interesting.) I think the error is in JPivot here: XMLA_Member.java:178: if (level.getChildLevel() == null || isCalculated) { childrenCardinality = 0; childrenOk = true; } XMLA_Member.java:464: public XMLA_Member[] getChildren() throws OlapException { if (childrenOk) { if (childrenCardinality == 0) return new XMLA_Member[0]; else return (XMLA_Member[]) aChildren.toArray(new XMLA_Member[0]); } // determine children model.retrieveMemberChildren(this); // will retrieve children return (XMLA_Member[]) aChildren.toArray(new XMLA_Member[0]); } I don't understand the purpose of this logic, in particular why it checks 'level.getChildLevel() == null'. In a parent-child hierarchy, a member may be at the last level and still have children. I notice that in the XMLA fragment from SSAS the level is named CEO, and that makes me think that SSAS is generating level names based on the depth in the parent-child hierarchy. That would explain why it works for SSAS, but I still think that JPivot is in the wrong here. Can someone from Jpivot comment on this? > -----Original Message----- > From: Will Gorman [mailto:wg...@pe...] > Sent: Friday, March 07, 2008 3:27 PM > To: Julian Hyde > Subject: XMLA Differences... > > I've updated the parent/child XMLA case with this: > > See the attached XMLA files from both Mondrian and MSAS. Here is > Sheri's > xml: > > MSAS XMLA: > <Member Hierarchy="[Employees]"> > <UName>[Employees].[All Employees].[Sheri Nowmer]</UName> > <Caption>Sheri Nowmer</Caption> > <LName>[Employees].[CEO]</LName> > <LNum>1</LNum> > <DisplayInfo>1000</DisplayInfo> > </Member> > > MONDRIAN XMLA: > <Member Hierarchy="Employees"> > <UName>[Employees].[All Employees].[Sheri > Nowmer]</UName> > <Caption>Sheri Nowmer</Caption> > <LName>[Employees].[Employee Id]</LName> > <LNum>1</LNum> > <DisplayInfo>7</DisplayInfo> > </Member> > > > File Added: xmla_diffs.zip > > I'm guessing the display info value is the difference. One > item of note, even when I reach the last node within the > Employees Hierarchy using MSAS XMLA it still shows a drill > down icon (+ or -). > > Will > > |
|
From: Julian H. <jul...@sp...> - 2007-05-21 22:32:41
|
As you say, the right approach is to add a formula on the parsed query object, rather than using string manipulation. I'm not a core jpivot developer, so I'm not the best person to evaluate this. Can one of the jpivot developers evaluate & commit Kap's code? (Attached as src.zip1; to view, rename to src.zip.) If anyone has the inclination to do it, I think that a 'create formula' button would be a great addition to jpivot. I sketched out the kind of formulas you could create in a regression test: http://mondrian.pentaho.org/api/src-html/mondrian/test/TestCalculatedMem bers.html#line.245 Each of those members is a different kind of formula. The dialog would require one or more members or levels as a parameter to build the formula, a description of the formula which would make sense to end-users, and the ability to generate a sensible default name for the formula. Julian > -----Original Message----- > From: Nobody [mailto:no...@sc...] On > Behalf Of Kap > Sent: Monday, May 21, 2007 6:24 AM > To: jh...@us... > Cc: kap...@us... > Subject: Auto computed growth functionality > > > Message body follows: > > Hi Julian, > I am K Ajith Paul nick name as kap/ajith, worked for > mondiran client, some time before in my organization. We > are using our mondian client as OpenI. > > We have done a functionality called Auto computed growth > over previous period by clicking a button. The same > functionality is done by adding as calculated member by > updating the MDX string only. (i am attaching the jpivot > source for your reference, as now i updated with jpivot > latest version 1.7) > The functionality includs > 1) on click of a button, it will identify all visible > measures and displays the growth% over the previous period > (forumla part is fixed and located in StringUtil.java) > 2) support for xmla client for the same > 3) Functionality to delete a computed member in the olap > navigator (MemberNavigator.java) > > I am requesting you to review the code and functinality. > (sending as the same structure so that u can just update > the files and build) > > Can you suggest any good approach for adding the calculated > member, like ParsedQuery obj.addFormula(uniquename, > formulaitem) it will be good, as i am feeling the present > approach is not a proper way,even though its working fine. > The same logic can be used for creating a computed member > as most of the clients demanding. > > Expecting your positive reply > Regards, > Ajith > > > > > -- > This message has been sent to you, a registered SourceForge.net user, > by another site user, through the SourceForge.net site. This message > has been delivered to your SourceForge.net mail alias. You may reply > to this message using the "Reply" feature of your email client, or > using the messaging facility of SourceForge.net at: > https://sourceforge.net/sendmessage.php?touser=1547882 > > |
|
From: Eduardo A. <edu...@gm...> - 2007-05-16 10:02:43
|
Hello, my name is Eduardo Andrade and I submitted what I think it's a bug last month "ReqID : 1708066 - Parent-Child Hierarchy w/o Closure displays only one level<http://sourceforge.net/tracker/index.php?func=detail&aid=1708066&group_id=58645&atid=488472>" and I would like to know if any member of the developing team as come across this problem ? Does anyone have a clue about what has changed to cause this issue ? I've looked into JPivot source code but don't have a clue where to search for the cause of this issue. I'd expect that the developing team could enlighten myself about this. Thank you for your time. Best regards, -- Eduardo Andrade edu...@gm... |
|
From: <EST...@co...> - 2007-02-14 07:38:52
|
We=B4ve a table configuration question. How can we set up any JPivot ta=
ble
configuration parameter in a JSP page? For example, set up the table to=
show the parent name in the header or set the table to show or not the
title headers.
There exists any tag like:
<jp:table ...>
<config show_header=3D1 ...>
</jp:table ...>
Thanks in advance. David P=E9rez.=
|
|
From: Anu G. D. <anu...@pu...> - 2007-02-07 05:58:56
|
Sir/Madam I seek help from designers, developers, testers,defect fixers,project managers or playing any other key role in Free/Open Source software development or maintenence in carrying out a study to identify practices and problems of defect management in various Free/Open Source Software projects. The insights gained from the study can further help us to extract publicly accessible defect data and determine impact of defect management practices on software quality. Please spend a few minutes of your precious time to fill up the Questionnaire. The most of the questions follow multiple choice formats and are quite easy to answer. To have the Online Questionnaire, please visit: http://anu.puchd.ac.in/phpESP/public/survey.php?name=FOSS_Defect_Survey (You can also copy and paste this link into your browser, and hit the 'Return' key.) I hope you will find all the questions interesting and thought-provoking. Your answers will be kept anonymous.The data thus collected will only be used for research purpose.It would be nice if you may further refer this mail to others actively engaged with Free/Open Source Software development. If you have any query or suggestions then feel free to contact. Thank You With regards, Anu Gupta Senior Lecturer Department of Computer Science and Applications, Panjab University, Chandigarh. INDIA In case of any problem in accessing/using the above mentioned link please contact: E-mail: anu...@pu... anu...@gm... |
|
From: Sandeep C. <qa...@sa...> - 2007-01-19 14:06:13
|
Hi, Is it possible to convert Jpivot toolbar buttons to hyperlinks. Please let me know asap. thanks in advance. Sandeep |
|
From: Jindrich S. <jin...@gm...> - 2007-01-17 11:59:59
|
Hello,
I have a table with two colums Sex and Age.
Sex, Age
-------------
M 25
F 32
M 85
F 44
I would like to see average age for Sex. Something like this:
Avg Age
-------------
M 33,3
F 42,3
I tried this MDX throught Jpivot XMLA and MSSQL 2000 Analysing services
WITH
MEMBER
[Measures].[AvgAge]
AS
'AVG(Descendants([Sex].[Sex].CurrentMember) ,[Measures].[Age])'
SELECT
{ [Measures].[AvgAge] }
ON COLUMNS,
{ [Sex].[Sex].Members}
ON ROWS
FROM PCPCube
but I doesn't work. Any idea?
Thank you
Jindra
|
|
From: Davide Z. <dav...@en...> - 2006-12-22 15:39:54
|
Hi! I am a member of the SpagoBI platform developer team, we use JPivot as OLAP client in our project. We made an extension for JPivot: normally, when you click on the drill-through button in a cell, the drill-through table shows the result set as a simple text table and only the columns of the result set are shown. With our extension, the drill-through table can show other calculated columns: configured groovy scripts are executed to create those columns. An user can write the groovy scripts by hand as per his requirements; each groovy script is executed for each row of the result set, takes all the columns of the row at input and calculate the result producing an additional column (that can contain also a link). A client of ours asked as this feature in order to have an additional column containing a link to another application: the link had to be composed by a static part (maybe the service main url) and a dynamic part (the parameters of the request), the dynamic part being obtained by the values contained inside the single row. We think that this feature is very useful, groovy scripts can do that and other calculations. At the moment the source code of this extension is inside the SpagoBI svn repository, but if you want I can send you the code for your evaluation and for contributing to JPivot project. Awaiting for your kind replay, please accept in the meanwhile my best regards. Davide Zerbetto |
|
From: Julian H. <jul...@sp...> - 2006-12-15 04:04:24
|
I have just fixed the jpivot source code for the mondrian API changes, and checked these into CVS along with the latest mondrian.jar. However, mondrian.jar is built using JDK 1.5, so you won't be able to compile jpivot using JDK 1.4 as things stand. Someone will need to pull over mondrian-jdk14.jar and retroweaver-rt-1.2.4.jar, and make some changes to build.xml. Julian _____ From: mon...@li... [mailto:mon...@li...] On Behalf Of Pappyn Bart Sent: Thursday, December 14, 2006 12:35 AM To: Mondrian developers Subject: Re: [Mondrian-devel] Problems since perforce change 8324 I already went back to change 8300. I have no time to investigate the problem right now. Do mind though, that xmla is broken since change 8324, the query seems to succeed, but all other discover message for the navigator seem to fail. Could jpivot mondrian native and jpivot xmla somehow be included in the regression tests to prevent such problems in the future ? Not sure how to do this, just an idea. Bart _____ From: mon...@li... [mailto:mon...@li...] On Behalf Of Julian Hyde Sent: Thursday, December 14, 2006 9:15 AM To: 'Mondrian developers' Subject: Re: [Mondrian-devel] Problems since perforce change 8324 In change 8324, I switched to use JDK 1.5 enums rather than hand-coded enumeration classes. I thought that the changes were internal to mondrian, but I guess I should have recompiled jpivot to check. This particular method used to take an int parameter, but now takes an instance of AxisOrdinal. It should be straightforward to change the code. For example, int i; Hierarchy[] hierarchies = query.getMdxHierchiesOnAxis(i); would become int i; Hierarchy[] hierarchies = query.getMdxHierarchiesOnAxis(AxisOrdinal.forOrdinal2(i)); Julian _____ From: mon...@li... [mailto:mon...@li...] On Behalf Of Pappyn Bart Sent: Wednesday, December 13, 2006 8:28 AM To: Mondrian developers Subject: [Mondrian-devel] Problems since perforce change 8324 I seem to have problems since perforce change 8324. It is not working any more against jpivot. I get mondrian native - jpivot : org.apache.jasper.JasperException: javax.servlet.jsp.JspException: mondrian.olap.Query.getMdxHierarchiesOnAxis(I)[Lmondrian/olap/Hierarchy; xmla gives a lot of errors, jpivot table is shown, but navigator does not work. After recompiling jpivot against latest mondrian.jar, compile fails. Is this a known problem ? Thanks, Bart ______________________________________________________________________ This email has been scanned by the Email Security System. ______________________________________________________________________ |
|
From: Anu G. D. <anu...@pu...> - 2006-12-09 08:47:50
|
Dear Sir/Madam We are conducting a study to understand how defect management is being carried out in various Free/Open Source Software projects. The insights gained from the study can further help to extract publicly accessible defect data and determine impact of defect management practices on software quality. Please spend a few minutes of your precious time to fill up the Questionnaire. The most of the questions follow multiple choice formats and are quite easy to answer. To have the Online Questionnaire, please visit: http://anu.puchd.ac.in/phpESP/public/survey.php?name=FOSS_Defect_Survey (You can also copy and paste this link into your browser, and hit the 'Return' key.) Your answers will be kept anonymous. The information thus collected will only be used for research purpose. If you have any query or suggestions then feel free to contact. Thank You With regards, Anu Gupta Senior Lecturer Department of Computer Science and Applications, Panjab University, Chandigarh. E-mail: anu...@pu... anu...@gm... |
|
From: Julian H. <jul...@sp...> - 2006-11-24 20:36:15
|
_____ From: Pappyn Bart [mailto:Bar...@va...] Sent: Thursday, November 23, 2006 12:34 AM To: Julian Hyde Subject: Mondrian : XML/A changes, Data change plug-in, Cache flushing Hi Julian, XML/A : Thanks for fixing the slicer in XML/A. Was on my roadmap to change, so I have a less work now :-) You're welcome. While I cannot test using the latest mondrian release now (no time enough), I was wondering if an other XML/A bug is solved also ? When selecting measures in the jpivot navigator using xmla, DBSCHEMA_MEMBERS is done for any dimension (also for measures). This one returns all measures (visible or not), but no calculated members. I was wondering if DBSCHEMA_MEASURES should be called instead and the result in jpivot be filtered afterwards to only show the measure dimension (since DBSCHEMA_MEASURES returns all calculated members, from all dimensions). Or should DBSCHEMA_MEMBERS be adapted to do return correct things if the measure dimension is involved. In my case, I am working with a virtual cube. I expect to see calculated members and all hidden measures should not be visible. It does sounds like DBSCHEMA_MEASURES would be more useful, because people definitely want to see calculated measures as well as regular measures. Andreas, what do you think? I presume that JPivot has a way to show calculated measures which are defined in the query, because these are not going to be returned even by DBSCHEMA_MEASURES. Regarding Mondrian's XMLA behavior: I prefer to work from use cases which have been run against MSAS. If you have a copy of MSAS, and can provide a request/response pair demonstrating the desired behavior, I can very easily implement it. Data change plug-in / cache flushing : I think I will start somewhere next week to write the plug-in interface for the data change listener (I mailed you a month ago about this). I was wondering if your changes for selectively flushing the cache are already released to perforce ? I'm haven't checked in the cache flushing functionality, but I am getting closer. I should have something in time for you to start next week. I read your email "Dimension cache clearing". It all makes sense - let me know if there are still questions to resolve. As regards testing, I'm not doing testing at the SQL level: I am writing tests which dump the state of the cache, flush, then dump the state of the cache again. For you, SQL tests make sense. Or better, an approach similar to NonEmptyTest, which looks at how many rows were read. This avoids the issue that the generated SQL is different for each database. Suppose you add (a) a global variable containing the number of rows read by all member readers, and (b) a mock listener. You could run a query, tell the mock listener nothing has changed, run the query again and see that no rows were read, tell the mock listener that dimension A has changed, run the query again and see that 10 rows were read. Julian |
|
From: Pappyn B. <Bar...@va...> - 2006-09-27 15:22:37
|
Hi, =20 Regarding to bug http://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D1566263&grou= p_i d=3D58645&atid=3D488472, =20 I reported this problem and also provide a solution (code) for it (see bug report). =20 If anyone of the developers would be so kind to put this into the jpivot source base ? =20 Thank you very much ! =20 Kind regards, Bart |
|
From: Julian H. <jul...@sp...> - 2006-08-29 16:51:43
|
Rocky, We love self-starters. If you can figure out how to download from CVS, build and debug the code, you will go far. If you can fix a bug, even better. Here's a good bug for you to work on: http://jira.pentaho.org:8080/jira/browse/ANALYSIS-84?page=all When you've fixed it, send me the patch. If you fix a couple of bugs, we'll give you commiter access. Good luck! Julian -----Original Message----- From: Nobody [mailto:no...@sc...] On Behalf Of Rocky Agrawal Sent: Tuesday, August 29, 2006 5:32 PM To: jh...@us... Subject: Willing to work for the JPivot project Message body follows: Dear Ma'am/Sir, I am an employee of a US based software comapny. For the time of my training, we have to do some development project for sort of a technological know-how and I am leading a team of 3 developers for the same. I would like the opportunity to work on JPivot during this time and some of the things that I see in your roadmap interest me a lot. Please let me know how can I join the developers community on JPivot and how can we work in synchronization to achieve something better? PS: I am new to sourceforge developers' community and so would appreciate all the help that you can provide as a ramp-up. thanks. warm regards, rocky. userid: agrawalrocky username: rocky agrawal project: jpivot -- This message has been sent to you, a registered SourceForge.net user, by another site user, through the SourceForge.net site. This message has been delivered to your SourceForge.net mail alias. You may reply to this message using the "Reply" feature of your email client, or using the messaging facility of SourceForge.net at: https://sourceforge.net/sendmessage.php?touser=1586360 |
|
From: Julian H. <ju...@hy...> - 2006-07-28 18:51:23
|
Thanks. I logged bug 1530578 = <http://sourceforge.net/support/tracker.php?aid=3D1530578> to track = this, and have checked in a fix. Julian > -----Original Message----- > From: Richard Emberson [mailto:rem...@ed...] > Sent: Friday, July 28, 2006 06:23 > To: ju...@hy... > Cc: 'Henry Olson' > Subject: Re: Bug in mondrian-2.1.1-derby distribution > > > In the class: com.tonbeller.jpivot.mondrian.MondrianQuaxUti > > change the equalMember method > From: > public boolean equalMember(Object oExp, Member member) { > mondrian.olap.Member m =3D ((MondrianMember) > member).getMonMember(); > return (m.equals(oExp)); > } > > To: > public boolean equalMember(Object oExp, Member member) { > mondrian.olap.Member m =3D ((MondrianMember) > member).getMonMember(); > mondrian.olap.Member oMon =3D toMember(oExp); > return (m.equals(oMon)); > } > > > Julian Hyde wrote: > > Can you send me the patch? I can't make a Jpivot release, but I can > > commit the change to Jpivot's CVS, and the next Mondrian > release will > > contain the bugfixed Jpivot. > >=20 > > Julian > > > > =20 > -------------------------------------------------------------- > ---------- > > *From:* Henry Olson [mailto:ho...@ed...] > > *Sent:* Thursday, July 27, 2006 22:03 > > *To:* ju...@hy... > > *Cc:* Richard Emberson > > *Subject:* Bug in mondrian-2.1.1-derby distribution > > > > Julian, > > > > =20 > > > > On Sunday I duplicated the failure sequence outlined > below with the > > mondrian-2.1.1-derby distribution. This seems to be a pretty > > serious bug in an unmodified distribution. On Wed., > Richard found > > the single line of code in JPivot where the problem originates. > > Perhaps Andreas is interested in the patch? I had > previously sent a > > note to Andreas =96 must have gotten lost in the spam > filter. If he > > takes your email, perhaps you could pass along this test case. > > > > =20 > > > > Richard can supply the patch, if he=92s not already done so=85 > > > > =20 > > > > Installing Mondrian-embedded: > > > > * Downloaded the distribution from Sourceforge > > * Extracted the war file: mondrian-embedded.war (from > > mondrian-2.1.1-derby.zip/mondrian-2.1.1-embedded/lib) to a > > temp directory > > * Uploaded to Tomcat 5.5 using the Tomcat Manager > Page/Deploy > > WAR file function > > * Clicked on /mondrian-embedded in the Tomcat Manager Page > > Applications List > > * Clicked on =93JPivot pivot table=94 > > * Clicked on =93MDX=94 toolbar button > > > > =20 > > > > Test case: > > > > * Paste in starting MDX > > > > select {[Measures].[Unit Sales]} ON COLUMNS, > > > > [Product].[All Products].Children ON ROWS > > > > from [Sales] > > > > * Execute the test case click stream below > > > > =B7 /Add 'Store' to Rows/ > > > > =B7 /Move 'Store' above 'Product'/ > > > > =B7 /Click 'OK'/ > > > > =B7 /Expand 'All Stores'/ > > > > =B7 /Expand any 'Product'/ > > > > =20 > > > > =E0Exception Thrown > > > > =20 > > > > =20 > > > > Thanks, > > > > =20 > > > > Henry > > > > > -- > This email message is for the sole use of the intended > recipient(s) and > may contain confidential information. Any unauthorized review, use, > disclosure or distribution is prohibited. If you are not the intended > recipient, please contact the sender by reply email and destroy all > copies of the original message. >=20 |
|
From: Mustafa A. <ma...@ed...> - 2006-07-20 23:16:04
|
Hi All,
=20
Im noticing a changed behavior in JPivot 1.5 Please let me know if it's
a known issue.
=20
Lets say we have 3 wholesalers (W1, W2, W3) and 3 products (P1, P2, P3)
on rows and time dimension on columns
We have valid data for the following combinations only.
W1 - P1
W2 - P1
W3 - P1
=20
1. In the OLAP navigatior we have selected All Wholesalers under
wholesaler and selected individual products (P1,P2,P3) under products.
2. The initial table view comes with All Wholesalers and Products
P1,P2,P3
3. Now when you expand All Wholesalers it displays W1,W2,W3 and for
each wholesalers it displays 3 products.
4. Notice that a combination like W2 - P2 and W2 - P3 is not a
valid one.
5. Now when you try to expand P2 under W2 then we get Null Pointer
Exception
=20
java.lang.NullPointerException
at
com.tonbeller.jpivot.mondrian.MondrianQuaxUti.isFunCallTo(MondrianQuaxUt
i.java:615)
at
com.tonbeller.jpivot.olap.query.ExpGenerator.genExp(ExpGenerator.java:74
)
at
com.tonbeller.jpivot.olap.query.Quax.genNormalExp(Quax.java:1137)
at com.tonbeller.jpivot.olap.query.Quax.genExp(Quax.java:1112)
at
com.tonbeller.jpivot.mondrian.MondrianQueryAdapter.onExecute(MondrianQue
ryAdapter.java:136)
at
com.tonbeller.jpivot.mondrian.MondrianModel.getResult(MondrianModel.java
:180)
at
com.tonbeller.jpivot.olap.model.OlapModelDecorator.getResult(OlapModelDe
corator.java:54)
at
com.tonbeller.jpivot.olap.model.CachingOlapModel.getResult(CachingOlapMo
del.java:48)
at
com.tonbeller.jpivot.table.TableComponent.updateOlapModel(TableComponent
.java:245)
at
com.tonbeller.jpivot.table.TableComponent.render2(TableComponent.java:25
0)
at
com.tonbeller.jpivot.table.TableComponent.render(TableComponent.java:234
)
at
com.tonbeller.wcf.component.RendererTag.doEndTag(RendererTag.java:137)
=20
6. Alternatively, if you select All Products in the OLAP Navigator
for Products and de-select individual products, then only valid
combinations are displayed in the JPivot. Invalid combinations like W2 -
P2 are automatically suppressed in 1.5
=20
7. Actually in JPivot 1.3 , all invalid combinations are displayed
and clicking on them just works fine without any exception.
=20
So it looks to me like when we introduce this auto suppress of
invalid combinations in 1.5, we didn't handle the case that the user
could still bring a invalid combination through his filters and we
should not throw an exception.
=20
I know it's a complex issue and I tried to explain as much as
possible. If you need any additional information, please let me know. We
are close to release and this issue is a real blocker. I would really
appreciate your timely help in this.
=20
Thanks
Mustafa
=20
This email message is for the sole use of the intended recipient(s) and
may contain confidential information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all
copies of the original message.
=20
|
|
From: Sergey K. <ser...@ma...> - 2006-06-03 15:14:38
|
Hello, first thanks for your great product. Check up files in jpivot_repository \mondrian-2.1, please. Download damaged. Send me this folder if it is not difficult, please. |
|
From: Julian H. <ju...@hy...> - 2006-05-14 20:21:03
|
The OLAP Survey is one of the most comprehensive and influential analyses of the state of business intelligence software: "We would very much welcome your participation in The OLAP Survey 6. This is the largest independent survey of business intelligence users worldwide. The Survey will obtain input from a large number of users to better understand their buying decisions, the implementation cycle and the business success achieved. Both business and technical respondents are welcome. The OLAP Survey is strictly independent. While Oracle, Microsoft, Cognos and other vendors assist by inviting users to participate in the Survey, the vendors do not sponsor the survey, nor influence the questionnaire design or survey results. As a participant, you will not only have the opportunity to ensure your experiences are included in the analyses, but you will also receive a summary of the results from the full survey. You will also have a chance of winning one of ten $50 Amazon vouchers. <http://www.survey.com/olap6sur8.html> Click here to complete the survey on-line." -- Gordon Laver It would be good to have representation from the Mondrian/JPivot community in that survey. (We'd like to better understand how you are using Mondrian/JPivot, too.) To complete the survey, go to http://www.survey.com/olap6sur8.html Julian |
|
From: <EST...@co...> - 2006-04-10 11:05:48
|
>The JPivot Portlet has not been upgraded to run with JPivot 1.5. What is the latter JPivot version with portlet support compatible with JBoss? >What are the problems you are seeing? I=B4ve tried the following installations: 1. Deploy using Ant build deploy, previusly setting the jboss.home, jboss.deploy, jboss-portal.deploy, but it doesn=B4t deploy the portlet correctly. . 2. Install JPivor.war application on jboss-4.0.3SP1. I=B4ve directly de= ploy the war file in the: jboss-4.0.3 SP1\server\default\deploy\jbossweb-tomcat55.sar directory and copy th= e library jar files into the jboss-4.0.3SP1\server\default\lib director= y. I=B4ve changed the jboss-service.xml: <attribute name=3D"UseJBossWebLoader">true</attribute>. Finally, JPivot application runs ok but when I deploy the portal war files into the jboss-4.0.3SP1\server\default\deploy\jboss-portal.sar directory I can see the portlet in the portlet navigator menu, but wh= en I click on it says me that the center target doesn=B4t exists. I=B4ve t= ried to change the portlet target to "left" but it neither run. Is there any JBoss portlet Howto?? any docuemntation or experience? Thanks in advance.= |
|
From: Sherman W. <sg...@ix...> - 2006-04-10 04:11:17
|
The JPivot Portlet has not been upgraded to run with JPivot 1.5. =20 What are the problems you are seeing? =20 =20 Sherman =20 _____ =20 From: EST...@co... [mailto:EST...@co...]=20 Sent: Tuesday, April 04, 2006 4:06 AM To: And...@to... Cc: jpi...@li... Subject: Jpivot installation on JBoss 4.03SP1 y jboss-portal-2.0.2RC1 =20 Hi, we are trying to install Jpivot on JBoss 4.03SP1 y jboss-portal-2.0.2RC1. We=B4ve read the Readme.txt that is in the jboss-portlet directory but we can=B4t run the JPivot context embeded in = the Tomcat JBoss plugin (we=B4ve copied the jpivot.war expanded into the jbossweb-tomcat55.sar directory), and we can=B4t run the JPivot portlet (jpivot-portlet-1.5.0.war) copying it into the jboss-portal.sar JBoss folder. =20 We=B4ve tried to use the ant build targets, after specify the build properties: jboss.home, jboss.deploy, jboss-portal.deploy, but it = doesn=B4t deploy the portlet correctly. =20 Finelly, we=B4ve tried too to use the latest JBoss Porlet version (jboss-portal-2.2.1RC1-bundled) but it doesn=B4t run, =20 Any idea? What are the correct steps and version for correct JPivot Portlet deployment. =20 Thanks in advance. David P=E9rez. =3D |
|
From: <SMF...@co...> - 2006-01-13 15:21:58
|
Hello All,
I =B4m one of the devolopers of JRubik,
We have adapt the treemap component developing a new plugin. I don't th=
ing
It's the best solution, it is
just an start point to increment the features that Jrubik can provide, =
and
if anyone is interested he will be
welcomed.
Other question:
We use
monModel.setExternalDataSource(javax.sql.Datasource);
for stabish the mondrian conection.
DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPassword); fails bec=
ause
the jpivot classLoader has not access to the drivers. That ones are
managed by theirs plugins classLoaders. This way works good with almost=
all
extensions except:
DrillThrough dt =3D(DrillThrough)olapModel.getExtension(DrillThrough.ID=
)
I think the problem is the way of stablish the conection in
MondrianDrillThroughTableModel:
private Connection getConnection() throws SQLException {
if (dataSourceName =3D=3D null) {
if (jdbcUrl =3D=3D null) {
throw new RuntimeException(
"Mondrian Connect string '" +
"' must contain either '" + RolapConnectionProperties.Jdbc +
"' or '" + RolapConnectionProperties.DataSource + "'");
}
return DriverManager.getConnection(jdbcUrl, jdbcUser, jdbcPassword);
} else {
return getDataSource().getConnection();
}
}
To solve the problem we have copy the MondrianDrillThroughTableModel as=
RubikDrillThroughTableModel:
RubikDrillThroughTableModel(OlapModel olapModel,Cell cell) {
private Connection getConnection() throws SQLException {
MondrianModel monModel =3D(MondrianModel)olapModel;
return monModel.getExternalDataSource().getConnection();
}
=BFdo you sugest anything to stablish the datasource as
MondrianDrillThroughTableModel way instead use the
RubikDrillThroughTableModel?
Thanks in advance.
Felix
=
|
|
From: Sherman W. <sg...@ix...> - 2005-12-30 00:23:00
|
I have been working on the Derby packaging, and have run into a few problems
in other areas.
There has been a number of checkins in Mondrian related to XML/A which have
changed class names and packages. The WAR builds have not kept up, and so
xmlaTest.jsp is broken. I am fixing that, including Richard's
DefaultXmlaServletImpl catch for the web.xml.
JPivot HEAD seems to now expect the xmlQuery tag to include a
"provider=Mondrian;" entry in the dataSource attribute, ie.
<jp:xmlaQuery id="query01"
uri="http://localhost:8080/mondrian/xmla"
dataSource="Provider=Mondrian;DataSource=MondrianFoodMart"
catalog="FoodMart">
Recent changes in DriverManager.fixup are aimed at doing a better job of
finding the schema file when it is embedded in a WAR, but I am finding a few
problems. This has broken the Mondrian tag lib, adhoc.jsp and taglib.jsp.
Sherman
|
5 messages has been excluded from this view by a project administrator.
