Data – Page 21 – Pardaan.com

Create a hierarchy in PowerPivot Data Model

Most Data Models include data that is inherently hierarchical. The Olympics data is also hierarchical. It’s helpful to understand the Olympics hierarchy, in terms of sports, disciplines, and events. Bron : Ashwini Tripathi Lees meer...

16 October 2015

Dynamics NAV & BC Tips & tricks

Extend the Data Model using calculated columns

It’s nice when the data in your Data Model has all the fields necessary to create relationships, and mash up data to visualize in Power View or PivotTables. But tables aren’t always so cooperative, so in today’s post will describe how to create a new column,…

15 October 2015

Dynamics NAV & BC Tips & tricks

Add Excel Sheet/Table to the PowerPivot Data Model

Download the Excel file from the link provided in previous post. Import data using copy and paste from Excel sheet or other source for PowerPivot Data Model. Open the Workbook: Select sheet one by one and Add to Data model of PowerPivot. Make sure all Table/Sheet…

13 October 2015

Dynamics NAV & BC Tips & tricks

Import data using copy and paste from Excel sheet or other source for PowerPivot Data Model.

You can copy & Paste data from an Excel workbook, or import data from a table on a web page, or any other source from which we can copy and paste into Excel. In the following steps, you add the data from a table. Bron :…

12 October 2015

Dynamics NAV & BC Tips & tricks

PowerPivot Creating a Data Model in Excel 2013

Before you can create a PivotTable, you’ll need some data. Let’s get some data from the Navision database. In Excel, open a blank workbook. You have several options for getting data from no of sources. Recall from my earlier post where we accessed data using web…

9 October 2015

Dynamics NAV & BC Tips & tricks

Using comments in XML Port Data

Setup data is one of the hardest things to keep strait in Dynamics NAV. If you have multiple developers on the same database, they might be modifying setup data to develop new features or testing for bugs. When you have setup data being changed constantly, you…

6 October 2015

Dynamics NAV & BC Tips & tricks

How to Update Dynamics NAV 2015 with Excel Data

You can easily update Dynamics NAV 2015 with Excel data on any editable list available in NAV. Microsoft Dynamics NAV 2015 is a flexible enterprise accounting solutuion that can be easily customized to your unique needs, ideal for distribution and job-based professional service organizations. Bron :…

28 September 2015