Stack Overflow
Stack Overflow

Questions tagged [pentaho-design-studio]

Pentaho Design Studio is a collection of editors, viewers and administration modules integrated into a single application that provides a graphical environment for building and testing Action Sequence documents, and JFree reports. NOTE: Not the same as "pentaho-report-designer".

Pentaho Design Studio is a collection of editors, viewers and administration modules integrated into a single application that provides a graphical environment for building and testing Action Sequence documents, and JFree reports. NOTE: Not the same as pentaho-report-designer.

See http://wiki.pentaho.com/display/ServerDoc2x/Design+Studio

83 questions
1
vote
1 answer

Pentaho xaction - How can I change database name on runtime?

I am using Pentaho Design Studio(pds-ce-win-32-4.0.0-stable). In an xaction file I need to change database name in the url like jdbc:sqlserver://IP:1433;databaseName=??????;integratedSecurity=false I generated an output as result set column that…
MNessa
  • 48
  • 8
1
vote
1 answer

Control data flow in Pentaho transformation with variables

I want to control data flow in pentaho transformation files with system variables. I found a component called 'simple evaluation' which is exactly what I want, however it can only be used in job files. I have gone through component-tree of…
Tony Zhu
  • 301
  • 1
  • 6
  • 16
1
vote
0 answers

Why is my Pentaho server running slow, on Linux?

I am using Pentaho 4.8 and this is the configuration in my start-pentaho.sh export CATALINA_OPTS="-Xms256m -Xmx1024m -XX:MaxPermSize=256m -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000" Can anybody please explain…
Hussain Akhtar Wahid 'Ghouri'
  • 6,527
  • 8
  • 50
  • 85
0
votes
1 answer

Getting data from a database and outputting it in another DB dynamically with Pentaho

I've been trying to solve the following problem for a while now. I hope you guy can help. I am passing a table from one DB to another DB using pentaho. I am using a Data Input Step in which I am selecting the last Max ID. Then in another Data Input…
user22409127
  • 1
0
votes
0 answers

How to grab value from DB table and use that value to replace another field in Pentaho

I'm currently using a table input step that runs a sql to extract data. I have another text file input stream and I need the data from the table input step to replace one of the field values in the text file input. How would I go about doing…
Jinsu
  • 1
  • 1
0
votes
0 answers

Pentaho job failing only when running through control-m

Pentaho job is failing when run through control-M and completes successfully when run manually on spoon and when run on the same server through a script. Below is the error: 2023/06/16 10:27:40 - TRANS_SRC_LND - ERROR (version 9.0.0.7-758, build…
Riya Dubey
  • 1
  • 1
0
votes
1 answer

Pentaho Report Designer Database connection with variable on preview

I set the db credentials in kettle.properties, i set the variables with credentials in data source successfully but when i click preview it gives me this error, it seems that it can't recognize the variable This is how I declared the variables in…
Cristina Moretti
  • 77
  • 8
0
votes
1 answer

Pentaho transformation swithc/sace doesnt work as suposed to be

Pentaho , i have transformatipn step set_useful_life have select from the table and assign the result to the variable. them switch/case, check result, and supposed to run SQL dwh_adhoc_useful_life step only if the variable is 2 I 100% sure that…
Andrey
  • 1,629
  • 13
  • 37
  • 65
0
votes
1 answer

Looking for updates in Pentaho7.x for log 4j vulnerability and it's procedure

We are currently using pentaho 7.X, after log 4j vulnerability we need a solution for that. Please let me know if we have any updates in pentaho 7.x after log4j issuse or we need to upgrade to latest version. If we need to upgrade to latest version,…
prason robin
  • 1
  • 1
0
votes
1 answer

Pentaho- Can we import a sub report/ report into a report in Pentaho?

I am having multiple reports which includes same subsections created by sub reports. I want to make changes in the sub reports in the main reports, Present approach- Open each report and modify the sub report in it. Expection- Change in one sub…
Pragati Das
  • 1
0
votes
1 answer

Pentaho- How do I view the backend sql of reports?

I have currently managed to get access to the Pentaho User console and have 4 reports that I plan to migrate to an alternate BI platform ( say Power BI or SSRS) Within Pentaho user console, I can view the reports, my home page also shows me option…
Ami
  • 3
  • 3
0
votes
1 answer

Pentaho-IVYDC and IVYBC Plugin

I Installed IVYDC And IVYBC plugins through pentaho market place but it is not rendered properly in pentaho dashboard .. when i tried to create dashboard through pentaho cde dashboards i cant use these two plugins ..In the dashboard components panel…
subash0203
  • 26
  • 4
0
votes
2 answers

Pentaho spoon error: "Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections."

I'm new in Pentaho environment. I installed pentaho CE recently on another computer and couldn't preview a simple mongoDB input step result which fetches data from mongodb. It is giving me the following error message: Blockquote …
Elias Gezahegn
  • 55
  • 6
0
votes
1 answer

convert strng to integer in pentaho report designer

Is there any way to convert the number in to string and concatenate '%' to that number. I tried writing expression for this. But what ever I have written it is giving me 0 value. like i already had one column with number datatype and I created a new…
sree
  • 3
  • 7
0
votes
1 answer

Schedule reports in Pentaho user console

How to schedule reports in Pentaho User Console. Also let me know how to email scheduled reports particular address in Pentaho User Console.
Swapnil Solanki
  • 1
  • 2
1 2
3
4 5 6