[LENS-788] Option to do flattening of columns on bridge tables later

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4
• Fix Version/s: 2.6
• Component/s: cube
• Assignee: Amareshwari Sriramadasu
• Reporter: Amareshwari Sriramadasu
• Created: 25/Sep/15 02:01
• Updated: 02/Sep/16 08:27
• Resolved: 30/Mar/16 05:40

Description

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.

Issue Links

• relates to: LENS-752 Support flattening of columns selected through bridge-tables(many-to-many relationships)