1 Reply Latest reply on Feb 29, 2012 10:46 AM by Dan Cory

    tableau studio missing meta data from view

      I created a view in Oracle 10g but when I connect to it from the tableau studio, the derived columns are missing. Yet I can use the view with Navicat Lite to retrieve all the data. The view definition is below. I can see only the highlighted columns in the studio. Strangely there are other views that come through OK.

       

      CREATE VIEW ANALYSTSTUDIO_APP_PAYLOAD_VIEW AS

      select     flow,

      RECEPTION_DATETIME,

      peer_addr,

      REGEXP_SUBSTR( req_data, '^.*\<trans_fmt\>([^<>]+)\</trans_fmt\>', 1, 1, 'i', 1) as INSTRUCTION_TYPE,

      REGEXP_SUBSTR( req_data, '^.*\<msg_funct\>([^<>]+)\</msg_funct\>', 1, 1, 'i', 1 ) as MSG_FUNCT,

      REGEXP_SUBSTR( req_data, '^.*\<action_type\>([^<>]+)\</action_type\>', 1, 1, 'i', 1 ) as ACTION_TYPE,

      REGEXP_SUBSTR( req_data, '^.*\<action_code\>([^<>]+)\</action_code\>', 1, 1, 'i', 1 ) as ACTION_CODE,

      REGEXP_SUBSTR( req_data, '^.*\<principal_amt\>([^<>]+)\</principal_amt\>', 1, 1, 'i', 1 ) as PRINCIPAL_AMT,

      REGEXP_SUBSTR( req_data, '^.*\<client_type\>([^<>]+)\</client_type\>', 1, 1, 'i', 1 ) as CLIENT_TYPE,

      REGEXP_SUBSTR( req_data, '^.*\<bi_tri\>([^<>]+)\</bi_tri\>', 1, 1, 'i', 1 ) as BI_TRI

      from ACT_AUDIT_REQUEST

      WHERE req_data like '<?xml%' ;

       

      I also tried using this as custom sql and it  does the same thing there too.