How to start?

[jose...@gmail.com]

Hello,

I am starting a new BI project and I want to use Pivot4j. I will not use JSF, Spring MVC will use.

I have already readed the section "How to Use" at

http://mysticfall.github.io/pivot4j/usage.html

Where can I get more information about Pivot4j how to use?

Exists some official Pivot4j tutorial online?

Some book?

Thank you,

[mysticf...@gmail.com]

Hi,

Glad to see another user for my project :)

I have to admit the documentation is not much of help right now. As I'm still very short handed even for writing the codes, there's no official documentation yet.

Though you can always ask me if you have any problem while using this project. I normally reply such questions promptly, as we don't have many users just now (I hope it will change when the Pentaho BI 5 is released).

Anyway, thanks again for having an interest for the project. And please let me know the specific nature of your problem, then I'll do my best to help.

Cheers,

Xavier Cho

[jose...@gmail.com]

Dear Xavier,

I have a Web application where I use olap4j directly.

Can I do all the things a do with olap4j using pivot4j?

Thank you,

José

[jose...@gmail.com]

Dear Xavier,

I think I find the error I spoke you yesterday.

It is necessary to load the Mondrian Olap4j Driver with:

Class.forName("mondrian.olap4j.MondrianOlap4jDriver");

Then I need to include Mondrian in my pom.xml:

<dependency>
<groupId>pentaho</groupId>
<artifactId>mondrian</artifactId>
<version>4.0.0-SNAPSHOT</version>
</dependency>

Then I get the error I said you:

java.lang.NoSuchMethodError:com.eyeq.pivot4j.mdx.impl.CupParser.getSymbolFactory()Ljava_cup/runtime/SymbolFactory;

Thank you

[jose...@gmail.com]

Xavier,

Sorry so many questions!

Pivot4j supports Mondrian 4.0 Schemas?

Thank you,

José

[mysticfall]

Hi,

It should be caused because the added library has javacup depenency itself.

So, please modify that line as follows :

<dependency>
    <groupId>pentaho</groupId>
    <artifactId>mondrian</artifactId>
    <version>4.0.0-SNAPSHOT</version>

    <exclusion>
        <groupId>javacup</groupId>
        <artifactId>javacup</artifactId>
    </exclusion>
</dependency>

And about Mondrian 4.0, I suppose it should be supported at lease theoretically, as Pivot4J does not depenend upon it directly.
It Olap4J supports it, then it should be fine. But I've never yet tested it before so things can go wrong.

However, I'm more than willing to assit you in this if you want to test it yourself. Supporting Mondrian 4.0 is important to me anyway, so I'm gald to have a real test case with you.

Please let me know it how it goes.

Thanks!

Xavier

2013년 8월 17일 토요일 오전 1시 56분 59초 UTC+9, jose...@gmail.com 님의 말:

[kelly...@gmail.com]

you can help me with pivot4J???
I need run from https://github.com/mysticfall/pivot4j.git... I can't...
problem in the pom..
I have install maven m2e

[mysticfall]

Hi,

Could you give me more details about the problem you are having with the POM?

Any error messages, stacktraces, or specific symptoms? I need more information to understand what has been gone wrong with your setup.

Thanks.

Xavier

2014년 1월 23일 목요일 오전 7시 48분 10초 UTC+9, kelly...@gmail.com 님의 말:

[kelly...@gmail.com]

Thank, Xavier.

the problem was that it was imported into eclipse. It imported in Netbeans and I could run the project. thank you very much. Now I'm watching the operation.

The error en eclipse:
pom.xml: Plugin execution not covered by lifecycle configuration: org.jacoco:jacoco-maven-plugin:0.6.4.201312101107:prepare-agent (execution: pre-test, phase: initialize)

org.eclipse.core.internal.resources.ResourceException: Resource '/pivot4j-analytics/target/generated-resources/xml/xslt/web.xml' does not exist.

[mysticfall]

Hi,

The message is an warning from the M2E plugin, which can be eliminated by following procedure ('Mark goal XXX as ignored...' line) described in our website :

• http://www.pivot4j.org/developer.html

As to the missing web.xml, you can just run "mvn verify" from the console first, then refresh your Eclipse project to generate it.

Please let me know if you need further assistance.

Thanks!

2014년 1월 24일 금요일 오전 5시 52분 2초 UTC+9, kelly...@gmail.com 님의 말:

[pcand...@gmail.com]

Hi,

I'm developing a spring mvc app with Pivot4J too.
My back-end is ok. I pass MDX and the server return me a table with results.
Now, I need the front-end, the client-side. The Pivot4J Analytics is a JSF module, I can't include in my project.
Can I develop my own client-side? Or it already exists?

If I have to develop, where do i start?

Thanks

[pcand...@gmail.com]

I read it on the FAQ:

"I don't want to write my own client from the scratch. Can I just customize the Pivot4J Analytics instead?

Believe me, writing your own client with the core API is not that much difficult at all![...]"

Well, I would like to develop my own client, using jquery and bootstrap. Unless already exists some client with those frameworks.

Can anybody help me?

[dodge...@gmail.com]

понедельник, 6 июля 2015 г., 15:28:57 UTC+3 пользователь pcand...@gmail.com написал:

Hi, I'm going to write own client too. Have you any progress?

[Paulo Candido]

No, I migrated to another tool. But tell me if you can

--

Paulo Cândido

[pto.r...@gmail.com]

> Paulo Cândido

Which tool did you migrate to?

[Paulo Candido]

I left Pivot4J, now I'm using a paid tool: GoodData

--
Pivot4J Project - http://mysticfall.github.com/pivot4j/
---
You received this message because you are subscribed to a topic in the Google Groups "pivot4j-list" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/pivot4j-list/eWFIbLQcfOk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to pivot4j-list...@googlegroups.com.
To post to this group, send email to pivot4...@googlegroups.com.
Visit this group at https://groups.google.com/group/pivot4j-list.
For more options, visit https://groups.google.com/d/optout.

--

Att,
Paulo Cândido

[amandu...@gmail.com]

Hi Xavier,
I am New to pivot4j when i am trying to run it i am getting this error can you please help me to solve it thank you

mondrian.olap.MondrianException: Mondrian Error:Internal error: Error while creating SQL connection: Jdbc=jdbc:derby:E:\SELF_LEARNING\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\pivot4j-analytics\WEB-INF\foodmart; JdbcUser=sa
at mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:987) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.olap.Util.newInternal(Util.java:2410) ~[mondrian-3.12.0.19-384.jar:3.12.0.19-384]
at mondrian.olap.Util.newError(Util.java:2426) ~[mondrian-3.12.0.19-384.jar:3.12.0.19-384]
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:247) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:188) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:216) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.rolap.RolapSchemaPool.createRolapSchema(RolapSchemaPool.java:294) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.rolap.RolapSchemaPool.getByKey(RolapSchemaPool.java:227) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:166) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.rolap.RolapSchemaPool.get(RolapSchemaPool.java:72) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:161) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:91) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.olap.DriverManager.getConnection(DriverManager.java:113) ~[mondrian-3.12.0.19-384.jar:3.12.0.19-384]
at mondrian.olap.DriverManager.getConnection(DriverManager.java:69) ~[mondrian-3.12.0.19-384.jar:3.12.0.19-384]
at mondrian.olap4j.MondrianOlap4jConnection.<init>(MondrianOlap4jConnection.java:162) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.olap4j.FactoryJdbc4Plus$AbstractConnection.<init>(FactoryJdbc4Plus.java:323) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.olap4j.FactoryJdbc41Impl$MondrianOlap4jConnectionJdbc41.<init>(FactoryJdbc41Impl.java:118) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.olap4j.FactoryJdbc41Impl.newConnection(FactoryJdbc41Impl.java:32) ~[mondrian-3.12.0.19-384.jar:?]
at mondrian.olap4j.MondrianOlap4jDriver.connect(MondrianOlap4jDriver.java:97) ~[mondrian-3.12.0.19-384.jar:?]
at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_131]
at java.sql.DriverManager.getConnection(DriverManager.java:208) ~[?:1.8.0_131]
at org.pivot4j.datasource.SimpleOlapDataSource.createConnection(SimpleOlapDataSource.java:75) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.datasource.AbstractOlapDataSource.getConnection(AbstractOlapDataSource.java:105) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.datasource.AbstractOlapDataSource.getConnection(AbstractOlapDataSource.java:95) ~[pivot4j-core-1.0-SNAPSHOT.jar:1.0-SNAPSHOT]
at org.pivot4j.analytics.datasource.simple.SimpleDataSourceManager.getCubes(SimpleDataSourceManager.java:124) ~[classes/:?]
at org.pivot4j.analytics.ui.CatalogChooser.getCubes(CatalogChooser.java:117) [classes/:?]
at org.pivot4j.analytics.ui.CatalogChooser.onCatalogChanged(CatalogChooser.java:152) [classes/:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_131]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_131]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_131]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_131]
at org.apache.el.parser.AstValue.invoke(AstValue.java:247) [jasper-el.jar:8.0.44]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:267) [jasper-el.jar:8.0.44]
at org.apache.myfaces.view.facelets.el.ContextAwareTagMethodExpression.invoke(ContextAwareTagMethodExpression.java:96) [myfaces-impl-2.2.3.jar:2.2.3]
at org.primefaces.behavior.ajax.AjaxBehaviorListenerImpl.processAjaxBehavior(AjaxBehaviorListenerImpl.java:54) [primefaces-5.3.jar:5.3]
at javax.faces.event.AjaxBehaviorEvent.processListener(AjaxBehaviorEvent.java:54) [myfaces-api-2.2.3.jar:2.2.3]
at javax.faces.component.behavior.BehaviorBase.broadcast(BehaviorBase.java:70) [myfaces-api-2.2.3.jar:2.2.3]
at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:415) [myfaces-api-2.2.3.jar:2.2.3]
at javax.faces.component.UIInput.broadcast(UIInput.java:359) [myfaces-api-2.2.3.jar:2.2.3]
at javax.faces.component.UIViewRoot._broadcastAll(UIViewRoot.java:1172) [myfaces-api-2.2.3.jar:2.2.3]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:365) [myfaces-api-2.2.3.jar:2.2.3]
at javax.faces.component.UIViewRoot._process(UIViewRoot.java:1656) [myfaces-api-2.2.3.jar:2.2.3]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:862) [myfaces-api-2.2.3.jar:2.2.3]
at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:42) [myfaces-impl-2.2.3.jar:2.2.3]
at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:196) [myfaces-impl-2.2.3.jar:2.2.3]
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:143) [myfaces-impl-2.2.3.jar:2.2.3]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) [myfaces-api-2.2.3.jar:2.2.3]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) [catalina.jar:8.0.44]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [catalina.jar:8.0.44]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) [tomcat-websocket.jar:8.0.44]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [catalina.jar:8.0.44]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [catalina.jar:8.0.44]
at org.apache.logging.log4j.web.Log4jServletFilter.doFilter(Log4jServletFilter.java:67) [log4j-web-2.0.2.jar:2.0.2]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) [catalina.jar:8.0.44]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) [catalina.jar:8.0.44]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) [catalina.jar:8.0.44]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94) [catalina.jar:8.0.44]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:504) [catalina.jar:8.0.44]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) [catalina.jar:8.0.44]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) [catalina.jar:8.0.44]
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) [catalina.jar:8.0.44]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) [catalina.jar:8.0.44]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502) [catalina.jar:8.0.44]
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132) [tomcat-coyote.jar:8.0.44]
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684) [tomcat-coyote.jar:8.0.44]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1533) [tomcat-coyote.jar:8.0.44]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1489) [tomcat-coyote.jar:8.0.44]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_131]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_131]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.0.44]
at java.lang.Thread.run(Thread.java:748) [?:1.8.0_131]
Caused by: java.sql.SQLException: Database 'E:\SELF_LEARNING\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\pivot4j-analytics\WEB-INF\foodmart' not found.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.Driver20.connect(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) ~[derby-10.10.2.0.jar:?]
at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_131]
at java.sql.DriverManager.getConnection(DriverManager.java:208) ~[?:1.8.0_131]
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:51) ~[commons-dbcp-1.2.1.jar:1.2.1]
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) ~[commons-dbcp-1.2.1.jar:1.2.1]
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188) ~[commons-pool-1.6.jar:1.6]
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) ~[commons-dbcp-1.2.1.jar:1.2.1]
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:227) ~[mondrian-3.12.0.19-384.jar:?]
... 67 more
Caused by: org.apache.derby.impl.jdbc.EmbedSQLException: Database 'E:\SELF_LEARNING\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\pivot4j-analytics\WEB-INF\foodmart' not found.
at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.handleDBNotFound(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.impl.jdbc.EmbedConnection40.<init>(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.Driver40.getNewEmbedConnection(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.Driver20.connect(Unknown Source) ~[derby-10.10.2.0.jar:?]
at org.apache.derby.jdbc.AutoloadedDriver.connect(Unknown Source) ~[derby-10.10.2.0.jar:?]
at java.sql.DriverManager.getConnection(DriverManager.java:664) ~[?:1.8.0_131]
at java.sql.DriverManager.getConnection(DriverManager.java:208) ~[?:1.8.0_131]
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:51) ~[commons-dbcp-1.2.1.jar:1.2.1]
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290) ~[commons-dbcp-1.2.1.jar:1.2.1]
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1188) ~[commons-pool-1.6.jar:1.6]
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) ~[commons-dbcp-1.2.1.jar:1.2.1]
at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:227) ~[mondrian-3.12.0.19-384.jar:?]
... 67 more

[Mike Banon]

Hi friend, I am not Xavier, but your problem looks obvious. Please
check your logs, there is a place:

Caused by: java.sql.SQLException: Database
'E:\SELF_LEARNING\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps\pivot4j-analytics\WEB-INF\foodmart'
not found.

Are you sure you have your foodmart database at this location? If yes,
what is its access rights? (maybe that app is opened by a user who
doesn't have the sufficient rights to access this database)

> --
> Pivot4J Project - http://mysticfall.github.com/pivot4j/
> ---

> You received this message because you are subscribed to the Google Groups "pivot4j-list" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to pivot4j-list...@googlegroups.com.