jpivot-users Mailing List for JPivot - a JSP based OLAP client
Brought to you by:
avix
You can subscribe to this list here.
2003 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
|
Jul
(4) |
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
---|---|---|---|---|---|---|---|---|---|---|---|---|
2004 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
2005 |
Jan
|
Feb
(11) |
Mar
|
Apr
|
May
(2) |
Jun
(3) |
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2006 |
Jan
|
Feb
|
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
(4) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(3) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
(3) |
Nov
|
Dec
|
2008 |
Jan
|
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2009 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(2) |
Oct
(1) |
Nov
|
Dec
|
2010 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
2011 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2013 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Petar J. <per...@ya...> - 2013-03-13 12:15:48
|
http://www.autofashion.ca/hk/pfjqrp.htm |
From: Farzaneh S. <far...@ya...> - 2011-02-14 07:56:54
|
Dear Sir/Madam I have some problem using JPivot tags for JSF2. actually I could not convert tags. I wonder if this conversion is possible ? If so, Where can I find useful information about this compound (JSF2 + JPivot). Thanks in advanced |
From: Petar J. <per...@ya...> - 2010-08-14 17:23:08
|
Hello guys, I have application that uses JPivot and I have mondrian running separately as an XMLA provider. When I access Mondrian XMLA from JPivot I use for example this <jp:xmlaQuery id="query01" uri="http://147.91.13.144:80/mondrian/xmla" dataSource="Provider=Mondrian;DataSource=DSname;" catalog="Cname"> MDX here </jp:xmlaQuery> and everything is fine. But I have another demand. I want to access XMLA provider (mondrian) over SSL which means I need to use https protocol. I am quite new with ssl and these security things, so I am asking for any information on how to set JPivot to access Mondrian using https. I found something like that for JPalo "By default JPalo uses http protocol to connect to Mondrian. If you want to change protocol to https set is.ssl=true otherwise set is.ssl=false." on this page http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/JPalo#HPaloPivot but I need to know is there something like that for JPivot Hope to get you reply soon Regards, Petar |
From: Parmesh <par...@or...> - 2010-01-15 06:22:16
|
hello when i navigate the table and click on + node it will expand but scrollbar goes to up (top) so i want to know how to handle this clickable event for every node how to know the flow of execution of code -- View this message in context: http://old.nabble.com/jpivot-table-expand-problem-tp27172918p27172918.html Sent from the jpivot-users mailing list archive at Nabble.com. |
From: Ashish P. <aas...@gm...> - 2009-10-05 08:17:03
|
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.-tp25746784p25746784.html Sent from the jpivot-users mailing list archive at Nabble.com. |
From: jasminej82 <spi...@gm...> - 2009-09-27 15:16:22
|
jasminej82 wrote: > > Hi all! > I need help... I'm trying to pass parameter from url to a mdx query. > I'm using this code: > > My first and simple cube > <Schema name="ContactWheels"> > <Cube name="ContactWheelsSite" cache="true" enabled="true"> > <Table name="contact"> > </Table> > <Dimension foreignKey="site_id" name="Aziende"> > <Hierarchy hasAll="true" allMemberName="Tutte le aziende" > primaryKey="code" primaryKeyTable=""> > <Table name="lookup_site_id"> > </Table> > <Level name="Nome azienda" column="description" type="String" > uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> > </Level> > </Hierarchy> > </Dimension> > > <Dimension foreignKey="owner" name="Owner"> > <Hierarchy hasAll="true" allMemberName="Tutti gli owner" > primaryKey="user_id" primaryKeyTable="access"> > <Join leftAlias="role" leftKey="role_id" rightAlias="access" > rightKey="role_id"> > <table name="role" alias="role"></table> > <table name="access" alias="access"></table> > </Join> > <Level name="Ruolo" column="role" table="role" type="String" > uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> > </Level> > <Level name="Nome utente" column="username" table="access" > type="String" uniqueMembers="false" levelType="Regular" > hideMemberIf="Never"> > </Level> > </Hierarchy> > </Dimension> > > <Measure name="Totale utenti" aggregator="count"> > <MeasureExpression> > <SQL dialect="generic"> > (case when contact.site_id >= 1 then 1 else null end ) > </SQL> > </MeasureExpression> > </Measure> > > </Cube> > </Schema> > > Etltools.jsp > <jp:setParam query="${query01}" httpParam="param" mdxParam="parammdx"> > <jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" > jdbcUrl="jdbc:postgresql://localhost:5432/centric_crm" jdbcUser="postgres" > jdbcPassword="postgres" > catalogUri="/WEB-INF/queries/contactwheels.mondrian.xml"> > select ([Aziende].[Tutte le aziende]) ON COLUMNS, (Parameter("parammdx")) > ON ROWS from [ContactWheelsSite] where ([Measures].[Totale utenti]) > </jp:mondrianQuery> > </jp:setParam> > > gg_crosstab1.jsp > <body bgcolor="white"> > <form action="gg_crosstab1.jsp" method="post"> > <wcf:include id="include01" httpParam="query" prefix="/WEB-INF/queries/" > suffix=".jsp"/> > <c:if test="${query01 == null}"> > <jsp:forward page="/index.jsp"/> > </c:if> > > <jp:table id="table01" query="#{query01}" /> > <h2><c:out value="${title01}"/></h2> > <c:out value="${title2}"/> > <p> > <c:if test="${query01.result.overflowOccured}"> > <p><strong style="color:red">Overflow</strong></p> > </c:if> > <wcf:render ref="table01" xslUri="/WEB-INF/jpivot/table/mdxtable.xsl" > xslCache="true"/> > </form> > </body> > </html> > > I call the jsp page with this url: > http://localhost:8080/Pentaho/gg_crosstab1.jsp?query=etltools¶m=marketing > manager > > The exception I get: > javax.servlet.ServletException: javax.servlet.jsp.JspException: > com.tonbeller.jpivot.olap.model.OlapException: 1 > > > What's wrong with my code? I'm newbie with mondrian and jpivot. > I've just configured to use it in my webapps and I need to get this > working. I have a big headache working at this from 3 days:( > Thanks a lot, hope to have an answer as soon as possible. > Have a great day, > > Veronica > Nobody can help me? -- View this message in context: http://www.nabble.com/Hi%21-Help-with-passing-parameter-to-mdx-query-by-jpivot-tp25530673p25634462.html Sent from the jpivot-users mailing list archive at Nabble.com. |
From: jasminej82 <spi...@gm...> - 2009-09-22 11:01:35
|
Hi all! I need help... I'm trying to pass parameter from url to a mdx query. I'm using this code: My first and simple cube <Schema name="ContactWheels"> <Cube name="ContactWheelsSite" cache="true" enabled="true"> <Table name="contact"> </Table> <Dimension foreignKey="site_id" name="Aziende"> <Hierarchy hasAll="true" allMemberName="Tutte le aziende" primaryKey="code" primaryKeyTable=""> <Table name="lookup_site_id"> </Table> <Level name="Nome azienda" column="description" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Dimension foreignKey="owner" name="Owner"> <Hierarchy hasAll="true" allMemberName="Tutti gli owner" primaryKey="user_id" primaryKeyTable="access"> <Join leftAlias="role" leftKey="role_id" rightAlias="access" rightKey="role_id"> <table name="role" alias="role"></table> <table name="access" alias="access"></table> </Join> <Level name="Ruolo" column="role" table="role" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> <Level name="Nome utente" column="username" table="access" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never"> </Level> </Hierarchy> </Dimension> <Measure name="Totale utenti" aggregator="count"> <MeasureExpression> <SQL dialect="generic"> (case when contact.site_id >= 1 then 1 else null end ) </SQL> </MeasureExpression> </Measure> </Cube> </Schema> Etltools.jsp <jp:setParam query="${query01}" httpParam="param" mdxParam="parammdx"> <jp:mondrianQuery id="query01" jdbcDriver="org.postgresql.Driver" jdbcUrl="jdbc:postgresql://localhost:5432/centric_crm" jdbcUser="postgres" jdbcPassword="postgres" catalogUri="/WEB-INF/queries/contactwheels.mondrian.xml"> select ([Aziende].[Tutte le aziende]) ON COLUMNS, (Parameter("parammdx")) ON ROWS from [ContactWheelsSite] where ([Measures].[Totale utenti]) </jp:mondrianQuery> </jp:setParam> gg_crosstab1.jsp <body bgcolor="white"> <form action="gg_crosstab1.jsp" method="post"> <wcf:include id="include01" httpParam="query" prefix="/WEB-INF/queries/" suffix=".jsp"/> <c:if test="${query01 == null}"> <jsp:forward page="/index.jsp"/> </c:if> <jp:table id="table01" query="#{query01}" /> <h2><c:out value="${title01}"/></h2> <c:out value="${title2}"/> <p> <c:if test="${query01.result.overflowOccured}"> <p><strong style="color:red">Overflow</strong></p> </c:if> <wcf:render ref="table01" xslUri="/WEB-INF/jpivot/table/mdxtable.xsl" xslCache="true"/> </form> </body> </html> I call the jsp page with this url: http://localhost:8080/Pentaho/gg_crosstab1.jsp?query=etltools¶m=marketing manager The exception I get: javax.servlet.ServletException: javax.servlet.jsp.JspException: com.tonbeller.jpivot.olap.model.OlapException: 1 What's wrong with my code? I'm newbie with mondrian and jpivot. I've just configured to use it in my webapps and I need to get this working. I have a big headache working at this from 3 days:( Thanks a lot, hope to have an answer as soon as possible. Have a great day, Veronica -- View this message in context: http://www.nabble.com/Hi%21-Help-with-passing-parameter-to-mdx-query-by-jpivot-tp25530673p25530673.html Sent from the jpivot-users mailing list archive at Nabble.com. |
From: Jesus R. <je...@je...> - 2009-01-28 21:06:22
|
Hi, I have a working Pentaho 2.0 server. I can create a Jpivot new analysis view and navigate through the olap cube and get the information of my working shema all displayed correctly. But when I click on save the page refreshes and all of the sudden some dimension children rows are empty both the child and the measures. If I try to clear cache and reload the saved analysis view it continues to be blank in those rows. ALso entering the query in the mdx box shows the same mistaken result. Pls help. -- View this message in context: http://www.nabble.com/JPivot-Save-button-returns-blank-rows-tp21714934p21714934.html Sent from the jpivot-users mailing list archive at Nabble.com. |
From: Pedro P. <ppe...@v2...> - 2008-02-21 12:41:41
|
Hello, I was having problems using the jp:clickable tag. My table rendered perfectly and drill down was working. But I could not make some members clickable. So I did a simple test, replacing my xmlaQuery with the correspondent mondrianQuery. And then my members became clickable. Is there a lack of support of the clickable tag in case of using XML/A queries? Or is there a bug in the XML/A implementation of the Mondrian OLAP API, that makes it somehow different to a direct access (using builtin mondrian server)? Thanks in advance, -- Pedro Pedruzzi | Engenharia de Software | V2COM | +55 11 3094-3939 |
From: LukePet <luk...@ya...> - 2008-02-11 15:48:24
|
I have this problem.. my dimension table is defined in this way: n_id | name1 | name2 ------------------------------- 1 | aaa | NULL 2 | aaa | bbb 3 | aaa | ccc 4 | aaa | ddd in the fact table there are records of this type: n_id | t_id | v_id | value --------------------------------- 1 | 1 | 3 | 1.5 2 | 2 | 3 | 1.3 3 | 2 | 3 | 1.2 4 | 3 | 3 | 1.4 and in mondrian xml schema I have defined a dimension of this type: <Dimension name="Dim" foreingKey="n_id"> <Hierarchy hasAll="false" primaryKey="n_id" primaryKeyTable="n_table"> <Level name="Level1" table="n_table" column="name1" uniqueMembers="false" hideMemberIf="IfBlankName"/> <Level name="Level2" table="n_table" column="name2" uniqueMembers="false" hideMemberIf="IfBlankName"/> </Hierarchy> </Dimension> and the measure of the cube is <Measure name="Values" column="value" aggregator="avg" formatString="#,##0.000"/> the problem is... in jpivot table if I group by Level1 ("aaa") the result is an avarage from the value associated to the n_id 1 and the values of other n_id (2,3,4). But I would that the value show is only read from code n_id 1...is possible? I would try to define a new Measure with CalculatedMember to exclude aggregation for the primary level but I need help. Can you help me about this problem? If I have a value associated to a specific level how can I exclude aggregation of sublevel? Is possible with CalculatedMember? or there are other solutions? Thanks. -- View this message in context: http://www.nabble.com/Load-a-non-aggregate-value-for-a-specific-level-tp15413201p15413201.html Sent from the jpivot-users mailing list archive at Nabble.com. |
From: <And...@to...> - 2007-10-22 08:17:29
|
Ups, it should by "${paramPool.Test1.mdxValue}" or "${paramPool.Test1.sqlValue}" or "${paramPool.Test1.displayName}" etc. Regards, Andreas Voss Softwareentwickler Tel: +49 6251 7000 - 354 Fax: +49 6251 7000 - 140 av...@to... Andreas Voss/Ton Beller AG/DE 22.10.2007 08:34 An "Kaneis Enas" <kan...@gm...> Kopie jpi...@li..., jpi...@li... Thema Antwort: [Jpivot-users] jp:clickable and paramPool JPivot uses jakarta beanutils as its expression language. Try "${paramPool.Test1}", that should work. Kind Regards, Andreas Voss Softwareentwickler Tel: +49 6251 7000 - 354 Fax: +49 6251 7000 - 140 av...@to... "Kaneis Enas" <kan...@gm...> Gesendet von: jpi...@li... 22.10.2007 02:49 An jpi...@li... Kopie Thema [Jpivot-users] jp:clickable and paramPool Hello everyone and congratulations on a magnificent project. I have been trying to understand how to use the paramPool contents that <jp:clickable> is populating. In the "first.jsp" I have (among other things) a jpivot component that uses the following clickable tag inside a jp:mondrianQuery. first.jsp----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- <wcf:paramPool/> <jp:mondrianQuery ..... <jp:clickable page="/second.jsp" uniqueName="[Customer].[Name]" propertyName="CustomerID" sessionParam="Test1"/> <jp:mondrianQuery> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- The mondrian schema has a <Customer> Dimension with a <Name> Level and there is a property <CustomerID> for that level. The <jp:clickable> tag correctly creates anchors for the customer names in a jpivot navigator. When I click on them it redirects to "second.jsp". The problem is that in "second.jsp" I don't know how to access what the user clicked. I thought that something like this whould work: second.jsp------------------------------------------------------------------- <wcf:paramPool/> <c:out value="${paramPool['Test1']}" /> <c:out value="${paramPool['CustomerID']"/> ------------------------------------------------------------------- Unfortunately none of the above ${paramPool}$ expressions work.... Any ideas what I'm doing wrong? Thanks! ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Jpivot-users mailing list Jpi...@li... https://lists.sourceforge.net/lists/listinfo/jpivot-users TONBELLER AG Werner-von-Siemens-Str. 2 D-64625 Bensheim Germany www.tonbeller.com Register Court: District Court Bensheim Registration: HRB 21474 Managing Board: Rutger Hetzler (CEO), Torsten Mayer Chairman of the Supervisory Board: Rüdiger Brand This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any unauthorised copying or dissemination of this message is strictly prohibited. Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die Weitergabe dieser E-Mail ist nicht gestattet. |
From: <And...@to...> - 2007-10-22 06:35:09
|
JPivot uses jakarta beanutils as its expression language. Try "${paramPool.Test1}", that should work. Kind Regards, Andreas Voss Softwareentwickler Tel: +49 6251 7000 - 354 Fax: +49 6251 7000 - 140 av...@to... "Kaneis Enas" <kan...@gm...> Gesendet von: jpi...@li... 22.10.2007 02:49 An jpi...@li... Kopie Thema [Jpivot-users] jp:clickable and paramPool Hello everyone and congratulations on a magnificent project. I have been trying to understand how to use the paramPool contents that <jp:clickable> is populating. In the "first.jsp" I have (among other things) a jpivot component that uses the following clickable tag inside a jp:mondrianQuery. first.jsp----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- <wcf:paramPool/> <jp:mondrianQuery ..... <jp:clickable page="/second.jsp" uniqueName="[Customer].[Name]" propertyName="CustomerID" sessionParam="Test1"/> <jp:mondrianQuery> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- The mondrian schema has a <Customer> Dimension with a <Name> Level and there is a property <CustomerID> for that level. The <jp:clickable> tag correctly creates anchors for the customer names in a jpivot navigator. When I click on them it redirects to "second.jsp". The problem is that in "second.jsp" I don't know how to access what the user clicked. I thought that something like this whould work: second.jsp------------------------------------------------------------------- <wcf:paramPool/> <c:out value="${paramPool['Test1']}" /> <c:out value="${paramPool['CustomerID']"/> ------------------------------------------------------------------- Unfortunately none of the above ${paramPool}$ expressions work.... Any ideas what I'm doing wrong? Thanks! ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Jpivot-users mailing list Jpi...@li... https://lists.sourceforge.net/lists/listinfo/jpivot-users TONBELLER AG Werner-von-Siemens-Str. 2 D-64625 Bensheim Germany www.tonbeller.com Register Court: District Court Bensheim Registration: HRB 21474 Managing Board: Rutger Hetzler (CEO), Torsten Mayer Chairman of the Supervisory Board: Rüdiger Brand This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any unauthorised copying or dissemination of this message is strictly prohibited. Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die Weitergabe dieser E-Mail ist nicht gestattet. |
From: Kaneis E. <kan...@gm...> - 2007-10-22 00:56:48
|
Hello everyone and congratulations on a magnificent project. I have been trying to understand how to use the paramPool contents that <jp:clickable> is populating. In the "first.jsp" I have (among other things) a jpivot component that uses the following clickable tag inside a jp:mondrianQuery. first.jsp----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- <wcf:paramPool/> <jp:mondrianQuery ..... <jp:clickable page="/second.jsp" uniqueName="[Customer].[Name]" propertyName="CustomerID" sessionParam="Test1"/> <jp:mondrianQuery> ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- The mondrian schema has a <Customer> Dimension with a <Name> Level and there is a property <CustomerID> for that level. The <jp:clickable> tag correctly creates anchors for the customer names in a jpivot navigator. When I click on them it redirects to "second.jsp". The problem is that in "second.jsp" I don't know how to access what the user clicked. I thought that something like this whould work: second.jsp------------------------------------------------------------------- <wcf:paramPool/> <c:out value="${paramPool['Test1']}" /> <c:out value="${paramPool['CustomerID']"/> ------------------------------------------------------------------- Unfortunately none of the above ${paramPool}$ expressions work.... Any ideas what I'm doing wrong? Thanks! |
From: <to...@wa...> - 2007-06-21 08:42:19
|
Hi Guys, This isn't a jpivot question as such but I was hoping you could help me in my quest. I've used pentaho to setup a report, the report has a dynamic amount of columns which with JFreeReport seems to be a bit of an issue but with JPivot, it works a treat, I have my report laid out exactly how I want it and the excel output works very well, what I'd like to know is, is it possible to get the report to dump the table straight to and XLS file on my hdd instead of displaying a webpage? I realise this is probably more of a pentaho issue as I've written a xaction and am running it through that but I thought I'd give it a shot anyway. Cheers Tom |
From: Yuan, G. <gy...@ns...> - 2007-05-14 15:33:49
|
Thank you, Andreas! -----Original Message----- From: And...@to... [mailto:And...@to...] Sent: Monday, May 14, 2007 10:58 AM To: Yuan, Grace Cc: jpi...@li...; = jpi...@li... Subject: Antwort: [Jpivot-users] JPivot 1.7.0 Release Note see=20 http://jpivot.sourceforge.net/news.html=20 Andreas=20 jpi...@li... schrieb am 14.05.2007 = 16:55:32: > Hi,=20 > I could not find JPivot 1.7.0 Release Note from the provided link on > sourceforge,=20 > can anyone tell me where I can find it?=20 >=20 > Thanks,=20 > Yuan = -------------------------------------------------------------------------= > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Jpivot-users mailing list > Jpi...@li... > https://lists.sourceforge.net/lists/listinfo/jpivot-users TONBELLER AG Werner-von-Siemens-Str. 2 D-64625 Bensheim=20 Germany www.tonbeller.com=20 Register Court: District Court Bensheim Registration: HRB 21474 Managing Board: Rutger Hetzler (CEO), Torsten Mayer Chairman of the Supervisory Board: R=FCdiger Brand _____ =20 This message is for the designated recipient only and may contain = privileged, proprietary, or otherwise private information. If you have = received it in error, please notify the sender immediately and delete = the original. Any unauthorised copying or dissemination of this message = is strictly prohibited. Diese E-Mail enth=E4lt vertrauliche und/oder rechtlich gesch=FCtzte = Informationen. Wenn Sie nicht der richtige Adressat sind oder diese = E-Mail irrt=FCmlich erhalten haben, informieren Sie bitte sofort den = Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie = die Weitergabe dieser E-Mail ist nicht gestattet. |
From: <And...@to...> - 2007-05-14 14:58:27
|
see http://jpivot.sourceforge.net/news.html Andreas jpi...@li... schrieb am 14.05.2007 16:55:32: > Hi, > I could not find JPivot 1.7.0 Release Note from the provided link on > sourceforge, > can anyone tell me where I can find it? > > Thanks, > Yuan ------------------------------------------------------------------------- > This SF.net email is sponsored by DB2 Express > Download DB2 Express C - the FREE version of DB2 express and take > control of your XML. No limits. Just data. Click to get it now. > http://sourceforge.net/powerbar/db2/ > _______________________________________________ > Jpivot-users mailing list > Jpi...@li... > https://lists.sourceforge.net/lists/listinfo/jpivot-users TONBELLER AG Werner-von-Siemens-Str. 2 D-64625 Bensheim Germany www.tonbeller.com Register Court: District Court Bensheim Registration: HRB 21474 Managing Board: Rutger Hetzler (CEO), Torsten Mayer Chairman of the Supervisory Board: Rüdiger Brand This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any unauthorised copying or dissemination of this message is strictly prohibited. Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese E-Mail. Das unerlaubte Kopieren sowie die Weitergabe dieser E-Mail ist nicht gestattet. |
From: Yuan, G. <gy...@ns...> - 2007-05-14 14:55:26
|
Hi, I could not find JPivot 1.7.0 Release Note from the provided link on = sourceforge,=20 can anyone tell me where I can find it? Thanks, Yuan |
From: Renato C. <re...@do...> - 2006-07-28 19:16:42
|
Hello, I'm looking for a OLAP solution and I'm studing the Pentaho Analysis. Pentaho Analysis supports Drill-Across? Thanks in advanced. Regards, Renato Cramer. |
From: lodestar <lod...@gm...> - 2006-07-28 07:33:02
|
my english is very poor!Sorry! I want study the Jpivot and WCF ,but i don't understand the render, why the xml and xsl? I must be render xml with xsl ? the xml's output don't reveal in the jsp? if i want see the xml's output, where? thanks a lot! |
From: Advait P. <adv...@ya...> - 2006-07-26 05:42:24
|
Hi, I was wondering if anybody has ever suceeded in using Jpivot with an Object Oriented db (I'm trying to get it to work with db4o) If yes, could you please give me some pointers. Thanks, Advait Pandit __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com |
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: Zschorn, A. <AZs...@ze...> - 2006-04-24 14:33:03
|
Hello, First thanks for your great product, I am using jpivot with myfaces and I need to access a JSF Bean from JPivot. How would I accomplish this?=20 Thanks=20 Andreas Zschorn |
From: Ziff D. W. Buyer's G. <Ziff_Davis_Web_Buyer'<s_...@ma...> - 2005-07-14 17:23:16
|
Your product information is available for 7 million qualified technology buyers to see through the Ziff Davis Web Buyers Guide. Dear Frau Kehl, Register online at http://r.vresp.com/?ZiffDavisWebBuyersGu/91637beaf3/364447/5e0a1fd696/d7397c2 to take ownership of your company and product listings currently displaying among 30,000 products within the most comprehensive technology directory in the world. Designed and built by the editors at Ziff Davis, the Web Buyers Guide sets itself apart from other technology directories and alternative search engines with: Targeted Search We serve enterprise technology markets and product categories. This means that buyers interested in your products no longer spend hours surfing the Web or wading through product brochures. Buyers can find you fast on the Ziff Davis Web Buyers Guide. Comprehensive Results Our results are comprehensive and up-to-date. With more than 30,000 enterprise products in 700 categories - no search engine produces more targeted technology product listings. Trusted Editors Each listing is organized and edited by the most trusted editors in the technology industry who report the most accurate and unbiased information in a no-nonsense style. Enterprise Technology Buyers We focus on meeting the critical research requirements of senior-level technology and business managers who influence technology purchases for their company. Register online at http://r.vresp.com/?ZiffDavisWebBuyersGu/9b3857dd23/364447/5e0a1fd696/d7397c2 to take ownership of your listings todayit requires only a few minutes and once youre registered you can edit and add to your listings at any time. Best regards, Melissa Reyen Editorial Director www.WebBuyersGuide.com ______________________________________________________________________ If you no longer wish to receive these emails, please reply to this message with "Unsubscribe" in the subject line or simply click on the following link: http://unsub.vresp.com/u.html?414e7fa3fd/5e0a1fd696/d7397c2 _____________________________________________________________________ This message was sent by Ziff Davis Web Buyer's Guide Ziff Davis Media Inc. 28 East 28th Street New York, NY 10016 |
From: Vladimer S. <vla...@be...> - 2005-06-09 22:39:39
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> <div class="moz-text-html" lang="x-western"> I am comparing a table produced using older (as of September 2004) and one of the most recent versions with regards to drill through. For some reason older version produces the result I expect.<br> <br> If a level of a hierarchy does not have any children I do not want users to even see plus/minus sign. It shows up in the newer version, but not in the old one.<br> <br> See snapshots below:<br> <br> <img src="cid:par...@be..." alt=""> vs. <img src="cid:par...@be..." alt=""><br> <br> I have compared files, and it seems that the problem lies somewhere in either mondrian.jar or jpivot.jar. I would appreciate any leads/comments/suggestions before I try to go into the source to figure out what causes this. <br> <br> Any lead would be greatly appreciated.<br> <br> Thanks,<br> Vladimer Shioshvili<br> <br> </div> </body> </html> |
From: Vladimer S. <vla...@be...> - 2005-06-09 22:35:11
|
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type"> </head> <body bgcolor="#ffffff" text="#000000"> I am comparing a table produced using older (as of September 2004) and one of the most recent versions with regards to drill through. For some reason older version produces the result I expect.<br> <br> If a level of a hierarchy does not have any children I do not want users to even see plus/minus sign. It shows up in the newer version, but not in the old one.<br> <br> See snapshots below:<br> <br> <img src="cid:par...@be..." alt=""> vs. <img src="cid:par...@be..." alt=""><br> <br> I have compared files, and it seems that the problem lies somewhere in either mondrian.jar or jpivot.jar. I would appreciate any leads/comments/suggestions before I try to go into the source to figure out what causes this. <br> <br> Any lead would be greatly appreciated.<br> <br> Thanks,<br> Vladimer Shioshvili<br> <br> </body> </html> |