cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Matrix consolidation in CDS View

twinkle3
Discoverer
0 Kudos
207

Hi Everyone,

 

We are trying to bring profit center elimination hierarchy(Matrix Consolidation) in the AFO report using  custom CDS View. But we are getting below warning, when we try to select profit center hierarchy in query the variable is showing blank and no hierarchies are displayed. How can we resolve this? 

twinkle3_0-1748929159828.png

twinkle3_1-1748929387718.png

 

 

View Entire Topic
JAnnapureddy
Product and Topic Expert
Product and Topic Expert
0 Kudos

To run matrix eliminations at the segment and profit center level, both Profit Center and Segment hierarchies are required.

Start by creating the Profit Center hierarchy and use it in the report selection inputs.