[jira] [Commented] (LENS-69) Cube expressions should be classified as measure or dimension

["Jaideep Dhok (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/LENS-69?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14287122#comment-14287122 ] 

Jaideep Dhok commented on LENS-69:
----------------------------------

Expressions could be measures or dimensions, but they can also exist on their own.

Example let's say we have a market fact table with buy and sale transactions of products. An expression could be profitability_indicator which can be  a case statement on SUM(sell_price) - SUM(buy_price). In this case this is neither a measure, nor a dimension.

Is the main intent to allow distinct values and min, max etc? Could that be done at AbstractCubeColumn level based on type? We already ensure an expression has a type.

> Cube expressions should be classified as measure or dimension
> -------------------------------------------------------------
>
>                 Key: LENS-69
>                 URL: https://issues.apache.org/jira/browse/LENS-69
>             Project: Apache Lens
>          Issue Type: Improvement
>          Components: cube
>            Reporter: Amareshwari Sriramadasu
>
> We have expressions sitting separate from measure or dimension. But they should be actually a measure or dimension. This would also allow to give more attributes defined for the expressions for example possible min or max values, or possible distinct values, format string and etc. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)