DT.transacs <- runQry("SELECT * from bi.transactiontype_view")
setkey(DT.transacs, transac_typeid)

# DT.transacs2 <- setkey(runQry(
# "
#   SELECT transactiontypeid   AS transac_typeid, 
#          transactiontypeabbr AS transac_type_abbr,
#          transactiontypedesc AS transac_type,
# 
#         CASE \"transactiontypeid\" 
#           WHEN '1'   THEN 'Stream'
#           WHEN '2'   THEN 'Sync'
#           WHEN '3'   THEN 'Sync'
#           WHEN '4'   THEN 'Ringtone'
#           WHEN '5'   THEN 'Ringtone'
#           WHEN '6'   THEN 'Download'
#           WHEN '7'   THEN 'Download'
#           WHEN '8'   THEN 'Download'
#           WHEN '9'   THEN 'Stream'
#           WHEN '10'  THEN 'Stream'
#           WHEN '11'  THEN 'Stream'
#           WHEN '12'  THEN 'Video'
#           WHEN '13'  THEN 'Video'
#           WHEN '14'  THEN 'Stream'
#           WHEN '15'  THEN 'Video'
#           WHEN '16'  THEN 'Video'
#           WHEN '17'  THEN 'Video'
#           WHEN '18'  THEN 'Video'
#           WHEN '19'  THEN 'Download'
#           WHEN '20'  THEN 'Download'
#           WHEN '22'  THEN 'Video'
#           WHEN '23'  THEN 'Download'
#           WHEN '25'  THEN 'Ringtone'
#           WHEN '26'  THEN 'Ringtone'
#           WHEN '27'  THEN 'Stream'
#           WHEN '28'  THEN 'Stream'
#           WHEN '29'  THEN 'Download'
#           WHEN '30'  THEN 'Video'
#          ELSE 'zOTHER TRANSACTIONTYPESz'
#         END AS \"transac_type_group\"
#         ,
# 
#         CASE \"transactiontypeid\" 
#           WHEN '1'   THEN 'Music OR Video'
#           WHEN '4'   THEN 'Ringtone'
#           WHEN '5'   THEN 'Ringtone'
#           WHEN '6'   THEN 'Music'
#           WHEN '7'   THEN 'Music'
#           WHEN '8'   THEN 'Video'
#           WHEN '9'   THEN 'Music OR Video'
#           WHEN '10'  THEN 'Music OR Video'
#           WHEN '12'  THEN 'Music OR Video'
#           WHEN '13'  THEN 'Video'
#           WHEN '14'  THEN 'Video'
#           WHEN '15'  THEN 'Video'
#           WHEN '16'  THEN 'Video'
#           WHEN '17'  THEN 'Video'
#           WHEN '18'  THEN 'Video'
#           WHEN '19'  THEN 'Music'
#           WHEN '20'  THEN 'Music'
#           WHEN '22'  THEN 'Video'
#           WHEN '23'  THEN 'Music'
#           WHEN '25'  THEN 'Ringtone'
#           WHEN '26'  THEN 'Ringtone'
#           WHEN '27'  THEN 'Music'
#           WHEN '28'  THEN 'Music'
#           WHEN '29'  THEN 'Music'
#           WHEN '30'  THEN 'Video'
#          ELSE 'zOTHER TRANSACTIONTYPESz'
#         END AS \"music_vs_video_by_transac\"
#         ,
# 
#         CASE \"transactiontypeid\" 
#           WHEN '1'   THEN 'Stream'
#           WHEN '2'   THEN 'Stream'
#           WHEN '3'   THEN 'Stream'
#           WHEN '4'   THEN 'Download'
#           WHEN '5'   THEN 'Download'
#           WHEN '6'   THEN 'Download'
#           WHEN '7'   THEN 'Download'
#           WHEN '8'   THEN 'Download'
#           WHEN '9'   THEN 'Stream'
#           WHEN '10'  THEN 'Stream'
#           WHEN '11'  THEN 'Stream'
#           WHEN '12'  THEN 'Download'
#           WHEN '13'  THEN 'Download'
#           WHEN '14'  THEN 'Stream'
#           WHEN '15'  THEN 'Download'
#           WHEN '16'  THEN 'Download'
#           WHEN '17'  THEN 'Stream'
#           WHEN '18'  THEN 'Stream'
#           WHEN '19'  THEN 'Download'
#           WHEN '20'  THEN 'Download'
#           WHEN '22'  THEN 'Download'
#           WHEN '23'  THEN 'Download'
#           WHEN '25'  THEN 'Download'
#           WHEN '26'  THEN 'Download'
#           WHEN '27'  THEN 'Stream'
#           WHEN '28'  THEN 'Stream'
#           WHEN '29'  THEN 'Download'
#           WHEN '30'  THEN 'Download'
#          ELSE 'zOTHER TRANSACTIONTYPESz'
#         END AS \"stream_vs_download\"
#         ,
# 
#         CASE \"transactiontypeid\" 
#           WHEN '19'  THEN 'Track'
#           WHEN '20'  THEN 'Track'
#           WHEN '23'  THEN 'Album'
#           WHEN '29'  THEN 'Album'
#          ELSE 'zOTHER TRANSACTIONTYPESz'
#         END AS \"album_vs_track\"
# 
# 
#   FROM production.dim_transactiontype
# "
# ), transac_typeid)