Stack Overflow
Stack Overflow

Questions tagged [pentaho-ctools]

Pentaho - Community Tools (ctools). A set of tools and components, working on top of Pentaho for custom dashboard implementation.

Pentaho - Community Tools (ctools). A set of tools and components, working on top of Pentaho for custom dashboard implementation.

Learn more about Pentaho - Community Tools (ctools) here.

60 questions
1
vote
0 answers

Load external JS with document.write from a third party in Angular 8

I'm creating a library with Angular 8 to render dashboards from Pentaho CTools to avoid to use iframes. If I call the script straight from index.html it works fine so I can render the dashboards. But in my case I need to inject that from appendChild…
Marco Duran
  • 11
  • 2
1
vote
0 answers

Pentaho 6.1 - How to show a drop-down list of possible results when searching in a field?

I have two fields where to look for the values ​​present in the first and fourth columns of the table. I would like to show a drop-down list of possible values ​​that start with the text I'm writing. How can I change the following javascript…
Fabrizio
  • 23
  • 7
1
vote
1 answer

How to pass a variable obtained from query component into a query on Pentaho CDE?

I managed to get data as variable with Query component. Now I want to pass this variable into a query. Here is what I did: On Query Component: myresult='NYC' in my example. The query on Datasources: I use this one to display a chart, when I…
user11492726
1
vote
0 answers

Cumulative Distinct Count SQL CTools (Pentaho)

I am trying to return a column that calculates the cumulative distinct count of users for each row (i.e. for one row, you are counting the distinct users from that date moving back to the first date/row). When I run this query in DB2, I get "invalid…
Andrea
  • 23
  • 4
1
vote
1 answer

How to Display Percentage values on TOP of CCC Bar Chart in CDE (Non-Stacked Bar Chart)

My requirement is to show percentage values on the top of the bar ccc Bar chart (non-stacked), so far I have got the percentages in between the bar charts all I need is to display them on the top. I have added this function in clickable action and…
Shinchan_Shiro
  • 73
  • 2
  • 13
1
vote
1 answer

Filter cached sqlJdbs query in Pentaho CE

I use sqlJdbs query as a data provider for my CCC controls. I use geospatial request in my query that's why I cache my results(Cache=True). Otherwise the request made long. It works fine. However I have to use parameters in my query to filter…
Timur Kobilov
  • 98
  • 9
1
vote
2 answers

Pentaho | Issue with CSV file to Table output

I am working in Pentaho spoon. I have a requirement to load CSV file data into one table. I have used , as delimter in CSV file. I can see correct data in preview of CSV file input step. But when I tried to insert data into Table Output step, I am…
Nilesh Patil
  • 91
  • 2
  • 11
1
vote
1 answer

How to make URL for column cells in CDE table component?

I am making a dashboard with table component. I want to make URL for records in table like in this link How to make URL for records in CDE table component? I apply the similar function and apply it in the "Post execution" in my table component…
Connie Chen
  • 113
  • 1
  • 15
1
vote
2 answers

Fetch Data From Remote Database Every Hour

Yesterday i Download Pentaho BI Server Data Integration Report Designer Than I connect report designer to the remote database and fetch table and draw chart of that data successfully. My Question is ,I want to run that file (which i create in…
Muhammad Younas
  • 1,543
  • 1
  • 22
  • 32
1
vote
0 answers

Pentaho Chart option

I am working with a Pentaho dashboard designer and in a stacked chart particular product is having more quantity and it is occupying more space when compared with the rest three products. Is there any way to make to display the chart color evenly…
Anushya Shyamala
  • 11
  • 3
1
vote
1 answer

Pentaho 5.4.0 Community Edition Remote Execution

am using Pentaho community edition 5.4.0 ,I explain My requirement very Simply, 1) I have my jobs and transformation in my local windows machine and i like to execute those in my client machine ,So that i installed same Pentaho community version…
Dhamodharan
  • 133
  • 1
  • 3
  • 16
1
vote
0 answers

Connecting Pentaho Spoon Data Integration with Business Analytics Web Localhost

I am doing an usecase with Pentaho - Cassandra. I installed Pentaho Business Analytics - successfully.. and connected to locahost. localhost:8080/pentaho. In the DataSources (Manage Data Sources) I can see MySQL, Postgres, etc. But my objective is…
Soundarya Thiagarajan
  • 574
  • 2
  • 13
  • 31
1
vote
1 answer

Error connecting to MS SQL SERVER in Pentaho

I m using Pentaho v5.2. When i tried to connect to sql server i m end with below error. I had downloaded and placed required driver sqljdbc4-2.0 jar in pdi-ce-5.2.0.0-209\data-integration\lib. Please help me as I'm new to Pentaho. Error connecting…
Ramakrishna perla
  • 11
  • 1
  • 2
1
vote
1 answer

Pentaho files browse panel folders are hidden

Hope you people are fine, I have been working in PENTAHO and have made a dashboard successfully, but when i have uploaded my files and folders on the server, cde, cda file are rendering in the file browser panel, but Folders don't appear for my…
shzyincu
  • 409
  • 4
  • 21
1
vote
0 answers

Lookup-map role mapper configuration on MONDRIAN

Dear Mondrian/Pentaho BI server team I am trying to implement this security options in Mondrian schema and currently am facing issues to get around with it. I am using pentaho biserver 5.0.1 Community edition. 1) Tried Listing 6.3. Lookup-map…
PhanJAf
  • 11
  • 8
1
2 3 4