Skip to Content

Measures not coming in Analysis office

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Aug 20, 2017 at 10:27 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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