Need Geographic Dimension

Go down

Need Geographic Dimension Empty 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

Back to top Go down

Need Geographic Dimension Empty 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

Back to top Go down

Back to top


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