Categorization of HANA models

[Former Member]

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.

[pfefferf · Accepted solution]

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

[Former Member · Accepted solution]

Thanks for your valuables Florian. But in my requirement, I need a table name which physically stores all view names. So, just want to confirm whether table BIMC_ALL_CUBES physically stores all Ana/Cal view names in the system.

FYI... I have also invested my time on below link

https://help.sap.com/viewer/88fe5f56472e40cca6ef3c3dcab4855b/2.0.00/enUS/0ed2466f7d7d4c20964005f4b8f...

Thanks in advance.

[pfefferf · Accepted solution]

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.