S4HANA Public cloud and SAP Datasphere connectivity

[Priya6]

Hi I am using S4HANA public cloud i created new connection in SAP datasphere with S4HANA public cloud by using application server, systemID and client details as connection type SAP ABAP.

However i am not able to see API and CDS view as Cube type in datasphere dataflow under connection metadata.

@bheemeshRao 

Please suggest

[bheemeshRao · Accepted solution]

Hi @Priya6 

If you want to bring in the data from CDS view to datasphere, your cds view should have annotation 

@Analytics.dataExtraction.enabled: true

Create a cds view with source as your cube, have the annotation @Analytics.dataExtraction.enabled: true

You can use Remote tables or Graphical view.

Could you please brief your use case, we can discuss on this.

[Priya6 · Accepted solution]

@bheemeshRaoI am using S4HANA Public Cloud edition and for enabling @analytics.dataExtraction.enabled: true i am using ABAP Development project in Ecllipse but when i am trying to declare @analytics.dataExtraction.enabled: true and activating CDS view i am getting error This Annotation is not permitted

[Priya6 · Accepted solution]

@bheemeshRao I created new Custom view in Ecllipse and below is defination

@AbapCatalog.sqlViewName: 'ZADD_EXT'

@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck #NOT_REQUIRED

@EndUserText.label: 'Test CDS view for extraction capability'

@Analytics.dataExtraction.enabled: true

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{

serviceQuality: #X,

sizeCategory: #S,

dataClass: #MIXED

}

define view entity Z_TEST_ADD_EXTRACTION_COPY as select from ztravel_001 as Travel

{

key mykey,

created_by

}

[bheemeshRao · Accepted solution]

Did you create a new view? also show me your view definition

[FelipeCadena · Accepted solution]

Hi @bheemeshRao, Thank you for your explication, I have a dude: Remote tables only works with CDS views. Are there options with transparent tables as ACDOCA or Calcultaion views?

[bheemeshRao · Accepted solution]

Hi FelipeCadena,

its possible to extract data from Transparent table ACDOCA using Remote tables.

Is your question to consume data from a hana calculation view using remote tables?