{"id":194,"date":"2006-08-25T09:05:35","date_gmt":"2006-08-25T16:05:35","guid":{"rendered":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/08\/25\/pentaho-tech-tips-call-for-prioritization\/"},"modified":"2006-08-25T09:05:35","modified_gmt":"2006-08-25T16:05:35","slug":"pentaho-tech-tips-call-for-prioritization","status":"publish","type":"post","link":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/08\/25\/pentaho-tech-tips-call-for-prioritization\/","title":{"rendered":"Pentaho Tech Tips: Call for prioritization"},"content":{"rendered":"<p>Open source is democratic, open, real.<\/p>\n<p>While I have a good sense for which Tech Tips would be useful, I&#8217;d also like to ask the community for what tips they&#8217;d like to see written up:<\/p>\n<ul>\n<li><b>Mondrian: Star Schema to OLAP cubes<\/b><br \/>A very basic Star Schema with a Fact and Two Dimensions show how this is built into a Mondrian cube and how to built a &#8220;Pivot view&#8221; Pentaho report.<\/li>\n<li><b>Mondrian: Advanced MDX <\/b><br \/>Sets, top, running totals, etc<\/li>\n<li><b>Kettle: Portable ETL<\/b><br \/>Showing how to use paramater injection to make your Kettle solution (Jobs and Transforms) executable inside of Pentaho.<\/li>\n<li><b>Kettle: Custom rollups using Excel<\/b><br \/>Showing how to build a dimension, reporting table, etc using a very easy to use interface for business users.<\/li>\n<li><b>Reporting: List of Values<\/b><br \/>Show how to use the most unfortunately named Secure Filter component to do list of values (even though you are not REQUIRED to do any security).&nbsp; Not very eloquent but the suggestion has been to call it a &#8220;Prompt For&#8221; component (see below).&nbsp; Think &#8220;parameter page&#8221; driven by &#8220;select distinct name from my_reporting_table.&#8221;<\/li>\n<li><b>Report Designer: How to build reports with Charts<\/b><br \/>The latest release included the charting expressions so now one can build reports with lovely looking charts.<\/li>\n<li><b>Report Designer: How to pass &#8220;Pentaho&#8221; parameters to reports<\/b><br \/>This allows the building of drill thru parameters, titles, and other &#8220;context&#8221; from the server<\/li>\n<li><b>Pentaho Spreadsheet Services: Your data looking sexy in Excel<\/b><br \/>A quick how to of how to get an instant excel analytic interface into ANY database.&nbsp; Example with <b>Oracle XE.<\/b><\/li>\n<\/ul>\n<p>Comments are ON&#8230; vote, have your say.&nbsp; I <i>WANT<\/i> to do all of these, and will, eventually.&nbsp; What do <i>YOU<\/i> want to see?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Open source is democratic, open, real. While I have a good sense for which Tech Tips would be useful, I&#8217;d also like to ask the community for what tips they&#8217;d like to see written up: Mondrian: Star Schema to OLAP cubesA very basic Star Schema with a Fact and Two Dimensions show how this is [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/194"}],"collection":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/comments?post=194"}],"version-history":[{"count":0,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/194\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/media?parent=194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/categories?post=194"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/tags?post=194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}