Archive for March, 2014

Dynamics Ax 2012 SP3 – Demand Forecasting

March 29th, 2014

Microsoft Dynamics AX 2012 R3 Demand Forecasting is an easy yet powerful tool. It lets you predict demand based on historical data, change the predictions, and import them back into the Microsoft
Dynamics AX forecast models.

It’s a cost effective solution (included in the Enterprise CAL) that takes advantage of the Microsoft technology that you are already using and are familiar with.
– To generate the baseline forecast it uses the power of SQL Server Analysis Services.
– To visualize the forecast, make changes, view or create new KPIs, it uses the extensive functionality of Microsoft Excel.

It lets you define customer order decoupling points at any level and to forecast for subcomponents. It is an ideal solution for mass customization. You can of course still use it to predict only direct
customer demand.

Key features:
• Statistical forecast
• Baseline generation at different levels of aggregation
• Forecast visualization and modification
• Importing back into Microsoft Dynamics AX
• Forecast accuracy KPI

Dynamics Ax 2012 SP3 – join Synergy Software Systems Dubai for the 10th April launch event.

March 29th, 2014

An overview of the new technology changes:

Microsoft Dynamics AX will showcase how uniting business and IT creates a dynamic business to help you engage with your customers, run agile operations and expand your business.
When: April 10, 2014
• Session 1: 11:00 AM SGT (Asia: GMT +8)
• Session 2: 15:00 GMT/16:00 CET (Europe)
• Session 3: 12:00 PM CDT (North America: GMT -6)

Watch this blog in the coming week for registration details to follow and for more introductory videos.

An introduction to the new advanced warehouse and transportation features:

Changes to UAE Company law

March 28th, 2014

The new provisions relating to Limited Liability Companies focuses on how to make the management of these companies simpler and more attractive to investors.

Significant changes are introduced to the shareholder structure, which now provides for single shareholding, and the introduction of an express provision in relation to granting a pledge over shares.

(It is uncertain how the perfection and enforcement of such a pledge would work in practice without numbered shares, or indeed any share certificates. )

The Draft Companies Law 2013 provides for the registration of share pledges and this area will of be of interest to lenders a simpler and more cost effective way to get security over this form of asset class.

The Draft Companies Law 2013 anticipates the creation of a formal companies’ register for share pledges through an e-filing system where the public may access companies’ documents. A significant move towards greater transparency and an invaluable tool in jurisdictions (such as England and Wales through Companies House) that currently operate the system.

For Public Joint Stock Companies, there are amendments to the provisions relating to the company’s share structure which include a slight relaxation on the strict pre-emption rules to allow for the issuance of new shares to a “strategic partner” which provide a route for new equity fund raising.

The Draft Companies Law 2013 introduces provisions prohibiting financial assistance to shareholders even though such concepts are the subject of de-regulation in other jurisdictions. The interpretation and implementation of this provision may cause delays, uncertainty and risk as there are no precedents.

The Draft Companies Law 2013 also provides a provision that clarifies the relationship between free zone entities and the on-shore regime. Free zone entities are exempt from the application of the Draft Companies Law 2013 provided such exemption is set out in the regulation governing the free zone. However, when the laws and regulations of the free zone permit business activities in on-shore UAE, the Draft Companies Law 2013 will apply. The provision allows for further regulations on the applicable conditions for such companies at a later stage.

The Draft Companies Law 2013 also contains numerous provisions in relation to corporate governance, following the financial crisis. The concept of ‘Social Responsibility’ is introduced for the first time but further regulations will be needed to establish this in the wider framework.

We consider that the draft supports the government policy of attracting foreign direct investment into sectors outside the oil industry by providing greater security and transparency for shareholders.

OneNote now free

March 23rd, 2014

Microsoft announced last week that it was making OneNote free. Paid upgrades and corporate sales as part of Office 365, however, still exist, and that may hint at Microsoft’s overall strategy for Office going forward.

The PC app, its note-taking service that syncs across platforms, the new Mac app, and a variety of small tools for the service are now available for anyone to use without cost.

Microsoft wants to drive up OneDrive usage, an experience that is tied closely to OneNote. So the company lowered friction to entry by increasing its platform support in OneNote and by ending pricing questions. No matter where you want to use the service, you can, and Microsoft would like to welcome you into the larger Office-as-a-Service world with open arms.

For some time now, Microsoft has also used OneNote as a service for experimenting with new ideas and platforms. The fact that it’s now the first of the Office apps to go freemium both on the desktop and the web could mean Microsoft is considering this kind of freemium model for other Office applications, as well. For some, OneNote could also be the gateway drug into the Office ecosystem, which, after all, already includes the free Office Web apps.

Isn’t Microsoft depreciating the value proposition of Office 365 by making a component that it once sold, free? Perhaps, but you have to wonder who was buying that service for its inclusion of OneNote, and, secondly, what the potential value-add is for Microsoft to spur new, engaged users, as opposed to a minor potential drag on sales of its Office service SKUs. A useful, but somewhat disparate service has been improved and brought into something approaching harmony.

One overlooked benefit of One note is that you can print to it and form it. This means that if you have an erp application that does not allow you tor reprint a document then you can achieve this via One Note- e.g. for cheque re-printing from Dynamics Ax.

SQL 2014 – standard version extra features

March 23rd, 2014

Recent changes in the documentation for SQL Server 2014 have include some significant changes that will have a fantastic impact on Standard Edition customers.

More Memory: The first s that the supported memory limit per instance is raised to 128 GB in SQL Server 2014

Buffer pool extensions: The Buffer Pool is one of the main memory consumers in SQL Server. When you read data from your storage, the data is cached in the Buffer Pool. SQL Server caches Execution Plans in the Plan Cache, which is also part of the Buffer Pool. The more physical memory you have, the larger your Buffer Pool will be (configured through the Max Server Memory setting). The Buffer Pool itself, is very fast (regarding latency).

The Buffer Pool Extensions itself consist of one file (the Extension File) that should be stored on very fast storage – i.e. an SSD drive. The Extension File is similar to the page file in the Windows OS. Instead of adding additional physical memory to your database server, configure an Extension File on a SSD drive – that’s it!

Memory pressure occurs when SQL Server needs more memory than is currently available. In that case the Buffer evicts pages from the Buffer Pool, which were least recently used. SQL Server uses a Least Recently Used Policy (LRU). If you have configured an Extension File, then SQL Server will write these pages into it, instead of writing directly out to our slow storage. If the page is a dirty one, then the page will be also concurrently written to the physical storage (through an asynchronous I/O operation). Therefore you can’t lose any data when you are dealing with the Buffer Pool Extensions. At some point in time your Extension File will be also completely full. In that case SQL Server has to evict older pages from the Extension File (again through a LRU policy), and finally writes those to the physical storage. The Extension File just acts as an additional layer between the Buffer Pool and the storage itself.

SQL patches March 2014

March 23rd, 2014

The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #9.
• KB Article: KB #2931078
• Build # is 11.0.3412
• Currently there are 29 public fixes listed (33 total)
Relevant for builds 11.0.3000 -> 11.0.3411.
Do not attempt to install on SQL Server 2012 RTM (any build < 11.0.3000) or any other major version March 2014 Cumulative Update for SQL Server 2008 SP3 Microsoft has also released SQL Server 2008 Service Pack 3 Cumulative Update #16
•Build # 10.00.5852
• KB Article: KB #2936421
• 2 public fixes
• Relevant for builds 10.00.5500 -> 10.00.5851
• NOT for SQL Server 2008 R2 (10.50.xxxx)

The small number of fixes (and zero fixes for the engine) is telling: this is almost certainly the last service pack for SQL Server 2008, support for this version ends in July. If you’re still on 2008 (and I know some of you are still on 2005 and even 2000, and ), its time to start considering moving on

SQL 2014 coming soon

March 19th, 2014

Microsoft released the latest version of its SQL Server database, SQL Server 2014, to manufacturing on March 18.

SQL Server 2014 will be available to customers as of 1 April 2014 (and that is not an April fool’s joke.)

The newest version of SQL Server’s biggest new feature is its built-in in-memory online transaction processing (OLTP) capability, which Microsoft has said can improve database performance up to 30 times (not 30 percent — 30 times) without any code changes to existing applications or hardware.

The in-memory OLTP engine is codenamed “Hekaton.” with capabilities to complement the in-memory data-warehousing and business-intelligence capabilities that are already in SQL Server.

With traditional database models, the assumption is that data lives on disk and is stored on disk pages which creates a lot of overhead when you try to access records. When data lives totally in memory, much, much simpler data structures can be used. Hekaton indexes of data structures and storage structures are optimized on the basis that when a table is declared memory-optimized, all of its records live in memory.”

New concurrency-control mechanisms remove barriers to scalability. It moved away from a partitioned multi core approach to a latch-free/lock-free design. (Latches are synchronization mechanisms designed to avoid data corruption caused when multiple users try to modify a data structure concurrently, .)

The indexing system for high-speed data access, is referred to as the “Bw-tree.” which gives much improved processor-cache performance, in SQL Server 2014t.

SQL Server 2014 is also designed to back up more simply and seamlessly to Windows Azure, enabling users to back up their on-premises data to the cloud at an instance-level for disaster-recovery purposes. Backups can be automatic or manual, and a backup can be restored to a Windows Azure Virtual Machine, if need be.

Only the Enterprise version of SQL 2014 includes Hekaton support. The Standard, BI, Web and Express SKUs do not.

Power BI and BI4Dynamics

March 13th, 2014

We will show you how to take advantage of Power BI to:

· Connect external sources and create new structures.
· Visualize data with Power View.
· Explore geospatial data using Power Map.
· Answer questions with natural query language.

Let us show you:

How BI4Dynamics data structures can work together with Power BI?

Which visualization features offered with Power BI are even better than standard Excel features.

Prophix 2011 – see what is new. Proven in the U.A.E.and K.S.A.

March 11th, 2014

Prophix delivers the best value by combining high-end functionality, low total cost of ownership, and the fastest implementations in its class. Indeed, leading industry analysts like Gartner, have ranked us #1 for Customer Satisfaction and #1 for Time to Deployment and Best Value in the CPM space.

Prophix is a single integrated performance management application that empowers organizations with budgeting, planning, forecasting, reporting, consolidations and personnel planning capabilities. Prophix enables organizations to create measurable targets against their business strategies ensuring that corporate objectives are met.

With over 20 plus years in this space, Prophix is the only solution provider in the marketplace to deliver cost-effective Enterprise level reporting and planning functionality in an easy to use and fast to deploy solution that generates virtually no IT resource burden. Today, Prophix has 2,000 plus customers worldwide and continues to grow and set the standard for Corporate Performance Management Solutions year after year.

Dynamics Ax 2012 Sp3 – coming to Dubai 1 May 2014- ask Synergy Software Systems for more information

March 9th, 2014

New features will include:

Application Lifecycle Management – Azure based set of tools, called Lifecycle Services (LCS), provided as the central point of engagement for customer and partner activities throughout the application lifecycle. New LCS functions enable: creation and managing support cases with Microsoft, knowledge base issue search and install resolution updates. The LCS Business Process Modeller is improved, connecting business processes and design gaps with business goals and objectives, and requirements traceability.

Retail – a new “Modern Point-of-Sale” – metro-styled POS client designed for mobile clienteling activities. A new set of functions for Call Centre sales and improved Catalogue features. Loyalty Programs and Gift Card handling has been redesigned, enabling these to operate across all companies within the AX database, adding: earning loyalty points based on an activity and new redemption rules. Customer affiliations influencing price/discount.

Advanced Warehouse Management – a new module that improves operational excellence for warehouse processes, containing; license plate identification, wave picking, new inventory reservation hierarchy, transport load planning and rating, mobile/handheld support, and freight invoice matching.

Demand Forecasting
– a basic planning function to create an Item SKU level demand forecast, leveraging the broader Microsoft technology stack, SSAS time-series algorithms and Excel data visualisations.

Master Data Management – managing the synchronization (push and pull) of master data changes from multiple environments, with conflict resolution, and batch scheduling and automation.