Skip to Content

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.

/wp-content/uploads/2013/06/3_228821.png

/wp-content/uploads/2013/06/4_228822.png

Auto Hide the Taskbar so that we can see the OK Button and Press it 🙂

/wp-content/uploads/2013/06/5_228823.png

Now we are able to see the OK Button Lets proceed to create the Measure now.

/wp-content/uploads/2013/06/6_228827.png

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

/wp-content/uploads/2013/06/7_228828.png

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.

/wp-content/uploads/2013/06/8_228829.png

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’.

/wp-content/uploads/2013/06/12_228836.png

Record Type is Mapped to VRGAR field coming from ECC.

/wp-content/uploads/2013/06/11_228838.png

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.

/wp-content/uploads/2013/06/9_228842.png

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.

/wp-content/uploads/2013/06/10_228843.png

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.

/wp-content/uploads/2013/06/13_228844.png

Thanks,

Deepak Machal

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

    1. Deepak Machal Post author

      Hi,

      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 .

      (0) 

Leave a Reply