Tags » Data Model

Repairing Month Sorting Order in Power Pivot - Part 2

Here is the Power Pivot way of customizing sort order for any table.

Read the previous article first.

Estimated reading time 8 min 559 more words


Repairing Month Sorting Order in Power Pivot - Part 1

If you use text month in a Power Pivot Table, it is sorted in alphabetical order.

Here is the solution to the problem.

Quick Solution time… 626 more words


Application data model examples

We’ve had quite a bit of interest in our ‘example’ data models from ERPs over the last few months.  A number of people have said that they don’t have a modelling tool easily accessible and therefore can’t see what the diagrams look like, which is a fair point. 178 more words

Traversing the Fleet of ships (Part 5 of 5)

The DisplayShipDetails class now needs to be updated.  Add to the class a couple of private properties, ShipDetails and ShipActionButtons and generate Getter and Setter methods for these two properties.  718 more words


Application metadata in an Agile Data Warehouse world

I have been reading quite a lot recently about the applicability of Agile methodologies for Data Warehousing amongst other initiatives and it appears to me that often the topic of source data analysis is under-represented in the literature and blogs. 733 more words

Traversing the Fleet of ships (Part 4 of 5)

The EditDialog class is created to hold the ship details in a form which the user can alter.  It therefore uses the DisplayShipDetails class and a new method which we have not added as yet, but will once we finish this class. 1,027 more words


00129: Editor Tracking dates in database time zone

Yesterday I found out the hard way that apparently since 10.1 you cannot publish a map service that has editor tracking enabled with database time zone. 337 more words