System table name to find Calculation View type (Scripted or Graphical)

[jyoti_senapati]

Hi,

Is there any system metadata table present where we can find the Calculation view type (graphical/Scripted).

Regards,

Jyoti Senapati

[KonradZaleski]

I didn't find any straightforward way for retrieving these information, but you can try this query:

SELECT 
  QUALIFIED_NAME, 
  CUBE_NAME, 
  CASE WHEN SQL_VIEWS."TYPE" IS NULL THEN 'GRAPHICAL' ELSE SQL_VIEWS."TYPE" END AS "VIEW_TYPE"
FROM
(
  SELECT
     "QUALIFIED_NAME",
     "CUBE_NAME"
  FROM 
     "_SYS_BI"."BIMC_CUBES" 
  WHERE 
     "SCHEMA_NAME" = '_SYS_BIC'
) ALL_VIEWS
LEFT JOIN
(
  SELECT 
     SUBSTR_BEFORE("OBJECT_NAME" , '/proc') AS "VIEW_NAME", 
     'SQL' AS "TYPE"
  FROM 
     "PUBLIC"."OBJECTS" 
  WHERE 
     SCHEMA_NAME = '_SYS_BIC' AND OBJECT_TYPE = 'PROCEDURE'
) SQL_VIEWS ON REPLACE(ALL_VIEWS.QUALIFIED_NAME,'::','/') = SQL_VIEWS."VIEW_NAME"
;

[muttepawar-2009]

system table name to get metadata of a calculation view in HANA