Measure in attribute view

[Former Member]

Hi ,

I have sale_price in the attribute view and defined as a non-key attribute view. I want to use it as measure..?

what is the procedure to handle measure's in attribute view.. please suggest

[former_member184768 · Accepted solution]

Hi Hari,

An Attribute as per definition and usability perspective is not supposed to have 'measures' with aggregation behavior. You use columns in attribute view in Calculated attributes, but these do not have aggregation properties.

If you need to use sales_price as a 'measure' then it should be defined in the Analytic view. As you may already know, the Analytic view can have only one base table from which measures can be selected, hence if you wish to use this along with other measures from other tables, then you may need to define additional analytic views and use them in JOIN or UNION (based on business requirement) in the Calc view.

Regards,

Ravi

[Former Member · Accepted solution]

thank you ravi !!

[rama_shankar3 · Accepted solution]

Hari,

Create a Analytical view on top of this attribute view and define as a measure. Then you can use this measure for calculations moving forward.

Regards,

Rama

[rama_shankar3 · Accepted solution]

Hi Hari,

Are you the same person (Vasu) who sent me an email on the same issue couple of days back? Just curious!

Regards,

Rama