SAP Hana Attribute View

[former_member192811]

Hello Everyone,

I have read that attribute views only display descriptive information , they do not store measures.

Now what i understand from measures is  that  measures means any numerical fields in the table.

However attribute views provide the option of having calculated columns.

Now for ex: if i have a column called student's marks(  which is numerical therefore measure ) and subject name(dimension) i can calculate the percentage by creating a calculated column and say Marks*100/subject name(count). Then the new percentage column in addition to marks columns is a measure and is it not true that attribute views cannot have measures . So how can we have calculated columns in attribute views or measures also for that matter.

Even if we ignore marks column or measure columns coming directly from tables  we can still do calculations using calculated columns which is very unlike of attribute view.

Kindly help me understand this.

Regards,

Pooja M

[former_member192811 · Accepted solution]

Hello Sree,

Thanks for the info but then what should be considered as measure? i am confused as to what numerical values should be considered as measure?

But attribute views do have the option of defining certain columns as measures, right? Then if I create  a calculated column using this measure column then am I not moving towards having measures in my view and eventually analytical view ( as analytical views hold transactional data /fact tables/measures)

I am still not clear with this.

Please help.

Regards,

Pooja M

[sreehari_vpillai · Accepted solution]

Hello Pooja,

What should be considered as a measure --> Measure is something on which aggregation calculations can be made meaningfully. Thus all the numeric attributes can not be treated as a measure. There is no point in manipulating a serial number or age right ? Think about stock, quantity , price etc . A measure always points to a fact (  Data warehouse - Wikipedia, the free encyclopedia ) .

But attribute views do have the option of defining certain columns as measures, right?--> Share us a screenshot where you see so

As I mentioned before , attribute views are the dimension set builder for analytic view and is not expected to hold measures. Because, ideally a facts doesn't turn to a dimension.

Dimension (data warehouse) - Wikipedia, the free encyclopedia

Measure (data warehouse) - Wikipedia, the free encyclopedia

Hope it helps.

Sree

[former_member192811]

Thanks Sree 🙂 got it !!!

[sreehari_vpillai]

Great Close it !

[sreehari_vpillai]

Here you are bit confused about what attribute views are used for. They are meant to provide attribute information of an entity which is distributed in multiple tables(material master, text tables, plant information etc- maximum stocking level is a numeric field, but in this context it is not considered as a measure. But as an attribute ) . It is not indented for a Dimension Vs Measure analysis .

Read 5.2.3 in developer guide .

which is numerical therefore measure --> all numeric field need not be a measure(maximum stocking level, age of an employee, experience in years , percentage of billing etc are numeric, but may not be a measure ).

Sree