Issue with CDS Extractor to extract "Dimension" data

[lakshminarasimhan_n4]

Dear All,

I am trying to create a CDS views as "Dimension", this reads the MARC data and below is the code.

i am receiving the below error "- No Assoc. found for Key Field WERKS. Either add Assoc. or remove DataCat #DIMENSION [Analytics]".

@AbapCatalog.sqlViewName: 'YVLAK_ATTR01'

@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: 'YLAK_ATTR01'

@Analytics: { dataCategory:#DIMENSION , dataExtraction.enabled:true }

@ObjectModel.representativeKey: ['Matnr','Werks']

define view YLAK_ATTR01 as select from marc {

key matnr as Matnr,

key werks as Werks,

pstat as Pstat,

lvorm as Lvorm

}

What could be the possible fix, please help and what could be the reason.

[mnr_sap1]

Dear LakshmiNarasimhan, Is this problem resolved? How did you solve it. Could you please share some info on this.

[SeshaP]

Hi,

Cds view giving error because of Multiple keys @ObjectModel.representativeKey: ['Matnr','Werks']

Please refer the below blog for fix

https://blog.sap-press.com/how-to-create-a-basic-interface-core-data-services-view-with-abap

Thanks

[ferdtulu]

MARC table has 2 key fields that you have already defined in the script. Which Release do you have backend? I think the brackets in the dataExtraction.enabled:true is not correct. See my example below.

[EAkin]

it looks like your compounding dimension is not defined properly, you can check below link 

Creation of Compounded Dimensions with ABAP CDS Vi... - SAP Community