Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SAP Hana Attribute View

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

Tags:
Former Member
replied

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

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question