If you are unable to create a new account, please email support@bspsoftware.com

 

Report [b]XQE-PLN-0204[b]can not be supported by a single fact stream query.[/b]

Started by gosoccer, 31 Aug 2015 10:06:54 AM

Previous topic - Next topic

gosoccer

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 expression
n "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.

cognostechie

Maybe there is a column in the package which has the 'minimum' function defined.

gosoccer

I disabled the Auto Summary as a part of the Query Property and it took care of the issue.
Thx for your time.

MFGF

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 expression
n "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.
Meep!