Virtual Key Figures Characteristics Makes Query More Dynamic
Virtual Key Figures (KF)/ Characteristics can be used to create the Query more dynamic. The value of Virtual KF/Characteristics does not store in the Data Target, it is calculated at runtime (At Query Execution time). Complex logic, database access is possible by using Virtual Key Figure and Characteristics. This paper shows how to create virtual Characteristics / Key Figure. Example shows about evaluating a value called as 20 Day Value, which requires a complex logic and also require data from existing ODS Characteristics for complex calculation.