Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In the last post, I installed the Analysis Cubes server. The next step is to configure the Analysis Cubes.

There are a choice of three Analysis Cubes Configuration Wizards available, one for each of the supported versions of SQL Server. I have selected the SQL Server 2016 version as this is the version of SQL Server I have installed:

Analysis Cubes Configuration Wizards

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Configure Analysis Cubes”

Hands On With Microsoft Dynamics GP 2016 R2: Install Analysis Cubes Server

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

To install the Analysis Cubes Server, launch the Microsoft Dynamics GP 2016 setup utility and click on Analysis Cubes Server under Additional Products:

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Install Analysis Cubes Server”

Hands On With Microsoft Dynamics GP 2016 R2: Add Analysis Cubes Client

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

In these next three posts, I am going to cover the Analysis Cubes Additional Product. I’ve only ever posted twice about this Analysis Cubes and in both cases it was about the Microsoft Dynamics GP 2013 Reporting – Second Edition book. So, for me, I am treading new ground.

Each machine which will be used to report from the Analysis Cubes needs to have the feature installed. To do this, open the Programs and Features control panel applet, select Microsoft Dynamics GP 2016 and click Change:

Programs and Features

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Add Analysis Cubes Client”

Changing Cortana’s Selected Method Of Travel

Microsoft Dynamics GPI’ve only recently started using Cortana in any meaningful way, but it has been doing one thing that is really annoying. It has been giving me travel tips based on travelling around by Transit instead of by car. The main one it reminds me of is getting home from the office when I am at the PI office and less often getting to that office from home (I spend a lot of time out on site with clients).

What’s the problem you’re wondering. The problem is that because it is using Transit, it tells me I have to leave work at 1320; or even worse that I need to leave home at 1400 on Saturday to get to the offic for 0700 Monday.

These messages have been popping up on my Windows Phone for a while and I have scoured the settings repeatedly looking for a way to fix it by changing the method of travel to car without success and had started thinking about switching off Coretana entirely.

Then the other day I had to get my laptop rebuilt (new OS installed after replacment of parts leading to jokes about the Laptop of Theseus) and activated Cortana. I found something called Notebook with lots of settings broken into areas.

To find Notebook, hit the Windows key and type Cortana. The third icon down on the side of the Start menu is Notebook:

Cortana Notebook

Continue reading “Changing Cortana’s Selected Method Of Travel”

Hands On With Microsoft Dynamics GP 2016 R2: Configure Web Components For Service Based Architecture

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Service Based Architecture (SBA) is a feature introduced in Microsoft Dynamics GP 2015 RTM which provides a REST web service which exposes Dynamics GP business logic as service operations.

The installation is a three part process, the previous but one post in this series covered adding the SBA feature to the desktop client on the web server, the previous covered the installation of the SBA web components and this one will cover the configuration.

After the installation of the web components completes, the Microsoft Dynamics GP Web Components Configuration Wizard will automatically launch. Click Next to proceed:

Microsoft Dynamics GP Web Components Configuration Wizard: Welcome

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Configure Web Components For Service Based Architecture”

Hands On With Microsoft Dynamics GP 2016 R2: Install Service Based Architecture Web Components

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Service Based Architecture (SBA) is a feature introduced in Microsoft Dynamics GP 2015 RTM which provides a REST web service which exposes Dynamics GP business logic as service operations.

The installation is a three part process, the previous post in this seriescovered adding the SBA feature to the desktop client on the web server, this post will cover the installation of the SBA web components and the next will cover the configuration.

To install the SBA Web Components on the web server, launch the Dynamics GP setup utility and, under Additional Products, click on Web Components:

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Install Service Based Architecture Web Components”

Hands On With Microsoft Dynamics GP 2016 R2: Add Service Based Architecture Feature

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

Service Based Architecture (SBA) is a feature introduced in Microsoft Dynamics GP 2015 RTM which provides a REST web service which exposes Dynamics GP business logic as service operations.

The installation is a three part process, the first of which I will cover in this post, and the remainder in the next posts of this series.

The first step is to add the SBA feature to the instance of the desktop Dynamics GP client installed on the web server. To do this open the Program and Features Control Panel applet easiest way is to press Win+R and type appwiz.cpl.

Select Microsoft Dynamics GP 2016 and click on Change:

Programs and Features

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Add Service Based Architecture Feature”

Hands On With Microsoft Dynamics GP 2016 R2: Create Installation Package

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

If you have a number of clients which need Microsoft Dynamics GP installed, this can become somewhat burdensome to ensure that they are all installed exactly the same way; if you do it manually at least. However, via the Microsoft Dynamics GP setup utility, you can build an installation package which much simplifies the job.

To create an installation package, launch the setup utility and select Create Installation Package from under the Install heading:

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Create Installation Package”

Hands On With Microsoft Dynamics GP 2016 R2: Configure & Use OData Service

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

I am not going to cover the configuraion and use of OData in this post, as it is not an area with which I have much experience. However, I know a man who does and I wrote a book with him in 2016:

Microsoft Dynamics GP Cookbook

Mark Polino is one of the three top people for reporting from Microsoft Dynamics GP and, in Chapter 13: Modern Business Intelligence for Microsoft Dynamics GP of the Microsoft Dynamics GP 2016 Cookbook, Mark covered how to configure and use the GP OData Service.

The full outline of topics covered by Mark is as follows:

  • Introduction
  • Activating OData for better external analysis
  • Secure OData to control access
  • Connecting OData to Excel for Business Intelligence
  • Connecting GP to Power BI with OData
  • Adding Power BI to the home page in Dynamics GP

Click to show/hide the Hands On With Microsoft Dynamics GP 2016 R2 Series Index

Hands On With Microsoft Dynamics GP 2016 R2: Install GP OData Service

Microsoft Dynamics GPWith the release of Microsoft Dynamics GP 2016 R2 it’s time for a series of “hands on” posts where I go through the installation of all of it’s components; the index for this series can be found here.

The OData Service for Microsoft Dyamics GP allows connections to be made to the Dynamics GP databases in order to run reports. To install the service, launch the Microsoft Dynamics GP setup utility and click on GP OData Service under Additional Products:

Microsoft Dynamics GP 2016 setup utility

Continue reading “Hands On With Microsoft Dynamics GP 2016 R2: Install GP OData Service”