Need Geographic Dimension

View previous topic View next topic Go down

Need Geographic Dimension

Post  DWG on Mon Apr 02, 2012 12:19 pm

Can anyone point me to a source for SQL Code to build a geographic dimension? I have found it for a date dim but not geo and it would seem like reinventing the wheel to write our own.

DWG

Posts : 1
Join date : 2012-04-02

View user profile

Back to top Go down

Re:Need Geographic Dimension

Post  hkandpal on Wed Apr 04, 2012 9:58 am

Hi,

if the dimension is at the country level then the minimum you can have are the foll columns.
GEO_SKEY
COUNTRY_CD
COUNTRY_DESC
REGION_DESC


thanks

hkandpal

Posts : 113
Join date : 2010-08-16

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum