tag:blogger.com,1999:blog-4527276399966185267.comments2024-03-06T20:16:30.599-08:00Diethard Steiner on Business IntelligenceAnonymoushttp://www.blogger.com/profile/05683544764949933581noreply@blogger.comBlogger660125tag:blogger.com,1999:blog-4527276399966185267.post-34516554068136362052018-01-01T05:21:31.716-08:002018-01-01T05:21:31.716-08:00I have the same problem.
Similar to here: https:/...I have the same problem. <br />Similar to here: https://forums.pentaho.com/showthread.php?196917-Error-using-Mondrian-4-aggregate-tables<br />Do you have any idea?Unknownhttps://www.blogger.com/profile/04771406119996499430noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-31949678837811256682017-11-02T10:27:21.496-07:002017-11-02T10:27:21.496-07:00Hi Diethard, thanks for such valuable hint!
One m...Hi Diethard, thanks for such valuable hint!<br /><br />One more question: how do we deal with this error on Windows? There's no LANG variable...Anonymoushttps://www.blogger.com/profile/11895245003593710999noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-54994954484140333242017-10-15T10:14:33.509-07:002017-10-15T10:14:33.509-07:00Thank you for this.! Thank you for this.! Sadakar Pochampallihttps://www.blogger.com/profile/13590828239755256167noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-56652555593011348552017-09-19T05:56:10.201-07:002017-09-19T05:56:10.201-07:00Hi Diethard Steiner, am facing issue in creating n...Hi Diethard Steiner, am facing issue in creating new username & password for Pentaho Carte Server.<br /><br />I tried following chnages in cofig.xml file<br /><br /><br />slave-8086<br />localhost<br />8086<br />Admin<br />Password@12345<br />N<br /><br /><br />It will be helpful if i get any suggestion here.Anonymoushttps://www.blogger.com/profile/13473094716874239374noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-59142572170701080152017-07-27T04:15:48.252-07:002017-07-27T04:15:48.252-07:00I don't have this example available any more. ...I don't have this example available any more. Also, there are better ways these days to implement a loop in PDI.Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-85973870593932749312017-07-27T02:23:35.657-07:002017-07-27T02:23:35.657-07:00I want to know abt this loop example where I can f...I want to know abt this loop example where I can find it?Vipul Sharmahttps://www.blogger.com/profile/17023332362562843440noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-68938975456157336012017-07-25T12:20:16.176-07:002017-07-25T12:20:16.176-07:00Thank you, your solution was the only one that wor...Thank you, your solution was the only one that worked for me.Unknownhttps://www.blogger.com/profile/02728392176123222333noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-31840321561713687072017-06-29T02:15:40.202-07:002017-06-29T02:15:40.202-07:00Thank you very much, I am now using this method an...Thank you very much, I am now using this method and it works well. But it's a pity you have to define a parameter twice. Anonymoushttps://www.blogger.com/profile/17084227811721613283noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-69351892335493803842017-06-22T22:51:44.062-07:002017-06-22T22:51:44.062-07:00They get passed down automatically from the job ar...They get passed down automatically from the job are transformation you call. Just make sure that the sub-job or sub-transformation does not have the same parameters defined in the settings. Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-90079048066689410352017-06-22T19:58:50.212-07:002017-06-22T19:58:50.212-07:00Because named parameter's scope is only confin...Because named parameter's scope is only confined to one trans or job as far as I know. Is there a way using named parameters globally?Anonymoushttps://www.blogger.com/profile/17084227811721613283noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-25950225029662260252017-06-22T13:10:16.495-07:002017-06-22T13:10:16.495-07:00Why don't you just use named parameters?Why don't you just use named parameters?Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-37655521414700345342017-06-22T10:23:43.228-07:002017-06-22T10:23:43.228-07:00Sorry, Do you mean is 'get system info' is...Sorry, Do you mean is 'get system info' is the only way to pass values to variables? I'm new to kettle, I look for the pentaho wiki only getting the named parameter help and nothing about variable. My requriement is define global variables avaliable to all trans and jobs. In other words, define once, use and pass values anytime in any trans, jobs and crontab or cmd schedule. For exmaple, a trans reads raw data within specific period, and writes to excel. A job call the trans and sends the result file in email. I want to define a variable "VAR_FILE_NAME" differing from 'Daily' to 'Weekly'.The trans uses "VAR_FILE_NAME" to create excel file, and the job uses "VAR_FILE_NAME" to make the email title. In this case, which is the apropriate way to defien and pass values to the global variable?Anonymoushttps://www.blogger.com/profile/17084227811721613283noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-15701431156405525662017-06-22T09:43:50.911-07:002017-06-22T09:43:50.911-07:00You can't set the variables in the same transf...You can't set the variables in the same transformation you use them. If it is possible to create a SQL prepared statement, remove the set variables step and create a direct hob from the get system info step to the table input step. Otherwise, you will have to put the get system info and set variables step into a seperate transformation and run this one before your main transformation so that the variables are available to it (use a job to orchestrate this).Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-33023543512631459652017-06-22T09:32:13.039-07:002017-06-22T09:32:13.039-07:00Yes, I linked the 'Get system info' step t...Yes, I linked the 'Get system info' step to 'Set variables' step. here is the log and screenshot on Dropbox for your to figure out.https://www.dropbox.com/sh/4u3a53hoxmnwrf6/AACDZ7PwLmoOh9iUXgPlJ-5Da?dl=0.<br />My reqiurement is how to passing values to variables in scheduling. Thank you very much!Anonymoushttps://www.blogger.com/profile/17084227811721613283noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-46421296286260873422017-06-22T09:02:35.958-07:002017-06-22T09:02:35.958-07:00Are you using the `Get System Info` step?Are you using the `Get System Info` step?Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-38382029802309941542017-06-22T08:40:08.716-07:002017-06-22T08:40:08.716-07:00Thanks! I've benn confused with passing value ...Thanks! I've benn confused with passing value to variables in cmd line for a few days, and this helps me a lot. But I still have some questions and hope you could help in your spare time.<br />I've tried the use of argument and it works fine. But when it comes to variable, there's question. I uses cmd line like this:<br />"pan /rep:file_repo /trans:CaterOrdersReport 1 7".<br />The error message is:<br />"Conversion failed when converting the varchar value '${var_date_start}' to data type int."<br />But it did works fine in the GUI form, which just exactly the same with mark's above.<br />The software environment is PDI 7.0 on AWS-Windows server 2012.Anonymoushttps://www.blogger.com/profile/17084227811721613283noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-13757235337693840372017-06-21T07:42:58.062-07:002017-06-21T07:42:58.062-07:00It sounds more like data that you want to display ...It sounds more like data that you want to display the output of transformation in a custom format, and yes, you can do this, in example using the QueryComponent (among other possibilites).Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-64529936377430474522017-06-21T06:03:31.016-07:002017-06-21T06:03:31.016-07:00Hi, it's a nice article, but is there any way ...Hi, it's a nice article, but is there any way how to pass some parameter from a Kettle job or transformation to the dashboard? <br /><br />I think about something like, you open the sparkl plugin and initially it is fulfilled with the some data coming from one etl endpoint, which you can naturally change and "push" it in the described above way to some another kettle endpointKonradhttps://www.blogger.com/profile/05945446851367973362noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-81349674269083823812017-05-08T11:02:08.819-07:002017-05-08T11:02:08.819-07:00Thankyu for the tutorial. I find it's easy to ...Thankyu for the tutorial. I find it's easy to understand.nikenhttps://www.blogger.com/profile/07865588651382076222noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-25471420050814263912017-04-24T06:32:21.883-07:002017-04-24T06:32:21.883-07:00Hi, I followed the example above. My transformati...Hi, I followed the example above. My transformation is saved here:C:\Pentaho7\design-tools\data-integration\Text File\sample1.ktr <br /><br />and here is my web service call:http://localhost:8181/kettle/executeTrans/?trans=2F%C:2F%Pentaho72F%design-tools2F%data-integration2F%Text%20File2F%sample1.ktr&VAR_LENS_MOUNT=m42<br /><br />I am getting HTTP ERROR:500 problem accessing /kettle/executeTrans. Do you know what i am missing?Anonymoushttps://www.blogger.com/profile/11795995806181794598noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-20114925035423414122017-03-27T09:26:39.775-07:002017-03-27T09:26:39.775-07:00Where i can set above setting exactly in database ...Where i can set above setting exactly in database connection. Will appreciate your help for steps.<br />ThanksDheeraj Nishadhttps://www.blogger.com/profile/08127645193902944779noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-60360332732101971332017-03-25T01:45:02.239-07:002017-03-25T01:45:02.239-07:00It looks like the result of a logical problem in y...It looks like the result of a logical problem in your mondrian schema. Apart from that, I guess you have enabled aggregate tables in the mondrian.properties on your server?Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-24907299252458951512017-03-25T00:10:27.881-07:002017-03-25T00:10:27.881-07:00Hi, I have created aggregate table using aggregate...<br /><br />Hi, I have created aggregate table using aggregate designer. Then published it on server. When I open jpivot for that cube and click expand to any of the dimension, I get an error. When I looked at mondrian_sql log file it shows a qeury created like this below. In that query, there is where clause that refers to aggregate table but the name of the aggregate table does not come up in "from" section. Am I missing any specific configuration?<br />select<br /> `Dim_Time`.`Time_Id` as `c0`,<br /> `Dim_Time`.`month_no` as `c1`<br />from<br /> `Dim_Time` as `Dim_Time`<br />where<br /> `Dim_Time`.`Time_Id` = `AggTable1`.`Dim_Time_Month_(Key)`<br />group by<br /> `Dim_Time`.`Time_Id`,<br /> `Dim_Time`.`month_no`<br />order by<br /> ISNULL(`Dim_Time`.`Time_Id`) ASC, `Dim_Time`.`Time_Id` ASCAnonymoushttps://www.blogger.com/profile/10968145708373185863noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-44517618559627327782017-02-06T03:20:39.756-08:002017-02-06T03:20:39.756-08:00Try to log a jira case on jira.pentaho.com.Try to log a jira case on jira.pentaho.com.Anonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.comtag:blogger.com,1999:blog-4527276399966185267.post-15574967667083489322017-02-06T02:55:57.680-08:002017-02-06T02:55:57.680-08:00We tried this with Pentaho 5.4.0.1-130
Your guide ...We tried this with Pentaho 5.4.0.1-130<br />Your guide works nice so far, but it doesnt work for text/html, as Florent Thomas mentioned already. Is there a workaround? like to set !important or something like that?Anonymoushttps://www.blogger.com/profile/03977114436596389238noreply@blogger.com