PAT 0.8 Released

[pstoellberger]

Hi PAT-fans,

for those of you who didn't notice, PAT 0.8 was released today!
New Features:

• New Query Design workflow
• Drill Up (opposite of Drill Replace)
• Major improvements of drill support
• Fix saving queries (especially on mondrian connections)
• Inline schema editor
• Re-Save queries
• Basic Role support
• Multiple Hierarchies

!!! Loading a saved query doesn't show the selections but you can execute the query anyway. And the Drag and Drop query design may still have a few issues. We know about it and will fix this as soon as possible !!!


You can access an online demo at our new server (donations are still welcome ;-)
Feedback is very welcome and needed. Please take some time to give us some feedback and/or file JIRA's!


You can download the following packages:


- PAT Standalone pre-configured server for Windows and Linux/Mac
Download, Extract, run start-patserver.bat / start-patserver.sh and access it via http://localhost:8080/


- PAT Standalone WAR
Just drop the WAR file into your favourite Java Webserver and access it via e.g: http://localhost:8080/pat-0.8/
PAT will use per default an in-memory HSQLDB for persistence, so if you restart its all gone.
You can change the settings in tomcat/webapps/pat-0.8/WEB-INF/pat.properties


- PAT Plugin (works with biserver 3.6)
Just download and extract the bundle into your pentaho-solutions/system folder
When you start up the User Console just look out for a blue cube icon :-)

- PAT User Guide
The user guide explains how to use and configure the pat-server and pat-plugin


For those of you who are interested in the bleeding edge versions of PAT, we have set up a continuous integration environment:
- CI PAT Standalone WAR
- CI PAT pre-configured server
- CI PAT plugin (without biserver)




Don't hesitate to contact us in case you need some further information, assistance with the download packages, or want to contribute!


Have fun!


-Paul

[pstoellberger]

P.S:
Feel free to post feedback in here as well!
What things do you like?
What do you think needs improvement?
.. We want to know everything!

[DBA_Alex]

Nice job guys - working on loading onto my Pentaho server now. Keep up the great work

[pstoellberger]

Thanks!
We'll do our best ;-)

[ndefontenay]

Hi.

I've downloaded PAT-0.8.war today and moved it to my tomcat webapps folder.
My problem is that it never ends deploying.

I get this with a blinking cursor at the end:

Oct 20, 2010 4:53:19 PM org.apache.catalina.core.AprLifecycleListener init
INFO: Loaded APR based Apache Tomcat Native library 1.1.20.
Oct 20, 2010 4:53:19 PM org.apache.catalina.core.AprLifecycleListener init
INFO: APR capabilities: IPv6 [true], sendfile [true], accept filters [false], ra
ndom [true].
Oct 20, 2010 4:53:19 PM org.apache.coyote.http11.Http11AprProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
Oct 20, 2010 4:53:19 PM org.apache.coyote.ajp.AjpAprProtocol init
INFO: Initializing Coyote AJP/1.3 on ajp-8009
Oct 20, 2010 4:53:19 PM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 701 ms
Oct 20, 2010 4:53:19 PM org.apache.catalina.core.StandardService startInternal
INFO: Starting service Catalina
Oct 20, 2010 4:53:19 PM org.apache.catalina.core.StandardEngine startInternal
INFO: Starting Servlet Engine: Apache Tomcat/7.0.2
Oct 20, 2010 4:53:19 PM org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive pat-0.8.war

If it can help, I can provide logs on request if I know what to look for.

[NoFxPT]

Hi there,

i am having some problems with the plugin as the Automatic Pentaho XMLA connection is not working.
"There has been an error regarding the Connection. Please contact the system administrator: It was not possible to establish a connection.

In tomcat i see a 401 error in the url http://127.0.0.1:8787/pentaho/Xmla. I guess it has to do with permissions? What is the correct username and password, i guess it should the be the admin username and password of pentaho, right?

Thanks for helping.

[NoFxPT]

Nobody?

[hansva]

well euhm PAT is kind off dead now it is saiku...
so what version of the bi-server are you using pat in ? it might be better to change to saiku because it's better supported and newer...

[NoFxPT]

Thanks for the reply, i could solve the situation creating a new connection.

About saiku i have installed it but doesnt have graphics display mode (pie, bars, etc)? PAT plugin had...

[NoFxPT]

Please answer...

[johanhammink]

Then you are not using the latest version. Saiku version 2.2 has also an graphical display

[NoFxPT]

I downloaded 2.1 from here... http://analytical-labs.com/

Where i can download 2.2?

[johanhammink]

You can download the latest version from: http://ci.analytical-labs.com/job/saiku-plugin/

[NoFxPT]

Thanks. The charts are being improved? The older ones had more interesting animations while loading.

[pstoellberger]

what animations?
2.2 should be released really soon... until then you can find our latest and greatest at http://ci.analytical-labs.com/job/saiku-server/

[nkander]

I'm very new to Pentaho so I'm not exactly sure what is Saiku? Is it an add-in to Pentaho?

[hansva]

it is an extra module for the pentaho BI-server OR a standalone server !
And it is very easy to add to the pentaho bi-server just download extract to the corect folders restart the server and it works !

[mbvt]

Yes it is. If you install (aka, copy) it into the BI server, you'll see (after restarting the server) a new type of document you can create. It's similar to the regular Analysis View, looks better, but is a bit more limited.
I don't know if you still need it after the BI Suite 4.0 release...

[crafter]

To add to hansva's explaination, Saiku allows you to provide OLAP analysis of data cubes. It used to be called PAT, and is a replacement for the JPivot tool that is shipped with the CE version of the bi-server.

[tfahland]

Ok, I installed Saiku as a plugin (version 2.2)

none of the charts are working, any ideas why not (the bar, line etc buttons show up) but it says it can't render the chart