Content By Role

Query Query: 0BCTCBC01

This Query can be used to view content organized by Role

Note Note

Because 0CB_IPDIR is set to X, only directly connected InfoSources and DataSources are visible. For example, if the Query is based on an InfoCube which is connected to an ODS Object by update rules, the only DataSource visible is the Export DataSource of the ODS Object. This also influences the logic of the counters.

End of the note.

Structure

Filters
Object Type Name Technical Name Value Restriction / Calculation
Flag: Query to InfoProvider Direct Relationship 0CB_IPDIR

This is restricted to X, meaning that only the InfoProvider the Query is based on is selected, and not those further down the DataFlow.

Free Characteristics
Object Type Name Technical Name
View/Query Type 0CB_VQT
Object Version 0CB_OV
Workbook/Template Type 0CB_WTT
InfoProvider Type 0CB_IPT
Variables
Object Type Name Technical Name
Selected Role(s) 0S_CBRLS
Object Version 0P_CBOV
Rows
Object Type Name Technical Name Value Restriction / Calculation
Role 0CB_ROLE
Workbook/*Template 0CB_WT
View/Query 0CB_VQ
InfoProvider 0CB_IP
InfoSource 0CB_IS
DataSource 0CB_DS
Columns
Object Type Name Technical Name Value Restriction / Calculation
Workbook/Template Count 0CB_WTCT
View/Query Count 0CB_VQCT
InfoProvider Count 0CB_IPCT
InfoSource Count 0CB_ISCT
DataSource 0CB_DSCT