Data: Dimensional
Report Studio List Report
This error is so vague.. has anyone ran into this before. I have searched the net and nothing
XQE-WRN-0052 The header/footer summaries can not be calculated because the query contains a relational function which implies local aggregation and there is not enough information. You may want to select an explicit aggregation type.
tia
Quote from: maxchuie on 02 Sep 2015 04:03:18 PM
Data: Dimensional
Report Studio List Report
This error is so vague.. has anyone ran into this before. I have searched the net and nothing
XQE-WRN-0052 The header/footer summaries can not be calculated because the query contains a relational function which implies local aggregation and there is not enough information. You may want to select an explicit aggregation type.
tia
Hi,
It seems to be complaining about the use of a relational function somewhere in your query. What calculations/summaries are defined?
MF.
MFGF it looks like they are using a count (distinct [Member Set B] for [Member Set A])
Quote from: maxchuie on 03 Sep 2015 01:33:52 PM
MFGF it looks like they are using a count (distinct [Member Set B] for [Member Set A])
Yep - that's most likely the culprit here.
How are these used within the report? Is [Member Set B] nested below [Member Set A]? If so, you could amend the expression to be
count(currentMeasure within detail [Member Set B])
This would need to be held at the same nesting level as [Member Set B]
Cheers!
MF.
It is being used as a summary calculation
they are not nested within each other they are their own dimension hope this makes sense