RSS Feed Details
 |
|
|
|
Link: http://forums.pentaho.com/
Description: Pentaho, Open Source, BI, Business Intelligence, Open, Reporting, Analysis, Workflow, Dashboards, Data Mining
RSS Feed Content
Dynamic Height With Report Designer
Published: Thursday June 20th 3AM
Link: http://forums.pentaho.com/showthre...ght-with-Report-Designer&goto=newpost
Description: I have a problem with the size of height in Report Designer. My layout is Canvas and I need to export my report to excel. The problem is that for example if I configurate with Dynamic Height the export doesn't work correctly because there are some fields that not adjust correctly with the cells. If I configurate Report D. with "Discard all whitespaces" it doesn't work too because the main column in my Excel it's incomplete. I attached a picture with my problem. Please help me I am goin... read more »
Can Not Save Dashboard When Using Cgg
Published: Thursday June 20th 3AM
Link: http://forums.pentaho.com/showthre...dashboard-when-using-CGG&goto=newpost
Description: Hello everyone I am using CDE to create dashboard, when i press "Shift + G", click on charts to render as CGG and after that i can not save dashboard anymore. Can anyone help me read more »
Not Able Add Different Table For Each Level Indvidually
Published: Thursday June 20th 3AM
Link: http://forums.pentaho.com/showthre...r-each-level-indvidually&goto=newpost
Description: i am trying to add individual tables for each level in a hierarchy , as an option has been provided to add that so i am considering that its possible but as and when i add the table for the level .. red cross becomes visible with the level and schema disappears from user console data sources may i know if there is any solution to this plz reply asap read more »
Can't Connect To Socks Proxy When Connect To Mssql
Published: Thursday June 20th 2AM
Link: http://forums.pentaho.com/showthre...- when-connect-to-MSSQL &goto=newpost
Description: First time I used PDI 4.4.0 in ubuntu 12.04. I connected to MSSQL, everything OK AAAAAAAAAAAAAAAAAAAAAAAAaa.jpg But in PDI 4.4.1 I can't connect to MSSQL and I received an error: Quote: rror connecting to database HabraDW1 : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: using class net.sourceforge.jtds.jdbc.Driver Network error IOException: Can't connect to SOCKS proxy:Connection refused Attached Images ... read more »
How Can I Integrate Digest Authentication Within .net And Pentaho
Published: Thursday June 20th 2AM
Link: http://forums.pentaho.com/showthre...n-within-NET-and-Pentaho&goto=newpost
Description: I have tried to found example code/demo from internet about integrate login authentication within .NET and Pentaho but unluckily no solution found... For example I have a web portal website need to login before use so that I have a customize login page let user to login the portal: After I clicked Login button, the system will login to my web portal. The web portal include pentaho link. that mean I no need to login Pentaho again if I already login the web portal. login.jpg Now the question is ho... read more »
How To Make A Transformation Wait Till All Previous Transformation Success
Published: Wednesday June 19th 9PM
Link: http://forums.pentaho.com/showthre...s-transformation-success&goto=newpost
Description: I have a job setting as the attached image. now I want 'get file names 2' start executing after both 'trans1' and 'trans2' successed. right now it's not working as the way I want. I considered 'success' step. but in the documentation it says 'success' is use for clearing error status. Please give me a hint on this issue. Appreciate it. Capture.jpg Attached Images Capture.jpg 10.6 KB read more »
Difficulty With Job/trans. File Copy - Please Help
Published: Wednesday June 19th 8PM
Link: http://forums.pentaho.com/showthre...ns-file-copy-please-help&goto=newpost
Description: I'm a new Pentaho user and I'm having some difficulty copying files from one directory to another. Here's the logic I'm trying to implement drives/IDs/etc. changed here but consistent with the pattern I need : - Get the CaseID and GenID from our table both are alphanumeric - Find the first letter of the GenID and then check if the following directory exists: Z: GenID1st GenID.CaseID -- If not, create it - Copy the files from Y: CaseID to Z: GenID1st GenID.CaseID Right now I have a very basic... ... read more »
Cobweb Result
Published: Wednesday June 19th 4PM
Link: http://forums.pentaho.com/showthread.php 144615-CobWeb-Result&goto=newpost
Description: Cobweb results I need to obtain a result similar to k-means for example: Cluster 1 0,1,1,0 Cluster 2 1,0,0,0 Cluster 3 1,0,1,1, is possible to obtain this my code is: ArffLoader loader = new ArffLoader ; loader.setFile new File "C: DAT titanic.arff" ; Instances structure = loader.getStructure ; Cobweb cw = new Cobweb ; cw.buildClusterer structure ; Instance current; while current = loader.getNextInstance structure = null cw.updateClusterer current ; cw.updateFinished ; cw.acuityTipText... read more »
Udjc Can You Have Multiple Info Streams As In More Than 1 Info Step Attached To Udjc
Published: Wednesday June 19th 4PM
Link: http://forums.pentaho.com/showthre...fo-Step-attached-to-UDJC&goto=newpost
Description: Hi, Just curious as I can make a UDJC work with one info stream but as soon as I add more than one I get errors. When you define the second info step: The first odd thing is that in the GUI you only see the fields from the first info step. If you run you get errors like "Unable to find Info field helper for field name 'FOO'" even though the field helper for FOO is defined in the code: at org.pentaho.di.trans.steps.userdefinedjavaclass.TransformClassBase.get TransformClassBase.java:730 ... read more »
Uncommited Rows
Published: Wednesday June 19th 3PM
Link: http://forums.pentaho.com/showthre...p 144612-Uncommited-rows&goto=newpost
Description: Hello all... I'm a new Kettle user, so maybe this is an old question I haven't yet found with searches... I have a transform that uses Table output as the final step, to write data to a table. However, when I run the transform the number of rows that get inserted into my empty table are less than the number reported as ". It seems that the problem is the "commit size" is such that I end up with a number of uncomitted records that are less than the commit size interval. For example... read more »
How To Get Mutiple Output File From One File
Published: Wednesday June 19th 2PM
Link: http://forums.pentaho.com/showthre...utput-file-from-one-file&goto=newpost
Description: HI, i am using Data grid step in input step, to get Company_name column header and name column header company.png so, i need multiple output file based on company name ----------------------------------------------- for example: output: AAA_TCS.csv AAA_Wipro.csv AAA_CTS.csv ..... .... ..... so many files will be there based on company name i need dynamic on company name ----------------------------------------------------- i used parameter name as company_name in output file AAA_ company_name.cs... read more »
Geokettle Won't Run On My Windows Machines
Published: Wednesday June 19th 12PM
Link: http://forums.pentaho.com/showthre...n-on-my-Windows-machines&goto=newpost
Description: I just downloaded the GeoKettle 2.5 for Windows. I installed it on two different machines that both have JRE 7. When I try to run the shortcut that was created on the desktop, nothing happens. When I run the Spoon.bat, nothing happens. Both machines are Windows 7 Professional. Any idea what's wrong read more »
Weka K-means
Published: Wednesday June 19th 11AM
Link: http://forums.pentaho.com/showthread.php 144602-Weka-K-MEANS&goto=newpost
Description: hi the k-means algorithm that data type is optimal: numeric nominal or mixed thanks... read more »
V1 Properties - Some Ccc Bar Charts Have Them, Some Don't
Published: Wednesday June 19th 11AM
Link: http://forums.pentaho.com/showthre...rts-have-them-some-don-t&goto=newpost
Description: Hello all I've noticed that the Webdetails samples with CCC Bar charts contain two properties v1-Bar Line, v1 - Show Legend that I do not have when I create something with that component. This screen shot is of one of the sample dashboards bar chart ccc sample.jpg This is a screen shot of a new dashboard after adding a CCC bar chart component bar chart ccc RLM.jpg Can anyone tell me why the properties would be different for the same component Thanks - Russell Attached Images bar chart ccc RLM.jp... read more »
Cdf Date Input Component
Published: Wednesday June 19th 11AM
Link: http://forums.pentaho.com/showthre...CDF-Date-Input-Component&goto=newpost
Description: It's been pointed out to me that the date input component does not update in our dashboards if the date displayed is edited directly in the text box. It will only update if the date is selected from the calendar that appears. Is there some code I could add to the post change or post execution that would make it accept the date that is typed into the field If that is not possible, is there a way to make the text field non-editable Thanks, N read more »
Embed Report Into Webapplication Java Based
Published: Wednesday June 19th 11AM
Link: http://forums.pentaho.com/showthre...bapplication java-based &goto=newpost
Description: I have created a Analyzer report in pentaho Userconsole my report is parameterized , now is it possible to embed this report in my existing webapplication which is developed in java. if it is possible please just give me guide line how to do it .. Thanks In Advance read more »
How To Concatenate A String Like The Below Example In Spoon
Published: Wednesday June 19th 10AM
Link: http://forums.pentaho.com/showthre...e-below-example-in-spoon&goto=newpost
Description: Hi, i want to concatenate a string like below in spoon ' ' Variable ' ' How can i do this using PDI Thanks for your help read more »
How To Export Pentaho Cde Dashboads In The Diffrent Type Output Pdf, Excel
Published: Wednesday June 19th 10AM
Link: http://forums.pentaho.com/showthre...t-type-output PDF-EXCEL &goto=newpost
Description: Good Morning, I am using client tool is CDE. I getting stuck while trying to export dashboard cde in different types of output like pdf and excel. I am not able see any function to export my dashboard in the pdf as well as excel. Please let me know how to achieve this.... Regards- Chandan Aggarwal read more »
Design With Spoon To Rollbaclk Complete Transformation
Published: Wednesday June 19th 9AM
Link: http://forums.pentaho.com/showthre...-complete-transformation&goto=newpost
Description: I need to rollback the complete transformation based on certain threshold.Point to be noted is this does not involve any database updates/delete/insert. Example : Convert table output to csv. Each row is validated before converting to csv format and if validation fails and reaches a certain threshold I do not want any data rows to be written to the csv. Please direct me if you have any examples read more »
Traffic Component
Published: Wednesday June 19th 8AM
Link: http://forums.pentaho.com/showthre...144588-Traffic-Component&goto=newpost
Description: Hi, I have problems using the Traffic Component. It shows always the red light. The 'Intervals Array' is defined and I'm using a datasource which gives me one integer back. What am I doing wrong I hope someone can help. Thanks in advance... read more »
From Metadata Editor To Cde Using Row-level Security
Published: Wednesday June 19th 7AM
Link: http://forums.pentaho.com/showthre...using-row-level-security&goto=newpost
Description: Hi everyone, I've built a small database to see how the row-level security works. Everything has been set in PME Pentaho Metadata Editor . Here is my .xmi for those who want to see how I set everything up you need to change from .txt to .xmi . I have also set up my user and role in my Administration Console. My roles in the administration console are : dummy and oakwood, and they have one employee each as user dummyEmployee in dummy and oakwoodEmployee in oakwood . So to login in the Pentaho Use... read more »
Unable To Execute A Map Reduce Job - Classnotfoundexception: Org.owasp.esapi.esapi
Published: Wednesday June 19th 7AM
Link: http://forums.pentaho.com/showthre...on-org-owasp-esapi-ESAPI&goto=newpost
Description: Hi, I am trying to execute the hadoop examples wordcount and weblogs-parser with the latest PDI distribution 4.4.1-GA . When I am executing the mapreduce job, the following error occurs at the end of the job. Code: 2013/06/19 12:07:54 - Pentaho MapReduce Web Log Parsing - ERROR version 4.4.1-GA, build 18329 from 2013-04-17 12.31.49 by buildguy : Hadoop Output - Unexpected error 2013/06/19 12:07:54 - Pentaho MapReduce Web Log Parsing - ERROR version 4.4.1-GA, build 18329 from 2013-04-17 12.31.49 ... read more »
Data Processing In Parent-child Manner In Pentaho Kettle.
Published: Wednesday June 19th 7AM
Link: http://forums.pentaho.com/showthre...manner-in-pentaho-kettle&goto=newpost
Description: Hi, i have an excel input like below. And i want to insert them into database in parent-child manner. parent code child code AB CD CD EF EF GH GH AB But i want to restrict the value of 4th row. As it will go into infinite loop. thanks in advance read more »
Unable To Apply Layout On New Dashboard
Published: Wednesday June 19th 6AM
Link: http://forums.pentaho.com/showthre...-Layout-on-New-dashboard&goto=newpost
Description: Hi Have Windows XP SP3 desktop. I installed Pentaho 4.8.1 and also installed CDE 13.06.05 Now i try to create new dash boards and apply a layout, page hangs and no layout applied. please let me know if i need to install other ctools like ccc, cda etc. Facing the problem in Firefox and chrome also. steps followed: File -> New CDE dashboard save the dashboard using Save As.. option. close and open it for edit. click Apply Template button and select a layout. page hangs and turns white after som... read more »
Javascript For Splitting The Date Field
Published: Wednesday June 19th 5AM
Link: http://forums.pentaho.com/showthre...Splitting-the-Date-field&goto=newpost
Description: Hi all, I need to split date which is in the format "7/12/2013" and get output as 2013-12-07. I used the below code which works perfectly fine on JS editor but the Pentaho output I get " in few places like 2013-NaN-12 or 2013-nan-nan and such //var Opt_In_Date = "7/12/2013"; var datestring = Opt_In_Date.split "/" ; var dt1 = datestring 0 ; var mon1 = datestring 1 ; var yr1 = datestring 2 ; if dt1<10 dt1 = '0'+dt1 ; if mon1<10 mon1 = '0'+mon1 ; var DATE_OF... read more »
Hreader Content In Clean.html Coming From
Published: Wednesday June 19th 5AM
Link: http://forums.pentaho.com/showthre...n-Clean-html-coming-from&goto=newpost
Description: Hi, I would like to know from which file or from where the " HREADER content comming from " in clean.html file in location " pentaho-cdf-dd resources styles " How it is render in the clean.html file. thanks in advances. read more »
D3
Published: Wednesday June 19th 5AM
Link: http://forums.pentaho.com/showthread.php 144575-d3&goto=newpost
Description: Hi, Exist a way to import a d3 graph into a dashboard How can i use a datasource from cde with the d3 graph Thanks read more »
How To Set The Pie Chart Color, Based On The Query Result Set
Published: Wednesday June 19th 5AM
Link: http://forums.pentaho.com/showthre...-on-the-query-result-set&goto=newpost
Description: Hi, I want to create a Pie chart with cccv2. The datasource for this chart will deliver a table like this: CATEGORY VALUE ------------------- OK 1 ERROR 4 OPEN 3 The order and the names of the " values are not fix user defined value . In the "Pre Execution" section I want to define a function to set the color values based on the " name of the query result set. So far I can define the colors: Code: function myColors // ToDo: Read the input table and set the regarding color val... read more »
I Have Some Questions For You About Roadmap
Published: Wednesday June 19th 4AM
Link: http://forums.pentaho.com/showthre...ns-for-you-about-roadmap&goto=newpost
Description: Hi, I have some questions for you about roadmap..Please give me some advice. 1. Could you explain your public or privateroadmap for years to come We expect to know your development plan by year asdetail as possible. If you have no plan, please tell me your opinion. 2.Could youdescribe the list of technologies in your open source Please describe asdetail as possible. 3.What technologiesdo you need more in your open source project Why 4.Whatnew open source project do you want to create in Big Data... read more »
I Have Some Questions For You About Roadmap
Published: Wednesday June 19th 4AM
Link: http://forums.pentaho.com/showthre...ns-for-you-about-roadmap&goto=newpost
Description: Hi, I have some questions for you about roadmap..Please give me some advice. 1. Could you explain your public or privateroadmap for years to come We expect to know your development plan by year asdetail as possible. If you have no plan, please tell me your opinion. 2. Could youdescribe the list of technologies in your open source Please describe asdetail as possible. 3. What technologiesdo you need more in your open source project Why 4. Whatnew open source project do you want to create in Big D... read more »
I Have Some Questions For You About Roadmap.
Published: Wednesday June 19th 3AM
Link: http://forums.pentaho.com/showthre...ns-for-you-about-roadmap&goto=newpost
Description: Hi, I have some questions for you about roadmap.. Please give me some advice. 1. Could you explain your public or private roadmap for years to come We expect to know your development plan by year as detail as possible. If you have no plan, please tell me your opinion. 2. Could you describe the list of technologies in your open source Please describe as detail as possible. 3. What technologies do you need more in your open source project Why 4. What new open source project do you want to create i... read more »
Invalid Download Link For Community Edition Pentaho Bi Server
Published: Wednesday June 19th 3AM
Link: http://forums.pentaho.com/showthre...dition-Pentaho-BI-Server&goto=newpost
Description: Hi, I was trying to download the Community Edition Pentaho BI Server from the link provided in http://community.pentaho.com/projects/bi_platform/. Which forwarding me to the URL http://sourceforge.net/projects/pent.../4.8.0-stable/ and while downloading its giving the file pdi-ce-4.4.0-stable.zip. Please help. thanks.. Siladitya Dash read more »
Mondrian.war Deployed In Eap6/as7 - Class Path Issues
Published: Tuesday June 18th 5PM
Link: http://forums.pentaho.com/showthre...P6-AS7-CLASS-PATH-ISSUES&goto=newpost
Description: Does anyone have experience with deploying Mondrian.war in EAP6 or AS7 The Mondrian.war is producing class path issues when deployed in jboss-as-server-7.2.0. This deployment worked fine in the prior version of AS. Any suggestions would be appreciated. 16:04:44,352 WARN org.jboss.as.server.deployment MSC service thread 1-1 JBAS015960: Class Path entry xercesImpl-2.2.1.jar in /content/mondrian.war/WEB-INF/lib/fop.jar does not point to a valid jar for a Class-Path reference. 16:04:44,353 WARN org.... read more »
Query Scripting In Report Designer
Published: Tuesday June 18th 5PM
Link: http://forums.pentaho.com/showthre...pting-in-report-designer&goto=newpost
Description: I want to query the database for all records whose name is in a user-supplied list of names. I want to do this via query scripting, by generating a where clause that checks if the record matches something in the user-supplied list. However, I can't seem to find any documentation on query scripting in report designer; the official tutorial only mentions it in passing, and googling doesn't turn anything useful up. Ideally I'd like something that explains how query scripting works in general, but r... read more »
Kettle And Libreoffice Base
Published: Tuesday June 18th 4PM
Link: http://forums.pentaho.com/showthre...tle-and-LibreOffice-Base&goto=newpost
Description: Hello, is it possible to use Kettle to access a database created with LibreOffice file with .odb extension I think LibreOffice Base uses Hypersonic HSQLDB . So I tried to make a database connection using Hypersonic connection type and Native JDBC . I left the fields Host Name, Port Number, User Name and Password blank. And in the Database Name field I put the path to the .odb file. The connection seems to work OK, but in the end it doesn't show any table only metadata . read more »
How To Install Pentaho Bi Server 4.8 On Linux
Published: Tuesday June 18th 4PM
Link: http://forums.pentaho.com/showthre...o-BI-Server-4-8-on-Linux&goto=newpost
Description: Hi everyone, I am a new Pentaho user. I want to install Pentaho BI Server community edition 4.8 on linux. I don't find documentation for this version on linux. Do you have an idea where I can find it regards Cygne read more »
Need Quick Help To Calculate Percentage In Report Analyzer
Published: Tuesday June 18th 2PM
Link: http://forums.pentaho.com/showthre...ntage-in-Report-Analyzer&goto=newpost
Description: I have the following data: Student_name Subjects Marks John Maths 60 60 60/100 100 Science 30 30 Social 10 10 This is the general approach to calculate the percentage and the same is working on Pentaho Report analyzer tool with this data. But when I filter out to select only two subjects Maths, Science then the percentage is calculating as: Maths 60 66.6 Science 30 33.3 It is calculating the percentage based on the distribution of selected values. is it not possible to get same actual values as ... read more »
Help To Create A Custom Step
Published: Tuesday June 18th 1PM
Link: http://forums.pentaho.com/showthre...-to-create-a-Custom-Step&goto=newpost
Description: Hi my name is davidson and i am a brazilian software developer , I'm trying to create a step that will execute an algorithm in r that will bring me 2 outputs, and I wish my step had 2 different outputs and the User to choose where they would each output. My english is not the best sry about that. Something like the image below: Captura de tela de 2013-06-18 14:29:42.jpg Is possible And is there any example or something I can use as a basis Thx., Attached Images Captura de tela de 2013-06-18 14:2... read more »
Help With Formula For Variable Length Rectangle
Published: Tuesday June 18th 12PM
Link: http://forums.pentaho.com/showthre...ariable-length-rectangle&goto=newpost
Description: Hi All, This might seem like a simple request, but I'm banging my head on the wall so I thought I'd ask for help. I want to creat a rectangle in report designer that changes length with data input, so I wrote this formula = ordered_gross_2013 /100 525/100 in the max-width area of the style section, just like the Inventory List report example in the welcome area of report designer, but for some reason the rectangle width doesn't change. I'm sure it's something simple I'm overlooking but any help ... read more »
Ldap Output Ssl
Published: Tuesday June 18th 10AM
Link: http://forums.pentaho.com/showthre...p 144531-LDAP-Output-SSL&goto=newpost
Description: I'm trying to build an Integrated Management System in order to create an Active Directory account automatically each time the HR program creates a new employee. I'm able to create the active directory user with all the needed fields, but I cannot change its password. In Active Directory, you must login with SSL to the AD and update the unicodePwd field. I cannot SSL login to AD with the ETL although I have correctly set the trust store path and the certificate. I can SSL login with java code. E... read more »
There Is No Kettle-vfs In Pentaho Artifactory
Published: Tuesday June 18th 10AM
Link: http://forums.pentaho.com/showthre...s-in-pentaho-artifactory&goto=newpost
Description: I check http://repository.pentaho.org/artifa...earch/artifact for kettle-vfs artifact, but doesn't find any version. The latest stable build 4.4.0 use 20100924 version. As i see, there is very similar artifact: > >commons-vfs</groupId> >commons-vfs</artifactId> >20091118-pentaho</version> </dependency> wich is predecessor of kettle-vfs, as i think. Should i use it in my maven project, or that isn't right Maybe you will deploy correct version to artifactory Tha... read more »
Greedystepwise Threshold
Published: Tuesday June 18th 10AM
Link: http://forums.pentaho.com/showthre...GreedyStepWise-threshold&goto=newpost
Description: Hi everybody, I am new in data Mining and WEKA tools. I have some data and i would like to filter them before applying the Linear regression. I apply the GreedyStepWise filter to my attributes 82 , but what i did not understand is how can i set the threshold What is the range of this value For example i tried Threshold = -0.7305 and i obtained 2 attributes from 82 after filtering. Any help please Thank you, Najem read more »
Parameter Datatype For Multiple Values In Prd
Published: Tuesday June 18th 10AM
Link: http://forums.pentaho.com/showthre...r-multiple-Values-in-PRD&goto=newpost
Description: Hi, Can anybody tell me what is the Datatype for a multiple Parameter I have a Dashboard with a multiselectable Static List of Strings. I mapped the selection as a parameter to the report. But in the Report Designer i dont find any Datatype for the Parameter such as Array or List or sth. Thx : read more »
Need To Pass A Value From Report Designer To Mysql Query. Is That Possible
Published: Tuesday June 18th 9AM
Link: http://forums.pentaho.com/showthre...L-query-Is-that-possible&goto=newpost
Description: Hi Taqua, I am trying to make a report for one of our customer's requirement where we have to show the Total Amount in Words for various fields. I can convert number to words in mysql using a function written by us. But the challenge is, I have to sum up the fields of different records and then convert it to words. This summing up can be done easily in Report Designer by using ItemSumFunction say Total_Sum while in the mysql query it is equal to impossible. Is there any way of passing this Total... read more »
Empty Cda File
Published: Tuesday June 18th 9AM
Link: http://forums.pentaho.com/showthread.php 144523-empty-cda-file&goto=newpost
Description: Hi, I have some problems with the cda files. I have created a simple dashborad and a cda file was created. If I use a text editor, I can read the inside code but if I try to edit it by pentaho, the cda file appears empty. can you help me read more »
Weka
Published: Tuesday June 18th 9AM
Link: http://forums.pentaho.com/showthread.php 144522-Weka&goto=newpost
Description: Buenas, Me he esta informando pero para ser sinceros voy bastante perdido sobre el tema de Mineria de Datos. Lo he sacado claro es: Con el Data integration tienes la posibilidad de extraer como fichero ARFF, para que el WEKA lo pueda analizar. Pero no se muy como generar un aRFF correcto para despues poderlo trabajar con WEKA y hacer predicciones. Si alguien sabe de algun tutorial basico o informaci n relacionada. Lo agradecer a. read more »
From Metadata Editor To Cde Using Row-level Security
Published: Tuesday June 18th 6AM
Link: http://forums.pentaho.com/showthre...using-row-level-security&goto=newpost
Description: Hi everyone, I've built a small database to see how the row-level security works. Everything has been set in PME Pentaho Metadata Editor . Here is my .xmi for those who want to see how I set everything up you need to change from .txt to .xmi . I have also set up my user and role in my Administration Console. My problem is that my data constraints are not taken into consideration whatever user I use to login in the BI Server. The table shown in my dashboard is always the same. Here is the MQL que... read more »
Linking Dial Charts With Bar Graphs
Published: Tuesday June 18th 6AM
Link: http://forums.pentaho.com/showthre...l-Charts-with-Bar-graphs&goto=newpost
Description: Hi, I am new to Pentaho and unware of JAVA scripting and XML coding. IS it possible to link Dial charts with bar graph charts Regards, Sneha read more »
Pentaho Hive2 Connection Through Report Designer
Published: Tuesday June 18th 6AM
Link: http://forums.pentaho.com/showthre...-through-Report-Designer&goto=newpost
Description: Hi Using Pentaho trial version for evaluation. In Report Studio, trying to create a HIVE2 connection but getting no response.. Got to know with some of the blogs that through Report Designer trial version, we cant connect to Pentaho HIVE2. Is it correct Thanks Gorav Goyal read more »
Pentaho Data Integration Stuido Not Able To Conect Hive2
Published: Tuesday June 18th 6AM
Link: http://forums.pentaho.com/showthre...not-able-to-conect-HIVE2&goto=newpost
Description: Hi Using the trial version for evaluation Trying to connect HIVE2 server implementation through Pentaho Data Integration but not able to connect. Getting below error message Error connecting to database Hive : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: using class org.apache.hadoop.hive.jdbc.HiveDriver Could not establish connecton to jdbc:hive://10.80.31.69:10000/default: java.net.SocketException: Ma... read more »
Cdf How To Start
Published: Tuesday June 18th 6AM
Link: http://forums.pentaho.com/showthre... 144511-CDF-How-to-start&goto=newpost
Description: I want to learn Pentaho CDF, but I don't know how to start Is the CDF Tutorial required But it's not free. Is there other material Thanks a lot. read more »
Column Freeze In Pentaho Html Reports
Published: Tuesday June 18th 4AM
Link: http://forums.pentaho.com/showthre...-in-pentaho-html-reports&goto=newpost
Description: Hi, A report which contains 10 Columns. So if the user scroll left to right First column to the last column , the first column should be freezed in html .How to freeze column in report. read more »
Odd Crash In Processing Step In Spoon
Published: Tuesday June 18th 4AM
Link: http://forums.pentaho.com/showthre...processing-step-in-spoon&goto=newpost
Description: Exception in thread "Thread-4253" java.lang.IllegalArgumentException: Comparison method violates its general contract at java.util.TimSort.mergeHi TimSort.java:868 at java.util.TimSort.mergeAt TimSort.java:485 at java.util.TimSort.mergeCollapse TimSort.java:410 at java.util.TimSort.sort TimSort.java:214 at java.util.TimSort.sort TimSort.java:173 at java.util.Arrays.sort Arrays.java:659 at java.util.Collections.sort Collections.java:217 at org.pentaho.di.trans.TransMeta.sortStepsNatural... read more »
Create Excel Report
Published: Tuesday June 18th 4AM
Link: http://forums.pentaho.com/showthre...4504-create-excel-report&goto=newpost
Description: Hi I have 10 records no. of records are not fixed in sql server table. i have to generate excel files from 10 records on the basis of " column in the table. Is it possible to generate excel files from the below table . Please see the attachment . For the below data , i have to generate 5 excel files. thanks Sandhya read more »
Parallel Execution Of Queries Against Same Database
Published: Monday June 17th 11PM
Link: http://forums.pentaho.com/showthre...es-against-same-database&goto=newpost
Description: Hi, I have several table input steps running in parallel, which are connected to same SQL Server database and writing it to separate flat files inside the same folder.The configuration details of database and the text file are coming from variables. My problem is , If 2 flows Table input ---> TFO starts at the same time, 2 queries are being fired to two different tables of say 1000k records in each, but time for reading from the database and usage of buffer memory to write the flat file diffe... read more »
Efficient Sql Queries On Mongodb
Published: Monday June 17th 9PM
Link: http://forums.pentaho.com/showthre...t-SQL-queries-on-MongoDB&goto=newpost
Description: How do you integrate MongoDB with other data in your organization MongoDB is great for building applications, and it has its own powerful query API, but it's difficult to mash up data between MongoDB and other tools, or to make tools that speak SQL, such as Pentaho Analysis Mondrian , connect to MongoDB. Building a SQL interface isn't easy, because MongoDB's data model is such a long way from SQL's model. Here are some of the challenges: MongoDB doesn't have a schema. Each database has a number ... read more »
Metric Dot Chart With Series Grouping
Published: Monday June 17th 9PM
Link: http://forums.pentaho.com/showthre...art-with-Series-Grouping&goto=newpost
Description: I'm trying to use a Metric Dot Chart. When I use a heat map I get the following: Heat Map.JPG. However, I'd like the base and ortho axis to be continuous as opposed to discrete so I switched to a Metric Dot chart. The result set is as follows: Result Set.jpg but I can't get the Metric chart to group on the row and seat columns. In fact I get no output at all. I'm trying to create a seat map and would like the row/seat info to be ordered. A cross tab would be perfect but my data is not in that fo... read more »
Shell Script Help
Published: Monday June 17th 8PM
Link: http://forums.pentaho.com/showthre...144487-Shell-Script-Help&goto=newpost
Description: Hey All, I'm trying to do something that seems like it should be simple: I'm trying to execute a different shell script for every input row. It's a result set of dates- I want to run a shell script multiple times with that date passed as an argument. It seems like execute shell script doesn't like being passed the result set, and it also seems like it's ignoring the working directory it's executing in the Pentaho directory regardless of what I put in the WD box . Am I totally barking up the wron... read more »
Null Interpolation Mode - Ccc Line Chart
Published: Monday June 17th 5PM
Link: http://forums.pentaho.com/showthre...tion-Mode-CCC-Line-Chart&goto=newpost
Description: CCC v1 used to automatically interpolate missing data points and I can't seem to replicate that in v2. I found the nullinterpolationmode param and set it to Linear. Now the values are interpolated correctly but the series draws with dots not lines. Sample attached, the top line only has 4 real data points. Am I doing something silly ScreenShot001.jpg Attached Images ScreenShot001.jpg 9.1 KB read more »
Is It Possible To Run Classic Reporting Engine On Iis
Published: Monday June 17th 2PM
Link: http://forums.pentaho.com/showthre...-Reporting-Engine-on-IIS&goto=newpost
Description: Just started a new job in a .NET shop after doing a lot of Java. Told them about how great Pentaho reporting was. I've previously embedded the PRE in web pages and was wondering, since the classic engine runs independently of an app server, is it possible to embed PRE the same way. Unsure if it runs on the client or if it's running primarily on the server. I did some searches but not much turned up since it embedding the engine does not seem overly popular as it is. Does anyone know of a Pentaho... read more »
Dashboard Auto Refresh - Blank Screen Lag Time
Published: Monday June 17th 11AM
Link: http://forums.pentaho.com/showthre...sh-blank-screen-lag-time&goto=newpost
Description: Hello, Does anyone have experience with this I've created a report in Report Designer and then added it to a Dashboard. The dashboard is a single report and set to refresh every 60 seconds. When the report refreshes, the screen goes blank for a good 5 seconds or longer before returning again with refreshed data. Is there a way to minimize this blank screen time The SQL query returns data instantaneously, and only returns 40 or so rows, so it is not a factor of waiting on the database. I have tri... read more »
Cde -- Navigation Menu Component
Published: Monday June 17th 10AM
Link: http://forums.pentaho.com/showthre...avigation-Menu-Component&goto=newpost
Description: Hello, I am trying to introduce a Navigation Menu Component into my Dashboard and it's displaying all the files in my Browser window Steel Wheels, etc. . I was just wondering how I could customize it so that it displays for only certain Solutions Additionally when I click on the solution it redirects me to a webdetails page and I was hoping someone would know how to disable that though ideally I would still be able to hover over the solution and select which dashboard from that solution I want t... read more »
Execute Prpt Report From Xaction
Published: Monday June 17th 10AM
Link: http://forums.pentaho.com/showthre...prpt-report-from-xaction&goto=newpost
Description: Hi, Im trying to execute a prpt report from an xaction file. I added a resource of type application/zip of the report. The report just plains a hello world without any data sources. When i try to add a pentaho report as an action element i got an error when i run the xaction org.pentaho.platform.api.engine.ActionExecutionException: RuntimeContext.ERROR_0017 Here is my xml of the xaction: Code: < xml version="1.0" encoding="UTF-8" > <action-sequence> >Rep... read more »
Kitchen Cmd Line And Log File.
Published: Monday June 17th 10AM
Link: http://forums.pentaho.com/showthre...en-cmd-line-and-log-file&goto=newpost
Description: How can I get log filename from kitchen.bat -log='filename' Thanks read more »
Parameterize Transformation Directory/name
Published: Monday June 17th 9AM
Link: http://forums.pentaho.com/showthre...formation-directory-name&goto=newpost
Description: Hi, I don't know if this has been answered elsewhere in the forum, but is there a way to fetch transformation directory and filename as Internal.Transformation.Filename.Directory yields null value. thanks rajparameterize.jpg Attached Images parameterize.jpg 12.6 KB read more »
Y-axis Range In Bar Chart
Published: Monday June 17th 9AM
Link: http://forums.pentaho.com/showthre...-axis-range-in-bar-chart&goto=newpost
Description: Hello, I hope you can help me with my problem. I have a report with a bar chart, created with Pentaho Report Designer 3.9.0. The Y-axis-range and the interval for helping lines is set automatically by Pentaho. To see the automatic result I attached a litte screenshot. report.jpg My problem is that I want the y-axis-range to be higher, so that there is an interval with one helping line above my highest y-value. In the example the range should be 0-100. So that the helping line on top is higher th... read more »
Pentaho Initialization Exception - Pentahosystem.error_0014
Published: Monday June 17th 9AM
Link: http://forums.pentaho.com/showthre...PentahoSystem-ERROR_0014&goto=newpost
Description: Hi there, I am trying to install Pentaho BI Suite CE 4.8.0 using an Oracle database and have made all neccesary changes from following Prashant Raju's really helpful guide. However, i am now completely stuck with this error: The following errors were detected One or more system listeners failed. These are set in the systemListeners.xml. PentahoSystem.ERROR_0014 - Error while trying to execute startup sequence for org.pentaho.platform.plugin.action.mondrian.MondrianSystemListener Please see the s... read more »
Deleting All Mails
Published: Monday June 17th 8AM
Link: http://forums.pentaho.com/showthre...44454-Deleting-all-mails&goto=newpost
Description: hi all i am using GET MAILS POP3/IMAP step to delete all mails in all folders in gmail-adress. i set it like: imap.gmail.com use SSL, port:993 username, password Protokol: IMAP Action: Delete messages Folder: GMAIL/All messages Get all messages it is giving me an error: 2013/06/17 14:31:04 - GMAIL entleeren - ERROR version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy : Unexpected error: null 2013/06/17 14:31:04 - GMAIL entleeren - ERROR version 4.2.0-stable, build 15748 from 20... read more »
Sending Big Datas Via Mail, No Smtp-server
Published: Monday June 17th 7AM
Link: http://forums.pentaho.com/showthre...-via-MAIL-NO-SMTP-SERVER&goto=newpost
Description: hi all For now i am using smtp.gmail.com for sending datas via emails. We do have no own smtp-server, but vpn. Now i learnt that gmail allows sending datas in a limited amount not more than 25MB . What other variants do i have to send big datas more than limited in gmail without own smtp-server Any suggestions are appreciated, thank you in advance read more »
Design Studio - Save Results To Array
Published: Monday June 17th 4AM
Link: http://forums.pentaho.com/showthre...io-save-results-to-array&goto=newpost
Description: Hello Im making an action sequence in Pentaho's Design Studio. I have a Relational action which gets datas from a database. I have a for cycle which cycles through of these datas. In every round i have an IF statement, within the statement i want to store some datas in an array for further use. After i cycled through of resultSet i want to send out an email with datas filtered by the IF statement. So my question is, that how could i set up an array to store datas in it How could i add items to t... read more »
Custom Component With Data Source
Published: Monday June 17th 3AM
Link: http://forums.pentaho.com/showthre...mponent-with-data-source&goto=newpost
Description: I'm trying to develop a custom component for CDE that requires a data source such as a chart ccc . If I subclass the component from the class BaseComponent , I do not have a data source property available or the ability to map parameters on query variables . can you give me some guidance on how to do thanks for any response read more »
Combine Cells Report To Excel.
Published: Monday June 17th 2AM
Link: http://forums.pentaho.com/showthre...ne-cells-report-to-excel&goto=newpost
Description: Hi everybody, I have a problem with Pentaho Report Designer. I have a report that contains fields with lot of words and Excel not combine cells with properly. I would like to config a dynamic size or something that could combine cells when be necessary. I attached a picture for your comprehesionreport.png Many thanks I wish you could help me. Attached Images report.png 3.8 KB read more »
How To Generate Sql Statement With Ansi Join Clause
Published: Sunday June 16th 5PM
Link: http://forums.pentaho.com/showthre...nt-with-ANSI-Join-Clause&goto=newpost
Description: When the join happens between a cube and dimension tables, Mondrian will generate the SQL like this: "SELECT ..... FROM .... WHERE fact_table.column = dimension_table.column". How can I generate SQL statements with ANSI Join style like "SELECT .... FROM fact_table JOIN dimension_table ON fact_table.column = dimension_table.column" I didn't find any options from Dialect Interface. There's a method called " in Dialect Interface, but I didn't see it guarantee using ANSI Joi... read more »
Carte: Passing Variable/parameter To Use For Filtering
Published: Sunday June 16th 9AM
Link: http://forums.pentaho.com/showthre...ter-to-use-for-filtering&goto=newpost
Description: Hi guys, I got one question: Using Carte I would like to pass a parameter/variable into a given KTR to filter excel-rows according to the value of this parameter. While it is rather obvious to use such parameter/variable inside a "Table Input" step I could not figure an approach for applying such filter-logic to get only specific rows from an Excel-File. Does somebody have a good/usable idea/input on that Thx and best regards, Tom read more »
Versioning Kettle Projects With Git On Github - Advice
Published: Sunday June 16th 9AM
Link: http://forums.pentaho.com/showthre...h-Git- on-GitHub -advice&goto=newpost
Description: Hi I am currently working on a project revolving around importing the Eurostat database provided as SDMX files into a local database Postgres using Kettle. When I am done with this step I plan to set up an MDX access to the data via Mondrian. The ultimate goal then is to examin the data using Weka and other non-Pentaho tools. Naturally I would like to version and organize this project and my experience tells me that Git with a GitHub repo will be a good choice. I have only mild experience in pro... read more »
Passing Group By Parameter From Master Report To Subreport
Published: Saturday June 15th 1PM
Link: http://forums.pentaho.com/showthre...ster-report-to-subreport&goto=newpost
Description: Hi, I use json as the datasource for my master report with only one collection. I group rows by field in my Report Group. Geting table details with everything I have after grouping I can't make explanation section for these rows which in Details in Group Footer. I tried to place a subreport in Group Footer with Band set to Block but the problem is that I can't iterate through rows as I did in Details section, because I'm losing Grouping parameter and I get all rows without grouping. It might sou... read more »
Merge Two Excel Tables To Mysql With Kettle
Published: Saturday June 15th 10AM
Link: http://forums.pentaho.com/showthre...les-to-Mysql-with-Kettle&goto=newpost
Description: Hello, I'm new in pentaho. I have 2 excel tables : table1 A, B, C, D and table2 A, B, E, F . I want to merge these two tables using Keetle to have as a result one MySql table3 A, B, D for exemple. Can you tell me how can I do this please Regards. read more »
Loop In Mysql For Pdi
Published: Saturday June 15th 2AM
Link: http://forums.pentaho.com/showthre...54-Loop-in-Mysql-for-PDI&goto=newpost
Description: Hi, My requirement is I have to fetch couple of fields from the source system database to ETL database using some loop condition. How can I implement this in Pentaho. I am new to Pentaho. Loop in the sense, I am going to get a field from current selected row and again I am using that field value to get another record from the same table and this will continue till n iteration. I can not build the loop in SQL command line without using stored procedure to load the data into ETL. Please help read more »
Excel Data Files And String Conversion
Published: Saturday June 15th 12AM
Link: http://forums.pentaho.com/showthre...es-and-String-conversion&goto=newpost
Description: I have a column which is text in excel containing text, numbers and dates. When i import the excel file in data integrator and mask the column by using " in the fields tab my date fields for that column get the '#' value. Cannot have that happen. How do i get the correct values from excel to display in the data integrator is there an element i got to use which will enable me to get the right values from excel to ETL Thanks read more »
Pentaho Java Api
Published: Friday June 14th 5PM
Link: http://forums.pentaho.com/showthre... 144337-Pentaho-Java-API&goto=newpost
Description: I am brand new to Pentaho and have the task of trying to integrate it into some Java applications I have been working on. So far my experience with Pentaho includes downloading the community BI-Server and setting up a couple of things in the admin console new users/datasources . I was able to get access to the datasource in my PUC as well for reports and analysis. Now I am trying to do practically the same thing in Java Add a new datasource and configure it . I have been looking for different Ja... read more »
Chart Post-processing Script For Adding Dataset
Published: Friday June 14th 5PM
Link: http://forums.pentaho.com/showthre...cript-for-Adding-Dataset&goto=newpost
Description: I have a query that returns one row of data and I am trying to plot the data on a chart with multiple series. I am unable to use the dataset collectors in the chart interface, so I thought I could create the dataset using a post-processing script. I've been unsuccessful so far. Here is my script: Code: import org.jfree.data.category.CategoryDataset; import org.jfree.data.category.DefaultCategoryDataset; DefaultCategoryDataset defaultcategorydataset = new DefaultCategoryDataset ; &n... read more »
Cannot Get Jndi Datasources Working In Report Designer
Published: Friday June 14th 3PM
Link: http://forums.pentaho.com/showthre...rking-in-report-designer&goto=newpost
Description: I'm trying to configure PostgreSQL datasources to work from JNDI. I copied over a working default.properties file from another machine to /.pentaho/simple-jndi/default.properties, but when I test them in report designer, I get a stack trace leading to a NullPointerException. I can connect to the databases from the command line, and through report designer by connecting directly without JNDI, using the same information/credentials used in the default.properties file. Is there some log file for re... read more »
Invalid String Or Buffer Length
Published: Friday June 14th 2PM
Link: http://forums.pentaho.com/showthre...-string-or-buffer-length&goto=newpost
Description: I am just working on my local laptop running the following locally on my machine... 64 bit version of Windows 7, the 64 bit JDK and JRE, MS SQLServer 2008 R2 and I downloaded the open source version of Pentaho Data Integration from Source Forge version 4.4.0 stable . When I first go in and set up my database connection with the database connection wizard I get the "Connection to the database mydatabasename is OK". However as I continue developing my transformation something goes awry a... read more »
Carte Slave Unable To Access The Repository
Published: Friday June 14th 1PM
Link: http://forums.pentaho.com/showthre...to-access-the-repository&goto=newpost
Description: I have setup a carte cluster using pdi 4.4 and mysql 5.5 following directions I found here: http://open-bi.blogspot.com/2009/11/...-serie-of.html then I followed the directions here to try to test the carte cluster: http://diethardsteiner.blogspot.com/...on-remote.html the issue I'm having is when I try to run the transformation I get this error: Quote: org.pentaho.di.core.exception.KettleException: org.pentaho.di.core.exception.KettleException: There was an error during transformation split org... read more »
How To Change Shared Connection Metadata From Java Code
Published: Friday June 14th 12PM
Link: http://forums.pentaho.com/showthre...-metadata-from-java-code&goto=newpost
Description: Is there a way to change connection metadata db server address, user, password etc. from java code I have tried something like that, but it didn't worked for me. Code: ... SharedObjects so = new SharedObjects ; for SharedObjectInterface soi : so.getObjectsMap .values if soi instanceof DatabaseMeta DatabaseMeta dm = D... read more »
Email If Sql Condition Is Met
Published: Friday June 14th 10AM
Link: http://forums.pentaho.com/showthre...-if-SQL-condition-is-met&goto=newpost
Description: How can I email if NULL rows are returned I have a transformation using MERGE ROWS DIFF / SYNC AFTER MERGE to reconcile data and, in this case, all NEW records will be added, but then I need to go back and for now manually update a column associated with the addition. This column will be NULL until someone updates it. So I'm trying to build a transformation or job that will only email when these null values are present essentially notifying me that a new record was added . Another somewhat logic... read more »
Pcm13: Pentaho Community Event 2013 - Let's Start
Published: Friday June 14th 10AM
Link: http://forums.pentaho.com/showthre...-Event-2013-Let-s-start &goto=newpost
Description: WhatLet's get this going #PCM13 is starting to get organized. For the ones that don't know, the Pentaho Community Meetings have been happening since 2008 a bit all over Europe. Last year was in Amsterdam. It's one of my main objectives to end up with the silly "Enterprise / Community" differentiation. This is an event for everyone with a connection to Pentaho - customers, user, hackers, developers, students. I'll try to bring more of the Pentaho people, but the main spirit will remain ... read more »
Pentaho Community Meetup 2013 - Portugal Vote For The Date
Published: Friday June 14th 10AM
Link: http://forums.pentaho.com/showthre...ugal -Vote-for-the-date &goto=newpost
Description: GroupPicture.jpg Let's get this going #PCM13 is starting to get organized. For the ones that don't know, the Pentaho Community Meetings have been happening since 2008 a bit all over Europe. Last year was in Amsterdam. This year we're going to break 2 rules: We usually don't repeat the event location and it's usually entirely sponsored by the community itself. When I accepted the role of SVP for Community I put as condition that we'd sponsor this year's event, and that we'd repeat Portugal and ma... read more »
Ie No Sign If As Is Running While Indeed It's Running
Published: Friday June 14th 10AM
Link: http://forums.pentaho.com/showthre...hile-indeed-it-s-running&goto=newpost
Description: Hi, my company is using IE as a default browser. The problem I have is IE doesn't display any sign when Action Sequence is triggered and is running, so users waiting for AS execution don't really know if it's triggered or not. In Mozilla there is at least running circle with " info in tab name instead of "Penatho User Console" and bottom left corner displays message: "Waiting for bi-srever..." I'm using IE 9 Pawel read more »
What To Do In Prd When Using A Java Tablemodel
Published: Friday June 14th 9AM
Link: http://forums.pentaho.com/showthre...-using-a-Java-TableModel&goto=newpost
Description: This might be a simple question, but I don't know what to do in PRD when passing in a Java TableModel. I thought I have to make a Table data source and name the columns exactly as they are named in the TableModel. But the report preview showing up in my Java application is empty. So doesn't it work that way Basically I'm doing the following: Code: TableModel tm = ResultSetTableModelFactory.getInstance .createTableModel rs ; // generate a TableModel DataFactory df = new TableDa... read more »
Creating Relationship On A Non-star Schema Model
Published: Friday June 14th 9AM
Link: http://forums.pentaho.com/showthre...-a-non-star-schema-model&goto=newpost
Description: Hi, Question : Can Pentaho Meta editor support a non-star schema model Scenario: We are trying to evaluate pentaho to embed as a BI tool for our DW product. Our datawarehouse is not a typical star scheme model in which dimensions are directly linked to facts;but we have group-bridge tables between dimenion and facts A typical join between DIM_PRODUCT& FACT_CASE looks like: DIM_PRODUCT.PRODUCT_ID = PRODUCT_BRIDGE.PRODUCT_ID and PRODUCT_BRIDGE.PRODUCT_GROUP_ID = PRODUCT_GROUP.PRODUCT_GROUP_ID ... read more »
Calling Webservices In Pentaho
Published: Friday June 14th 9AM
Link: http://forums.pentaho.com/showthre...g-webservices-in-pentaho&goto=newpost
Description: Hi gurus, I am new to pentaho. Currently we have requirement in our project to call webservices and publish the results to oracle table. Below is the detail requirement: we are getting State,Zipcode details as csv format from source. Now we need to populate the longitude, latitude details using webservices corresponding to that state, city and store it in table. I tried to understand the existing transformation in sample folder but is giving me error. This is urgent requirement. Please help. Tha... read more »
How Will Make Dynamic Charts.
Published: Friday June 14th 8AM
Link: http://forums.pentaho.com/showthre...will-make-dynamic-charts&goto=newpost
Description: Hi, How to display an two charts with different details in a single dashboard panel.. How will dynamically changing charts in single dashboard panel.. In first chart contains country with customers, when you click an particular country means it shows the another chart in the same panel how will make it.. read more »
Displaying The Pentaho Generated Reports To The User
Published: Friday June 14th 6AM
Link: http://forums.pentaho.com/showthre...ated-reports-to-the-user&goto=newpost
Description: Hi All, Can you please help me, how to display the report generated using the pentaho tool should be shown to the End User. Basically, I just need to understand, how to display the report after building the report Please forward me the steps in doing so..Thanks a lot in advance. read more »
Cda With Pentaho Data Integration And Rest Client Fails
Published: Friday June 14th 4AM
Link: http://forums.pentaho.com/showthre...on-and-REST-client-fails&goto=newpost
Description: Hi, i try create my first dashboard, but with no result. I've kettle transformation that gets data from Zabbix via zabbix API JSON-RPC , but can't. Kettle transformation in Spoon works fine and returns the data, but not in CDA. When I run my cda file then i see errors in catalina.out. May be it's bug or my mistake some where it's my first experience with Pentaho . Where's i'm wrong Thanks p.s. bug report if it's http://redmine.webdetails.org/issues/2270 catalina.out messages when open cda in pen... read more »
Date Conversion And Bst
Published: Friday June 14th 4AM
Link: http://forums.pentaho.com/showthre...-Date-conversion-and-BST&goto=newpost
Description: Hello, I'm running PDI CE v4.4 and have used a select values step to convert a field to a date using the mask yyyy-MM-dd HH:mm:ss.SSS. However PDI is rejected all dates between 2013-03-31 01:00 and 2013-03-31 02:00 as this the British Summer Time switch over so technically the date does not exists. Is there any way to turn off this as I'm processing data that does not originate from the UK and not all UK servers automatically switch with time change as this is delayed to avoid issues with the ov... read more »
Configurable Excel Output - Best Practice
Published: Friday June 14th 4AM
Link: http://forums.pentaho.com/showthre...cel-Output-Best-Practice&goto=newpost
Description: Hello Community I want to be able to export the result of a MDX query as a Excel sheet. I know how to do with CDA and also with a Pentaho Report Viewer. But I want to be able to configure the generated Excel file. Like defining Column Headers, adding a Logo and stuff like that. Is it possible to define for a report for example to only export the textual data and not the whole report Or to configure the CDA output Thanks & Regards read more »
Weka Svm Smo - C And Gamma Parameter Optimization
Published: Friday June 14th 2AM
Link: http://forums.pentaho.com/showthre...a-Parameter-Optimization&goto=newpost
Description: Hello, I am using the Weka SMO Support Vector Machines for Machine Learning. I was trying to optimize the " and the " parameters, and was reading the following documentation: http://weka.wikispaces.com/Optimizing+parameters I read the "Optimizing SMO with RBFKernel C and gamma " section, but I couldn't figure out how I could set the " and ". I would appreciate it if somebody could please let me know how I could optimize the parameters. I was using the GUI tool. Can ... read more »
How To Solve If Dimension Table Has Composite Key.
Published: Friday June 14th 2AM
Link: http://forums.pentaho.com/showthre...-table-has-composite-key&goto=newpost
Description: I google some information about the composite ,but I can't find solution. Anyone could give some keyword or example Example Dimension table1 account_id customer_id model pn 1 2 AAA a12 1 2 AAA a13 1 2 BBB b12 2 1 AAA a13 2 1 CCC c12 3 1 DDD d13 3 1 DDD d33 3 1 DDD d23 3 3 DDD d65 Fact table2 account_id customer_id region date1 date2 pn 1 2 T 20120102 20120202 a12 1 2 T 20120102 20120202 a12 1 2 T 20120102 20120203 b12 1 2 T 20120102 20120203 a13 2 1 C 20120202 20120203 a13 2 1 C 20120102 2012020... read more »
How To Manage User Security In Pentaho Community Edition
Published: Friday June 14th 2AM
Link: http://forums.pentaho.com/showthre...entaho-Community-Edition&goto=newpost
Description: Hi Experts, I'm a newbie to Pentaho. Is there any way Client tool or console to manage security Roles, Users, User Groups, Access Levels in Pentaho Community Edition in adnavced manner. Thanks in advance. : read more »