Issue in consuming CDS view in Analysis for office

[former_member672218]

Hello,

I am trying to create a simple CDS view that could be consumed in Analysis for Office. I am able to open my CDS and am able to see the output in AO. However, I am stuck with the below

1. I want to set up a prompt where the user can enter the selection conditions. I searched the forum and used the @consumption.filter:{ selectionType: #SINGLE, multipleSelections:true, mandatory:true } before the field . However , I still don't get any selection prompt in AO

2. All my CDS output fields get displayed directly in the free characteristics in the AO even though I have set it for ROWS based on @AnalyticsDetails.query.axis: #ROWS

Can you please suggest where I go wrong? We are on ABAP 7.4 SP21 .

Regards,

Venkat V

[former_member647389]

We've the same problem and the same SAP Version