Skip to Content
0

Measures not coming in Analysis office

Aug 18, 2017 at 09:15 PM

100

avatar image

Hi,

When i am consuming the ABAP CDS View (Consumption type) measures are not coming in the analysis office please let me know if you see any solution.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tushar Sharma Aug 20, 2017 at 10:27 AM
0

Hi,

Firstly, make sure to use "@Analytics.query: true" for your consumption CDS view.

Secondly, use "@AnalyticsDetails.query.axis: #ROWS" for the field you want to make Measure.

Ex:-

@EndUserText.label:''

@AbapCatalog.sqlViewName:'sql_viewname'

@Analytics.query: true

@OData.publish: true

define view <> as select from <> {

@AnalyticsDetails.query.axis: #ROWS

Amount // Field you want to make as Measure

}

For more info: Defining Analytical query CDS view

Thanks,

Tushar Sharma

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi,

Those setting were already in place but still measures are not coming.

0

Hi,

Sorry, for the late response.

I want to add one more thing when ever we are defining the measures, it has to be defined with quantity or unit of measure.

Ex:

In composite/basic view.

define view zview1 as select from <> 
{
   @Semantics.currencyCode: 'true'
   Local_Currency,
   @Semantics: { amount : {currencyCode: 'Local_Currency'} }
   Amount
}

Now, in consumption view for above basic/composite view:

define view <> as select from zview1 
{
   @AnalyticsDetails.query.axis: #FREE
   Local_Currency,
   @AnalyticsDetails.query.axis: #ROWS
   @Semantics: { amount : {currencyCode: 'Local_Currency'} }
   Amount // Field you want to make as Measure
}

Thanks,

Tushar Sharma

0