Pentaho Community Forums - BI Platform http://forums.pentaho.com/ BI Server (PCI), Pentaho User Console, Admin Console, Solutions, Design Studio, xactions... en Thu, 23 May 2013 15:46:34 GMT vBulletin 60 http://forums.pentaho.com/images/misc/rss.png Pentaho Community Forums - BI Platform http://forums.pentaho.com/ cda cache inconsistency http://forums.pentaho.com/showthread.php?143083-cda-cache-inconsistency&goto=newpost Thu, 23 May 2013 13:17:42 GMT Hi We have a folder in .../pentaho-solutions in where we store our dashboards and we also have a Public folder within that folder Something like:... Hi

We have a folder in .../pentaho-solutions in where we store our dashboards and we also have a Public folder within that folder
Something like:
.../pentaho-solutions/afolder
.../pentaho-solutions/afolder/Public

for dashboards in .../pentaho-solutions/afolder all is fine.

But, for dashboards in .../pentaho-solutions/afolder/Public the scheduler caches the queries like:
afolder/Public/datasource.cda (as seen in CDA Cache Manager)
When accessing a dashboard via a browser it gets cached like
/afolder/Public/datasource.cda (as seen in CDA Cache Manager)

The extra slash in the beginning makes it so I don't get a match on the scheduled queries and all queries will be ran at runtime.

Anyone else having this problem?

Any leads on how to fix this?

Cheers / Erik ]]> BI Platform ErikAndersson http://forums.pentaho.com/showthread.php?143083-cda-cache-inconsistency Unauthorized Access Error installing plugins from Marketplace http://forums.pentaho.com/showthread.php?143037-Unauthorized-Access-Error-installing-plugins-from-Marketplace&goto=newpost Wed, 22 May 2013 16:18:40 GMT Hi all, i got an error on my pentaho CE deploy. I had set a Pentaho CE server with Active Directory authentication using my own roles definition, all... Hi all, i got an error on my pentaho CE deploy. I had set a Pentaho CE server with Active Directory authentication using my own roles definition, all working good, i can stablish permissions to the reports or cubes based on roles or users, but when i try to install a plugin from the marketplace with any account (including admins) i get this error:

Error installing
Unauthorized Access. Your Pentaho roles do not allow you to make changes to plugins.

where can change the marketplace authentication? i tryed to override permissions on <pentaho-path>/biserver-ce/pentaho-solutions/system/pentaho.xml as this:

 <overrides>
<file path="/pentaho-solutions/admin">
<acl-entry role="Pentaho-Admin" acl="FULL_CONTROL" />
</file>
<file path="/pentaho-solutions/system/marketplace">
<acl-entry role="Pentaho-Admin" acl="FULL_CONTROL" />
</file>
</overrides>

but nothing working, can someone help me???
 ]]> BI Platform alucard1626 http://forums.pentaho.com/showthread.php?143037-Unauthorized-Access-Error-installing-plugins-from-Marketplace unable to start BI server with jdk or jre 1.6 - but with jre 1.7 works http://forums.pentaho.com/showthread.php?143029-unable-to-start-BI-server-with-jdk-or-jre-1-6-but-with-jre-1-7-works&goto=newpost Wed, 22 May 2013 14:26:55 GMT As in the subject line I can't start the BI server (4.8 stable) using jre or jdk 1.6 (update 45) on my linux (RH) test server.
I get this error message from catalina.out "Error occurred during initialization of VM. java/lang/NoClassDefFoundError: java/lang/Object"
But I had also unziped into a directory the jre 1.7 (update 21) and pointing at it into the start-pentaho.sh file (just changing the export JAVA_HOME line), and everything works fine!!
I must use the 1.6 version for compatibility so I can't run the server using the workaround above.
Thanks for the help
Matteo ]]> BI Platform bllmtt http://forums.pentaho.com/showthread.php?143029-unable-to-start-BI-server-with-jdk-or-jre-1-6-but-with-jre-1-7-works Upgrade BI server 3.8 to 4.5 http://forums.pentaho.com/showthread.php?143005-Upgrade-BI-server-3-8-to-4-5&goto=newpost Wed, 22 May 2013 06:05:42 GMT Hi, In our current production environment we are using BI Server 3.8 stable version. Now we want to upgrade BI Server to 4.5 stable version. I... Hi,

In our current production environment we are using BI Server 3.8 stable version. Now we want to upgrade BI Server to 4.5 stable version.

I didn't got any documentation about upgrade process. Can I get any help on this ?

Thanks,
Krishna Gawade. ]]> BI Platform gawadesk http://forums.pentaho.com/showthread.php?143005-Upgrade-BI-server-3-8-to-4-5 Pentaho on existing Tomcat 7 http://forums.pentaho.com/showthread.php?143004-Pentaho-on-existing-Tomcat-7&goto=newpost Wed, 22 May 2013 06:03:49 GMT Hi,

I wonder if there is a way to run Pentaho Web application on existing Tomcat 7 as standard war (not have to be closed war) ?

I'm not familiar with BI server that comes by default with Pentaho installation. Actually, I see Tomcat inside and not sure what additional things BI server adds.


Thanks,
Pavel ]]> BI Platform pavel.orehov http://forums.pentaho.com/showthread.php?143004-Pentaho-on-existing-Tomcat-7 <![CDATA[Can't save analysis view on BI server]]> http://forums.pentaho.com/showthread.php?142988-Can-t-save-analysis-view-on-BI-server&goto=newpost Tue, 21 May 2013 22:07:45 GMT I developed a OLAP schema using pentaho schema workbench, published to BI server successfully. Then I used new analysis view to prepare a special... I developed a OLAP schema using pentaho schema workbench, published to BI server successfully. Then I used new analysis view to prepare a special view for my purpose. When I saved the view but got "ANALYSISSAVER.ERROR_0006 - Save is disabled". I googled around but couldn't find right answer. Not sure if anyone had same issue as mine.

A few days back, I could save these view to files, not sure why I can't do it now. Also there is no errors from log files for this action.

I attached the error image for your reference. I use Pentaho Community BI 4.8.

Thanks a lot.
Attached Images
]]> BI Platform brightlee6 http://forums.pentaho.com/showthread.php?142988-Can-t-save-analysis-view-on-BI-server Scheduling a dynamic xaction calling PDI Component http://forums.pentaho.com/showthread.php?142967-Scheduling-a-dynamic-xaction-calling-PDI-Component&goto=newpost Tue, 21 May 2013 12:30:26 GMT Hi, I have an xaction which accepts dynamic parameters and pass the parameters to a PDI Job which executes accordingly. Each time the parameter... Hi,

I have an xaction which accepts dynamic parameters and pass the parameters to a PDI Job which executes accordingly. Each time the parameter value only gets changed but the job will be constant. What I want to do is, If first time, the parameters are passed, I want to schedule and run the xaction or PDI job with the given parameters. So, each time if the scheduled job or xaction runs, it should use the same parameter.

Likewise , using the same job , I will schedule different times but my parameter will have to get changed accordingly . How to do that ?

How to implement scheduling for xaction other Pentaho Admin Console ? ]]> BI Platform satran http://forums.pentaho.com/showthread.php?142967-Scheduling-a-dynamic-xaction-calling-PDI-Component <![CDATA[The entity "nbsp" was referenced but not declared]]> http://forums.pentaho.com/showthread.php?142901-The-entity-quot-nbsp-quot-was-referenced-but-not-declared&goto=newpost Mon, 20 May 2013 08:31:39 GMT I just saw this error message for the first time on the console since I can neither refreshr the global variable BI or anything when I try to... I just saw this error message for the first time on the console since I can neither refreshr the global variable BI or anything
when I try to refresh the global variables for example I see this message:
[fr_71] Error while trying to execute startup sequence for org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener</td></tr>

also when I try accessing the Pentaho User Console I see this error message
The following errors were detected
[fr_49] One or more system listeners failed. These are set in the systemListeners.xml.
PentahoSystem.ERROR_0014 - [fr_71] Error while trying to execute startup sequence for org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener

Please see the server console for more details on each error detected. ]]> BI Platform Rouhida http://forums.pentaho.com/showthread.php?142901-The-entity-quot-nbsp-quot-was-referenced-but-not-declared sql server data not loaded on report http://forums.pentaho.com/showthread.php?142896-sql-server-data-not-loaded-on-report&goto=newpost Mon, 20 May 2013 06:38:55 GMT Hi everyone,
First I should say that I'm really excited with the whole product.The whole package is fantastic. Then I have encountered an issue, I have created a report in designer and published the report successfully on BI server v3.9.0 community edition. while on report designer I see the output, but on user-console nothing is presented. I have configured the JDBC and database connection but still no changes.
Something else is that I don't see anything event static texts in PDF output format.

thank in prior

A.H. ]]> BI Platform alihonarmand http://forums.pentaho.com/showthread.php?142896-sql-server-data-not-loaded-on-report <![CDATA[[JAVA] How to get user password in administration console]]> http://forums.pentaho.com/showthread.php?142770-JAVA-How-to-get-user-password-in-administration-console&goto=newpost Fri, 17 May 2013 15:00:31 GMT Hi everyone,

I'm currently adding some functionnalities to my pentaho administration console and I would need to get the user selected password.

In a first time, in the ProxyPentahoUser class, the password value was set to "" by default so I removed it but nothing seems to work...

So, has anyone an idea about how to deal with that ?

Thanks ! ]]> BI Platform pentaUser http://forums.pentaho.com/showthread.php?142770-JAVA-How-to-get-user-password-in-administration-console Penataho Dashboard design http://forums.pentaho.com/showthread.php?142685-Penataho-Dashboard-design&goto=newpost Thu, 16 May 2013 05:37:40 GMT I want to develope Dashboard. Can someone provide Guidelines for developing Dashboard using Pentaho Dashboard. Thanks. I want to develope Dashboard. Can someone provide Guidelines for developing Dashboard using Pentaho Dashboard.

Thanks. ]]> BI Platform hitesh http://forums.pentaho.com/showthread.php?142685-Penataho-Dashboard-design config c3p0 which create to many connection http://forums.pentaho.com/showthread.php?142680-config-c3p0-which-create-to-many-connection&goto=newpost Thu, 16 May 2013 04:25:06 GMT Dear All,
I am using c3p0 to solve the problem that server will inactive after 8 hours. However, When I using c3po I have new issue that it's create too many sleeping connection. This is my mysql5.hibernate.cfg.xml file
<hibernate-configuration><session-factory>
<!--
hibernate c3p0 settings
-->
<property name="connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hibernate.c3p0.acquire_increment">3</property>
<property name="hibernate.c3p0.idle_test_period">10</property>
<property name="hibernate.c3p0.min_size">5</property>
<property name="hibernate.c3p0.max_size">75</property>
<property name="hibernate.c3p0.maxIdleTime">1800</property>
<property name="hibernate.c3p0.max_statements">0</property>
<property name="hibernate.c3p0.timeout">25200</property>
<property name="hibernate.c3p0.preferredTestQuery">select 1</property>
<property name="hibernate.c3p0.testConnectionOnCheckout">true</property>
<!--
hibernate cache settings
-->
<property name="cache.provider_class">org.hibernate.cache.EhCacheProvider</property>
<property name="hibernate.generate_statistics">true</property>
<property name="hibernate.cache.use_query_cache">true</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost:3306/hibernate</property>
<property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
<property name="connection.username">root</property>
<property name="connection.password">password</property>
<property name="connection.pool_size">10</property>
<property name="show_sql">false</property>
<property name="hibernate.jdbc.use_streams_for_binary">true</property>
<property name="hibernate.hbm2ddl.auto">update</property>
<mapping resource="hibernate/mysql5innodb.hbm.xml"/>
<mapping resource="PentahoUser.hbm.xml"/>
<mapping resource="PentahoRole.hbm.xml"/>
<mapping resource="PentahoUserRoleMapping.hbm.xml"/>
</session-factory>
</hibernate-configuration>

I execute a "SHOW PROCESSLIST" command and it show too many Sleep connection.How can I fix this problem ?

185 | root | localhost:52944 | hibernate | Sleep | 8 | | NULL

thankyou very much ]]> BI Platform sacpv04 http://forums.pentaho.com/showthread.php?142680-config-c3p0-which-create-to-many-connection Pentaho User Console http://forums.pentaho.com/showthread.php?142674-Pentaho-User-Console&goto=newpost Thu, 16 May 2013 01:23:05 GMT Hi al... I just want to know, can we show the report to our own website? Just only show the report,without any template from pentaho. Any can... Hi al...

I just want to know, can we show the report to our own website? Just only show the report,without any template from pentaho.

Any can help me? Please..... ]]> BI Platform MOHD HISYAMMUDIN http://forums.pentaho.com/showthread.php?142674-Pentaho-User-Console Close window in Log out http://forums.pentaho.com/showthread.php?142652-Close-window-in-Log-out&goto=newpost Wed, 15 May 2013 16:40:46 GMT Log Out Can you help me please? I want to close the window and close the session at the...]]> I need to close the window when the user clicks on File -> Log Out
Can you help me please? I want to close the window and close the session at the same time.. ]]> BI Platform diegoruizg http://forums.pentaho.com/showthread.php?142652-Close-window-in-Log-out Pentaho BI platform x64 http://forums.pentaho.com/showthread.php?142620-Pentaho-BI-platform-x64&goto=newpost Wed, 15 May 2013 09:29:29 GMT Hi guys, I am new to Pentaho so I am sorry if my questions are bad/dumb. I downloaded Pentaho BI server from... Hi guys,

I am new to Pentaho so I am sorry if my questions are bad/dumb.

I downloaded Pentaho BI server from http://sourceforge.net/projects/pent...?source=navbar

But there is only a x86 version.

I am trying to install it on a MS Server 2008R2 x64 and I need a x86 version of the installer.

Does anyone knows where to find it?

Thanks in advance ]]> BI Platform tljubas http://forums.pentaho.com/showthread.php?142620-Pentaho-BI-platform-x64 Source code location http://forums.pentaho.com/showthread.php?142592-Source-code-location&goto=newpost Tue, 14 May 2013 22:14:35 GMT Hi,

I'm looking for the Pentaho CE 4.8 source code to download. i downloaded a zip file called pentaho-platform-master.zip at https://github.com/pentaho/pentaho-platform which seems to be the right one. Is it, I'm new at java? Thanks.

Kevin Struckhoff
eBay ]]> BI Platform struckhoffk http://forums.pentaho.com/showthread.php?142592-Source-code-location Cascading Parameters Error http://forums.pentaho.com/showthread.php?142529-Cascading-Parameters-Error&goto=newpost Mon, 13 May 2013 22:05:46 GMT When I try to run a report with cascading parameters,I am getting a query failed message in the error log with the error "ParentException:
java.sql.SQLException: Statement is unsupported while there is a cursor open on a Vectorwise table" and Error parsing parameter information alert on the user console screen. This happens when the report is ran for the first time.It works fine when ran for the second time.The sql works fine when previewed in the report designer.

Not sure if there is some thing that has to be changed in the code for the cursors.Please let me know if any one of you have dealt with this issue before or any ideas how to fix this.

Thanks. ]]> BI Platform dsoumya http://forums.pentaho.com/showthread.php?142529-Cascading-Parameters-Error Set domain name to pentaho system http://forums.pentaho.com/showthread.php?142480-Set-domain-name-to-pentaho-system&goto=newpost Mon, 13 May 2013 07:02:45 GMT Hi All. We are just starting with pentaho BI system integration in our company. We have decided to put Pentaho User Consule as an IFrame in our... Hi All.
We are just starting with pentaho BI system integration in our company.
We have decided to put Pentaho User Consule as an IFrame in our backoffice.
As such, I need the Pentaho IFrame will be streach according to his content(the Pentaho User Consule).
I already found a solution for this but I have to sstretch et the domain name of the Pentaho User Consule in a JavaScript.
My question is: is there a specific javascript file or any segment of javascript code that loads in any page of the user consule so I can plane my javascript in?
the line is very simple: document.domain="mydomain.com".

any help will be appriciated.

Thank,
Avi ]]> BI Platform avig http://forums.pentaho.com/showthread.php?142480-Set-domain-name-to-pentaho-system Installing BI Server CE on an existing Windows and Tomcat 7 server http://forums.pentaho.com/showthread.php?142362-Installing-BI-Server-CE-on-an-existing-Windows-and-Tomcat-7-server&goto=newpost Fri, 10 May 2013 15:48:00 GMT Hey, I have googled a little bit but found nothing. Is there a tutorial or manual available that guides me through the steps of installing the... Hey,

I have googled a little bit but found nothing. Is there a tutorial or manual available that guides me through the steps of installing the Pentaho BI server CE into an existing Tomcat 7 installation with a Postgres database in the background?

Thanks for any advice!

Bobse ]]> BI Platform Bobse http://forums.pentaho.com/showthread.php?142362-Installing-BI-Server-CE-on-an-existing-Windows-and-Tomcat-7-server runing pentaho in liferay http://forums.pentaho.com/showthread.php?142360-runing-pentaho-in-liferay&goto=newpost Fri, 10 May 2013 15:20:03 GMT Hi all I am about developing an academic project and I need to run Pentaho bi in Liferay Portal. I did some googling and found some old documents... Hi all
I am about developing an academic project and I need to run Pentaho bi in Liferay Portal.
I did some googling and found some old documents in liferay website but it is so old and it does not provide enough explainations

any help provided is largely welcomen and will be appreciated.

many thanks ]]> BI Platform raccio http://forums.pentaho.com/showthread.php?142360-runing-pentaho-in-liferay Penatho Enterprise Edition http://forums.pentaho.com/showthread.php?142344-Penatho-Enterprise-Edition&goto=newpost Fri, 10 May 2013 10:24:47 GMT Hi I have been using penatho Enterprise Edition, but it will not allow some functionalities like BA server,UserConsole,Enterprise Console after... Hi

I have been using penatho Enterprise Edition, but it will not allow some functionalities like BA server,UserConsole,Enterprise Console after 30days of its installation..
Now my Question is Is there any way to run the developed reports and any works which have developed in the tool can be run on anyother application servers like JBoss,Is it Possible or not?
If possible can you provide me any doc or guidance for doing that..


Thanks In Advance
Abhishek D ]]> BI Platform Abhishek Dhavala http://forums.pentaho.com/showthread.php?142344-Penatho-Enterprise-Edition PacService.ERROR_0025 - Connection attempt failed... http://forums.pentaho.com/showthread.php?142285-PacService-ERROR_0025-Connection-attempt-failed&goto=newpost Thu, 09 May 2013 11:35:37 GMT Hi,

I am trying to setup an installation of biserver-ce.4.8.0 and I just can't seem to add a database connection in the administration console. No matter what I try I keep getting this:

Code:
PacService.ERROR_0025 - Connection attempt failed: No suitable driver found for jdbc:mysqldb:mysql:localhost3306/[databasename]
whats wrong with the driver in /administration-console/jdbc?

Any ideas? ]]> BI Platform eag http://forums.pentaho.com/showthread.php?142285-PacService-ERROR_0025-Connection-attempt-failed continue customize mantle folder pentaho http://forums.pentaho.com/showthread.php?142267-continue-customize-mantle-folder-pentaho&goto=newpost Thu, 09 May 2013 04:35:43 GMT Dear all, My Pentaho User Console do not display the Browser at first time login.I know we must to change property showSolutionBrowser from false... Dear all,
My Pentaho User Console do not display the Browser at first time login.I know we must to change property showSolutionBrowser from false to true in SolutionBrowserPerspective class.But In my case,I can not build new matle zip to change.I keep continous process of mantle folder which the previous persion created. How can I do for this problem ?

thankyou very much ]]> BI Platform sacpv04 http://forums.pentaho.com/showthread.php?142267-continue-customize-mantle-folder-pentaho Error loading database connection in admin user console. http://forums.pentaho.com/showthread.php?142223-Error-loading-database-connection-in-admin-user-console&goto=newpost Wed, 08 May 2013 10:15:10 GMT Dear all,I have a problem in admin user console that When I log on to admin user console screen, I have receive this error

"Error Loading Database Connection
Unable to refresh database connection list: The call failed on the server; see server log for details"

In Administration does not load any things,I try to create new and it show error. How can I fix this problem ?
thankyou vey much
pentahoserver1.jpg

Attached Images
]]> BI Platform sacpv04 http://forums.pentaho.com/showthread.php?142223-Error-loading-database-connection-in-admin-user-console Xaction (Export to xls) http://forums.pentaho.com/showthread.php?142214-Xaction-(Export-to-xls)&goto=newpost Wed, 08 May 2013 08:06:14 GMT It is possible in Pentaho 3.5.2 to make an action sequence (xaction) to export a report created in birt performed in excel format xls? From the... It is possible in Pentaho 3.5.2 to make an action sequence (xaction) to export a report created in birt performed in excel format xls?

From the design studio, the avaliable options are: html/pdf

Thanks in advance ]]> BI Platform juarodco http://forums.pentaho.com/showthread.php?142214-Xaction-(Export-to-xls) How to recalculate measure based on filtered values http://forums.pentaho.com/showthread.php?142157-How-to-recalculate-measure-based-on-filtered-values&goto=newpost Tue, 07 May 2013 07:42:11 GMT Hi all, I am a newbie in SSAS, I have encountered a minor issues in cube and I cant solve it in many days Please help me this, I very appreciate... Hi all,

I am a newbie in SSAS, I have encountered a minor issues in cube and I cant solve it in many days
Please help me this, I very appreciate your ideas.

My cube has a measure that shows the percentage.
The percentage does not displays correctly when we use filter. For example:
• Without filter any dimensions, it is correct
Age Percentage
15 - 24 11.64%
25 - 24 24.21%
35 - 44 24.03%
45 - 54 20.17%
55 - 64 12.92%
65+ 6.66%
Do not know 0.38%
Grand Total 100.00%

• With filter Gender=Male (or any dimensions), it likes this.
Age Percentage
15 - 24 4.72%
25 - 24 13.55%
35 - 44 15.87%
45 - 54 13.52%
55 - 64 8.07%
65+ 3.66%
Do not know 0.18%
Grand Total 59.58%

what I expect that it should be 100% in Grand Total and the percentage of each category must be recalculated.

Many thanks ! ]]> BI Platform komaty http://forums.pentaho.com/showthread.php?142157-How-to-recalculate-measure-based-on-filtered-values Report Data From Hive http://forums.pentaho.com/showthread.php?142106-Report-Data-From-Hive&goto=newpost Mon, 06 May 2013 10:07:40 GMT firstly i want know if is possible creating a hive data source in Pentaho BI Server CE. If is possible i need help to create a new hive data... firstly i want know if is possible creating a hive data source in Pentaho BI Server CE.
If is possible i need help to create a new hive data source. I installed Cloudera CDH4 in my VW, now i need create my datasource of Hive in my Pentaho BI server.


Regards

Kelton ]]> BI Platform mr_kapa_23 http://forums.pentaho.com/showthread.php?142106-Report-Data-From-Hive MDX question http://forums.pentaho.com/showthread.php?142075-MDX-question&goto=newpost Sun, 05 May 2013 19:31:37 GMT I have such a fact table Payment: paymentID, abonentID, serviceID ....., OrganizationName That is, the organization is not a dimension. How do I... I have such a fact table Payment:
paymentID, abonentID, serviceID ....., OrganizationName
That is, the organization is not a dimension. How do I receive only payments for a particular organization? ]]> BI Platform Kouki http://forums.pentaho.com/showthread.php?142075-MDX-question Birt and export excel Pentaho (xaction) http://forums.pentaho.com/showthread.php?142012-Birt-and-export-excel-Pentaho-(xaction)&goto=newpost Sat, 04 May 2013 10:07:04 GMT It is possible in pentaho to make an action sequence (xaction) to export a report created in birt performed in excel format xls? From the design... It is possible in pentaho to make an action sequence (xaction) to export a report created in birt performed in excel format xls?

From the design studio, the avaliable options are: html/pdf

Thanks in advance ]]> BI Platform juarodco http://forums.pentaho.com/showthread.php?142012-Birt-and-export-excel-Pentaho-(xaction) Xaction with TreeView http://forums.pentaho.com/showthread.php?141963-Xaction-with-TreeView&goto=newpost Fri, 03 May 2013 11:53:45 GMT Hello everybody,

My final idea is this but i don't know how to do. Now i intend something. I try with creating new JPivot with the jsp of JPivot changing it and with analyzer xaction and this new jsp with Jpivot code try to create de Data Tree. I look the CCC data tree but i dont' know how to use .

I use a Windows XP Machine i say this cause I look tha pmalves say(in a post) that somewhere was examples but that examples was for linux(sh files). ]]> BI Platform Emilio1985 http://forums.pentaho.com/showthread.php?141963-Xaction-with-TreeView Scheduled reports randomly stop working http://forums.pentaho.com/showthread.php?141956-Scheduled-reports-randomly-stop-working&goto=newpost Fri, 03 May 2013 09:59:13 GMT I have a scheduled report using a public schedule on Pentaho Community Edition 4.8 The set up is very basic: one report with fixed parameters sent... I have a scheduled report using a public schedule on Pentaho Community Edition 4.8

The set up is very basic: one report with fixed parameters sent to the same recipients every workday.

Every time I set it up, the report runs as scheduled and gets sent. Then, it stops being sent. I have to re-schedule (and sometimes even that doesn't work).

There's nothing on catalina.out or pentaho.log about it.

Has anyone had this problem?

Where else can I look for quartz logs?

Is there a way to "force" the execution of the schedule with cron? ]]> BI Platform depr001 http://forums.pentaho.com/showthread.php?141956-Scheduled-reports-randomly-stop-working Scheduler error http://forums.pentaho.com/showthread.php?141916-Scheduler-error&goto=newpost Thu, 02 May 2013 19:12:26 GMT Hi, I just installed the BI Server Release 4.8.0.stable.51169 on a Windows 2008 Server. I created no new action sequences. I keep getting the... Hi,

I just installed the BI Server Release 4.8.0.stable.51169 on a Windows 2008 Server. I created no new action sequences.

I keep getting the following error:

ERROR [org.pentaho.platform.engine.services.solution.SolutionEngine] e6c0f545-b35a-11e2-897c-f1aab9c9d5bf:SOLUTION-ENGINE:scheduler.xaction: Action Sequence execution failed, see details below| Error Time: Quinta-feira, 2 de Maio de 2013 16h02min57s GMT-03:00
| Session ID: scheduler.xaction
| Instance Id: e6c0f545-b35a-11e2-897c-f1aab9c9d5bf
| Action Sequence: scheduler.xaction
| Execution Stack:
EXECUTING ACTION: Scheduler (org.pentaho.platform.engine.services.solution.PojoComponent)
| Action Class: org.pentaho.platform.engine.services.solution.PojoComponent
| Action Desc: Scheduler
| Loop Index (1-based): 0
Stack Trace:org.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 - [pt_18] Activity failed to execute
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeComponent(RuntimeContext.java:1325)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeAction(RuntimeContext.java:1262)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.performActions(RuntimeContext.java:1161)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeLoop(RuntimeContext.java:1105)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:987)
at org.pentaho.platform.engine.services.runtime.RuntimeContext.executeSequence(RuntimeContext.java:897)
at org.pentaho.platform.engine.services.solution.SolutionEngine.executeInternal(SolutionEngine.java:399)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:317)
at org.pentaho.platform.engine.services.solution.SolutionEngine.execute(SolutionEngine.java:193)
at org.pentaho.platform.engine.services.BaseRequestHandler.handleActionRequest(BaseRequestHandler.java:159)
at org.pentaho.platform.scheduler.QuartzExecute.execute(QuartzExecute.java:198)
at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)

Anyone knows what is causing it? ]]> BI Platform lgallindo http://forums.pentaho.com/showthread.php?141916-Scheduler-error DEsgion studio 4.0:Xaction Get Data from OLAP cientific expresion http://forums.pentaho.com/showthread.php?141889-DEsgion-studio-4-0-Xaction-Get-Data-from-OLAP-cientific-expresion&goto=newpost Thu, 02 May 2013 09:15:09 GMT Hello everybody,

I have a strange problem and i think cause Get data from OLAP because de same sentence in the JPIvot Analysis viewer don't do that. I have a MDX sentence like this:

With Member Measures.estadistica as
SUM({Crossjoin(Crossjoin({[Comercial].[{parametrocomer}]},
{[Empresa].[{parametronombre}]}),
{[Fecha].[{parametroanyo}]})},Measures.[Ventas] )/
SUM({Crossjoin(Crossjoin({[Comercial].[All Comercials]},
{[Empresa].[{parametronombre}]}),
{[Fecha].[{parametroanyo}]})},Measures.[Ventas] ) *100
member [Measures].[suma] as (Sum({Crossjoin(Crossjoin({[Comercial].[{parametrocomer}]}, {[Empresa].[{parametronombre}]}), {[Fecha].[{parametroanyo}]})}, [Measures].[Ventas]))

select NON EMPTY {[Measures].estadistica,[Measures].suma} ON COLUMNS,
NON EMPTY [Articulo].[All Articulos] ON ROWS
from [CapriCubeDEmo]

select NON EMPTY {[Measures].estadistica,[Measures].suma} ON COLUMNS,
NON EMPTY [Articulo].[All Articulos] ON ROWS
from [CapriCubeDEmo]

The sentece is perfect but when it return a SUM with values > 9.999.999,99 then it returns like this
1.241985901E7(cientific expresion) and not this 12.419.859,01. Why? in Analyzer rusn perfect but in the Get Data from OLAP runs(Xaction).

Thanks. ]]> BI Platform Emilio1985 http://forums.pentaho.com/showthread.php?141889-DEsgion-studio-4-0-Xaction-Get-Data-from-OLAP-cientific-expresion Admin Console (Community) import username password roles from oracle db to hibernate http://forums.pentaho.com/showthread.php?141868-Admin-Console-(Community)-import-username-password-roles-from-oracle-db-to-hibernate&goto=newpost Wed, 01 May 2013 23:36:20 GMT Hi guys,

Sorry, I'm newbies. Would like to know, is it possible to import username, password, roles from oracle db to hibernate sql (default used by Pentaho)? or is there any other solution to use username, password and roles directly from oracle db without import to hibernate sql.

Currently I'm working with the Pentaho Community BI 4.8.0-stable.

Thanks. ]]> BI Platform mal http://forums.pentaho.com/showthread.php?141868-Admin-Console-(Community)-import-username-password-roles-from-oracle-db-to-hibernate Error parsing parameter information error when I run a report http://forums.pentaho.com/showthread.php?141852-Error-parsing-parameter-information-error-when-I-run-a-report&goto=newpost Wed, 01 May 2013 17:32:49 GMT When I run the report with cascading parameters for the 1st time I get an error "Error parsing parameter information". When I run it 2nd time it runs fine from then.

Here is the error msg from the error log file.

ParentException:
java.sql.SQLException: Statement is unsupported while there is a cursor open on a Vectorwise table.

Could any one please help me with this. Thanks.

Regards,
Sow.
Attached Images
]]> BI Platform sowjanya http://forums.pentaho.com/showthread.php?141852-Error-parsing-parameter-information-error-when-I-run-a-report Parameter parsing error while opening a report http://forums.pentaho.com/showthread.php?141814-Parameter-parsing-error-while-opening-a-report&goto=newpost Tue, 30 Apr 2013 23:50:02 GMT I have a problem opening a report having cascading parameters for the first time in PUC. If I open the second time it runs fine from then. Could some... I have a problem opening a report having cascading parameters for the first time in PUC. If I open the second time it runs fine from then. Could some one help me with this.


Here is the error form error log file.

ParentException:
java.sql.SQLException: Statement is unsupported while there is a cursor open on a Vectorwise table.

Regards,
Sow.
Attached Images
]]> BI Platform sowjanya http://forums.pentaho.com/showthread.php?141814-Parameter-parsing-error-while-opening-a-report file based triggering in design studio http://forums.pentaho.com/showthread.php?141764-file-based-triggering-in-design-studio&goto=newpost Tue, 30 Apr 2013 07:31:00 GMT is it possible to do file based triggering in Design Studio? my requirement is when ever a file comes in to a directory a job should trigger and... is it possible to do file based triggering in Design Studio?

my requirement is when ever a file comes in to a directory a job should trigger and execute the file.


please help me out....

thanks in Advance ]]> BI Platform lakshmi bolineni http://forums.pentaho.com/showthread.php?141764-file-based-triggering-in-design-studio Ajax report using xaction http://forums.pentaho.com/showthread.php?141742-Ajax-report-using-xaction&goto=newpost Mon, 29 Apr 2013 20:05:09 GMT My goal is to write an html page that accesses data from pentaho via an ajax call to an xaction and then to render the response using some js... My goal is to write an html page that accesses data from pentaho via an ajax call to an xaction and then to render the response using some js charting library (highcharts, for example). I would like to build a folder structure in the pentaho-solutions directory that allows me to share code across common reports (see below).

I have an xaction working that will retrieve data from Pentaho and return it in json format. All I need to do is figure out where these html and supporting files can live and be referenced from. My preference is to have them live next to, or near the xaction files.

If this isn't the best approach to building these types of reports, I'm all ears. I've done research and haven't found anything that solves my problem.

Some url like this, maybe?
http://mydomain.com/pentaho/solution...foo&param2=bar

Pentaho-solutions
..mydirectory
….reports
……reportname1 (or any other report name)
……..index.html (the html page that the xaction would redirect to)
……..data.xaction (the xaction that returns data for the ajax call)
……libs (for common files used amongst all xaction reports)
……..jquery.js
……..highcharts.js (and any other common charting libraries)
……..shared.js (some common js code)
……..shared.css (shared styles so that all reports look the same) ]]> BI Platform jgormley http://forums.pentaho.com/showthread.php?141742-Ajax-report-using-xaction Login Error Pentaho User Console http://forums.pentaho.com/showthread.php?141737-Login-Error-Pentaho-User-Console&goto=newpost Mon, 29 Apr 2013 17:53:49 GMT Hi,
I've created two roles (ROLE1 and ROLE2) and two users (USER1 and USER2) with Pentaho Administration Console and I've assigned the USER1 to the ROLE1 and the USER2 to the ROLE2. I can't login with this two users at Pentaho User Console.

Can anyone help me? Is not enough to set roles and users using the PAC? Is there some configuration file to be modified?

Thank you :D ]]> BI Platform lg89 http://forums.pentaho.com/showthread.php?141737-Login-Error-Pentaho-User-Console Connect Cloudera CDH4 in Pentaho BI Server 4 http://forums.pentaho.com/showthread.php?141709-Connect-Cloudera-CDH4-in-Pentaho-BI-Server-4&goto=newpost Mon, 29 Apr 2013 10:16:52 GMT Hello,
I'm new in Pentaho, and i need connect my bi server with cloudera cdh4.




i already have my pentaho prepared to Cloudera CDH 4 (http://wiki.pentaho.com/display/BAD/...+Cloudera+CDH4) now i need create a new datasouce in my pentaho.


Someone can help me? ]]> BI Platform mr_kapa_23 http://forums.pentaho.com/showthread.php?141709-Connect-Cloudera-CDH4-in-Pentaho-BI-Server-4 PAD - Is there any way to place aggregation tables to different schema? http://forums.pentaho.com/showthread.php?141705-PAD-Is-there-any-way-to-place-aggregation-tables-to-different-schema&goto=newpost Mon, 29 Apr 2013 09:01:55 GMT Could someone, pls, advice me, how to place aggregation tables to db schema, separate from main facts table? Is it possible? Could someone, pls, advice me, how to place aggregation tables to db schema, separate from main facts table?
Is it possible? ]]> BI Platform wipiton http://forums.pentaho.com/showthread.php?141705-PAD-Is-there-any-way-to-place-aggregation-tables-to-different-schema Schedule ETL transformation using BI server http://forums.pentaho.com/showthread.php?141696-Schedule-ETL-transformation-using-BI-server&goto=newpost Mon, 29 Apr 2013 06:38:11 GMT How to schedule an ETL transformation in BI Server community edition.... How to schedule an ETL transformation in BI Server community edition.... ]]> BI Platform harsha249 http://forums.pentaho.com/showthread.php?141696-Schedule-ETL-transformation-using-BI-server Error: Creating Adhoc report with Sql Serverconnection http://forums.pentaho.com/showthread.php?141568-Error-Creating-Adhoc-report-with-Sql-Serverconnection&goto=newpost Fri, 26 Apr 2013 14:08:04 GMT Hi, I created a JNDI connection in Admin Console for a SQL Server 2008 R2 database with JTDS driver 1.2.4. Test connection was successful. But... Hi,

I created a JNDI connection in Admin Console for a SQL Server 2008 R2 database with JTDS driver 1.2.4. Test connection was successful. But when I try to create adhoc-report in BI Serve. I get the error message like below:

Pentaho error: "unable to generate model: java.lang.runtimeException: Jdbc URL jdbc:jtds;SqlServer..... does not start with jdbc:jtds:SqlSever..."

Please jelp me. ]]> BI Platform rvmahadevan http://forums.pentaho.com/showthread.php?141568-Error-Creating-Adhoc-report-with-Sql-Serverconnection Could any one help me with my install problem (WIN XP+4.8.0) http://forums.pentaho.com/showthread.php?141541-Could-any-one-help-me-with-my-install-problem-(WIN-XP-4-8-0)&goto=newpost Fri, 26 Apr 2013 01:45:51 GMT And I tried to connect it with mysql 5.6 just like I did with 4.5.0 I dont have this with 4.5.0 , but with 4.8.0 just cant start the service :( ... And I tried to connect it with mysql 5.6 just like I did with 4.5.0
I dont have this with 4.5.0 ,
but with 4.8.0 just cant start the service :(

thanx in advance!

2013-04-26 09:26:41,843 ERROR [org.springframework.web.context.ContextLoader] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'filterChainProxy' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authenticationProcessingFilter' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security.xml]: Cannot resolve reference to bean 'authenticationManager' while setting bean property 'authenticationManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authenticationManager' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security.xml]: Cannot resolve reference to bean 'daoAuthenticationProvider' while setting bean property 'providers' with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'daoAuthenticationProvider' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security-hibernate.xml]: Cannot resolve reference to bean 'userDetailsService' while setting bean property 'userDetailsService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userDetailsService' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security-hibernate.xml]: Cannot resolve reference to bean 'userRoleDao' while setting bean property 'userRoleDao'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userRoleDao' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security-hibernate.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security-hibernate.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.mysqlDialect
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:473)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:164)
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:429)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:728)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:380)
at org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:255)
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:199)
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:45)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4135)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4630)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:445)
at org.apache.catalina.core.StandardService.start(StandardService.java:519)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
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:601)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authenticationProcessingFilter' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security.xml]: Cannot resolve reference to bean 'authenticationManager' while setting bean property 'authenticationManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'authenticationManager' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security.xml]: Cannot resolve reference to bean 'daoAuthenticationProvider' while setting bean property 'providers' with key [0]; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'daoAuthenticationProvider' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security-hibernate.xml]: Cannot resolve reference to bean 'userDetailsService' while setting bean property 'userDetailsService'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userDetailsService' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security-hibernate.xml]: Cannot resolve reference to bean 'userRoleDao' while setting bean property 'userRoleDao'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'userRoleDao' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security-hibernate.xml]: Cannot resolve reference to bean 'sessionFactory' while setting bean property 'sessionFactory'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sessionFactory' defined in file [D:\kettle\48\biserver-ce\pentaho-solutions\system\applicationContext-spring-security-hibernate.xml]: Invocation of init method failed; nested exception is org.hibernate.HibernateException: Dialect class not found: org.hibernate.dialect.mysqlDialect
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:275)
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:104)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1245)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1010)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:472)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:380)
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:264)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:261)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:185)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:168)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:884)
at org.springframework.security.intercept.web.FIDSToFilterChainMapConverter.<init>(FIDSToFilterChainMapConverter.java:54)
at org.springframework.security.util.FilterChainProxy.afterPropertiesSet(FilterChainProxy.java:119)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
... 39 more ]]> BI Platform pianaish http://forums.pentaho.com/showthread.php?141541-Could-any-one-help-me-with-my-install-problem-(WIN-XP-4-8-0) how to write xaction file http://forums.pentaho.com/showthread.php?141511-how-to-write-xaction-file&goto=newpost Thu, 25 Apr 2013 15:02:39 GMT How to write xaction file to run a particular transformation in bi server. Here the input is taken from the database and output is stored to a... How to write xaction file to run a particular transformation in bi server. Here the input is taken from the database and output is stored to a database? ]]> BI Platform harsha249 http://forums.pentaho.com/showthread.php?141511-how-to-write-xaction-file Integration Questions, SSO with JAAS and customized filtering possibilities http://forums.pentaho.com/showthread.php?141490-Integration-Questions-SSO-with-JAAS-and-customized-filtering-possibilities&goto=newpost Thu, 25 Apr 2013 07:46:42 GMT Good Morning, 1) Im currently running pentaho webapplication on a jboss where i also deployed my custom webapplication which uses the jboss jaas... Good Morning,

1) Im currently running pentaho webapplication on a jboss where i also deployed my custom webapplication which uses the jboss jaas authentication.
Is it possible to configure pentaho to use also the jaas authentication module? (And if its possible is there a how to?, i searched though the forum and wiki but i only find other sso techniques.)

2) My custom webapplication has implmented some special filtering functions. How can i pass my filtering parameters from my webapplication though some pentaho analyser views or dashboards?






Thanks and best regards,
student ]]> BI Platform student http://forums.pentaho.com/showthread.php?141490-Integration-Questions-SSO-with-JAAS-and-customized-filtering-possibilities How i can install Hive on Windows , and connect with my Pentaho. http://forums.pentaho.com/showthread.php?141451-How-i-can-install-Hive-on-Windows-and-connect-with-my-Pentaho&goto=newpost Wed, 24 Apr 2013 13:45:05 GMT HI everybody,
I'm beginning working with Pentaho and i need help.
I already have one virtual machine with Hadoop installed, and now i need install the Hive on Windows, and make the connection with my Pentaho. the problem is that i don´t know how i do this.
i don't know where i make the download of Hive, the drives to make the connection . I don't know nothing .


I'm make a intership in one company, and they asked me, to study / work with Pentaho and make a lot of thing. The problem is that i never worked with Pentaho.


Someone can Help? Step by Step.. Please.


My contact :


Email : keltonpedrosilva@hotmail.com
Skype : mr_kapa_23 ]]> BI Platform mr_kapa_23 http://forums.pentaho.com/showthread.php?141451-How-i-can-install-Hive-on-Windows-and-connect-with-my-Pentaho Anyone knows release date of 5.0? http://forums.pentaho.com/showthread.php?141449-Anyone-knows-release-date-of-5-0&goto=newpost Wed, 24 Apr 2013 13:10:33 GMT Hi. As in topic - anyone knows something about release of 5.0? Where can I find any news about next release? Hi.

As in topic - anyone knows something about release of 5.0?
Where can I find any news about next release? ]]> BI Platform dzilupl2 http://forums.pentaho.com/showthread.php?141449-Anyone-knows-release-date-of-5-0 Configure Saiku pluin with SSAS http://forums.pentaho.com/showthread.php?141447-Configure-Saiku-pluin-with-SSAS&goto=newpost Wed, 24 Apr 2013 12:46:49 GMT Hi Can anyone please share how you have configured Pentaho BI Server 4.5 with SSASand view cubes using Saiku? Thanks for you help! Vinoth Hi
Can anyone please share how you have configured Pentaho BI Server 4.5 with SSASand view cubes using Saiku?

Thanks for you help!
Vinoth ]]> BI Platform vinothindia http://forums.pentaho.com/showthread.php?141447-Configure-Saiku-pluin-with-SSAS Porblem with excel writer on Bi-server 4.5.0 http://forums.pentaho.com/showthread.php?141444-Porblem-with-excel-writer-on-Bi-server-4-5-0&goto=newpost Wed, 24 Apr 2013 12:04:45 GMT Hi, I have problems with xaction executing excel writer on a kettle's transformation.
I know that on previous version of bi-server we had to copy excel writer's folder to bi-server to make it work correctly.
But in the current version I can't find this folder.
So is there something else to do to execute excel writer properly in an xaction?
I just want to point out that the job work perfectly on the bi-server if executed with Kettle.
thanks for your help.

Jean-Christophe ]]> BI Platform jcseneret http://forums.pentaho.com/showthread.php?141444-Porblem-with-excel-writer-on-Bi-server-4-5-0 Pentaho Report in iFrame http://forums.pentaho.com/showthread.php?141438-Pentaho-Report-in-iFrame&goto=newpost Wed, 24 Apr 2013 10:56:43 GMT Hello all,
I don't know how to show report in PUC inside iFrame, however i tried to do so and was able to view that in Chrome browser but was unable to view it at Mozzila Firefox and IE. ]]> BI Platform rahultiwary3190 http://forums.pentaho.com/showthread.php?141438-Pentaho-Report-in-iFrame Pentaho BI Server and MS SQL Server 2012 http://forums.pentaho.com/showthread.php?141436-Pentaho-BI-Server-and-MS-SQL-Server-2012&goto=newpost Wed, 24 Apr 2013 10:20:56 GMT Hi. I'm trying to work with Pentaho BI Server and MS SQL Server 2012. and install using the guide (http://www.prashantraju.com/projects/pentaho/)In the attachment, I post all the modified files, and log with errors.
My software:
MS SQL Server 2012
Pentaho BI Server 4.8
JTDS 1.3.0
Nothing works, please help.
If not change the files and use the hsqldb, all the work (the connection to the data warehouse, data analysis, reporting, etc.)
Attached Files
]]> BI Platform Kouki http://forums.pentaho.com/showthread.php?141436-Pentaho-BI-Server-and-MS-SQL-Server-2012 Excel writer error with bi-server http://forums.pentaho.com/showthread.php?141432-Excel-writer-error-with-bi-server&goto=newpost Wed, 24 Apr 2013 09:48:48 GMT Hi,
I can't execute kettle's transformation including Excel Writer on Bi-server. I know that in previous version of Kettle and bi-server, we need to copy excel writer plugin folder from Kettle to 'pentaho-solutions/system/kettle/plugins/steps/ExcelWriter' to make it work.
But in version 4.4 I can't find this folder.
So what can i need to do to "install" excel Writer on Bi-server.
I just want to point out that the transformation work fine on kettle on the same server.

Thanks for your help. ]]> BI Platform jcseneret http://forums.pentaho.com/showthread.php?141432-Excel-writer-error-with-bi-server Access problem to my database *.frm files http://forums.pentaho.com/showthread.php?141428-Access-problem-to-my-database-*-frm-files&goto=newpost Wed, 24 Apr 2013 08:23:55 GMT Hello,

I'm a beginner with pentaho.

Even if my connection to my database works, when I try to do a new report with my database i got this message :

10:16:05,340 ERROR [SqlMetadataQueryExec] SqlMetadataQueryExec.ERROR_0002 - Query execution failed: Can't find file: '.\@0022pointage@0022\@0022seances@0022.frm' (errno: 22 - Invalid argument)


Resolved !
I must declare datasource in PUC and NOT IN PAC ]]> BI Platform paddy.forums http://forums.pentaho.com/showthread.php?141428-Access-problem-to-my-database-*-frm-files http://localhost:8080 accepts request but never responds http://forums.pentaho.com/showthread.php?141388-http-localhost-8080-accepts-request-but-never-responds&goto=newpost Tue, 23 Apr 2013 16:58:55 GMT I have a problem where I am installing the Pentaho BI server (on Ubuntu Linux) and changing the port for hypersonic DB - because something else is... I have a problem where I am installing the Pentaho BI server (on Ubuntu Linux) and changing the port for hypersonic DB - because something else is using 9001 first. (Hadoop I think - there is a Jira for it).

Anyway I can start tomcat but when I make a web request to http://localhost:8080/ I never get a response. It just sits there - not producing an error in the logs, and not producing anything on the browser. Any suggestions?

The only thing suspicious is

17:34:29,620 WARN [PackageManager] Unresolved dependency for package: org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaModule
17:34:29,637 WARN [PackageSorter] A dependent module was not found in the list of known modules.

(I am using 4.8.0 BI Server)

alex@leguin:~/projects/pentaho/biserver-ce$ ./start-pentaho-debug.sh
/home/alex/projects/pentaho/biserver-ce
/home/alex/projects/pentaho/biserver-ce
WARNING: Using java from path
DEBUG: _PENTAHO_JAVA_HOME=
DEBUG: _PENTAHO_JAVA=java
Using CATALINA_BASE: /home/alex/projects/pentaho/biserver-ce/tomcat
Using CATALINA_HOME: /home/alex/projects/pentaho/biserver-ce/tomcat
Using CATALINA_TMPDIR: /home/alex/projects/pentaho/biserver-ce/tomcat/temp
Using JRE_HOME: /usr
Using CLASSPATH: /home/alex/projects/pentaho/biserver-ce/tomcat/bin/bootstrap.jar
Listening for transport dt_socket at address: 8044
23-Apr-2013 17:34:21 org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /usr/lib/jvm/jdk1.6.0_32/jre/lib/amd64/server:/usr/lib/jvm/jdk1.6.0_32/jre/lib/amd64:/usr/lib/jvm/jdk1.6.0_32/jre/../lib/amd64:/usr/java/packages/lib/amd64:/usr/lib64:/lib64:/lib:/usr/lib
23-Apr-2013 17:34:22 org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
23-Apr-2013 17:34:22 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 405 ms
23-Apr-2013 17:34:22 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
23-Apr-2013 17:34:22 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.29
23-Apr-2013 17:34:22 org.apache.catalina.startup.HostConfig deployDescriptor
INFO: Deploying configuration descriptor pentaho.xml
23-Apr-2013 17:34:22 org.apache.catalina.startup.ContextConfig validateSecurityRoles
INFO: WARNING: Security role name PENTAHO_ADMIN used in an <auth-constraint> without being defined in a <security-role>
[Server@52a34783]: [Thread[main,5,main]]: checkRunning(false) entered
[Server@52a34783]: [Thread[main,5,main]]: checkRunning(false) exited
[Server@52a34783]: Initiating startup sequence...
[Server@52a34783]: Server socket opened successfully in 0 ms.
[Server@52a34783]: Database [index=0, id=0, db=file:../../data/hsqldb/sampledata, alias=sampledata] opened sucessfully in 1063 ms.
[Server@52a34783]: Database [index=1, id=1, db=file:../../data/hsqldb/hibernate, alias=hibernate] opened sucessfully in 610 ms.
[Server@52a34783]: Database [index=2, id=2, db=file:../../data/hsqldb/quartz, alias=quartz] opened sucessfully in 10 ms.
[Server@52a34783]: Startup sequence completed in 1684 ms.
[Server@52a34783]: 2013-04-23 17:34:25.030 HSQLDB server 1.8.0 is online
[Server@52a34783]: To close normally, connect and execute SHUTDOWN SQL
[Server@52a34783]: From command line, use [Ctrl]+[C] to abort abruptly
17:34:29,620 WARN [PackageManager] Unresolved dependency for package: org.pentaho.reporting.engine.classic.extensions.datasources.cda.CdaModule
17:34:29,637 WARN [PackageSorter] A dependent module was not found in the list of known modules.


SOME EXTRA INFO.


alex@leguin:~/projects/pentaho/biserver-ce$ java -version
java version "1.6.0_32"
Java(TM) SE Runtime Environment (build 1.6.0_32-b05)
Java HotSpot(TM) 64-Bit Server VM (build 20.7-b02, mixed mode)
alex@leguin:~/projects/pentaho/biserver-ce$ arch
x86_64
alex@leguin:~/projects/pentaho/biserver-ce$ uname
Linux
alex@leguin:~/projects/pentaho/biserver-ce$ uname -a
Linux leguin 3.2.0-40-generic #64-Ubuntu SMP Mon Mar 25 21:22:10 UTC 2013 x86_64 x86_64 x86_64 GNU/Linux ]]> BI Platform alexmc http://forums.pentaho.com/showthread.php?141388-http-localhost-8080-accepts-request-but-never-responds