Fiory Analytics

gistfile1.txt

@Metadata.layer: #CUSTOMER
@UI.selectionPresentationVariant: [{
  qualifier: 'Default',
  presentationVariantQualifier: 'Default',
  selectionVariantQualifier: 'Default'
}]

@UI.presentationVariant: [{
  qualifier: 'Default',
  visualizations: [{
    type: #AS_CHART,
    qualifier: 'ChartDefault'
  }]
}]

@UI.chart: [{
  qualifier: 'ChartDefault',
  title: 'Gross Amount / Product Category',
  chartType: #COLUMN,
  dimensions: ['ProductCategory'],
  measures: ['GrossAmount']
}]

@UI.selectionVariant: [{
  qualifier: 'Default',
  text: 'Default'
}]

annotate entity ZTest_Analytical_Ihwan
    with 
{
@UI.lineItem: [{ position: 10 }]
@EndUserText.label: 'Sales Order'
SalesOrder;

@UI.lineItem: [{ position: 20 }]
@EndUserText.label: 'Sales Order Item'
SalesOrderItem;

@UI.lineItem: [{ position: 30 }]
@EndUserText.label: 'Product'
Product;

@UI.lineItem: [{ position: 40 }]
@EndUserText.label: 'Product Category'
@UI.selectionField: [{ position: 10 }]
ProductCategory;

@UI.lineItem: [{ position: 50 }]
@EndUserText.label: 'Customer'
Customer;

@UI.lineItem: [{ position: 50 }]
@EndUserText.label: 'Gross Amount'
GrossAmount;

    
}

ZTest_Analytical_Ihwan

@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Sales Order Analytical Data Model'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
@Metadata.allowExtensions: true
@Analytics.query: true
@OData.publish: true

define view entity ZTest_Analytical_Ihwan as select from SEPM_P_SalesOrderItemCube( P_DisplayCurrency: 'EUR')
{

    key SalesOrder,
    key SalesOrderItem, 
    Product,
    ProductCategory,
    ProductType,
    
    @AnalyticsDetails.query.display: #TEXT_KEY
    Customer,
    
    
    @Semantics.amount.currencyCode: 'Currency'
    GrossAmountInDisplayCurrency as GrossAmount,
    DisplayCurrency as Currency
}