I'm looking to match a complete system that rivals MS Win Server/MS SQL Server w/ SSIS/SSAS/SSRS/PowerBI but with Pentaho, Plug-Ins, PostgreSQL/MongoDB however cost free on software. I asked this questions recently and has been answered in detail.

What is not most common and best supported Linux distro (assuming Desktop and not EE due to some cost) is that used for the Pentaho suite? Has anyone had good luck with OpenSUSE-Leap?

And how scalable is it? If I get all this onto a box, and build out ETL that runs a decent amount of data in, and a fair sized DB, and a number of Dashboards being hosted, can it perform reasonably on the hosted dashboard side for an end user to slice and dice, drill and click about and have interactive changes within seconds, adhering to general industry response times?

There is strange behavior of pentaho quartz scheduler.
I made simple test job named "test_job_3_min" that work 3 minutes long, upload it on server through user console and set schedule that launch it every minute.
Inside job I made standard logging every 5 sec to DB table and check if there is a copy of "test_job_3_min" launched.
So there is only one copy of this job working at every moment of a time.
I can see that one in three launches succeeded.pentaho_job_launches.jpg

This is all ok and working fine, but in PUC Schedules section I can see strange lines for my job with status "Finished" along with main every minute schedule.
Some time there is one line with empty Last Run and Next Run. Some time there is one more line with Last Run specified.
Schedule for that lines is also strange - no duration specified "Every at <time>".

]]>BI PlatformSkivhttps://forums.pentaho.com/threads/230894-Pentaho-user-console-scheduler-multiple-lines-for-one-jobDeleted public folderhttps://forums.pentaho.com/threads/230886-Deleted-public-folder?goto=newpost
Sat, 17 Feb 2018 11:30:32 GMTHi,
I have been playing around a bit with BI 8 and trying out some things.
You start out with a Home and Public folder.
Now I deleted the Public...Hi,

I have been playing around a bit with BI 8 and trying out some things.
You start out with a Home and Public folder.
Now I deleted the Public folder.
But there does not seem to be a way to recreate it?
As far as I can tell you can only create folder in Home and Public but not in the root.
So once you delete Public, there is no way to get it back?
]]>BI PlatformSmidgehttps://forums.pentaho.com/threads/230886-Deleted-public-folderPenatho CE 8.0 nginx config - Login and Logout redirect?https://forums.pentaho.com/threads/230883-Penatho-CE-8-0-nginx-config-Login-and-Logout-redirect?goto=newpost
Fri, 16 Feb 2018 09:01:37 GMTAnyone configured Pentaho 8 behind nginx?
Connecting via a load balancer https 443 (which looks after the certs) through on port 3000 to the...Anyone configured Pentaho 8 behind nginx?

Connecting via a load balancer https 443 (which looks after the certs) through on port 3000 to the default Pentaho 8080.

So I can hit https://<external_IP>:443/penatho/
and I get a redirect to http://<internal_IP>>:3000/Login
(I can see this internally on the rproxy server as a wget on localhost:3000/pentaho get a 302 to :3000/pentaho/Login)

I can work around this....
Going direct to https://<external_IP>:443/penatho/Login
allows me to login ( the proxy_hhtp_version and proxy_interscept_errors seem to fix that)

But then I'm not able to Logout (which is another redriect)

Any ideas?
]]>BI Platformbonsorshttps://forums.pentaho.com/threads/230883-Penatho-CE-8-0-nginx-config-Login-and-Logout-redirectConfiguring Pentaho BA Application in Linux Boxhttps://forums.pentaho.com/threads/230882-Configuring-Pentaho-BA-Application-in-Linux-Box?goto=newpost
Fri, 16 Feb 2018 06:00:00 GMTDear Team,
Kindly help.
How to configure the Pentaho BA Application in Linux, Like i need to view my Home and Public report files and folders...Dear Team,

Kindly help.

How to configure the Pentaho BA Application in Linux, Like i need to view my Home and Public report files and folders from linux.

I need to set one global parameter for 2 main master reports. these 2 reports are linking each other means separate reports. rather creating 2 parameters for each reports , set one parameter and set it to 2 reports.

Is there any way to schedule the Pentaho reports from command prompt or setting the mail server which is presented in pentaho user console from command prompt?

Also, Is there any way to take the Pentaho BA Application report files and folders in the Linux box, I need to view my designed reports in Linux box?

Kindly advise.
]]>BI Platformvijay antonyhttps://forums.pentaho.com/threads/230878-Pentaho-user-Console-Mail-Server-setting-from-Command-PromptDynamically add Date time in subject and attachment name in pentaho report schedulinghttps://forums.pentaho.com/threads/230875-Dynamically-add-Date-time-in-subject-and-attachment-name-in-pentaho-report-scheduling?goto=newpost
Wed, 14 Feb 2018 11:03:19 GMTDear Team,
While scheduling pentaho reports from pentaho user console, Would like to set date time dynamically in subject and attachment names,...Dear Team,

While scheduling pentaho reports from pentaho user console, Would like to set date time dynamically in subject and attachment names, also would like to set parameterization in receiptants.

kindly help me on this
]]>BI Platformvijay antonyhttps://forums.pentaho.com/threads/230875-Dynamically-add-Date-time-in-subject-and-attachment-name-in-pentaho-report-schedulingInstallation instructions for Pentaho Server 8.0https://forums.pentaho.com/threads/230867-Installation-instructions-for-Pentaho-Server-8-0?goto=newpost
Tue, 13 Feb 2018 09:56:34 GMTAre there any up to date instructions for installing the server from pentaho-server-ce-8.0.0.0-28.zip. All the instructions I've found seem to be for the enterprise edition and include features I don't seem to have, like the operations mart.
]]>BI PlatformGabbyGabehttps://forums.pentaho.com/threads/230867-Installation-instructions-for-Pentaho-Server-8-0Datasource for uploading CSV files issue in Pentaho Server 8.0 CEhttps://forums.pentaho.com/threads/230837-Datasource-for-uploading-CSV-files-issue-in-Pentaho-Server-8-0-CE?goto=newpost
Fri, 02 Feb 2018 11:00:08 GMTHello.

I've installed Pentaho Server 8.0 CE on Linux Ubuntu 16.04 Server.

When I am trying to upload csv file to the server over browser on my local machine:
File -> Manage Data Sources -> New Data Source -> CSV File
and selecting valid csv file from my local PC after pressing "Import" button I am receiving "UploadFileServlet.ERROR_0005 - An error occured while uploading the file UploadFileServlet.EROR_0010 - File name is invalid."

Thanks.
]]>BI PlatformVitaliyUAhttps://forums.pentaho.com/threads/230837-Datasource-for-uploading-CSV-files-issue-in-Pentaho-Server-8-0-CEPentaho and PostGreSQL / System Build to Match SQL Server SSIS/SSAShttps://forums.pentaho.com/threads/230835-Pentaho-and-PostGreSQL-System-Build-to-Match-SQL-Server-SSIS-SSAS?goto=newpost
Thu, 01 Feb 2018 22:34:06 GMTHello Community, my first post, and I hope its in the correct group.
I work a lot with SQL Server SSIS/SSAS and PowerBI, and lesser so with the...Hello Community, my first post, and I hope its in the correct group.

I work a lot with SQL Server SSIS/SSAS and PowerBI, and lesser so with the Oracle equivalents. I'm looking to build a lab environment that is all open source, and use Linux, Pentaho w/ various Plug-ins, and PostgreSQL as an answer to expensive engineered solutions as SQL Server and Oracle BI products.

I have looked at the chart of the Pentaho CE and EE, and it would appear that the EE server level would have the services for thing like minting a cube. So that would mean I would acquire an Linux Server OS. Does Pentaho have a Developers edition of the EE through a special program? Or can CE be made to function in a more crippled manner?

Thanks,
Data_Geek
]]>BI PlatformData_Geekhttps://forums.pentaho.com/threads/230835-Pentaho-and-PostGreSQL-System-Build-to-Match-SQL-Server-SSIS-SSASPentaho 7 Login Error using LDAP/JDBC Hybrid configurationhttps://forums.pentaho.com/threads/230811-Pentaho-7-Login-Error-using-LDAP-JDBC-Hybrid-configuration?goto=newpost
Mon, 29 Jan 2018 15:57:59 GMTI've followed Pentaho 7 (EE) documentation on how to set LDAP/JDBC hybrid configuration: created the tables and filled them with the appropriate values then updated the configuration files as instructed.

When trying to login to the PUC the following error is thrown:

java.util.concurrent.ExecutionException: javax.jcr.LoginException:LoginModule could not perform authentication:Target of Bean was never
resolved:
org.springframework.security.core.userdetails.UserDetailsService

My security.properties includesprovider=ldap
role.provider=jdbc

I set the providerName in pentahoObjects.spring.xml to jdbc<pen:bean id="activeUserRoleListService"class="org.pentaho.platform.api.engine.IUserRoleListService"><pen:attributes><pen:attr key="providerName" value="jdbc"/></pen:attributes></pen:bean>

If I deploy another clean pentaho-server instance with the same ldap configuration in applicationContext-security-ldap.properties and security.properties it works :(. I don't want to migrate the first one to solve the problem.