Skip to Content
Author's profile photo Former Member

Error when Creating Analytics View – Measure Cannot be Identified

When creating an analytic view in HANA, I received the following error, which prevented me from saving the view.

/wp-content/uploads/2013/05/error_message_217164.jpg

Even with extensive search in SCN, I was unable to find any hints on the cause of this error, and how to resolve it. Hopefully, this post will save someone else couple of hours, and some hair pulling!

When creating the analytic view, I used a LEFT join in my Data Foundation, to retrieve the data I needed , which could then be fed to Logical View (as shown in the screen shot below).

/wp-content/uploads/2013/05/overall_screen_217218.jpg

However, for the Data foundation, there can only be ONE main driving table. The analytic view can use only FACTS from this driving table. In this situation, I had NOT specified this driving table/central table, which can be used in Analytic view for FACTS/MEASURES.

/wp-content/uploads/2013/05/overall_screen_1_217235.jpg

To resolve the error, select the central table and assign it to Central Entity. You should now be able to save the analytic view.

Central Entity.jpg

On a closing note, when there is a situation where we need measures from multiple FACT tables, we will have to create separate Analytic Views – one for each measure – and then combine them in a Calculation View.

Assigned Tags

      8 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Sarosh Jacob
      Sarosh Jacob

      Thanks! It helped me with the same issue

      Author's profile photo Former Member
      Former Member

      Yes helped me too! Saved me a lot of time. 🙂

      Thank you!

      Author's profile photo Thamizharasan Mohan
      Thamizharasan Mohan

      It worked. Thanks a lot...! 🙂

      Author's profile photo Former Member
      Former Member

      TX FOR THE INFORMATION.IT HELPED TO ME

      Author's profile photo Brijesh Miglani
      Brijesh Miglani

      Thank you for sharing you experience on Central Entity.

      Just wanted to make a note here..It not advised to use multiple Analytic views by means of JOIN in Calculation view. It will have performace impact.

      Used Star join instead in calculation view.

      Cheers !

      Author's profile photo Former Member
      Former Member

      Thank a lot

      Cheers

      Author's profile photo Benjamin Fischer
      Benjamin Fischer

      Thank you so much!!!

      Author's profile photo Tomasz Pietrowski
      Tomasz Pietrowski

      Saved a lot of time,

      thanks for sharing.