{"id":202,"date":"2006-10-30T12:02:23","date_gmt":"2006-10-30T19:02:23","guid":{"rendered":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/10\/30\/sales-percent-increase-month-to-month-qtr-to-qtr\/"},"modified":"2006-10-30T12:02:23","modified_gmt":"2006-10-30T19:02:23","slug":"sales-percent-increase-month-to-month-qtr-to-qtr","status":"publish","type":"post","link":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/10\/30\/sales-percent-increase-month-to-month-qtr-to-qtr\/","title":{"rendered":"Sales Percent increase month to month, qtr to qtr"},"content":{"rendered":"<p>This is a common situation:&nbsp; Don&#8217;t show me what my total sales figures were month after month, show me something that describes something important to my business.&nbsp; ie, <b>Sales Growth<\/b><\/p>\n<p><a href=\"http:\/\/www.crossjoin.co.uk\/about.html\">Chris Webb<\/a>, who runs a <a href=\"http:\/\/cwebbbi.spaces.live.com\/\">wildly popular MSFT blog<\/a> in addition to being an in demand independent consultant, <a href=\"http:\/\/community.pentaho.org\/techtip\/articles\/mdx_calculations_previous_period_groth.php\">wrote an article on Previous Period Growth using Pentaho.<\/a>&nbsp; Mondrian (Pentaho Analysis Server) uses MDX, a powerful expressive multidimensional query language which Chris is one of the leading experts on its practical use and applications.<\/p>\n<p>Chris outlines how to build a &#8220;custom&#8221; calculated measure that displays the <a href=\"http:\/\/community.pentaho.org\/techtip\/articles\/mdx_calculations_previous_period_groth.php\">Sales Previous Period Growth:<\/a><br \/><a href=\"http:\/\/community.pentaho.org\/techtip\/articles\/mdx_calculations_previous_period_groth.php\"><img decoding=\"async\" src=\"http:\/\/www.pentaho.com\/images\/techtip\/prevperiodgrowth\/ppgdemo11.JPG\" \/><\/a><br \/>All you need is the zero install pentaho demo installation to run through his tech tip, available at <a href=\"http:\/\/www.pentaho.org\/download\/latest.php\">http:\/\/www.pentaho.org\/download\/latest.php<\/a><\/p>\n<p>Remember, this isn&#8217;t trivial (ie, writing MDX fragments) but it&#8217;s VERY VERY powerful.&nbsp; Check out the <a href=\"http:\/\/mondrian.pentaho.org\/documentation\/mdx.php\">Mondrian MDX reference here<\/a> for some of the powerful analytic calculations available.&nbsp; Remember, once you&#8217;ve got your MDX member working properly HIDE that complexity from your users by <a href=\"http:\/\/www.nicholasgoodman.com\/bt\/blog\/2006\/06\/09\/mondrian-olap-power-at-your-users-fingertips\/\">adding it to the Mondrian OLAP schema definition.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a common situation:&nbsp; Don&#8217;t show me what my total sales figures were month after month, show me something that describes something important to my business.&nbsp; ie, Sales Growth Chris Webb, who runs a wildly popular MSFT blog in addition to being an in demand independent consultant, wrote an article on Previous Period Growth [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[6,16,9,11],"tags":[],"_links":{"self":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/202"}],"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=202"}],"version-history":[{"count":0,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/posts\/202\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/media?parent=202"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/categories?post=202"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.nicholasgoodman.com\/bt\/blog\/wp-json\/wp\/v2\/tags?post=202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}