Hi S'bu

I assume you mean GP 10?

As per our friend Google...

Setup Tables.

These tables have 4 prefix. IV40100 – this is Inventory Control Module setup table. ...

Hi, J Gravelle

There is a data warehousing structure that will make it much easier to do this calc, as well as the flexibility to do loads more...The Date dimension

By...

Hi Sachin

As requested, here is an example, but first, just a bit of waffling...

In the code, I create a dummy temp table, and put some random values in. My last...

Hi Sachin

Being a DW developer, I am always on the lookout for the simplest way of doing things. Another suggestion/question would be (if I understand the scenario correctly), why not...

Good, solid article on the date dimension.

I love role-playing dimensions - they can expand business users' understanding of their data to points that they had never considered.

For example, one of...