Default layout of ABAP CDS measures in Analysis for Excel

[shyam_uthaman]

Hi All,

I have an ABAP CDS view and am able to do a default layout for dimensions using @AnalyticsDetails.query.axis: #ROWS , COLUMNS or FREE annotation but how do I do the same for measures?

Analysis for Office shows me all measures and I only want to represent a few. The annotation above doesn't seem to work for measures.

Any suggestions?

Shyam

[nora_roch · Accepted solution]

Hi Shyam,

did you try the Annotations: @AnalyticsDetails.query.hidden or @Consumption.hidden.

See also the SAP Community Wiki: CDS views: HowTo use in BW contexts .

Cheers,

Nora

[former_member283567]

Thank you very much Shyam!
This is exactly what I was looking for.