Replication of BW – CKF/RKF into HANA as Calculated/Restricted Columns
During one of my project in BW to HANA Transition of BW based Copa Reports, I have done the modeling in HANA based upon the the multiproviders/Cubes/DSO and various Lookup in BW.
After Doing the Analytical view of Cube in HANA, i have created the CKF or RKF which in case can also be created in front end in BO but rather i choose to create here in HANA for better performance.
So here in this document i have tried to showcase the steps which are involved in creation of CKF and RKF in HANA which are the replication of what we have in BEx Queries. So here we go :
now there is small defect in hana 51 version whenever one try to create the new calculated measures,OK button is not visible so we are required to hide the Taskbar. check belowscreen shots for details.
Auto Hide the Taskbar so that we can see the OK Button and Press it 🙂
Now we are able to see the OK Button Lets proceed to create the Measure now.
Now lets try to replicate the CKF which is created in BW Query to Hana Modelling. This is the test CKF which i have created in BEx Query
Now in HANA right Click on Calculated Measures –> New. Give data type as decimal and prefer scaling factor, Column type as Measure and select the relevant key figures. After Creating the expression always validate as if you dnt it will get created even if it contains error and while activating the Analytical View it will throw and error and believe me that error log is not very much user friendly as we have in BW so why waste time there better to Validate the expression first.
This is how we replicate the CKF from Bex to HANA.
Lets see how we replicate the RKF from BEx to HANA. I have created the Test RKF in Bex query which i will try to replicate in HANA.
We have one RKF having keyfigure restricted with Record Type not equals to ‘F’.
Record Type is Mapped to VRGAR field coming from ECC.
Now go to HANA Modeller Create the restricted column similar to calculated measures. Select the Keyfigure which you want to restrict and then select the characteristic and its value.
Now Click on Add restriction Select the characteristic VRGAR in our case select the Operator its “Equal” in our case and give the requisite value.
If you want condition as VRGAR = F then Check the INCLUDE Box and If you want VRGAR not equals “F” then uncheck the INCLUDE Box.
Click Ok to create we can use this RKF in CKF as well.We can see tha calculated Measures created under Calculated Columns and Restricted under Restricted Columns.