Product: Aqua Data Studio
Version: 17.0.0-ga-22
Build #: 48126
Build Date: 2016-Jan-07 07:16:04 PM
Operating Environment: Linux (3.13.0-71-generic, amd64) / UTF-8 / en / IN / Oracle Corporation 1.8.0_40-b26
Memory: Max=704,643,072; Total=388,497,408; Free=149,296,744; CPUs=8
Steps to reproduce:
1.Dnd a dimension in Columns deck.
2.Dnd a measure in Color deck.
3.Right click on measure in color deck & select Dimension option.
4.Right click on dimension in color deck & select continuous option.
5.Select Treemap from All accordion.
Appropriate Treemap chart is generated.
6.Dnd a measure(which is not available in color deck) in Rows deck.
7.Right click on measure in rows deck & select Add table calculation option.
Keep default settings as it is & click on OK.
8.Click on Analysis menu & uncheck Aggregate measure option.
OR
Open attached 14154_GA-22.vizx
Go to Scenario 1 sheet
Click on Analysis menu & uncheck Aggregate measure option.
Actual result:You will observe that measure field in rows deck turns invalid which is appropriate behavior but incorrect chart is generated.
As only dimension & a continuous dimension are vaild so treemap chart should be generated same as that generated in step 5
Also on hovering on chart you will observe that Disaggregate measure is written in tool-tip which is incorrect.
Expected result: As treemap chart is generated on dimension field in columns deck & continuous dimension is color deck so in tool-tip disaggregate measure should not be available.
Also chart should be generated as per valid fields available in columns & chart properties deck.
Also Aggregate measures options should be disabled in Analysis menu as there is not valid measure field present in rows deck.
Observation: This issue only occurs for Treemap chart.
Appropriate chart is generated in case of radar chart.
This issue only occurs if table calculation is applied on measure field in rows deck.
This issue only occurs if a continuous dimension or a secondary date dimension is available in chart properties deck.
Works fine if a measure field is available in chart properties deck.
Scenario 2:
1.Dnd a dimension in Columns deck.
2.Dnd a measure in Rows deck.
3.Dnd a measure(which is not available in rows deck) in color deck.
4.Right click on measure in Rows deck & select Add table calculation option.
Keep default settings as it is & click on Ok.
5.Go to Analysis menu & uncheck Aggregate measures option.
OR
Open attached 14154_GA-22.vizx
Go to Scenario 2 sheet
Go to Analysis menu & uncheck Aggregate measures option.
Actual result: Measure field in rows deck turns invalid which is appropriate behavior but for table chart diaggregate icon appears on measure field in color deck.
Expected result: As table chart does not support disaggregate mode, disaggregate mode icon should not be displayed on measure field in color deck.
Also disaggregate measures option should be disabled in Analysis menu.
Observation: This issue only occurs if table calculation is applied on measure field in rows deck.
Broken build for both scenarios: 17-beta-6
@nhi: fix in v17 only if low impact. Otherwise, fix in v18 only.