Skip to Content
Author's profile photo Former Member

Replication of BW – CKF/RKF into HANA as Calculated/Restricted Columns

Hello Guys,

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 :

This is Analytical view which i have created this is in accordance to the modelling done in BW for Copa Cube./wp-content/uploads/2013/06/1_228792.png

You can see all calculated Columns/restricted Columns/Attribute Views  on right side of modelling pan. Right click on Calculated Columns and Click New./wp-content/uploads/2013/06/2_228793.png

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.



Deepak Machal

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Pierre-Yves Guillou
      Pierre-Yves Guillou

      Very interesting! Is it a brand new HANA system you have implemented or just a conversion from BW on standard DBMS to a BW on HANA ?

      Author's profile photo Former Member
      Former Member
      Blog Post Author


      This is the new hana system we are trying to create the report totally in BO based upon on hana only. We have imported all requisite standard tables into hana and have fetch data wat we are fetching from BW cubes. So in our case we have totally avoided BW. It is like

      ECC --> Various standard table(according to datasource/masterdata IO in BW) --> Imported to HANA --> Modelling --> Universe in IDT on HANA --> Webi Reports .

      Author's profile photo CH Raman
      CH Raman

      Hi Deepak,

      Best article and very useful. thanks for sharing deepak and expecting more docs form you on BW-HANA.


      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thanks Raman 🙂