ABAP CDS Views Consumption in BO webi Report

[former_member199945]

Hi Experts,

I would like to know the procedure or steps for consuming SAP S4hana CDS views in Business objects webi report ?

Please some one can assist me on this.

As per my knowledge we can consume CDS Views via OLAP Connection for S4 hana system with http (system details) we have tried this approach . But we can't see any CDS views in the system.

Thanks

[former_member637984]

You can use the transit queries based on the CDS views. Simply create an OLAP connection and consume the queries.

Hope this would help.

SAP NOTE:

2548900 - How to consume ABAP CDS (Core Data Service ) view in Web Intelligence Document?

[former_member595836]

Consumption CDS views are automatically exposed as transient queries (if properly defined using right annotations). You can test in transaction RSRT first.

Below is the naming convention of generated transient query:

2C<SQL View name of CDS>

In Webi, you need to select BEx query as source of data and enter transient query name as per the convention above.

Hope that helps. Thanks, Anup

[rama_shankar3]

Great info - thanks - I will try solution in my S4 system and keep yall posted !