SAP Hana Attribute View
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.
Sreehari V Pillai replied
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.
Hope it helps.