Saiku-adhoc 1.0 GA date filter

[lyywy]

I meet a problem, whether i set any period, it always filters Jan.
I changed IE10, chrome and firefox, it always happens.

I found the SQL is error from Mysql log. the SQL just is filter Jan. period.
seems saiku-adhoc's date picker don't use the date that i selected.

Does anybody have same problem?

I am using pentaho 4.8 and saiku-adhoc 1.0 GA

Cda file detail:

resources admin/resources E9C79ACC-FE56-7E59-9219-71A5FFF7A614 admin/resources/metadata/samdecaux_discount_face.xmi MODEL_1 false -1 Contract head LC_FACT_XSHT_HEAD_HTBJDBH NONE Contract head LC_FACT_XSHT_HEAD_HTBH NONE Contract head BC_FACT_XSHT_HEAD_YDRQ NONE AND [Contract head.BC_FACT_XSHT_HEAD_YDRQ] > [param:F_Contract head_BC_FACT_XSHT_HEAD_YDRQ_FROM] AND [Contract head.BC_FACT_XSHT_HEAD_YDRQ] < [param:F_Contract head_BC_FACT_XSHT_HEAD_YDRQ_TO] ]]> Quotation code Contract code Booking date

[lyywy]

CDA, i am using 13.02.07 (STABLE), installed from Marketplace in Pentaho

[lyywy]

I found it likes #issue 152, anybody can tell me where can get newest version?
i go to http://ci.analytical-labs.com/job/saiku-adhoc-plugin/39/, but it can' run in pentaho 4.8.

[lyywy]

it is solved, thanks

[ncmonger]

How did you solve this?
For me, the filter seems to ignore month difference.
For example, Period From: March 1 and Period To: April 1 did not pull one month's worth of data. It's returns empty set.

[piersharding]

Hi - did anyone solve this, as I have the same problem? The default to/from date is always passed instead of what is selected in the date popup.

Any help would be much appreciated!

Thanks,
Piers Harding.

[lyywy]

hi,
please install newest saiku-adhoc from http://ci.analytical-labs.com/job/saiku-adhoc-plugin/39/

1. Go to biserver-ce/pentaho-solutions/system/saiku-adhoc/lib folder 2. Open cda-TRUNK-SNAPSHOT.jar in rar 3. Add old verion CdaContentGenerator.class to cda-TRUNK-SNAPSHOT\pt\webdetails\cda, CdaContentGenerator.class is in old verson cda-TRUNK-SNAPSHOT.jar
   the attachment is using by me.
   Regards,Wu Yong

Date: Fri, 5 Jul 2013 20:28:14 -0700
From: [email protected]
To: [email protected]
CC: [email protected]
Subject: Re: [saiku-adhoc] Saiku-adhoc 1.0 GA date filter (#181)

Hi - did anyone solve this, as I have the same problem? The default to/from date is always passed instead of what is selected in the date popup.

Any help would be much appreciated!

Thanks,

Piers Harding.

¡ª
Reply to this email directly or view it on GitHub.

[piersharding]

Thanks ever so much for this - it has worked perfectly for me too.

For updating the jar file on ubuntu I did:

copy "new" version of jar to temp after snapshot install

cp cda-TRUNK-SNAPSHOT.jar /tmp/
cd /tmp

make the path for the file to add to jar

mkdir -p pt/webdetails/cda

put class file from "old" jar into directory path

mv CdaContentGenerator.class pt/webdetails/cda/

add to jar

jar uf cda-TRUNK-SNAPSHOT.jar pt/webdetails/cda/CdaContentGenerator.class

now copy this jar back to the saiku-adhoc/lib dir

Cheers,
Piers Harding.

[cgagon]

What was the actual commit that fixed this issue?

[ncmonger]

Before following the steps listed by Piers above, you have to replace the whole pentaho-solutions/system/saiku-adhoc directory with the one unzipped from the #39 build (link repeated here for clarity: http://ci.analytical-labs.com/job/saiku-adhoc-plugin/39/).

Complete Steps:

1. cd /tmp/
2. wget http://ci.analytical-labs.com/job/saiku-adhoc-plugin/39/artifact/saiku-adhoc-plugin/target/saiku-adhoc-plugin-trunk-SNAPSHOT.zip
3. unzip saiku-adhoc-plugin-trunk-SNAPSHOT.zip
4. cd /pentaho/biserver-ce/pentaho-solutions/system
5. mv saiku-adhoc /tmp/.
6. cp -R /tmp/saiku-adhoc .
7. Follow the steps above by Piers Harding.

NOTE: This fixes the problem I mentioned above.