Creating a list report in Analytics 11.0.5 when i add fiscal year (2016, 2017, etc.) to the report it does a row sum of FY. FY is numeric for cases where you need to do FY -1, etc. if there are two rows that have 2017 it sums up to one row with 4034. I tracked down, thanks to COGNOISE, how to prevent it from generating summary rows for everything, but i cannot get it to not summarize columns that i don't want to summarize. Is there a way to add a numeric field and not have it summarized?
Quote from: TripJ on 23 Mar 2017 12:36:53 PM
Creating a list report in Analytics 11.0.5 when i add fiscal year (2016, 2017, etc.) to the report it does a row sum of FY. FY is numeric for cases where you need to do FY -1, etc. if there are two rows that have 2017 it sums up to one row with 4034. I tracked down, thanks to COGNOISE, how to prevent it from generating summary rows for everything, but i cannot get it to not summarize columns that i don't want to summarize. Is there a way to add a numeric field and not have it summarized?
I'm assuming it's a column in a relational database (as opposed to members in an OLAP cube) here? What is the Usage property of the item set to be in Framework Manager? My guess is it's currently set as Fact, and it ought to be set as Attribute?
Cheers!
MF.
Quote from: TripJ on 23 Mar 2017 12:36:53 PM
Creating a list report in Analytics 11.0.5 when i add fiscal year (2016, 2017, etc.) to the report it does a row sum of FY. FY is numeric for cases where you need to do FY -1, etc. if there are two rows that have 2017 it sums up to one row with 4034. I tracked down, thanks to COGNOISE, how to prevent it from generating summary rows for everything, but i cannot get it to not summarize columns that i don't want to summarize. Is there a way to add a numeric field and not have it summarized?
Hi
1.In List report select fact column.
2. for the fact set the property called Detail Aggregation= None.
After setting this property. run and check it.
I hope this will be usefull.