Hey guys,
I have a very simple Crosstab using non-OLAP DMR (FACTS/DIMS) 10.2.1. After filtering the I'm getting the following error when I run the report:
XQE-PLN-0204
The aggregate expressionn "minimum([Business View].[CASE_REC].[InvestCount] FOR [UCM Business View].[Z_DIM].[Z_Z_CD]; [Business View].[REC_DIM].[REC_TYPE_CD]; [Business View].[RECTYPE_DIM].[REC_TYPE_DESC])" can not be supported by a single fact stream query.
I'm not even using minimum within my report so I'm not sure where it's picking it up.
Thanks in advance for your time.
Maybe there is a column in the package which has the 'minimum' function defined.
I disabled the Auto Summary as a part of the Query Property and it took care of the issue.
Thx for your time.
Quote from: gosoccer on 31 Aug 2015 10:06:54 AM
Hey guys,
I have a very simple Crosstab using non-OLAP DMR (FACTS/DIMS) 10.2.1. After filtering the I'm getting the following error when I run the report:
XQE-PLN-0204
The aggregate expressionn "minimum([Business View].[CASE_REC].[InvestCount] FOR [UCM Business View].[Z_DIM].[Z_Z_CD]; [Business View].[REC_DIM].[REC_TYPE_CD]; [Business View].[RECTYPE_DIM].[REC_TYPE_DESC])" can not be supported by a single fact stream query.
I'm not even using minimum within my report so I'm not sure where it's picking it up.
Thanks in advance for your time.
If I'm reading this correctly, you're using filtering (detail filters / summary filters) with a dimensional package?
If so, I think that's the root cause of your issue.
MF.