Stack Overflow
Stack Overflow

Questions tagged [pentaho-cde]

Community Dashboard Editor from Open-source provider of reporting, analysis, dashboard, data mining and workflow capabilities.

304 questions
3
votes
1 answer

Pentaho merge rows (diff) not showing "changed"

I've got this steps The merge rows diff is configured as follow But when a update is detected it doesn't show the "changed" tag, it show two rows, a deleted and a new The documentation says that a "changed" tag should be displayed on the update…
mariowise
  • 2,167
  • 2
  • 21
  • 34
3
votes
2 answers

Pentaho BI Marketplace

I'm trying to make some changes in my Dashboards with CDE . But when I access Pentaho plateform 5.0 as Admin I can't find the Marketplace in all the menus Thanks for helping me !
ATTAR
  • 33
  • 1
  • 4
3
votes
1 answer

Pentaho CDE Chart

I am trying to create a line chart in pentaho (CDE). But what I see that happens is: first query column goes into dimension, and all the rest go into expressions. But what I need to do is this: columns: Year, Type, Value I need Year to be the X axe…
Kal
  • 323
  • 2
  • 7
  • 17
3
votes
1 answer

Pass parameter to pentaho CDE report

I created a CDE parameter report in this report I want pass parameter through url my CDE report link as below http://localhost:8080/pentaho/content/pentaho-cdf-dd/Render?solution=demo&path=&file=pass_parameter.wcdf&userid=joe&password=password and…
Neo-coder
  • 7,715
  • 4
  • 33
  • 52
3
votes
2 answers

Datatable in Pentaho CDE

I'm trying to do datatables in pentaho cde. In pentaho the name of component is Table Component. The problems is where I try to do a dynamic query with a no specific number of columns, and the following error occurs: DataTables warning (table id =…
trai bui
  • 588
  • 12
  • 36
2
votes
1 answer

How mysql repository works in Pentaho User console?

Based on Pentaho guideline (https://help.pentaho.com/Documentation/8.2/Setup/Installation/Archive/MySQL_Repository) I successfully converted pentaho File based repository to MySQL database repository. Now does anyone have any idea how MySQL…
NP007
  • 659
  • 8
  • 21
2
votes
1 answer

Number with a lot decimals in pentaho cde table component

i have 4 columns in a table of pentaho cde. the 1st column is a string the second and third column are numbers with a lot of decimals. i want this numbers in this format ###,## how can i do it in table component of pentahop cde.
ilanas
  • 117
  • 1
  • 11
2
votes
2 answers

Issue in creation a chart in pentaho

I recently use pentaho BA 8 and I have a problem in the creation of a new chart with sql query in Pentaho. I've made a query and assign that in the chart, but in the moment to see the preview view, the view appear in blank. FYI, the chart is…
Felipe Guerra Araya
  • 21
  • 3
2
votes
2 answers

Where are CDE Dashboard files stored?

For the life of me I cannot find where Pentaho stores the user-created CDE Dashboard files in the file structure? I am using the Community Edition, and I assumed that all the files would be stored in /biserver-ce/pentaho-solutions. When I sign…
whistler
  • 876
  • 2
  • 15
  • 31
2
votes
0 answers

How to resolve Pentaho JPivot Resultset Overflow?

My logs table contains more than 9 lacks records and i'm using the following query Select date_format(time,"%d-%m-%y") as day,uri,1 as count from logs; Query gives the overflow exception in JPIVOT PENTAHO Community Edition
Dilip D
  • 567
  • 1
  • 5
  • 28
2
votes
0 answers

how to change date format(time zone) in CDE Dashboard in Pentaho

The data source which the date is stored in GMT is linked with Pentaho. when i am creating CDE Dashboard, i am unable to find the option changing data format into IST(GMT, +5:30:00). Let me know where to change the data format(layout Panel or…
learningstudent
  • 577
  • 1
  • 4
  • 14
2
votes
2 answers

pentaho cde include/exclude where clause in sql query

I am building a Dashboard using Pentaho CDE, in which a table will show data from a query like this : select * from types where id = ${id} Now i get the id from url parameter like this id = Dashboards.getQueryParameter('id'); If I dont give the id…
dumb_terminal
  • 1,815
  • 1
  • 16
  • 27
2
votes
1 answer

How To Add Analysis Graph in CDE Dashboard in Pentaho

I made Some Graph in Pentaho Analysis Report and Than i Made New Dashboard in CDE Now i Want to add these Analysis Graph in CDE Dashboard is it possible or i have to made new Graph ? I am new in Pentaho
user5064261
2
votes
1 answer

Pentaho CDE Bar chart display

I am trying to display a simple static Bar Chart in pentaho CDE but while previewing it i am not getting any result. I am using Pentaho 5.4.0.1.130 version. my console display. my chart component panel details I checked the Query result in mysql…
Helping Hand..
  • 2,430
  • 4
  • 32
  • 52
2
votes
2 answers

how to pass parameter name as a databasename in pentaho BA Server?

I have scenario where i have one table in one database which consist all the database names,so in drop-down container i am displaying all this database name, now in another query i want to pass this database name as a parameter and want to retrieve…
Helping Hand..
  • 2,430
  • 4
  • 32
  • 52
1
2
3
…
20 21