What's new in Prophecy?
Prophecy has been under continuous development since before 1998! This page was created in June 2013 and summarises the changes to Prophecy since then.
|6th April 2016
||For customers with Prophecy years which are not Jan to Dec there are some new database configuration settings which will make years in Prophecy labelled "2016-17" or "2016-2017".
The 'Autosize to widest' option on the right-click menu in Prophecy reports now supports an additional shortcut key. If you hold Shift and click the option it also auto-sizes the row labels (as well as the numeric cells). If you hold Shift and Ctrl then the column widths will be sized to optimise the column label cells too.
Nested label format rules now work on columns as well as rows in Prophecy reports.
Cells with currency symbols would previously copy to the Windows clipboard with these symbols included. Now the currency symbol will be stripped, making Excel accept the cell as a number and not a text value.
|17th December 2015
||This release supports multiple 'available from' / 'discontinued from' dates per individual sku, a much-requested feature from some customers.
Secondly, if you try to log into Prophecy whilst your database manager is running a Prophecy maintenance script (which is not a good idea!) you will see the 'Supervisor Message' window, as previously. However, if you leave the 'Supervisor Message' window displayed then Prophecy will wait until the database management script has finished and then automatically continue whatever database activity you were running, providing that the structure and content of the database have not changed.
If the structure or content of the database have changed then the only safe option allowed is to close Prophecy and re-login to the database. Therefore Prophecy will notify you that it needs to close and then close automatically.
These changes improve the security of Prophecy Client and Database Manager interaction. Although it is inconvenient to have to log out of the database when you want to use it, database maintenance really needs exclusive access to your database and should be undertaken when everyone is out of Prophecy. The improved cooperation between the Prophecy Client application and database scripts in this update simply better protects the integrity of the database in cases where there are users logged into Prophecy during a database maintenance script.
In addition, there are all the latest performance and stability improvements.
|27th October 2015
||'Specials' on the Product and Customer Selector has been renamed 'Data-driven' to better describe its function and to reflect the new functionality that has been added to this feature.
Now you can set a data-driven drilldown script to ensure that, when you drill down, you only get to the child items that have sales or forecasts. In fact, the 'rule' can be fully customised for you by your database manager, using simple SQL.
Please view a YouTube video which demonstrates the new feature in action by clicking this link.
In addition, there are all the latest stability improvements.
17th September 2015
||Big new feature! With an appropriate data source you can now graphically view the promotional program for the item(s) you are forecasting alongside the forecasts in a new Gantt-style view. We have prepared a 5 minute, self-running demo which runs in your browser window -
please click here to view it now and contact Data Perceptions if you would like help in implementing the new view.
For Prophecy databases hosted in SQL Server, Prophecy will now endeavour to reconnect to SQL Server in the event of a dropped connection. If you suffer a disconnection Prophecy will offer to retry connecting and then resestablish the connection if it can. Dropped connections occur due to wifi disconnects, computer going into hibernation or sleep or for other network disruptions. Please note that reconnection only occurs for the actual Prophecy database and not for any other connections that Prophecy may have initiated - e.g. to a tracking database or SQL Nugget source. However, it does mean you shouldn't lose forecast changes in the event of a disconnect.
In addition, there are all the latest stability improvements.
20th July 2015
||This is largely a maintenance release to align the existing 32 bit Prophecy code base with the new 64 bit version which was launched today. Please see click here to read the July 2015 Prophecy Newsletter, which fully describes the benefits of the new 64 bit Prophecy version.|
19th March 2015 ,20th March 2015, 31st March
2015, 8th April 2015, 10th April 2015.
|This is an important maintenance release for Prophecy. The Prophecy report files and database configuration files are being changed to a more modern file format : zipped XML. This is the same format used by Microsoft Office from Office 2007 onwards. If you are working over a slow VPN connection to Prophecy you should see an improvement in Prophecy's initial startup time. However, the main benefits from this 're-plumbing' will come in the future because it opens up the possibility for much more ambitious enhancements to Prophecy.
You should notice no differences to your Prophecy experience as a result of this underlying 'plumbing' change, other than at the beginning, where you may see a message from Prophecy telling you that a report library needs to be converted. This conversion will happen automatically and quickly - the message is for information only. Thereafter, your Prophecy will be loading the converted report library files rather than the original versions but the ongoing experience will be identical to before the conversion.
This release also includes a couple of fixes and a possible performance enhancement for SQL Server Prophecy database users.
(Note: V126.96.36.199, released 20th March 2015 is a minor (but required) maintenance update to V188.8.131.52.)
(Note: V184.108.40.206, released 31st March 2015 is a second, minor maintenance update which resolves a Library rights issue.)
(Note: V220.127.116.11, released 8th April 2015 is the second, minor maintenance update which resolves an issue with incorrect 'Very Long Labels' being displayed for products and customers.)
(Note: V18.104.22.168, released 10th April 2015 contains a further fix to retrieval of very long product and customer labels and fully restores the previous behaviour to Prophecy.)
9th February 2015
|17th December 2104||22.214.171.124||Fix to address very long scripted selection text in replaying reports. The space allowed for the script in the saved report file has been doubled. Long selection script text only occurs when the sort order for the item being selected (i.e. products or customers) is 'None' because the original order of items has to be saved in the script text. For any other sort option (e.g. as hierarchy or alphabetical) the original order is not necessary because the items can be ordered using the sort rule when the report replays.|
|11th December 2014||126.96.36.199||A couple of fixes to incorrect behaviour on the report Navigator (binoculars icon ) which were introduced in V188.8.131.52.|
|24th November 2014||184.108.40.206||
Features, performance improvement and fixes:
|28th October 2014||220.127.116.11||When you Alt-Tab away from Prophecy and then back the Prophecy report cell you were previously on retains the 'focus' so you don't have to click on the window to restart using Prophecy. Added real-time messaging from the database manager to advise on things like future Prophecy maintenance, the addition of new items etc. Also added some minor stability features.|
|11th Sept 2014||18.104.22.168||Please read the Data Perceptions Newsletter for more information on the new features in this release. You can read it online by clicking this link .|
|6th June 2014||22.214.171.124||
Various fixes and minor improvements:
|9th May 2014||126.96.36.199||Added 'Paste' button to product and customer selector dialog boxes. Say you've copied a selection of product or customer codes from another application to the Windows clipboard and wish to see them in the selection in Prophecy. All you have to do now is click the new 'Paste' button and the items will be magically added to the currently selected items in the right hand list of the product or customer selector. The paste logic is able to ignore any codes or other text which cannot be found in the database - it simply parses the clipboard text into separate fields using a selection of delimiters (i.e. commas, semi-colons, tab characters etc.) and then tries to find each field in the hierarchy. If found, it adds it to the selection! Note: the logic always looks for codes that match, irrespective of the current label format selection in the dialog box or Prophecy report.|
|7th April 2014||188.8.131.52||
'Parallel Years' Quick Graph option now displays (optional) moving average series lines. Moving average series lines are now optional (i.e. can be switched off) on all relevant Quick Graph types. Moving average series lines now drawn with a dotted line for added clarity.
Internationalisation fix on 'Export to Excel' feature for non-UK geographies.
|28th March 2014||184.108.40.206||
Copy/paste now behaves completely consistently for all permutations where hidden rows or columns are concerned. They are always skipped. (There was previously one paste permutation where data in the clipboard would be pasted into the hidden cells rather than the next visible cells.)
The Product and Customer Label Builder option now works more effectively when using properties of the item's parents. There should be no duplication, for example when the label includes the item's parent and you are showing 'Total Products' or 'Total Customers'.
|23rd January 2014||220.127.116.11||
Added two new features to the product and customer selection tools:
Fixed zero-day crash on Facts selector when changing label formats and then reordering facts.
|1st January 2014||18.104.22.168||A more modern font is used if the Windows version supports it (i.e. Vista or later). Export to Excel feature speeded up as it was found to be noticeably slower when interoperating with newer versions of Excel. Various minor improvements and bugfixes.|
|6th November 2013||22.214.171.124||Previously, copying from cells which contain currency or other text characters would not paste correctly into other cells. This has now been fixed!|
|22nd October 2013||126.96.36.199||
Added small buttons to Save/Update report dialogs which let you see the list of products and customers which will be saved in the report if you save/update the report as a list-based (rather than script-based) report.
A couple of fixes for non-customer-reported issues which Data Perceptions discovered during recent testing.
System-compiled attributes (i.e. products bought by specified customer / customers buying specified product) now have improved labels, which include item codes. (N.b. a Prophecy Database Manager update is also required in order for the improved labels to feed through into the Prophecy Client application.)
|12th September 2013||188.8.131.52||
Prophecy data entry rules now display more appropriately for all types of cells and Prophecy options. For example, features like the Forecast Wizard, 'Paste All' option could previously potentially trigger a rule volation box for every cell in the target range. With this improvement a single advice dialog will appear at the end of the process.
You can now alter your Prophecy personal reports file - the file which populates the 'Personal' domain reports in the Prophecy Reports Manager dialog box. The filename can be set or changed by the following steps:
|6th August 2013||184.108.40.206||
Minor updates, fixes and performance updates, including:
|17th July 2013||220.127.116.11||Maintenance release - contains several fixes and performance tweaks.|
|26th June 2013||18.104.22.168||
Several 'variables' have been added to the Conditional Formatting, Label Contents functionality ('Format' tab in Prophecy --> 'Label contents' button). They make it easier to set up rules which match against Prophecy years or forecast versions.
The 'Label contents' rules feature allows you to introduce shading into your Prophecy reports, which persist on axis reorientations, drill downs and changed item selections.
For example, say you want cells for year '2013' to be highlighted using a different background colour in order to make current year data more visible. You would create a label rule which matches the text '2013'. Any rows or columns with the text '2013' will then be painted with your specified background colour.
But what happens next year - i.e. when current forecast year is 2014? Presumably you would want '2014' to be highlighted instead? Previously you would have had to edit the rule so that the text to be matched is changed from '2013' to '2014' and then updated the report in the Prophecy Reports Manager.
However, now you can specify a 'variable' for the year. So, say 2013 is the currently selling year (i.e. forecast year 1) in Prophecy. To always match to the currently selling year, even when it is no longer 2013, you would click the 'Variables' button on the 'Add or edit a rule' dialog box and choose the highlighted option:
When you choose the highlighted option the special variable syntax will appear in the the label field as shown below. You can then replace the '??' with, in this case, '1' (because you want to always match against forecast year 1 in the Prophecy database):
As you can see from the Variables menu in the previous screenshot, there are additional variables which allow you to match against history years and also forecast version labels.
Press F1 for help when you are on the 'Add or edit a rule:' dialog box for more information on this powerful feature!
|5th June 2013||22.214.171.124||New quick graph type plus enhancements to Takeaway database generation - see https://www.dataperceptions.co.uk/whatsnew-quickgraphs.php for more information.|
Telephone 01494 785574 (UK) to talk to a Prophecy expert now!