Report Studio Error XQE-WRN-0052

[maxchuie]

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

[MFGF]

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.

[maxchuie]

MFGF it looks like they are using a              count (distinct [Member Set B] for [Member Set A])

[MFGF]

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.

[maxchuie]

It is being used as a summary calculation
they are not nested within each other they are their own dimension hope this makes sense