Pentaho Tools :

Pentaho C-Tools(CDE,CDF,CDA),Pentaho CE & EE Server,OLAP-Cubes,Analysis using Pivot4J, Saiku Analytics, Saiku Reporting, Ad-hoc Reporting using Interactive Reporting Tool,Dashboards,Reports using PRD, PDD,Data Integration using Kettle ETL,Data Mining usign WEKA,Integration of Servers with Databases,Mobile/iPad compatible Dashboards using Bootstrap Css,Drilldown dashboards,Interactive Dashboards

Friday, 13 September 2013

Tech Tips - Pentaho CDE,CDA empty file & CDA Cache Manger

CDE,CDA issue:

I was wondered while opening .cda file in pentaho Server. I didn't find any scripting.
Generally when we create "Database"connections  while designing the dashboard , the scripting automatically generates in .cda file.  

When I saved as  the CDE with some other name with "Spaces" for example "CDE Dashboard Demo" (there are white spaces among the words) the .cda file also takes the same name with .cda extension.

It'll allow the names with spaces but  it can not contain any  database connections scripting. So avoid giving spaces in Naming the dashboard also when you save as avoid spacing. 

This is an issue in CDA creation.
Thank you pedro for letting me know the tip in C-Tools forum.

Issue link:
http://redmine.webdetails.org/issues/1367

CDA Cache Manager:

In the pentaho browser , go to Tools->CDA Cache Manager

Here you can find Scheduled queries and cached queries.

Sadakar
BI developer