Pentaho Community Forums

Using my own log4j configuration

send2dsr — Thu, 02 Sep 2010 13:38:46 GMT

Hello all,

I am using PDI for my project and I am running it from java application. As PDI is using its own logging configuration I wanted to over ride with my own log4j configuration. Any ideas would be appreciated.

Regards
Sri

[Mondrian] Extending Role interface

Luc Boudreau — Thu, 02 Sep 2010 13:34:39 GMT

Hello everyone,

I'm working on a case about Mondrian's Role implementation. The problem is
this. If you grant access to a SharedDimension in a CubeA, but not in CubeB,
the Role gets to access the Dimension even in CubeB because the Role
interface does not take into account the context into which the Dimension is
accessed. As a matter of fact, this impacts all children of a
SharedDimension (hierarchies, levels and members).

A discussion a while back on this list had concluded that the root of the
problem was due to Dimension.equals() implementation taking into account
only the name of the object. After evaluating the proposed fix, I concluded
that the performance impact is too great and will lead to many more problems
than it actually solves. The proposed fix would make the cache sizes
explode, because it would create a new cache for each DimensionUsage.
Actually, it won't solve the problem at all, because the dimension Java
object is indeed equal and thus leads the code to make faulty assumptions.
(see
http://forums.pentaho.com/showthread...ures-dimension.
)

But good news! There is a proper way to fix this. I propose to extend the
Role interface so that it takes into account the cube context into which the
access rights are evaluated. For example, the method...

Access getAccess(Dimension dimension);

....would become...

Access getAccess(Dimension dimension, Cube cube);

My first thought was to create new signatures alongside the existing ones,
but that would lead to security holes in the code. I would very much like to
fix this once and for all. Now, because this is part of the public API, I
would like to have some feedback on this. Do Mondrian developers use the
Role interface directly? Is there any foreseeable bad consequences to doing
this?

Also, I expect some serious code refactoring would occur. The context Cube
is not always readily available to all parts of the code which calls the
Role's access checkers. I will need to make sure that the context is
available for these checks. When Grants are created, we will need to specify
the context into which they are effective. etc.

There might be other solutions possible. I'd like to hear some ideas. IMO,
extending the Role interface is the "kosher" way of fixing this, because it
is at fault, but hey, I might be wrong.

Cheers!

_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Subtracting one minute form a datetime.

JohnMIII — Thu, 02 Sep 2010 13:33:15 GMT

Has any one tried to do date time arithmitic using the PDI objects. I did find in the calculator object that you can add time to a data time but not subtract minutes.
I also tried to use the user defined java expression, I got the getminute method to work but could not set the minutes..also I am not a java programmer so i could not find an example to work from....any help would be appreciated thanks.

Need Help with MDX

whitish — Thu, 02 Sep 2010 11:31:30 GMT

Hi all,

I have an issue with writing MDX with input parameters:
- date range
- pulisher name
I have wrote th enext one MDX:

Code:

WITH member [TimePeriods Degenerated].[AggregateDates]

AS 'Aggregate([TimePeriods Degenerated].[All Periods].[${date1}] : [TimePeriods Degenerated].[All Periods].[${date2}])'

SELECT

NON EMPTY { [Measures].[Q Impressions] } ON COLUMNS,

NON EMPTY (

 ( [Publisher].[All Publisher].[${paramPublisher}])

)

 ON ROWS FROM

[Ad Banners]

where ([TimePeriods Degenerated].[AggregateDates])

But the point is that I don't need to aggregate Date. Also I need to display in my table [TimePeriods Degenerated].[All Periods].Children } But when I add this to my MDX

Code:

WITH member [TimePeriods Degenerated].[AggregateDates]

AS 'Aggregate([TimePeriods Degenerated].[All Periods].[2008-09-22] : [TimePeriods Degenerated].[All Periods].[2009-09-22])'

select

NON EMPTY { [Measures].[Q Impressions] } ON COLUMNS,

NON EMPTY (

CrossJoin ( [Publisher].[All Publisher].[${paramPublisher}], { [TimePeriods Degenerated].[All Periods].Children })

)

 ON ROWS FROM

[Ad Banners]

where ([TimePeriods Degenerated].[AggregateDates])

I receive error:

Code:

Mondrian Error:Hierarchy '[TimePeriods Degenerated]' appears in more than one independent axis.

All that I need to display three fields in my report: Publisher, Timperiod, Q Impressions using two input parameters: "Date Range" and "Publisher"

Maybe someone have ideas how to achieve what I need, I m so appreciate for that!

Best Regards,
Alex

open flash chart is not drillable!!!

GianlucaF_exp — Thu, 02 Sep 2010 09:02:32 GMT

Hello ,in the creation of dashboards using the open flash I can not find a way to drill on a flash chart . I wanted to know if anyone has found a way to drill on open flash charts.
I also wanted to know if I can import new libraries open flash in Pentaho.
Thanks

Gianluca

to take input file name to excel input from previous step.

debadutta — Thu, 02 Sep 2010 08:40:52 GMT

Hi All,
I am using Pentaho 3.2.0.
I have a transformation like follows

Excel Input -> Table Output.

For automation I want to give the file path to the excel sheet dynamically. So, I try for the " Accept filenames from previous step " provided in the "Excel Input" . And
In the Previous step I use "Get data from XML". There I pass the file path like this.

F:\database\BI PROS\ess.xls

Now when I check on "Accept file names from Previous Step " and select the step as "Get Data from XML" from the drop down. But in "Field in the input to use as filename" I am struggling. I have no idea what to give in that field.

Please help me regarding this.

Thanks
Dev.

PDI 4.0.0 CE and different ways to connect to SAP?

00eisbaer — Thu, 02 Sep 2010 07:34:45 GMT

Hello everyone,

I just read an article about SAP Connectivity with Pentaho 4 CE (http://www.it-novum.com/news-list/bl...-tools-42.html). The article says, that there is more than one possibility to extract data from SAP with different Input Types.
Now i tried to design a transformation which connects to SAP and i only found the way via SAP Input (via Aschauer-EDV plugin). The article says, that there is another SAP Connector integrated named "ITN Connector ERP." I cannot find it, so i have to ask how to use this one?

Thanks in advance!

Mondrian OLAP Cube as Datasource. How to define parameter in Report?

whitish — Thu, 02 Sep 2010 07:27:03 GMT

Hi all,

I m trying to use my olap cube for reporting, but faced w/problem when defining report parameters. For example, I need define input parameter "Publisher".

It seems that I have problem in declaring parameter within the query:

Code:

SELECT



NON EMPTY { [Measures].[Q Impressions] } ON COLUMNS,

NON EMPTY (

CrossJoin ( [Publisher].[All Publisher].Children, { [TimePeriods Degenerated].[All Periods].Children })

)

 ON ROWS FROM

[Ad Banners] 

where 

(

strToMember(Parameter("paramPublisher", STRING, "[Publisher].[All Publisher].[NULL]"))

)

paramPublisher initialized by a simple sql (select publisher_name from...) and have type String.

Maybe someone have idea how can I declare this parameter and use in my report?

King Regards,
Alex.

How to truncate a table in pentaho

debadutta — Thu, 02 Sep 2010 04:29:21 GMT

Hi All,
I am using Pentaho 3.2.0.
I have a transformation

Table input ->Insert/Update.
I want to truncate the target table after table input. I think 'analytic quary' comes handy in this case. Please suggest me in this regarding.

Thanks
dev

Running transformation in Kettle 4.0 Carte

dhanisetti — Thu, 02 Sep 2010 01:46:19 GMT

Hi,

Can I run the same transformation more than once at a time in Kettle 4.0 version Carte?

Thanks,
Tata

Out Of Memory Issue in Carte

dhanisetti — Thu, 02 Sep 2010 01:42:32 GMT

Hi Everyone,

I have a requirement where i need to run set of transformations in parallel in Carte server. As Kettle 3.2.0 does not allow me run the same transformation more than once at a time, i am renaming the transformations and sending them to Carte server for exeution. After their execution, the transformations will be removed from Carte server. Everything is working fine but sometimes i am getting "java.lang.OutOfMemoryError: Java heap space" when carte is parsing .ktr files. Each of my .ktr files size is less than 10KB only. Does anyone have any idea what could be causing OOM?

Environment Details:
Kettle 3.2.0
jetty-6.1.9
Linux x86_64

Here is the stack trace:
2010-09-01 14:09:08.819::WARN: Error for /kettle/addTrans/
java.lang.OutOfMemoryError: Java heap space
at org.apache.xerces.dom.DeferredDocumentImpl.createC hunk(Unknown Source)
at org.apache.xerces.dom.DeferredDocumentImpl.ensureC apacity(Unknown Source)
at org.apache.xerces.dom.DeferredDocumentImpl.createN ode(Unknown Source)
at org.apache.xerces.dom.DeferredDocumentImpl.createD eferredTextNode(Unknown Source)
at org.apache.xerces.parsers.AbstractDOMParser.charac ters(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerI mpl.scanContent(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerI mpl$FragmentContentDispatcher.dispatch(Unknown Source)
at org.apache.xerces.impl.XMLDocumentFragmentScannerI mpl.scanDocument(Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse (Unknown Source)
at org.apache.xerces.parsers.XML11Configuration.parse (Unknown Source)
at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(U nknown Source)
at org.pentaho.di.core.xml.XMLHandler.loadXMLString(X MLHandler.java:583)
at org.pentaho.di.trans.TransConfiguration.fromXML(Tr ansConfiguration.java:64)
at org.pentaho.di.http://www.AddTransServlet.doGet(Add...ervlet.java:99)
at org.pentaho.di.http://www.AddTransServlet.doPut(Add...ervlet.java:57)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:730)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
at org.mortbay.jetty.servlet.ServletHolder.handle(Ser vletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler.handle(Se rvletHandler.java:362)
at org.mortbay.jetty.servlet.SessionHandler.handle(Se ssionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(Co ntextHandler.java:726)
at org.mortbay.jetty.handler.ContextHandlerCollection .handle(ContextHandlerCollection.java:206)
at org.mortbay.jetty.handler.HandlerCollection.handle (HandlerCollection.java:114)
at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha ndlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:324)
at org.mortbay.jetty.HttpConnection.handleRequest(Htt pConnection.java:505)
at org.mortbay.jetty.HttpConnection$RequestHandler.co ntent(HttpConnection.java:842)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:648)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa rser.java:211)
at org.mortbay.jetty.HttpConnection.handle(HttpConnec tion.java:380)
2010-09-01 14:14:50.01::WARN: Error for /kettle/addTrans/
java.lang.OutOfMemoryError: Java heap space
2010-09-01 14:14:50.000::WARN: Error for /kettle/addTrans/
java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOfRange(Unknown Source)
at java.lang.String.(Unknown Source)
at java.lang.StringBuilder.toString(Unknown Source)
at org.pentaho.di.http://www.AddTransServlet.doGet(Add...ervlet.java:99)
at org.pentaho.di.http://www.AddTransServlet.doPut(Add...ervlet.java:57)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:730)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)

Thanks in advance,
Tata

Can the BI Server be used to create PRPT files?

jgenoese — Thu, 02 Sep 2010 00:48:15 GMT

Greetings. I'm a Pentaho noob, and I'm creating a multi-tenancy application, wherein I'd like each customer to be able to create and execute reports while dynamically varying the output target. The desktop Designer app is undesirable in my case, because we don't want to assume any responsibility at all for customer infrastructure, so we will give them access to the BI Server as a report painter.

The difficulty I'm having is that the report artifacts prodused by the BI Server (xaction files) do not support output-targets.

Here's my question: Is it possible to have the BI server create PRPT bundles, seeing that they have the flexibility that I require?

Many thanks.

PRPT bundles and the BI Server

jgenoese — Thu, 02 Sep 2010 00:38:48 GMT

Greetings. I'm a Pentaho noob, and I'm creating a multi-tenancy application, wherein I'd like each customer to be able to create and execute reports with a flexible output target. Rather than having each customer deploy a desktop app, we decided that the BI Server is the ideal vehicle for permitting customers to create their own reports. However, we want those reports to be delivered "in context" i.e. while within the business application, not in BI Server. The business app will communicate with BI Server behind the scenes to deliver report content.

The difficulty I'm having is that the report artifacts (xaction files) created in the BI server do not support output-targets. Is it possible to have the BI server create PRPT bundles, as they have the flexibility that I require?

Ideas, anyone?

Javascript : Write the next date that met a condition in a previou row

psouto — Wed, 01 Sep 2010 17:48:20 GMT

Hi!
I'm trying to create a table that allows me to know for each article the date(s) where it happen a stock zero or negative and the next date with positive stock.

Imagine I have a table like this:

Date;Article;Stock
2008-09-03;a;55
2008-09-08;a;27
2008-09-12;a;11
2008-09-15;a;0
2008-09-18;a;-8
2008-09-21;a;5
2008-09-04;b;12
2008-09-07;b;-8

The final table should be like this:
Article;DateStockZeroOrNegative;NextDateStockPosit ive
a;2008-09-15;2008-09-21
b;2008-09-07;(Today() if not other positive stock date on the table);

I thought starting by:
-sort rows by product and date
-User Defined Java Expression to determine if is stockpositive: Long.valueOf(Stock>0?1:0)
What should be my next steps?

Thanks in advance.

PS) i'm not a native english speaker. My thread tittle maybe not describes correctly my doubt.

New forum formats are killing me

khelms — Wed, 01 Sep 2010 15:00:40 GMT

This is my first complaint: Gads the new format of the forum page is hard to get used to.

I'm on the verge of writing a transform to download the site contents so they can be browsed in a different format.

Ok - rant off.

OpenFlashChartComponent question

psapozhnikov — Wed, 01 Sep 2010 14:11:57 GMT

Hi

When the flash bar chart report is being render in Bi server to the left of it it puts

image-tag=

Is there a way to stop that.

Also is it possible to give full url to src="" of the flash itself the swf file? So instead of src="openflashchart..." do src="http://10.0.2.16:8100/pentaho/openflashchart..." Is this possible or no?

Thanks
Pavel

Filter rows to multiple steps (multiple conditions)

Mick_data — Wed, 01 Sep 2010 14:08:16 GMT

Hi.
At the moment using the Filter Row step is possible to use only one condition.
If a record satisfy that condition it goes to TRU, otherwise it goes to FALSE.

Is it possible to have a more complex filter which checks multiple condition and send records to multiple steps?
Example:
If month = january --> step 1.
If month = february --> step 2.
...
else --> step 13.

Can I achieve that somehow or do I need to use 11 Filter Row steps?
Thanks.
Mick

PDI 4.0: Total length of all fields of the input stream of a step in a transformation

RomanFischer — Wed, 01 Sep 2010 13:29:34 GMT

Hallo,

as an internal service provider we want to internaly "sell" our ETL activities to our departments using the total amount of data transfered to the target databases.

The simple thing I want to do is to use all the fields we send to the "Table Output"-steps in the "data stream" of a transformation, calculate the total length of these fields and sum these over all rows.

Of course I want to do this in a generic way, so that I have not to change the calculation every time a new field is added to the result.

Sadly I have no idea how to loop over all fields of the input stream in a javascript-step or in a "User Defined Java Class" (or anywhere else)?

Any hints?

Kind Regards

PDI Connection Latency on EC2

martins — Wed, 01 Sep 2010 11:47:51 GMT

Dear Forum members,

we are using PDI 4.0.0 together with Amazon EC2 and Amazon RDS.
The solution works perfectly, but there are huge connection latency when we are doing save and load operations from kettle_repo. We have to wait a couple of minutes for each save operation. Obviously this takes toll on our development time.

The kettle_repo is RDBMS. PDI is installed on the Amazon EC2 instance together with the BI server.

All other connections perform reasonably well, so we are trying to understand if there any specifics with PDI that need to be tuned.

Any ideas?

best regards

Martin Stangeland
http://www.conduct.no/bi

Sum of all selected elements

Planetzone — Wed, 01 Sep 2010 11:44:12 GMT

Hello, I want to get a sum of all selected elements of a dimension in my analysis.
It should be displayed like the "All" element of a dimension, which shows the sum of all elements, but it should consider my restrictions in the dimension.
Basically I want the sum of all displayed Measures in a column.
Is something like that possible with an MDX statement?

Thanks.
Regards
Sebastian

Pentaho User Group Italia proposal

sramazzina — Wed, 01 Sep 2010 10:21:58 GMT

Ciao a tutti,

mi sono fatto promotore di un'iniziativa per la formazione di un Pentaho User Group italiano. La proposta è stata fatta sull'omomnimo gruppo di linkedin (ecco il link http://tinyurl.com/39xl4uj). Vi aspetto numerosi con idee, commmenti, suggerimenti. Doug si è già reso disponibile ad aiutarci a fare partire il gruppo e questo è molto positivo.

Per chi non fosse presente sul social LinkedIn ecco il testo integrale del mio post:

Following the initiative of our colleagues from England I would like to copy this nice idea and propose the creation of a Pentaho Usergroup also in Italy. The italian section of Pentaho forum is a bit sleeping but I think there are a lot of people interested in sharing opinions, ideas, experiences or other things related to our preferred Open Source BI tool. The proposal could to to organize a website for our group and organize some meetings on a regular base using web collaboration tools or by person for a beer and stay together. Because this is for italian people I post the same also in italian and I suggest to answer in italian

---------------------------

Facendo seguito all'idea dei nostri amici e colleghi inglesi mi permetto di proporre, allo stesso modo, la formazione di uno Usergroup italiano su Pentaho. L'iniziativa mi sembra interessante e ritengo che nonostante la poca attività nel forum di Pentaho in lingua italiana ci sia un discreto numero di persone che sono interessate a conoscersi, scambiarsi idee, esperienze ed opinioni riguardanti il nostro tool di BI preferito. Potremmo approntare un sito web apposito per il nostro usergroup ed organizzare una serie di incontri con cadenza regolare sfruttando tool di collaborazione o incontrandoci di persona (spero sia maggiormentem percorribile questa opzione) per una birra o semplicemente stare insieme. Non so quanti di voi saranno a Lisbona ma un primo meeting potrebbe essere per illustrare agli assenti un resoconto della due giorni di incontro della community.

Ciao a tutti.

Report Designer: Japanese characters shown in HTML but not in PDF

Nicolas.Raoul — Wed, 01 Sep 2010 09:39:42 GMT

Hello all,

My report contains Japanese characters for series (Line Chart with one line for 渡辺, one line for 高橋, etc).
When I click "Run" to generate my report, I have the choice between PDF and various other formats:

PDF: Japanese characters are not shown.
HTML, XLS, RTF: Shown correctly

How to make Japanese characters (kanjis, kanas) visible in PDFs too?
Thanks!
Nicolas Raoul

Transformation "Fields to log" are not read correctly from the repository

mgimeno — Wed, 01 Sep 2010 08:52:58 GMT

I've created a transformation and I've defined the transformation "fields to log" for it.

After saving it when I open again the transformation the transformation "fields to log" are not loaded correctly :confused: (they are empty!!!)

This occurs only when the transformation is saved to a repository. If the transformation is saved to a XML file the "fields to log" are read correctly

It seems there is a bug in the transformation read process from the repository because the "fields to log" values are saved correctly in the database

(I'm using Kettle 4.0.1-stable, repository is stored in a MySQL database and kettle runs in windows XP)

Any help will be appreciated (we use intensively the logging feature in our development and this bug stop us to upgrade for this new version)

Thanks in advance
Manel Gimeno

problem with JPivot drill through on an XMLA cube under IBM Websphere WAS 6.1

jarodcanal — Wed, 01 Sep 2010 08:42:41 GMT

Hi,

I use a SQLSERVER (2005) cube published by IIS on localhost with XMLA (the cube data comes from "Adventure Works" data).
I deployed a basic JPivot web application under IBM Websphere WAS 6.1 (6.1.0.29 without webservices feature packs), using Mondrian 3.2.0.13661 release as a base.
For testing purpose, cube access is not authenticated; so far everything is working, I can realize cube queries with Jpivot and see the result on screen (charts, PDF and Excel exportation,... are also working).

But when I try to activate the "drill through" option, I got the following error in the "Drill Through Table" component on screen:
An error occured
java.lang.ClassCastException: com.ibm.ws.webservices.engine.xmlsoap.SOAPElement incompatible with javax.xml.soap.Text

Any help on this?
Thanks in advance.

I reported the bug on JIRA:
http://jira.pentaho.com/browse/MONDRIAN-798

I attach my web.xml to this post.

A more detailed log of the problem from the System.out:

Code:

1/09/10 10:33:23:083 CEST] 00000023 SystemOut     O [JPivot] 01 sep 2010 10:33:23,083 ERROR [Session FUAXkeyYERPkzqnfSBPtjRh] com.tonbeller.jpivot.xmla.XMLA_DrillThroughTableModel#executeQuery: ?

java.lang.ClassCastException: com.ibm.ws.webservices.engine.xmlsoap.SOAPElement incompatible with javax.xml.soap.Text

    at com.tonbeller.jpivot.xmla.XMLA_SOAP.executeDrillQuery(XMLA_SOAP.java:1143)

    at com.tonbeller.jpivot.xmla.XMLA_Result.(XMLA_Result.java:61)

    at com.tonbeller.jpivot.xmla.XMLA_Model.getDrillResult(XMLA_Model.java:254)

    at com.tonbeller.jpivot.xmla.XMLA_DrillThroughTableModel.executeQuery(XMLA_DrillThroughTableModel.java:207)

    at com.tonbeller.jpivot.xmla.XMLA_DrillThroughTableModel.getColumnCount(XMLA_DrillThroughTableModel.java:105)

    at com.tonbeller.wcf.table.TableComponent.setModel(TableComponent.java:224)

    at com.tonbeller.wcf.table.EditableTableComponent.setModel(EditableTableComponent.java:235)

    at com.tonbeller.jpivot.table.navi.DrillThroughUI$DrillThroughHandler.request(DrillThroughUI.java:123)

    at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167)

    at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167)

    at com.tonbeller.wcf.component.ComponentSupport.request(ComponentSupport.java:104)

    at com.tonbeller.jpivot.table.TableComponent.request(TableComponent.java:181)

    at com.tonbeller.wcf.controller.WcfController.request(WcfController.java:71)

    at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:119)

    at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)

    at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)

    at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)

    at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)

    at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)

    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:837)

    at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:680)

    at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:588)

    at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:525)

    at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:122)

    at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:232)

    at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)

    at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:751)

    at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1478)

    at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:126)

    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)

    at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)

    at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)

    at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

    at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

    at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

    at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

    at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)

    at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)

    at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)

    at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

[1/09/10 10:33:23:068 CEST] 00000023 SystemErr     R java.lang.ClassCastException: com.ibm.ws.webservices.engine.xmlsoap.SOAPElement incompatible with javax.xml.soap.Text

[1/09/10 10:33:23:068 CEST] 00000023 SystemErr     R     at com.tonbeller.jpivot.xmla.XMLA_SOAP.executeDrillQuery(XMLA_SOAP.java:1143)

[1/09/10 10:33:23:068 CEST] 00000023 SystemErr     R     at com.tonbeller.jpivot.xmla.XMLA_Result.(XMLA_Result.java:61)

[1/09/10 10:33:23:068 CEST] 00000023 SystemErr     R     at com.tonbeller.jpivot.xmla.XMLA_Model.getDrillResult(XMLA_Model.java:254)

[1/09/10 10:33:23:068 CEST] 00000023 SystemErr     R     at com.tonbeller.jpivot.xmla.XMLA_DrillThroughTableModel.executeQuery(XMLA_DrillThroughTableModel.java:207)

[1/09/10 10:33:23:068 CEST] 00000023 SystemErr     R     at com.tonbeller.jpivot.xmla.XMLA_DrillThroughTableModel.getColumnCount(XMLA_DrillThroughTableModel.java:105)

[1/09/10 10:33:23:068 CEST] 00000023 SystemErr     R     at com.tonbeller.wcf.table.TableComponent.setModel(TableComponent.java:224)

[1/09/10 10:33:23:068 CEST] 00000023 SystemErr     R     at com.tonbeller.wcf.table.EditableTableComponent.setModel(EditableTableComponent.java:235)

[1/09/10 10:33:23:068 CEST] 00000023 SystemErr     R     at com.tonbeller.jpivot.table.navi.DrillThroughUI$DrillThroughHandler.request(DrillThroughUI.java:123)

[1/09/10 10:33:23:068 CEST] 00000023 SystemErr     R     at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.tonbeller.wcf.controller.DispatcherSupport.request(DispatcherSupport.java:167)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.tonbeller.wcf.component.ComponentSupport.request(ComponentSupport.java:104)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.tonbeller.jpivot.table.TableComponent.request(TableComponent.java:181)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.tonbeller.wcf.controller.WcfController.request(WcfController.java:71)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:119)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:263)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:837)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:680)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:588)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:525)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:122)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:232)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:751)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1478)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:126)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)

[1/09/10 10:33:23:083 CEST] 00000023 SystemErr     R     at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

This is the JSP I am using for testing.

Code:



<%@page language="java" contentType="text/html; charset=ISO-8859-1"

    pageEncoding="ISO-8859-1"%>



<%@ taglib uri="http://www.tonbeller.com/jpivot" prefix="jp"%>

<%@ taglib uri="http://www.tonbeller.com/wcf" prefix="wcf"%>

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>







prueba de consulta de cubo SQLSERVER 2005 en local por<br />
XMLA






















    uri="http://localhost/olap/msmdpump.dll"

    catalog="Proyecto de Analysis Services1">

        select {[Fact Internet Sales].[Fact Internet Sales]} on columns,

        {[Dim Customer].[Dim Customer]} on rows

        from [Adventure Works DW]














    id="navi01" query="#{query01}" visible="false" />






    model="#{query01}" visible="false" />






















    id="toolbar01" bundle="com.tonbeller.jpivot.toolbar.resources">


        model="#{navi01.visible}" />


        img="mdx-edit" model="#{mdxedit01.visible}" />












































    ref="toolbar01" xslUri="/WEB-INF/jpivot/toolbar/htoolbar.xsl"

    xslCache="true" />






    xslUri="/WEB-INF/jpivot/navi/navigator.xsl" xslCache="true" />




    ref="mdxedit01" xslUri="/WEB-INF/wcf/wcf.xsl" xslCache="true" />



<%-- sort properties --%>





<%-- chart properties --%>





<%-- print properties --%>








    ref="table01" xslUri="/WEB-INF/jpivot/table/mdxtable.xsl"

    xslCache="true" />


    xslUri="/WEB-INF/jpivot/table/mdxslicer.xsl" xslCache="true" />

Regards

Attached Files

web.xml (2.1 KB)

Connecting to Oracle (OCI) with PDI 4.0.x by replacing spoon.bat with one from 3.2.0

RowanC — Wed, 01 Sep 2010 08:00:11 GMT

Hi All,

I've had a whole bunch of trouble connecting to my oracle db via OCI in 4.0.x I've tried looking at classpaths, environment variables (ORACLE_HOME, PATH) and looking at everything I could understand in the spoon.bat file (where I felt like the problem was).

In the end, I gave up, and figured that since everything worked fine in 3.2.0, but doesn't in 4.0, perhaps the batch file might be interchangeable (the final command looks similar).

IT WORKED!!!! and finally, I can connect to my DB in V4.

My question is, shoud I file this as a bug, and if so, how? I seem to be having trouble finding a simple how-to guide for relative newbies (like me, but perhaps this is because newbies shouldn't be filing bugs?)

This is the same problem that I was following in post here

Help & feedback is always appreciated.
Cheers,
Rowan.

Analysis view not generated using PDI 4(Agile BI)

dhaneshmkumar — Wed, 01 Sep 2010 06:50:18 GMT

Hi all,

I am using PDI 4(Agile BI) on a windows platform.

When I right click on "table output" and select visualize>>Analyzer , I am getting the following error stack,

"Network Error (tcp_error)

A communication error occurred: "" The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests. You may wish to try again at a later time.
For assistance, contact your network support team."

Report Wizard is working properly. I guess its related some issue with my mozilla firefox browser.

I noted the same error when I try to run an xaction from PDS.

Can anyone help me out in this? Hoping for positive response,

Thanks & Regards,
Dhanesh

Problem in remote access of pentaho server running on Tomcat

siladityadash — Wed, 01 Sep 2010 06:30:31 GMT

Hi,

We are using pentaho 3.6 on linux. To access the server remotely we modified some of the files which blocked the adhoc report to work properly. These are the modifications which I did in tomcat server.

1. Modified the web.xml file located at "/opt/pentaho/server/biserver-ee/tomcat/webapps/pentaho/WEB-INF"

Before:-

base-url

http://localhost:80/pentaho/

Proxy Trusting Filter

org.pentaho.platform.web.http.filters.ProxyT rustingFilter

TrustedIpAddrs

127.0.0.1

Comma separated list of IP addresses of a trusted hosts.

After:-

base-url

http://172.16.0.116:80/pentaho/

Proxy Trusting Filter

org.pentaho.platform.web.http.filters.ProxyT rustingFilter

TrustedIpAddrs

127.0.0.1,172.16.0.116

Comma separated list of IP addresses of a trusted hosts.

2. Modified the server.xml located at "/opt/pentaho/server/biserver-ee/tomcat/conf"

Before:-

maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" />

After:-

maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
connectionTimeout="20000" disableUploadTimeout="true" />

After doing all of these changes when we try to access the adhoc report its giving some javascript error like

QueryInterface: function QueryInterface() {
[native code]
}
message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [nsIXMLHttpRequest.send]
result: 2147500037
name: NS_ERROR_FAILURE
filename: http://172.16.0.116:8080/pentaho/js/pentaho-ajax.js
lineNumber: 246
columnNumber: 0
inner: null
data: null
initialize: function initialize() {
[native code]
}

So can someone tell me what are the steps I have to follow if i need to access the tomcat server remotely. Before writing this mail i gone through the customer portal also "http://kb.pentaho.com/kb/". But that has not contains all of the steps.

How to create a cumulative chart?

Nicolas.Raoul — Wed, 01 Sep 2010 05:13:31 GMT

I want to create a chart of cumulated sales like the one below.
What is the best tool to create such a chart?

Report Designer?
Analyzer Report?
Analysis View?

Attachment 6026

The data is available both from the Pentaho Analysis (typical sales OLAP cube), or if necessary as raw MySQL, one line per sale.

I tried with Report Designer and finally managed to create this non-cumulative chart from the cube:

Attachment 6027

How can I make it cumulative, displaying for each day the total sales up to this day?
I tried to figure out how to use the "Sum (Running)" function, but I can't find any documentation on Google...

How would you use to produce such a graph?
Thanks a lot!
Nicolas Raoul

Attached Images

cumulative-sales.png (14.8 KB)
sales.png (14.2 KB)

Customizing Emails Sent Via Pentaho

PriyankaP — Wed, 01 Sep 2010 05:07:31 GMT

Hi,

I am scheduling reports and sending them in email as xsl attachment. While subscribing I've been given to enter the email subject as 'Report Name'. But in the email I also get the following message "This message was automatically generated by a subscription from the Pentaho BI server."

I want to customize the email content..

I am using Biserver 3.6

Please can anyone help.

Need a help with xml structure

agungb — Wed, 01 Sep 2010 02:30:01 GMT

Cargar múltiples archivos planos.

carlosj — Tue, 31 Aug 2010 19:24:52 GMT

Buenas tardes para todos, he estado trabajando con la integración de datos desde hace poco y encuentro un inconveniente el cual no me ha dejado progresar con la carga de los archivos a una bdd.

En la compañía donde trabajo se cargan constantemente archivos planos para actualizar las bases de datos, es extremadamente complejo implementar un sistema para actualizar desde una bdd a la otra, por este motivo se implementó el sistema de archivos planos, en total son cerca de 40 archivos con extensión .txt de diferentes tamaños y en total generan algo mas de 5 millones de registros.

He podido crear la lectura de los archivos y sus respectivos registros, todo esto gracias a un comodín que me permite hacer esto fácilmente en la carpeta donde son almacenados (este es el comodín por si alguna persona se le presenta el caso de leer multiples archivos de una misma carpeta. ".*\.txt"), pero a la hora de cargarlos únicamente me carga a la base de datos un bloque igual al "tamaño de la transacción (commit)" que hay en el proceso de salida a la tabla (he probado en access, mysql y postgres), si pongo en este campo un valor muy grande, se queda bloqueado el proceso.

La pregunta concreta es.

Que procedimiento se debe implementar, o que corrección sobre el proceso ya sea de entrada o de salida, de tal forma que pueda cargar todos los registros de todos los archivos en un solo paso?

muchas gracias de antemano a las respuestas que me den orientación o solución al inconveniente.

Simple Issue - But it driving me nutts

pavelcc — Tue, 31 Aug 2010 19:04:53 GMT

When I drag and drop any element to the details area I want them to stick to each other.
But they are not! I wonder why and how can I make them to stick to each other?
Sometime they do get stick to each other by default.

So, my final question is how can I take the control and handle it the way I want to?

Please shed some lights on it. If you have any question let me know. Thank you.

PAC using anonymousUser to connect to bi-server-ce

dataguy12 — Tue, 31 Aug 2010 18:27:47 GMT

Hi all,

If I configure the console.xml thusly:

joe

Shouldn't I see joe in this bi-server-ce output?

Code:

2010-08-31 13:23:18,064 DEBUG [org.springframework.security.intercept.AbstractSecurityInterceptor] Previously Authenticated:

org.springframework.security.providers.anonymous.AnonymousAuthenticationToken@bb64

3639: Principal: anonymousUser; Password: [PROTECTED]; Authenticated: true; Details: 

org.springframework.security.ui.WebAuthenticationDetails@ffff8868: RemoteIpAddress: 

192.168.1.41; SessionId: 00BC137EDAA1A03AA88624A9896C69BC; Granted Authorities: 

Anonymous

Instead I keep seeing Anonymous no matter what username I provided.

Second but related question, how do I tell PAC that the authentication has been switched from DAO to LDAP?

Thanks!

Problem with Switch\Case and Filter Rows

saket — Tue, 31 Aug 2010 17:58:32 GMT

Hi,

I am using a PDI 4.0.0-stable Build Date: 2010-06-15 11.00.26

I am writing a very complex and big transformation in which I have lot of branches. The problem that I am facing right now is that Switch\Case and Filter Rows are not behaving as expected.

Based on a condition I am setting a variable FLAG to either Y or N in java script step. After that I have a Switch\Case dependant on FLAG. If the value is Y I want it to go one route and if the value is N I want it to go another route, but even though the value of FLAG is Y PDI always executes the N route. I have verified the value of FLAG by writting to a text file and it is Y.

I replaced the switch\case with filter row step with true and false pointing to two different branches. This way it worked at times and did not worked other times. It became more unpredictable.

Can any body suggest any thing? I will really appreciate a quick response.

Regards,
Saket Maheshwary

Manipulating Excel File (VBA Execution?)

acovato — Tue, 31 Aug 2010 16:01:47 GMT

Hi all,

I'm wondering if anyone knows of a way to execute VBA (or perhaps do something else) to manipulate an Excel file? Unfortunately, the file I need to work with is not a standard flat file and requires me to delete blocks of rows/columns, shift things around, etc. The only way I can think of to do this is through VBA...

Any help on this would be appreciated!

Thanks so much in advance,

AC

Aggregate Formula into group footer

flotho — Tue, 31 Aug 2010 15:21:04 GMT

Dear all of you,

I wrote here after IRC. I have the following problem.
The SUM function put into a message field into the group footer doesn't work.
I use the following report :
http://opensource.tdeo.fr/kipigo/Consommation_VEH.prpt

The SUM quotient percent has a really strange behavior. Actually if I didn't precise a reset group, the value computed is the one for all the set of records. I have the same result if I choose the first group.
see there on the left bottom : http://opensource.tdeo.fr/kipigo/report_whithout_reset_on_name_WRONG_VALUE.pdf

Unfortunately, if I precise the second group I have now a value that is impossible :
http://opensource.tdeo.fr/kipigo/report_with_reset_on_name_WRONG_VALUE.pdf

Thanks a lot for your help

error while trying to publish a schema

mayomayin — Tue, 31 Aug 2010 14:55:43 GMT

Hi all

I'm making a cube in a schema using schema workbench, it worked fine when i make a MDX query on it, so i want to publish it, but it throws an error:
Publish failed, please see server logs for further details

And this is the server log

31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_144, sys_idx_82]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.GRANTED_AUTHORITIES
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [authority, username]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fk7471775dd9edc77f, fk7471775d41b6da97]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_136, sys_idx_52, sys_idx_50]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.LNGPARAMS
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [paramkey, itemid, paramvalue]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fke304fccbfa34bfdc]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_84, sys_idx_146]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.LSPARAMS
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [paramkey, itemid, paramvalue]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fk89bc75cdfa34bfdc]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_86, sys_idx_148]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.PARAMTYPESMAP
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [paramkey, itemid, paramvalue]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fkd3eda1b0fa34bfdc]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_88, sys_idx_150]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.PRO_ACLS_LIST
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [acl_position, recip_type, acl_mask, recipient, acl_id]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fkb65646c2b23c5d30]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_152, sys_idx_90]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.PRO_FILES
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [revision, directory, child_id, file_id, data, lastmodified, filename, parent, fullpath]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fk94a87e25cbbbb0ea, fk94a87e2569fabf5e]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_92, sys_idx_sys_ct_90_94, sys_idx_97, sys_idx_95]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.PRO_SCHEDULE
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [scheddesc, revision, startdate, scheduleid, schedtitle, last_trigger, repeatinterval, groupname, enddate
, repeatcount, cronstring, schedref]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: []
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_99]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.PRO_SUBCONTENT
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [revision, subcontid, subcontactref, subconttype]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: []
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_101, sys_idx_sys_ct_96_103]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.PRO_SUBCONTPARMS
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [paramkey, itemid, paramvalue]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fkf3ce4c47846761a]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_106, sys_idx_104]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.PRO_SUBCONT_SCHEDLIST
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [scheduleid, schedid, elt]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fkf0d3fbd69e226721, fkf0d3fbd62593bc9e]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_108, sys_idx_112, sys_idx_110]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.PRO_SUBSCRIBE
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [subscrid, subscrtitle, subscruser, revision, subscrdest, subscrtype, subscr_contid]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fk5e7511f89d8ac376]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_114, sys_idx_116]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.PRO_SUBSCRPARMS
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [paramkey, itemid, paramvalue]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fk95dade9355dc7de8]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_118, sys_idx_120]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.PRO_SUBS_SCHEDLIST
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [scheduleid, schedid, elt]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fk2a8c749b7329c46c, fk2a8c749b9e226721]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_126, sys_idx_122, sys_idx_124]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.RTELEMENT
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [revision, created, solnid, parid, partype, readonly, instanceid]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: []
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_128]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.SSPARAMS
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [paramkey, itemid, paramvalue]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: [fk60e4afe6fa34bfdc]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_130, sys_idx_132]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.USERS
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [enabled, username, description, password]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: []
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_54]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: table found: PUBLIC.USER_SETTINGS
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: columns: [username, setting_value, user_settings_id, setting_name]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: foreign keys: []
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.TableMetadata
INFO: indexes: [sys_idx_134]
31-08-2010 10:36:07 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute
INFO: schema update complete
31-08-2010 10:36:07 AM org.hibernate.cache.UpdateTimestampsCache
INFO: starting update timestamps cache at region: org.hibernate.cache.UpdateTimestampsCache
31-08-2010 10:36:07 AM org.hibernate.cache.EhCacheProvider buildCache
ADVERTENCIA: Could not find configuration [org.hibernate.cache.UpdateTimestampsCache]; using defaults.
31-08-2010 10:36:07 AM org.hibernate.cache.StandardQueryCache
INFO: starting query cache at region: org.hibernate.cache.StandardQueryCache
31-08-2010 10:36:07 AM org.hibernate.cache.EhCacheProvider buildCache
ADVERTENCIA: Could not find configuration [org.hibernate.cache.StandardQueryCache]; using defaults.

I really don't understand what is the error or wath i'm doing wrong
Can you help me, please??

The JDNI DataSource is configured fine... i think so

Auto-generated keys

yfontes — Tue, 31 Aug 2010 14:05:56 GMT

Hello,

Forgive me if it is a silly question.

I have a file stream wich I get the follow collums:

Field1, Field2, Field3, Field4

Then I'd like to normalize it in the database such this:

Table_A: IdA (auto), Field1, Field2;
Table_B: IdB (auto), IdA, Field3, Field4;

My transfomration steps:
Text file input > Select values > Table Output -Table_A (with "return autogenerated key" checked)

And now I'm stuck. How can I get genereted IdA + Field3 and Field4 from inicial stream
and save them to another output table (Table_B)?

Thanks,
Yuri.

java.sql.SQLException: invalid schema name

scomed — Tue, 31 Aug 2010 13:46:01 GMT

Hi,
I’m evaluating the trial version, but I have a problem:
-I build a simple Mondrian schema with Schema Workbench tool, connecting on a oracle 10g database with this options:

Driver class name: oracle.jdbc.driver.OracleDriver
Connection URL: jdbc:oracle:thin:@(description=(address=(host=172. 16.0.127) (protocol=tcp) (port=1521)) (connect_data=(sid=STAT3)))
Username: IRIS
Password: IRIS
Schema:
Require schema attributes:

-I try to execute the mdx query “select {[Dimensione Cliente]} on rows, {[New Measure IMPEURO]} on columns from [Cube IRMA 1]” into schema workbench with success
-I publish the schema on pentaho with success
-I try to create an analyzer report with pentaho, I select my new schema and cube, then the wizard is displayed
-if I drag a filed into the table I get this error:
java.sql.SQLException: invalid schema name: IRIS in statement [select "DWH_DIM_CLIFOR"."CODCLIFOR" as "c0" from "IRIS"."DWH_DIM_CLIFOR"]

If I copy and paste into a oracle sql editor the query [select "DWH_DIM_CLIFOR"."CODCLIFOR" as "c0" from "IRIS"."DWH_DIM_CLIFOR"] is executed with success.

What can I do?

Thanks.

Parameter function does not work for mdx query

Claus80 — Tue, 31 Aug 2010 13:44:37 GMT

Hi,

I created a report that use an mdx query.

The mdx query is parameterized but the Parameter function does not work properly.
I followed the link http://diethardsteiner.blogspot.com/...37969087064266 in order to set the parameter value properly.

The mdx query is the following:
WITH MEMBER [DateType].[Result] AS
Aggregate(
LastPeriods(12,Parameter('datePar', [DateType], [DateType].[All Dates].[2010].[2].[4]))
)
MEMBER [DateType].[PreviousYear] AS
Aggregate(
LastPeriods(12, [DateType].[2009].[2].[4])
)
SELECT
{[DateType].[Result],[DateType].[PreviousYear]} ON COLUMNS,
[FlightType].members ON ROWS
FROM
[Volumes]
WHERE
[Measures].[Passengers]

Whatever value i set for the 'datePar' parameter, always the default value is used.
If i use the notation ${datePar} a value is generated.

Actually, PRD does not work properly.

Thanks in advance,

Claus

Analytic View / Analytic Report

aGoram — Tue, 31 Aug 2010 13:43:18 GMT

Hi,

Is is possible to create an Analytic view, based on a already created Analytic Report (exemple: 3 fields out of 10 and 1 filter on employees country)

Problem while scheduling my report :(

hanihh — Tue, 31 Aug 2010 13:01:16 GMT

Hello there,
I'm facing a problem while trying to schedule my report.
What I did was right click on the report and choose schedule and then fill the fields like the attached snapshot.
an ambigous error occured
I saw the log file but no new intry on it

I tried to make a schedule from PAC, it succeded but no result in PUC...
Attachment 6023

Attached Images

Screenshot.jpg (29.0 KB)

Publish Cube from Metadata Editor

mondrian_newbie — Tue, 31 Aug 2010 12:17:12 GMT

Hello All,
We have created a cube using the Pentaho Metadata Editor and used the "Publish to Server" option. But when we checked the Pentaho Analyzer Report , the cube was not being displayed there.

Any suggestions in this regard would be helpful.

Thank You.

Regards,
mondrian_newbie
..

Store Uploaded files into database

rishi — Tue, 31 Aug 2010 12:16:59 GMT

Hi,

I have a requirement to store the uploaded files which may be - a dbase file / excel file etc... into database.

If any one knows how to integrate Pentaho with java (web application) to accomplish this task, do let me know.

It would be helpful, if a link to documentation concerning this can be provided.

Thanks in advance.

Print via PDF (encoding problem)

mszczepaniak — Tue, 31 Aug 2010 11:55:51 GMT

Hello

When I want print my "analysis view" via PDF I've wrong national chars encoding (check attach) - ###, with XLS everythink it's ok.

Could you help me, how resolve this issue ? What is wrong ?

Anyone ?

Regards,
Michael

Attached Images

wrongEncoding.jpg (30.4 KB)

Delete Multiple Files

Mick_data — Tue, 31 Aug 2010 10:49:16 GMT

Hi.
I use "Delete Files" step in a job to delete multiple text files.
My settings are:
File/Folder: C:\Work\\04Consolidate\August
Wildcard (RegExp): *\.txt
----
2010/08/31 11:37:16 - Version checker - OK
2010/08/31 11:39:39 - Spoon - Spoon
2010/08/31 11:39:59 - Spoon - Save as...
2010/08/31 11:39:59 - Spoon - Save file as...
2010/08/31 11:40:05 - Spoon - Starting job...
2010/08/31 11:40:05 - test - Start of job execution
2010/08/31 11:40:05 - test - exec(0, 0, START.0)
2010/08/31 11:40:05 - START - Starting job entry
2010/08/31 11:40:05 - test - Starting entry [Delete files 2]
2010/08/31 11:40:05 - test - exec(1, 0, Delete files 2.0)
2010/08/31 11:40:05 - Delete files 2 - Starting job entry
2010/08/31 11:40:05 - Delete files 2 - Processing argument [C:\Work\\04Consolidate\August].. wildcard [*\.txt] ?
2010/08/31 11:40:05 - Delete files 2 - Processing folder [C:\Work\\04Consolidate\August]
2010/08/31 11:40:05 - Delete files 2 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error
2010/08/31 11:40:05 - Delete files 2 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error
2010/08/31 11:40:05 - Delete files 2 - Total deleted files = 0
2010/08/31 11:40:05 - Delete files 2 - Processing argument [C:\Work\\03OutText\August].. wildcard [*\.txt] ?
2010/08/31 11:40:05 - Delete files 2 - Processing folder [C:\Work\\03OutText\August]
2010/08/31 11:40:05 - Delete files 2 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error
2010/08/31 11:40:05 - Delete files 2 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error
2010/08/31 11:40:05 - Delete files 2 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error
2010/08/31 11:40:05 - Delete files 2 - Total deleted files = 0
2010/08/31 11:40:05 - Delete files 2 - Processing argument [C:\Work\\02Filter\August].. wildcard [*.\txt] ?
2010/08/31 11:40:05 - Delete files 2 - Processing folder [C:\Work\\02Filter\August]
2010/08/31 11:40:05 - Delete files 2 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error
2010/08/31 11:40:05 - Delete files 2 - Total deleted files = 0
2010/08/31 11:40:05 - Delete files 2 - Processing argument [C:\Work\\01InText\August].. wildcard [*.\txt] ?
2010/08/31 11:40:05 - Delete files 2 - Processing folder [C:\Work\\01InText\August]
2010/08/31 11:40:06 - Delete files 2 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error
2010/08/31 11:40:06 - Delete files 2 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error
.....
2010/08/31 11:40:07 - Delete files 2 - ERROR (version 4.0.1-stable, build 13826 from 2010-08-26 14.18.03 by buildguy) : Error
2010/08/31 11:40:07 - Delete files 2 - Total deleted files = 0
2010/08/31 11:40:07 - test - Starting entry [Success]
2010/08/31 11:40:07 - test - exec(2, 0, Success.0)
2010/08/31 11:40:07 - Success - Starting job entry
2010/08/31 11:40:07 - test - Finished job entry [Success] (result=[true])
2010/08/31 11:40:07 - test - Finished job entry [Delete files 2] (result=[true])
2010/08/31 11:40:07 - test - Job execution finished
2010/08/31 11:40:07 - Spoon - Job has ended.
2010/08/31 11:41:16 - Spoon - Spoon
2010/08/31 11:42:51 - Spoon - Spoon
2010/08/31 11:43:14 - Spoon - Spoon
-----------------------------------------
Regarding this Job, another question:
no files have been deleted, so why the Job entry is classified as Success??

Thanks.
Mick

Action Sequence (Xaction) execution for PDI Job fails

axelb — Tue, 31 Aug 2010 10:33:52 GMT

Hi,

I created with Design Studio an action sequence to execute a Kettle job, but it fails and I don't see what I'm doing wrong. In fact, I reduced the job only to a couple of steps, just Start and Success. But the error is still there:

Pentaho BI Platform - Error in Action Failed [es_161] Error: SolutionEngine.ERROR_0007 - [es_27] Action sequence execution failed (org.pentaho.platform.engine.services.solution.Sol utionEngine) [es_116] Debug: [es_21] Starting execute of Prinex-BPC Reloaded//Prueba.xaction (org.pentaho.platform.engine.services.solution.Sol utionEngine)
[es_116] Debug: [es_30] Getting runtime context and data (org.pentaho.platform.engine.services.solution.Sol utionEngine)
[es_116] Debug: [es_33] Loading action sequence definition file (org.pentaho.platform.engine.services.solution.Sol utionEngine)
[es_161] Error: SolutionEngine.ERROR_0007 - [es_27] Action sequence execution failed (org.pentaho.platform.engine.services.solution.Sol utionEngine)

Server Version: Pentaho Platform Engine Core 3.5.2.stable.41050

The container is under pentaho-solutions directory and other xactions work fine.

As you can see, the process is very simple. No inputs or outputs.

Attachment 6020

Any idea ?

Thanks

Attached Images

2010-08-31_123339.jpg (28.1 KB)

Problem with date_trunc() in TimeDimension

whitish — Tue, 31 Aug 2010 10:26:30 GMT

Hi all,

I use postgres DB, and trying to build degenerated dimension. For this reason i need to extract year as dimension level from the field date_time in table:

Code:

w_measures_f

(

  date_time timestamp without time zone NOT NULL,

...

)

when i run sql:

Code:

select date_trunc('year', date_time) from w_measures_f

it works Ok.

In my schema i created degenerated dimension with the next code:

Code:

But when I display data in Analyzer View (or in PAT) I receive error:

Code:

An exception was encountered while executing the query.

java.lang.ClassCastException: java.sql.Timestamp cannot be cast to java.lang.String

Maybe someone know how to fix this. I m so appreciate in advance.

King Regards,
Alex.

CASE WHEN in mySQL not working with Parameters?

dirks — Tue, 31 Aug 2010 09:40:15 GMT

Hi,

I have a mySQL query with a CASE WHEN statement. If I use parameters (like ${startDate}), the query does not work. I dont get a result. If I replace the paramaters with real data, like "2010-01-01", the query works.

It looks as if the parameters dont get passed to the CASE WHEN statement.

Dirk

Schema Workbench - MySQL schemas not available.

Schleich — Tue, 31 Aug 2010 07:46:12 GMT

Hi,
I am new to Mondrian and to Schema Workebench and I'm having trouble connecting to a MySQL source database.

I user the following parameters in the database connection window:
Driver Class Name: com.mysql.jdbc.Driver
Connection URL: jdbc:mysql://192.168.1.1:3306
User nme: myuser
Password: mypassword

The test connection is succesful, but, when I try to use a schema, it fails with error "No schemas available for this database connection, but schemas entered". Also, when I try the JDBC Explorer, there is no schema available.

The user has sysadmin privileges.
I have placed the JDBC connector in the \drivers directory. The driver I use is "mysql-connector-java-5.1.13-bin.jar"

Also, I was succesfull accessing an Oracle database. I'm only having trouble with the access to MySql database.

Thank you for any help on this matter. Regards.

Start-pac.bat as a service

axelb — Tue, 31 Aug 2010 07:26:10 GMT

Hi!

Is there anyway to convert start-pac.bat to a Windows Service so it starts at server boot time ?

Thank you for your help!

MetaEditor doesn't start

intellagent — Tue, 31 Aug 2010 06:36:21 GMT

Starting the Meta-editor under Windows XP I got the error message: "Goto can't be used at this time."and the editor doesn't start. Who knows the solution?

Best regards
Janos:mad:

How to truncate a table in pentaho

debadutta — Tue, 31 Aug 2010 05:02:47 GMT

Parameters of TOMCAT

Martillo — Tue, 31 Aug 2010 02:29:06 GMT

Hello,

Anybody could explain me a bit what are the meanings of these parameters please?

CATALINA_OPTS="-Xms256m -Xmx768m -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"

Xms ??
Xmx ??
XX:MaxPermSize ??
I hope you can help me.

regards.

[Mondrian] Mondrian read only replication back on line

Nicholas Goodman — Tue, 31 Aug 2010 00:47:59 GMT

Means we don't need to use p4??? Gosh, even I am willing to learn git
now!! Thank you!!!! :)

-pedro

On 10/08/31 01:47, Nicholas Goodman wrote:
> Greetings Mondrian devs!
>
> As part of our work at DynamoBI we have Eigenbase Perforce replicating to a read only GitHub location. Since Mondrian source is managed in Eigenbase perforce we setup the replication for Mondrian as well (main and 3.2 branch).
>
> http://github.com/eigenbase/mondrian
>
> GitHub also allows read only SVN access - so you can now watch/sync Mondrian via Git or SVN. GitHub has reported some issues with SVN as it's a new feature (read only view on top of Git) but it should work with most clients.
>
> Kind Regards,
> Nick
> PS - If you're interested in the details of the replication or with some dead simple instructions for checking out via SVN or GIT
> http://pub.eigenbase.org/wiki/Perfor...______________
> Mondrian mailing list
> Mondrian (AT) pentaho (DOT) org
> http://lists.pentaho.org/mailman/listinfo/mondrian
_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Generated SQL

haubuchon — Mon, 30 Aug 2010 23:11:32 GMT

I'm trying to see what is the generated SQL from a MDX Query.

I tried enabling log4j like I saw in a post: http://ramathoughts.blogspot.com/200...o-display.html

but no logs are being created.

Only the stdout log in tomcat/logs is used but no debugging traces.

I am on Windows and use tomcat as a service.

Any ideas why ?
Is there another way to see the generated SQL ?

Thanks.

Text file output not write all lines

ElmoVil — Mon, 30 Aug 2010 22:35:10 GMT

Hi,
I'm having a strange problem with PDI 3.2.0 and text file output

It's a bit urgent to resolve this so of you have any ideas of what's going on here please give a feedback

Well i have a text file output that acording to the log it writes 220 registers, but i look the file with a simple notepad and it have 187 lines!!

That's not all, because the last line writed (187th) contains half of the columns that supposed.

This transformation require a date in params, that change the results of a table input. I change this param, verify the query and its all right, the log output said the correct number of tuples supposed to write the text file output but when open the file contains less lines and the last one almost always its not complete.

The parameters of the text file output step relevant are:

append checked

accept file name from field checked

split every ... rows: 0

I added a Ending line of file but doesn't appear at all in the file writed.

Another strange thing is that the kettle logs shows no error at all, but only when I execute in RowLevel it throws an ArrayIndexOutOfBoundException over a merge join step :confused:
Note that: only in rowlevel logging!

Perhaps it could be memory issue, with a some param dates are about 86000 lines to write but with another are just 220 so i discart this.

i can give you more details about the transformation if you want, i supposed that with this description will be enought to get and idea

MDX compatibility - SELECT CLAUSE in FROM

haubuchon — Mon, 30 Aug 2010 21:25:31 GMT

I read that this syntax is valid in the Microsoft documentation.

Do you know if this is supported by Mondrian ? (A Select statement at the FROM clause).

I tried a couple of ways without success ...

Thanks

Code:

SELECT

    [Measures].Members ON rows,

    [Geography].[Geo].Members ON columns

FROM

    (SELECT [Time].[Calendar].[Year].[2010] ON rows FROM [Sales])

Please help on the following item. I am trying to use Informix with the Pentaho

zoescout — Mon, 30 Aug 2010 21:25:25 GMT

Please help on the following item. I am trying to use Informix with the Pentaho product and I notice that hibernate works fine with pentaho, basically due to our changes to hibernate3. Also, I created a delegate class for informix and then updated the quartz jar file.

But I have a question and a problem with trying to run it.
1. Question--> It appears that Pentaho uses hypersonic regardless of the main database you are using. Is this correct? Does it actually use 2 different database managers for it to work?

2. I have everything except the hibernate connection using hypersonic and the informix for the main db being accessed by hibernate. the hibernate access seems ok. But I get the following error from starting and I was hoping someone could tell me where it is getting the id and why it changes it to all uppercase. btw... I do not want to add INFORMIX id to the hypersonic database.

16:12:08,473 ERROR [SQLLookupRule] Error Start: Pentaho Pentaho Platform Engine Core 3.6.0-stable.41852
16:12:08,491 ERROR [SQLLookupRule] 3ee2c453-b47b-11df-a4c6-a1ae03bed5ce:COMPONENT:context-17391051-1283202727448:global-department-list.xactionConnectFactory.ERROR_0001 - Database connection could not be established to: SampleData
org.pentaho.platform.api.data.DatasourceServiceExc eption: java.sql.SQLException: User not found: INFORMIX
at org.pentaho.platform.engine.services.connection.da tasource.dbcp.PooledDatasourceHelper.setupPooledDa taSource(PooledDatasourceHelper.java:147)
at org.pentaho.platform.engine.services.connection.da tasource.dbcp.PooledOrJndiDatasourceService.retrie ve(PooledOrJndiDatasourceService.java:46)
at org.pentaho.platform.engine.services.connection.da tasource.dbcp.PooledOrJndiDatasourceService.getDat aSource(PooledOrJndiDatasourceService.java:115)
at org.pentaho.platform.plugin.services.connections.s ql.SQLConnection.initWithJNDI(SQLConnection.java:1 92)
at org.pentaho.platform.plugin.services.connections.s ql.SQLConnection.setProperties(SQLConnection.java: 107)
at org.pentaho.platform.engine.services.connection.Pe ntahoConnectionFactory.getConnection(PentahoConnec tionFactory.java:129)
at org.pentaho.platform.engine.services.connection.Pe ntahoConnectionFactory.getConnection(PentahoConnec tionFactory.java:73)
at org.pentaho.platform.plugin.action.sql.SQLBaseComp onent.getConnection(SQLBaseComponent.java:879)
at org.pentaho.platform.plugin.action.sql.SQLBaseComp onent.getConnection(SQLBaseComponent.java:845)
at org.pentaho.platform.plugin.action.sql.SQLBaseComp onent.getDatasourceConnection(SQLBaseComponent.jav a:795)
at org.pentaho.platform.plugin.action.sql.SQLBaseComp onent.executeAction(SQLBaseComponent.java:212)
at org.pentaho.platform.engine.services.solution.Comp onentBase.execute(ComponentBase.java:463)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeComponent(RuntimeContext.java:129 1)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeAction(RuntimeContext.java:1260)
at org.pentaho.platform.engine.services.runtime.Runti meContext.performActions(RuntimeContext.java:1159)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeLoop(RuntimeContext.java:1103)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeSequence(RuntimeContext.java:985)
at org.pentaho.platform.engine.services.runtime.Runti meContext.executeSequence(RuntimeContext.java:895)
at org.pentaho.platform.engine.services.solution.Solu tionEngine.executeInternal(SolutionEngine.java:399 )
at org.pentaho.platform.engine.services.solution.Solu tionEngine.execute(SolutionEngine.java:317)
at org.pentaho.platform.engine.services.solution.Solu tionEngine.execute(SolutionEngine.java:193)
at org.pentaho.platform.engine.core.system.PentahoSys tem.globalStartup(PentahoSystem.java:723)
at org.pentaho.platform.engine.core.system.PentahoSys tem.globalStartup(PentahoSystem.java:678)
at org.pentaho.platform.engine.core.system.PentahoSys tem.init(PentahoSystem.java:302)
at org.pentaho.platform.engine.core.system.PentahoSys tem.init(PentahoSystem.java:206)
at org.pentaho.platform.web.http.context.SolutionCont extListener.contextInitialized(SolutionContextList ener.java:136)
at org.apache.catalina.core.StandardContext.listenerS tart(StandardContext.java:3764)
at org.apache.catalina.core.StandardContext.start(Sta ndardContext.java:4216)
at org.apache.catalina.core.ContainerBase.addChildInt ernal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(Co ntainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(Sta ndardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployDirec tory(HostConfig.java:926)
at org.apache.catalina.startup.HostConfig.deployDirec tories(HostConfig.java:889)
at org.apache.catalina.startup.HostConfig.deployApps( HostConfig.java:492)
at org.apache.catalina.startup.HostConfig.start(HostC onfig.java:1149)
at org.apache.catalina.startup.HostConfig.lifecycleEv ent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLife cycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(Standa rdHost.java:736)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(Stan dardEngine.java:443)
at org.apache.catalina.core.StandardService.start(Sta ndardService.java:448)
at org.apache.catalina.core.StandardServer.start(Stan dardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:552)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:433)
Caused by: java.sql.SQLException: User not found: INFORMIX
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:582)
at java.sql.DriverManager.getConnection(DriverManager .java:185)
at org.apache.commons.dbcp.DriverManagerConnectionFac tory.createConnection(DriverManagerConnectionFacto ry.java:48)
at org.apache.commons.dbcp.PoolableConnectionFactory. makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.pool.impl.GenericObjectPool.add Object(GenericObjectPool.java:996)
at org.pentaho.platform.engine.services.connection.da tasource.dbcp.PooledDatasourceHelper.setupPooledDa taSource(PooledDatasourceHelper.java:133)
... 49 more
16:12:08,497 ERROR [SQLLookupRule] Error end:

Is REGEX Expression within "Checks if files exist" Job Entry Possible?

kandrews — Mon, 30 Aug 2010 20:09:51 GMT

Hi All,

Within a Job I have an "Get Files via FTP" job entry that uses REG EX within the Specify File(s) to retrieve and it works!

I thought that I could check if the files exist on the FTP server b4 trying to retrieve...

Figured a "Checks if Files Exist" was what I needed added in the VFS syntax to reference the file.

ex. ftp://foo:fooo@myserverfoo/var/ftp/e...lah\.dat\.done)

When I hard code the file name it works!

When I use the same Reg Ex expression that I prove worked in the "Get Files/FTP" job entry it fails.

Does a Job Entry specifically have to state that it works with REG EX expressions? Or is that implicit and all do?

If not I'll check and add a Jira to hopefully have the Job Entry that checks for files etc use REG EX just like the Get Files with FTP does.

Thoughts?

Thanks

Kent

Sept 1, 2010 - Pentaho Reporting and BI Server 3.7 preview and demo

dmoran — Mon, 30 Aug 2010 19:58:50 GMT

Kurtis Cruzada, Pentaho product manager, will talk about and demonstrate the new features of Pentaho Reporting and BI Platform 3.7.

Event login information and details can be found here: http://wiki.pentaho.com/display/COM/...echnical+WebEx

The session will be recorded in case you miss it.

The presentation will start Wednesday, Sept 1st 14:00:00 GMT

San Francisco (USA) . 7:00 AM PDT
Orlando (USA). . . . 10:00 AM EDT
London (England). . . 3:00 PM BST
Lisbon (Portugal) . . 3:00 PM WEST
Berlin (Germany). . . 4:00 PM CEST
Jakarta (Indonesia) . 9:00 PM WIB
Sydney (Australia). . 12:00 AM Thursday EST

To convert time for other timezones, Click Here

Community Tech WebEx - Wed Aug 18th 2010 - Roland Bouman - Kettle Cookbook

dmoran — Mon, 30 Aug 2010 19:54:02 GMT

Roland Bouman, Co-author of Pentaho Solutions, will present the Kettle Cookbook, an open source community project for auto generating Kettle documentation.

Event login information and details can be found here: http://wiki.pentaho.com/display/COM/...echnical+WebEx

The session will be recorded in case you miss it.

The presentation will start Wednesday, Aug 18th 14:00:00 GMT

San Francisco (USA) . 7:00 AM PDT
Orlando (USA). . . . 10:00 AM EDT
London (England). . . 3:00 PM BST
Lisbon (Portugal) . . 3:00 PM WEST
Berlin (Germany). . . 4:00 PM CEST
Jakarta (Indonesia) . 9:00 PM WIB
Sydney (Australia). . 12:00 AM Thursday EST

To convert time for other timezones, Click Here

Question about Data Sources

LymanSS — Mon, 30 Aug 2010 19:17:56 GMT

Hi all,
I'm trying to set up a system for editing/developing my solutions in a development, using svn for version control, and ultimately publishing to our production server.

The problem that I'm running into is the database connections. The server that holds the database is on the other side of a firewall, so in my development instance I have to run through an SSH tunnel. So I have the datasource set up to query against the local host at the port where the SSH client is listening.

The production server doesn't have this problem, so it can directly query against the database. Ideally I'd just be able to specify the data source by name, and have that name map to two different connections in the two different environments. However it seems that when I configure a report to query through the SSH tunnel in my development environment, that configuration carries forward to the production server when I publish the report.

I'm sure there's a right way to do this and I'm just missing it. Can anyone tell me what I should be doing here? Thanks

Scott

Report Export Format issue

meussram — Mon, 30 Aug 2010 17:56:48 GMT

Hi,

I am a beginner with Pentaho. However I have created a Business View with Metadata Editor, published it to our Pentaho BI server and created and saved a report.

My issue is that when running the report once logged in my account on the BI server, I am not given a choice as to whether I want to export my report as HTML, CSV or whatever. The export format seems to be tied to the latest choice of preview format I made while editing the report...

Any help would be very welcome,

Thanks,

Sam

Error loading Adhoc Reporting

RVT — Mon, 30 Aug 2010 17:52:27 GMT

We would like to embed the Adhoc Reporting part of the BI Server into our software separate from the rest of the BI Server interface, but I encountered an odd error while trying to load waqr.html directly in my browser:

Code:

[JavaScript Application]



message: Messages is not defined

fileName: file:///Users/rvt/biserver/biserver-ce/tomcat/webapps/pentaho/adhoc/js/ui/WizPg0.js

lineNumber: 43

stack: ()@file:///Users/rvt/biserver/biserver-ce/tomcat/webapps/pentaho/adhoc/js/ui/WizPg0.js:43

()@file:///Users/rvt/biserver/biserver-ce/tomcat/webapps/pentaho/adhoc/js/ui/WizPg0.js:32

([object Object])@file:///Users/rvt/biserver/biserver-ce/tomcat/webapps/pentaho/adhoc/js/ui/WaqrWizard.js:22

loadWaqr()@file:///Users/rvt/biserver/biserver-ce/tomcat/webapps/pentaho/adhoc/waqr.html:275

onload([object Event])@file:///Users/rvt/biserver/biserver-ce/tomcat/webapps/pentaho/adhoc/waqr.html:1



name: ReferenceError

I did a little bit of poking around the HTML and JavaScript, but JavaScript isn't particularly a strong point of mine and I couldn't see any reason why WizPg0.js wouldn't be able to find Messages, which is imported in waqr.html.

Can you offer any insight as to how to avoid this without having to embed the entire BI Server interface?

connection error

lisa7171 — Mon, 30 Aug 2010 17:46:41 GMT

Hello there,

We downloaded Pentaho BI EE suit 4 and we could not connect to the database, Vertica.

There is an error. We were following the installation manual (JVM SKD, vertica JDBC drivers).

are there other files to be updated or parameter to be changed?

thanks
Lisa

Attached Images

connectioonError.jpg (46.4 KB)

Mondrian User Defined Function in PRD

Nathan — Mon, 30 Aug 2010 15:50:27 GMT

I have a Mondrian Schema that uses a User Defined Function. It works fine on the BI Platform with my custom class package in tomcat\webapps\pentaho\WEB-INF\classes. I'm trying to write a report against the schema and I'm having trouble because PRD doesn't know where to find the custom class for the User Defined Function. Where do I need to put my files relative to PRD?

Repository cache refresh failed - missing "all-delete-orphan"

Nathan — Mon, 30 Aug 2010 15:32:52 GMT

I'm using Pentaho 3.5.2. Sometimes when I update the solution repository from the user console, I get a message that says "Repository cache refresh failed." When I search the log, I see

Code:

2010-08-30 10:22:25,876 ERROR [org.pentaho.platform.repository.hibernate.HibernateUtil] HIBUTIL.ERROR_0008 - commitTransaction() failed.

org.hibernate.HibernateException: A collection with cascade="all-delete-orphan" was no longer referenced by the owning entity instance: org.pentaho.platform.repository.solution.dbbased.RepositoryFile.childrenFiles

I can restart the Pentaho server application and it refreshes fine for a while until I run into this error again. I'm running on Windows, and I wonder if there is some file system permission problem or something that could be causing this?

Parameter set to 'all items'

DBA_Alex — Mon, 30 Aug 2010 15:24:15 GMT

I'm trying to build a report that takes an optional parameter - either the user selects an item from a dropdown or wants to view all the items in the list. What is the best way to build this type of parameter?

how to get object of excel input step in java

nikhil_d — Mon, 30 Aug 2010 14:19:36 GMT

Hi All,

I have loaded the KTR file into java object. From that object I want a Object of "Excel input step". In that step I want to change the excel file dynamically and then I want to run the KTR file. Any suggestion will be appreciated.

Thanks in advance

Edit BI platform

marcojrfurtado — Mon, 30 Aug 2010 12:54:20 GMT

Hello,

I'm developing an application and I need to use some sort of application to browse my solutions folder.
I downloaded the biserver-ce-manual and decided to use the main page browser.

The problem is that I cannot put it directly where I need it, so I have to edit the page intead of simply calling the Home page. I took a look at /pentaho/mantle/Mantle.jsp, where it is located, but it wasn't of much help. It seems that the page is mostly built with this Javascript: pentaho/mantle/mantle.nocache.js. Unfortunately it is a compressed code and I couldn't find the source.
I even tried to google a solution but nobody seems to have this problem, so it must be really easy to edit the Browser. I just can't figure out how to do it.

pdi-ce4.0.1-missing info in logfile - Kitchen - Finished/Start/Stop+Processing ended.

PL_@NTA — Mon, 30 Aug 2010 12:02:05 GMT

Hello,

i miss some informations when using kitchen with version from pdi-ce-4.0.1 (Detail: SNAPSHOT-r13826)
With kitchen in Version 3.2.0 the following finish informations are written into my logfile:
2010/08/30 10:15:51 - Kitchen - Finished!
2010/08/30 10:15:51 - Kitchen - Start=2010/08/30 09:46:31.250, Stop=2010/08/30 10:15:51.259
2010/08/30 10:15:51 - Kitchen - Processing ended after 29 minutes and 20 seconds (1760 seconds total).

What can i do to bring back the result/finish infos ?

*new:*
Here a logfile comparison with version 4 vs. 3
"kitchen version 4.0.1"
INFO 30-08 15:23:51,851 - Using "C:\Temp\6\vfs_cache" as temporary files store.
INFO 30-08 15:23:52,179 - Kitchen - Kitchen
INFO 30-08 15:23:52,179 - Kitchen - Kitchen
INFO 30-08 15:23:52,257 - test-case - Start of job execution
INFO 30-08 15:23:52,257 - test-case - Starting entry [Write To Log]
INFO 30-08 15:23:52,288 - PDI-4219 - FOO=415
Table=${Table}
INFO 30-08 15:23:52,288 - test-case - Finished job entry [Write To Log] (result=[true])
INFO 30-08 15:23:52,288 - test-case - Job execution finished
INFO 30-08 15:23:52,288 - Kitchen - Kitchen
INFO 30-08 15:23:52,288 - Kitchen - Kitchen
INFO 30-08 15:23:52,288 - Kitchen - Kitchen
""
"kitchen version 3.2.0"
INFO 30-08 15:23:52,679 - Kitchen - Logging is at level : Detailed logging
INFO 30-08 15:23:52,679 - Kitchen - Start of run.
INFO 30-08 15:23:52,773 - org.pentaho.di.core.util.ResolverUtil@5e1077 - Scanning for classes in [file:/C:/Program%20Files/data-integration/lib/kettle-engine.jar] matching criteria: [Lorg.pentaho.di.core.util.ResolverUtil$Test;@18b33 64
INFO 30-08 15:23:53,413 - StepLoader - Looking for plugins in directory: plugins\steps
INFO 30-08 15:23:53,429 - org.pentaho.di.core.util.ResolverUtil@1c783c5 - Scanning for classes in [file:/C:/Program%20Files/data-integration/lib/kettle-engine.jar] matching criteria: [Lorg.pentaho.di.core.util.ResolverUtil$Test;@19c0b d6
INFO 30-08 15:23:53,757 - Using "C:\Temp\6\vfs_cache" as temporary files store.
INFO 30-08 15:23:53,913 - SharedObjects - Reading the shared objects file [file:///C:/Documents and Settings/stel.PL.009/.kettle/shared.xml]
INFO 30-08 15:23:53,929 - Thread[test-case (test-case (Thread-2)),5,main] - exec(0, 0, START.0)
INFO 30-08 15:23:53,929 - test-case - Starting entry [Write To Log]
INFO 30-08 15:23:53,929 - Thread[test-case (test-case (Thread-2)),5,main] - exec(1, 0, Write To Log.0)
INFO 30-08 15:23:53,929 -
PDI-4219
- FOO=415
Table=${Table}
INFO 30-08 15:23:53,929 - test-case - Finished job entry [Write To Log] (result=[true])
INFO 30-08 15:23:53,929 - Kitchen - Finished!
INFO 30-08 15:23:53,929 - Kitchen - Start=2010/08/30 15:23:53.898, Stop=2010/08/30 15:23:53.929
INFO 30-08 15:23:53,929 - Kitchen - Processing ended after 0 seconds.

Thanks for your help.

Roles en Nueva Vista de Análisis

j_nep — Mon, 30 Aug 2010 11:36:15 GMT

Es posible usar los roles de pentaho en una nueva vista de análisis?

El esquema FoodMart tiene definido el rol California Manager con algunas restricciones.
El usuario suzy tiene asignado el rol California Manager, por lo que al entrar con este usuario tendría que tener restricciones a la hora de ver los datos, pero puede ver lo mismo que el usuario joe (administrador), si se crea una "Nueva vista de Análisis"

Hay que configurar alguna cosa más a la hora de asignar roles o simplemente no es posible que se asignen roles en la nueva vista de análisis¿?

He mirado el archivo analysis_view_template.xaction (pentaho-solutions\system\mondrian) y no parece tener ningún parámetro de entrada para roles.

No es posible usar roles en las nuevas vistas de análisis?

Muchas gracias!!

Publishing reports from DB outer localhost

lo3 — Mon, 30 Aug 2010 09:05:23 GMT

Hi everyone,

Does anyone know whether is possible to launch a report in the users console when the database is not in the localhost?

Thanks in advanced!

pentaho translation

glahuka — Mon, 30 Aug 2010 08:33:56 GMT

Hi all,

I'm trying to translate pentaho's PUC to spanish just translating the .properties files... There is a lot of work already done , but... for example, the "new Ad Hoc report" view is in english... I've made a folder called "es" in adhoc folder (bi-platform-appserver/ ... /messages/nls/ ...) and then I've put in this folder a message_strings.js file with all the spanish messages... well... it doesn't work...

Please, what can I do for translate all PUC applications?

Thanks a lot,

Glahuka

Get variables doesn't work

axelb — Mon, 30 Aug 2010 08:29:04 GMT

Hi,

I have very simple job with two transformations and two Set variables steps, each one flowing to each tranformation. Besides, TRF20 (second transformation) receives a result from TRF10 (first transfomation).

I can get the variables in the first transformation without trouble. However, in the second one, that's is not possible. In fact, the step in transformation recovers the truncated names of variables (???)...

First image shows job. Step with variables not received is Set variables 2

Attachment 6013

Follwing you can see Set variables 1 step definition

Attachment 6014

and the step that recovers variables in TRF10

Attachment 6015

Now, you can see Set variables 2 step

Attachment 6017

Then, the step in transformation TRF20 that should recover variables values, but it does not...

Attachment 6016

In fact, I recover this string

${Aud ${Cate ${C ${ ${C

Any idea about the cause of this ?

What am I doing wrong ?

Thank you for your help.

Attached Images

SQL for Measures in Schema

PriyankaP — Mon, 30 Aug 2010 07:38:15 GMT

Hi,

I have a mysql query as follows:

select a.download_date, a.CompanyName, a.category_desc,

(select count(b.download_status) from current_week_tat_bog as b where b.download_status='Y' and b.category_id=a.category_id and b.CompanyId=a.CompanyId and b.download_date=a.download_date) as Recieved,

(select count(c.shipped_status) from current_week_tat_bog as c where c.shipped_status='Y' and c.category_id=a.category_id and c.CompanyId=a.CompanyId and c.download_date=a.download_date) as Shipped

from current_week_tat_bog as a

group by a.category_id, a.CompanyId, a.download_date

order by a.download_date, a.CompanyId, a.category_id;

In analysis report, on x-axis I have CompanyName and CategoryDescription and on y-axis I have Orderdate. Under each orderdate, I have 2 Measures 'Received' and 'Shipped'.

Clearly from the above query, 'Received' is count of 'download_status' where 'download_status="Y"' for that particular category, company and download_date.

My question now is, how to put the above sub-query for 'Received' Measure in the schema?

What has to be used for this.. Views or MeasureExpression or Propertires or ??? :confused:

Please help...

Thanks & Regards

:)

Dashboard created with cdf.de (0.2)

pmfilippi — Mon, 30 Aug 2010 07:14:37 GMT

I have installed cdf-de (0.2) in a bi server 3.5.2-ce installation, and then a create a dashboard with the dasboard editor.

Is it possible to use this dashboard in another bi server installation (3.5.2-ce) wich do not have the cdf-de installed?

I have seen that the format file are different:
- .cdfde and .wcdf for dashboard created with cdf-de
- .xcdf and tamplate for the other

Thank in advance.

Something confused in Parallel running JobEntry

fengw2007 — Mon, 30 Aug 2010 06:21:57 GMT

Hi everyone !

env : Kettle V-3.2 , windows 7 .

when I start a job ,then run shell1 , shell2 in parallel , after both shell1 and shell2 are finished , then goes to shell3 . What should I do ?

I've got this by the way of log file ,see my attachment. when shell1 & shell2 finished , it makes a log file ,then I judge whether the files exist. If true , run shell3.
An alternative method is making the shell1 , shell2 as a job , but we can't see the dependences directly!

I want to make it simple , whether I should use some jobentry or step to do this :confused:

I've seen the sample "JavaScriptMod - skip rows after x rows" , it seems only work in one standalone transformation.

What should I do ? Or someone can give me some advise?

Tks!

Attached Files

run parallel.kjb (30.3 KB)

Count particular value occurrence

anupjoshi7 — Mon, 30 Aug 2010 05:19:29 GMT

Hi everyone!

I have to count workdays of an employee using functions or formula .

User_id day_type

004 w
004 w
004 wo
004 w
005 w
005 w
005 w
005 wo

where w stands for work days and wo for week off.
I have achieved to count total occurrence of w and wo using group by user_id .......................

But how to count occurrence of w for particular user for showing only workdays of an employee.

first steps with OLAP Navigator

pep44 — Mon, 30 Aug 2010 00:02:30 GMT

Hello,

I made the sample tutorial: „Analysis View Tutorial“ with the SteelWheels schema and SteelWheels Salec cube. I worked successfully with the OLAP- Navigator as in the sample explained.

I wonted to get the idea how can I create cube on our data and how can I make similar analysis. But without success….

How can I see/ understand the cube of the sample - the SteelWheels Salec cube ?

Are there more (other) similar well explained samples (tutorials) ?

Thank you in advice for answers!

P.

Is Spoon script unable to see data inserted in same transformation in a MySql DB?

User1001 — Sun, 29 Aug 2010 15:17:20 GMT

Hi,

Target DB : Mysql 5.0
Kettle version: 4.0.0 (stable)

In a Spoon transformation which is supposed to insert 4500 rows in a target table, there are 95 rows which are duplicate (duplicate based on a column value).

I have designed the transformation to check for duplicates using database look-up step. If a duplicate is found then it should be written to a log file or else the record should be inserted in the table.

If I execute the transformation, the database lookup step gets fully executed before the insert step and it is not able to check for the duplicate records. As a results all the data gets inserted in the table. Is there any way to make the lookup step to check for duplicates being inserted in the same transformation? Kindly suggest.

Thanks.

MS SQL & Pentaho Report Desiger

BI_SNAX — Sun, 29 Aug 2010 14:10:03 GMT

Hi all,
After many attempts I can not succeed connection to a SQL Server database.
Someone already had to make this connection. Can I know how ?
Thank you.:o

[Mondrian] PeriodsToDate and Aggregate problem

Diethard Steiner — Sun, 29 Aug 2010 11:27:21 GMT

Hi,

I've come across an example where my calculated member will yield wrong
results. I've been trying in the last few days to find a solution for this,
but so far no luck.

I have two measures:

[Measures].[Marketing Spending (Actual)]: Aggregation: Sum
[Measures].[New Subscriptions (Actual)]: Aggregation: Sum

Then I created following calculated member in the schema:
[Measures].[CPA (Actual)]=[Measures].[Marketing Spending
(Actual)]/[Measures].[New Subscriptions (Actual)]

If I run a query like this I get the correct results:
SELECT
[Measures].[CPA (Actual)] ON 0
from [Global B2C Weekly KPI Cube]
WHERE
[Date.Weekly Calendar].[2010].[1]:[Date.Weekly Calendar].[2010].[32]

I can even add some other dimensions and all looks fine.

But, when I create a calculated Member in the MDX query with PeriodsToDate
and Aggregate, the results looks like the sum of the CPAs by week.

WITH MEMBER [Measures].[x] AS
Aggregate(PeriodsToDate([Date.Weekly Calendar].[2010],[Date.Weekly
Calendar].[2010].[32]),[Measures].[CPA (Actual)])
SELECT
[Measures].[x] ON 0
from [Global B2C Weekly KPI Cube]

So my take is that as PeriodsToDate gives back all the members, the
calculated measure is calculated for each member and then summed up.

In this case the measures should be summed first for the time period and
then the calculation should be performed. I don't want to create extra
members just to get the sums and then another ember to calculated the CPA.
There must be a more efficient way.

Does somebody know how I can solve this?

Thanks,
Diddy

_______________________________________________
Mondrian mailing list
Mondrian (AT) pentaho (DOT) org
http://lists.pentaho.org/mailman/listinfo/mondrian

Performance question regarding unnecessary join performed

theodor — Sun, 29 Aug 2010 07:03:01 GMT

In the documentation of mondrian regarding performance I found the following remark :

"If a dimension (or, more precisely, the level of the dimension being accessed) is in the fact table, Mondrian does not perform a join."

Here's an example to emphasize what i understood from the the remark :

CUBE(FACT_A) - an actual table FACT_A
ID(PK)
DATE
ORG
SCORE
RESULT - A FK to DIM_RESULT

DIMENSION(DIM_RESULT) - an actual table DIM_RESULT
RESULT(PK)

Now suppose i had a mondrian select :

SELECT {[RESULT].children}
ON COLUMNS,
{[SCORE].[All SCORES].Children}
ON ROWS
FROM [FACT_A]

I would expect mondrian not to do a join with DIM_RESULT since the it has a single column which is also the PK and hence contained in FACT_A table in the column RESULT
but its not the case he does a join.

Have i misunderstood the performance remark, if so can anyone give me an example ?

csv file read in transformation help

karthikvx — Sun, 29 Aug 2010 00:08:10 GMT

Hi:
I am using pdi 4.0.1 CE version on java 1.6

In my example transformation, I have a steps as below
get-rows-from-result -----> modified-java-script-1 ----> filter ---> read-csv-file ---> modified-java-script-2.

In my modified-java-script-2, I can't see the fields created in modified-java-script-1. I see only the csv-file-output-fileds.

Can you please inform, how to see the fields created to read-csv-file in the transformation.

Thank you.

Cargar datos en Weka

pic3 — Sat, 28 Aug 2010 18:19:31 GMT

Hola a todos.
Como podéis ver por mi pregunta, soy nuevo en Weka v3-6-3.

Realmente son dos problemas los que tengo:

1. Genero un archivo arff desde PDI 4.0.1, con ARFF Output, con origen en una tabla de la BD. Me genera el archivo arff pero los campos con decimales los pone con ',' y luego al cargar en Weka se arma un lío. Ya sé que el separador decimal tiene que ser '.' pero no sé como decírselo.

2. También he tratado de hacer en Weka-Explorer la carga de datos directamente desde la BD, mysql, pero me dice:
'connecting to:jdbc:mysql://127.0.0.1:3306/mysql = false'
'exception: java.sql.SQLException: No suitable driver found for jdbc:mysql://127.0.0.1:3306/mysql'

Está claro que es un problema con el driver de la BD pero no encuentro documentación de dónde situarlo y cómo decírselo a Weka.

Os agradezco de antemano las respuestas.

create facts and dimension ...for cube

macentrap — Sat, 28 Aug 2010 11:15:33 GMT

Hello all,

I am new to analysis service and I am just trying to understand the basic concepts.
So, if I have relational database that I would like to analyze it. I understand that I need to create cube(s), but my question is where do I create dimension tables and fact tables first place and associate them to my tables in relation database to populate data? Most of examples that I see online are starting at point where they create cube(s). Are there any example that show me from creating dimension and fact tables?
Thanks.

AdditionAL INFO:

completed information gathering on what details will be required on cube

in current setup installed:
installed BI 3.6
mysql
psw, pdi & prd

Resume a transformation

lophophora — Fri, 27 Aug 2010 21:24:57 GMT

Hello everyone,

I'm new in all this whole datawarehousing topics but first I'd like to thank you all for this huge commmunity effort.

My question is the following.

I have a source database, transformation and a target database and I want to run the ETL process monthly. when I run it for the first time, I extract all the data then I transform it and load it to the target database without problems.

When I run the ETL for the second time I have that all the data from the first etl process is now duplicated in the target database. I have the option to truncate the table before each transform but this option will make the ETL process take each time longer.

Is there any way to make a transformation resume from where the last transformation left?
Do I make my self clear?

Thanks all in advance

Lophophora

how to turn on this unix log level option in shell scripts kettle.sh

karthikvx — Fri, 27 Aug 2010 20:21:23 GMT

Hi:
I am using the 4.0.1 ce release, the java is 1.6
In windows environment, I see the log is showing on the console and put the log details in file. In unix I can't see the same detail logs. Is there any other options I should turn on. The log files are created. I am not able to see the write-log informations in file. Any help or comment will be useful.
thank you.

Upgrading from ver 2.0 of Platform to ver. 3.6.0 stable broke Mondrian Aggregates

Bolek — Fri, 27 Aug 2010 20:04:53 GMT

I upgraded from version 2.0 of the platform to version 3.6.0 stable a few months ago and have now noticed that aggregate tables for mondrian that were used under version 2.0 are NOT being used in version 3.6.0 for the same MDX queries using the same schema file and same underlying MySQL database structure.

I wanted to keep this first post simple w/o posting all the details, DDL of Fact Table, Aggregate Table, MDX query, mondrian schema, etc. (May be required for anyone willing to assist on this).

I may have to do that...but just curious if anyone else ran into this situation and determined that certain general changes need to be made.

In general this is what the modrian logs tell me.....

Under version 3.6.0 some aggregate tables are being used, so it's not a general setting of using aggregates or not. What I see in the mondrian sql log is that when I have a MDX query involving my Time dimension, mondrian fires off a SQL query without the time component in the WHERE clause and in that query the expected aggregate table is being used.

Then mondrian fires off the same query but this time includes the time dimension table but falls back to using the base Fact table.

My aggregate table has the Year and Month components of my time dimension and is structured the exact same way as under version 2.0.

Under version 2.00 of the platform I get a single SQL query that includes the time dimension and uses the aggregate table.

Did anyone out there face a similar situation when migrating from version 2.0 to 3.6.0 ?

Thanks,
Bill

SQL Query not returning correct results

gstempel — Fri, 27 Aug 2010 19:43:31 GMT

First, let me preface this by admitting this is probably stretching the limits, but here goes.
The sql statement (over 100K bytes in size) returns 17,481 rows when executed in mysql query browser, but only returns 3,580 rows when submitted as the query in a table input.
If there is a limit to the sql statement length, I would have expected an error, but no error is generated. It just won't return more than 3,580 rows.
Before you question the need for a query of this size, allow me to explain:
A time consuming inner select had to be repeated for 6 different querys, obviously creating a significant amount of overhead. To get around this, I ran the inner select as a separate job step, then used javascript to convert the results into a hard coded select in the form:
"select 2343234 from dual union select 458844 from dual union ...."
Any thoughts?

inheriting report structure to other reports

akotian — Fri, 27 Aug 2010 18:18:12 GMT

Hello everyone,

I am new to Pentaho and would really appreciate any help.

I want to know if it is possible to create a parent/master report with some layout and formatting
and then inherit this structure in other reports so that all the reports have the same layout.

Please let me know if this is possible.

I tried searching this forum for such threads but was not able to find any.

Thanks in advance for your help.

I am using PRD 3.6.1- GA

Swing application Classpath and progress monitoring

Pieter — Fri, 27 Aug 2010 15:12:40 GMT

Hi,

I'm creating a Swing application from which I want to run kettle-jobs. And send an email when the job fails. For this I have some questions.

What do I need to put on the classpath in order for the Job to run successfully. (Now I put all the jars I could find in the pdi distribution on the classpath).
Is there a convenient way to track the progress of the run of a Job? Now I added a Log4jStringAppender which sends events, but I was wondering if there wasn't a more convenient way?
I need to determine the outcome of the run, for this I use the Result-object returend by a Job.run() call. Are there better options?

Thanks in advance

Pieter

New Formula Functions - power to the parameters!

Taqua — Fri, 27 Aug 2010 14:30:09 GMT

More...

Simple Excel input file - wrong preview

omm — Fri, 27 Aug 2010 13:12:24 GMT

I have an excel file in which one of the column is a date.
When I click the preview on the Excel input file...
Instead of showing the date 10/1/2009 it was showing 12/31/1969
Even, I have tried writing into a file, but all the dates are shown as 12/31/1969 for some reason.
I did mention the format MM/dd/yyyy in the fields tab for the excel input file.

Did anyone come across such an problem or know why it is happening?

Unable to load the driver hive

prasukj — Fri, 27 Aug 2010 11:29:23 GMT

Hi experts,

Report is working fine in pentha report designer.
but when i publish the report to BI server, and try to render it , its throwing error
ParentException:
java.sql.SQLException: Unable to load the driver: org.apache.hadoop.hive.jdbc.HiveDriver

Note:my source is hive which data is extracted into the report

why i am able to get to see the report in PRD but not in BI server

Pentaho Report Parameter Passing

riyaz — Fri, 27 Aug 2010 10:13:21 GMT

Hi,

I am new to this Pentaho Report Designing. I have a requirement to pass parameters from UI which was developed in jave to report design...will any one please help.

Thank in advance

adding a column value for every row till it reaches a condition

watchman — Fri, 27 Aug 2010 09:07:53 GMT

Hi

I have a weird requirement. I need to add a column value for each row till it reaches a particular total.

For example I have a stream like

A | B
-------
a | 13
b | 11
c | 10
d | 8
e | 1
f | 1

I need something like below.

A | B | sub_total
----------------------
a | 13 | 13 ( r1 + r 0)
b | 11 | 24 ( r1 + r2 )
c | 10 | 34 ( r1 + r2 + r3)
d | 8 | 42 ....
e | 1 | 43 ...
f | 1 | 44 ...

anyway to get this?

The purpose of this is, I dont want any rows after a particular sub_total values. For example discard all rows if sub_total > 40

greatly appreciate any help..!

thanks
manoj

Web Service to access Business models

madhupenta — Fri, 27 Aug 2010 08:21:55 GMT

Hi,

I need to know whether the business models in the metadata.xmi file can be hosted as a web service through user console.. also where would I find documentation where i can learn how to go about using user console' s set of web services??
Please help on this as I am trying to work on something where external applications access pentaho's web services