If you are, like us, users of Oracle Process Manufacturing then you'll have written a lot of reports which rely on Item Costings (both for products and ingredients). One of the things that makes the current structure of the Noetix View difficult to work with is that it provides a detailed breakdown of the costs - something that's useful if you're reporting on the costs themselves - which is not useful if you're reporting on, for example, the value of inventory where you're just interested in the *total* cost.Of course it's fairly easy to get there,...
Monday, July 30, 2012
Friday, July 27, 2012
The idea behind this report is that most, if not all, of our users will need to keep running the same reports over and over again every month and so rather than coming up with some fantastic way of categorising the reports why not just write a report that looks at the logs and see which reports the user has run and how often and provide the user with this list to pick the report from?Here's the screen capture of the final report;My Reports - Sample...
This blog post just covers a very simple "tagging" example that I've been using in our SharePoint 2007 Reporting Services server to allow the sharing of reports between different areas. For example in Finance we have a simple report that gets GL Journal Entry lines for a specific Account Code combination that is useful to many of the teams in Finance so they all want access to it. Using tags each team can have it's own view of reports that...
Thursday, July 5, 2012
This is a very simple blog which is just a list of Oracle Date/Time calculations (i.e. every two hours, every day, 8am every day, etc). These formulas are intended to help you calculate the "next" date for a given requirement.Midnight;TRUNC(SYSDATE)+1Tomorrow at 7am;TRUNC(SYSDATE)+1 + 7/24Every two hours (on the hour);TRUNC(SYSDATE, 'HH') + 2/24 Every two hours (on the hour) between 8am and 6pm every day;CASE WHEN TRUNC(SYSDATE, 'HH') + 2/24 <= TRUNC(SYSDATE) + 19/24 THEN TRUNC(SYSDATE, 'HH') + 2/24 ELSE TRUNC(SYSDATE)+1 + 8/24 ...
In order to improve performance when reporting we like to pre-build some of the data for the reports. In order to keep this data fresh we have written a simple PL/SQL script that we need to schedule to run daily.The PL/SQL behind this is simply;begin for v_DateRange in (SELECT TRUNC(SYSDATE) - 7 Start_Date, ...
Subscribe to:
Posts (Atom)
