webdetails / cda Goto Github PK

The dataAccess list is apparently sorted by order of creation and by datasource type. When the number of queries grows heavily it may be hard to find a specific query. I'd like the dataAccess to be sorted alphabetically.

version postgresql : 9.1
version biserver : 4.5.0
version cda : TRUNK-SNAPSHOT

I get a "pt.webdetails.cda.dataaccess.QueryException: ReportDataFactoryException : The generated SQL-query did not execute successfully." when I provide parameters to cda file

full log trace here : http://pastebin.com/sQCyz9Qn

sample postgresql dataset : http://pastebin.com/9kYkAPvU

metadata model (you will have to put your own db settings (check between lines 586 and 610)) : http://pastebin.com/jkyfLA1t

cda file that generate the issue : http://pastebin.com/HVVpeP0T

I have done the same kind of tests with a hypersonic db and it did work.

As a user I want to be able to see if a query is running when I use the previewer (a progress indicator)

I have add a progress indicator to CDA previewer in the following way:

In cda/previewer/previewer.js
Add in the beginning:

if($.blockUI){

$.blockUI.defaults.fadeIn = 0;

$.blockUI.defaults.message = '

';

$.blockUI.defaults.css.left = '50%';

$.blockUI.defaults.css.top = '40%';

$.blockUI.defaults.css.marginLeft = '-16px';

$.blockUI.defaults.css.width = '32px';

$.blockUI.defaults.css.background = 'none';

$.blockUI.defaults.overlayCSS = { backgroundColor: "#FFFFFF", opacity: 0.8, cursor: "wait"};

$.blockUI.defaults.css.border = "none";
}

After:
refreshTable = function(id){

add:
$.blockUI();

After:
showTable = function(data){

add:
$.unblockUI();

In cda/previewer/previewer.html:

After:

<script type="text/javascript" src="previewer/js/jquery.i18n.properties.js"></script>

add:

<script type="text/javascript" src="previewer/js/jquery.blockUI.js"></script>

In the directory:
cda/previewer/js include the file jquery.blockUI.js

I download the most recent version for jquery.blockUI.js, the version 2.65.0-2013.09.02.

In the directory:
cda/previewer/img include the file processing_transparent.gif

I got the processing_transparent.gif from pentaho-cdf plugin (pentaho-solutions/system/pentaho-cdf/resources/style/images/processing_transparent.gif).

Please add it to the next version of CDA.

I have tested it with Pentaho BI 4.8.0 installed on Ubuntu Server 12.04 and with the CDA plugin version 13.06.05 (Stable). I tested it with Firefox 21.0 y Chrome.

Thanks in advance.

Juan Carlos

Even though dd4a386 is really helpful, the problem still exists if CDA resources (files) are shared between users. The problem is in the class pt.webdetails.cda.settings.SettingsManager, which holds a general cache used by all the users.

I'm trying to solve that by having settings manager use compound key, which consists of the resource id along with current Pentaho session user name. Please tell me if I'm digging in the wrong direction.

I would like to know if it's possible to create a custom CDA datasource.

I've been playing with a beanshell datasource (scriptable over scripting) to call a custom java class that allow me to query a MongoDB (https://github.com/kleysonr/pentaho-cda-mongodb) and a GraphQL server (https://github.com/kleysonr/pentaho-cda-graphql).

For many reasons I would like to avoid writing java code as a beanshell.

Best Regards.
Kleyson Rios.

Hi all,

We're using Pentaho 5.0.1-stable with the latest CD* trunk versions from the Marketplace as of today (2014-05-07). We've seen this bug since a few weeks ago, but it hasn't been annoying enough until today :-D.

When CDA has an error due to a badly built SQL query or something of the sort, it does not produce a good error log entry. Instead, it seems as if another exception is generated within the error handling code:

may 07, 2014 7:36:40 PM com.sun.jersey.spi.container.ContainerResponse mapMappableContainerException
Grave: The exception contained within MappableContainerException could not be mapped to a response, re-throwing to the HTTP container
java.lang.NoSuchMethodError: org.pentaho.reporting.engine.classic.core.ReportDataFactoryException.getParentThrowable()Ljava/lang/Throwable;
        at pt.webdetails.cda.dataaccess.PREDataAccess.performRawQuery(PREDataAccess.java:147)
        at pt.webdetails.cda.dataaccess.SimpleDataAccess.queryDataSource(SimpleDataAccess.java:138)
        at pt.webdetails.cda.dataaccess.AbstractDataAccess.doQuery(AbstractDataAccess.java:245)
        at pt.webdetails.cda.CdaEngine.doQuery(CdaEngine.java:134)
        at pt.webdetails.cda.CdaEngine.doExportQuery(CdaEngine.java:160)
        at pt.webdetails.cda.CdaCoreService.doQuery(CdaCoreService.java:76)
        at pt.webdetails.cda.CdaUtils.doQueryInternal(CdaUtils.java:130)
        at pt.webdetails.cda.CdaUtils.doQuery(CdaUtils.java:141)
        at pt.webdetails.cda.CdaUtils.doQueryPost(CdaUtils.java:125)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)

Is this new "getParentThrowable()" method only available to Pentaho 5.1 or something like that? We don't have anything left to upgrade in our "Marketplace" section.

Kind regards,
Antonio

Hi,
I am working on pentaho CDA document to fetch data. Problem I am facing is that when I write MDX query in CDA document there is row duplication. When I use same query in Saiku then single row is returned, but in case of CDA there are duplication of row.
Following is my MDX query.

WITH
SET [~Time_Time.Default_Year] AS
Exists({[Time.Default].[Year].Members}, [~Time_Time.Default_Day])
SET [~Time_Time.Default_Month] AS
Exists({[Time.Default].[Month].Members}, [~Time_Time.Default_Day])
SET [~Time_Time.Default_Day] AS
{[Time.Default].[${selectedYear}].[${selectedMonth}].[${selectedDay}]}
SET [~ROWS_Time_Time.Default] AS
Hierarchize({[~Time_Time.Default_Year], [~Time_Time.Default_Month], [~Time_Time.Default_Day]})
SET [~Client_Client_ClientId] AS
{[Client].[${ClientId}]}
SET [~Client_Client_ClientName] AS
Exists({[Client].[ClientName].Members}, [~Client_Client_ClientId])
SET [~ROWS_Client_Client] AS
Hierarchize({[~Client_Client_ClientId], [~Client_Client_ClientName]})
SET [~ROWS_UserStatus_UserStatus] AS
{[UserStatus].[UserStatusName].Members}
SET [~ROWS_UserType_UserType] AS
{[UserType].[UserType].Members}
SELECT
NON EMPTY {[Measures].[NewAddedProfiles], [Measures].[TotalProfileCount], [Measures].[UpdateProfileCount]} ON COLUMNS,
NON EMPTY NonEmptyCrossJoin([~ROWS_Time_Time.Default], NonEmptyCrossJoin([~ROWS_Client_Client], NonEmptyCrossJoin([~ROWS_UserStatus_UserStatus], [~ROWS_UserType_UserType]))) ON ROWS
FROM [UserProfilebyClient]

following is result out put in CDA document

Hi,

After clean install of CDA via ctools-installer.sh I can see the following jar files in biserver-ce-4.8.0-stable/biserver-ce/pentaho-solutions/system/cda/lib

drwxr-xr-x 12 calummiller staff 408 5 Jun 13:59 .
drwxr-xr-x 17 calummiller staff 578 5 Jun 13:59 ..
-rw-r--r--@ 1 calummiller staff 190135 5 Jun 13:59 cda-core-13.03.25-sources.jar
-rw-r--r--@ 1 calummiller staff 324900 5 Jun 13:59 cda-core-13.03.25.jar
-rw-r--r--@ 1 calummiller staff 190135 5 Jun 13:59 cda-core-13.06.05-sources.jar
-rw-r--r--@ 1 calummiller staff 324899 5 Jun 13:59 cda-core-13.06.05.jar
-rw-r--r--@ 1 calummiller staff 42292 5 Jun 13:59 cda-pentaho-13.06.05.jar
-rw-r--r--@ 1 calummiller staff 108487 5 Jun 13:59 cpf-core-TRUNK-SNAPSHOT.jar
-rw-r--r--@ 1 calummiller staff 134076 5 Jun 13:59 cpf-pentaho-TRUNK-SNAPSHOT.jar
-rw-r--r--@ 1 calummiller staff 227120 5 Jun 13:59 jackson-core-asl-1.8.2.jar
-rw-r--r--@ 1 calummiller staff 666505 5 Jun 13:59 jackson-mapper-asl-1.8.2.jar
-rw-r--r--@ 1 calummiller staff 20408 5 Jun 13:59 robochef-0.9.6.jar

Looks like 2 version of the cda-core are being installed

Calum