Custom Analytical Queries / CDS - Deriviation Functions

2 months ago 10

Hi,

im trying to recognize the conception of deriviation functions successful the discourse of customized analytical queries and cds views. 

My Goal is to recognize and make deriviation functions for circumstantial analytical query fields

As shown below, one privation to make a elemental Derviation Function for the tract DeriviationPlaneType

jsur_0-1724244326760.png

I proceeded arsenic follows (i tried to usage the deriviation for CostCenter (ZF_MYCOSTCENTER) arsenic an template):
1. My Base CDS Entity

jsur_1-1724244464403.png

2. My Deriviation CDS-Entity, my extremity is to lone person planetypes with the worth '747-400'

jsur_2-1724244508098.png

3. My Primary Data Source, arsenic acold arsenic one understand, one request to subordinate the cds-entity which contains the tract with the deriviation relation (ZI_PLANETYPE -> ZF_MYPLANETYPE-> DeriviationPlaneType)

jsur_3-1724244594218.png

4. Custom CDS-View

jsur_4-1724244750593.png

jsur_5-1724244778104.png

jsur_6-1724244803426.png

5. Custom Analytical Query

I've created a customized analytical query based connected the beforementioned customized cds-view.

jsur_7-1724244889208.png

But my Deriviation Function is not showing up

jsur_8-1724244931672.png

Did one miss anything?

I besides tried to conscionable transcript F_MYCOSTCENTER

jsur_9-1724245013438.png

and creating a elemental Cube

jsur_10-1724245041188.png

But one americium getting an mistake connection erstwhile utilizing this cube successful a customized analytica query erstwhile selecting my deriviation function.

jsur_11-1724245112474.png

jsur_12-1724245131082.png

I anticipation anyone tin assistance maine to hole this and to get an amended knowing however deriviation relation work.

best regards

Jonas

Read Entire Article