-
1. Re: Data blending - Extracts the secondary data source
Santiago SanchezAug 2, 2018 5:30 PM (in response to Venkatesh Badrinathan)
Hmmm it's hard to tell from the image but the secondary data source should be aggregated at the level you are using in the view. Is it possible you have a dimension in 'Detail' (or setup on the blend relationship) that would make the secondary data source aggregate at a very granular level?
-
2. Re: Data blending - Extracts the secondary data source
Venkatesh Badrinathan Aug 3, 2018 7:18 AM (in response to Santiago Sanchez)Hi, Thanks for your inputs. my secondary data source is at detail level. my view only shows the aggregated numbers.
for example:
secondary data source has 10 detail rows with different categories.
my view has to show how many rows per category.
category1-4
category2-4
category3-2
i read you say "the secondary data source should be aggregated at the level you are using in the view"
mine does not follow that rule.
any suggestions? thankyou.
-
3. Re: Data blending - Extracts the secondary data source
Santiago SanchezAug 3, 2018 10:40 AM (in response to Venkatesh Badrinathan)
It's hard to tell. If you can attach a workbook with some sample data then we could likely troubleshoot better.