Skip to Content
avatar image
Former Member

Categorization of HANA models

Hello Experts,

How to categorize all analytical & calculation views in BIMC_ALL_CUBES table in _SYS_BI schema?

Like, in BIMC_ALL_DIMENSIONS table, if we filter on column name

CUBE_NAME = $ATTRIBUTE then, we will get all Attribute views in the system.

Thanks.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jul 18, 2017 at 05:19 AM

    If you wanna determine all Attribute, Analytic and Calculation Views in your system (or stored in schema _SYS_BIC for XS Classic) you can get that information from system view VIEWS. The column VIEW_TYPE indicates the type of the view.

    Following a little statement, which "translates" the VIEW_TYPE values:

    select schema_name, view_name, view_type, 
      case view_type 
        when 'JOIN' then 'ATTRIBUTE VIEW'  
        when 'OLAP' then 'ANALYTIC VIEW'
        when 'CALC' then 'CALCULATION VIEW'
      end as view_type_renamed from views
    where is_column_view = 'TRUE'
     and schema_name = '_SYS_BIC'
    

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded

    • I think the description for the table (in the provided link) already explains everything.

      • Attribute Views are not part of the table.
      • Analytic/Calculation views are only part, if they are Cubes or they are enabled for Multi-Dim Reporting.