[
https://issues.apache.org/jira/browse/LENS-788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Archana H closed LENS-788.
--------------------------
> Option to do flattening of columns on bridge tables later
> ---------------------------------------------------------
>
> Key: LENS-788
> URL: https://issues.apache.org/jira/browse/LENS-788
> Project: Apache Lens
> Issue Type: Improvement
> Components: cube
> Affects Versions: 2.4
> Reporter: Amareshwari Sriramadasu
> Assignee: Amareshwari Sriramadasu
> Fix For: 2.6
>
> Attachments: LENS-788.4.patch
>
>
> With support to flatten (aggregate) columns from bridge table joins added in
> LENS-752, this is enhancement to apply aggregate later to applying filters or
> expression over the columns.
> For ex :
> With schema example given LENS-752, if user queries revenue with a filter :
> cube select usersport.name, revenue where time_range_in(dt,x,y) and
> usersport.name in ('Cricket').
> The query should have an option to apply filter before aggregate or not.
> Similarly :
> cube select (case when usersport.name='cricket' then 'CKT' when
> usersport.name='football' then 'FB' else 'NA' end), revenue where
> time_range_in(dt,x,y).
> The query should have option to apply expression before aggregate or not.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
