Skip to Content
0

Categorization of HANA models

Jul 18, 2017 at 04:47 AM

57

avatar image
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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Jul 18, 2017 at 05:19 AM
2

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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/0ed2466f7d7d4c20964005f4b8fcc729.html

Thanks in advance.

0

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.
0