FOR clause can not contain multifact error

[cogdev4u]

hi All,

I am getting this error when I run my report.

RQP-DEF-0328

The FOR clause in expression 'Year Prompt'.'Year NBR' must not contain multiple facts.

checked for it on cognos site it says that I need to fix determinants.
I set the determinants in my model and I also ran into issue of cognos not recognising joins.
so as per advice in this thread I put all joins in one layer and in other one just defined scope relation (bet dimention and measures) and its working now. But I still get the same error (RQP-DEF-0328 The FOR clause...).

Has any one seen this issue before and aware of any way out.This is very critical for us as some high priority reports are waiting to be built out of this.

Would appreciate any help,hit,
Thanks and Regards,
cogdev4u

 

[jpanzeca]

Hi,

Did you get an answer for this. I am getting this error now too.

Thanks,
John.

 

[cogdev4u]

hi jpanzeca,

I didn't get any answer for this.It usually happens when you try to get data from two fact tables in one query. Now we have seperate query for each fact table data and then we join them for our final result query.You can try that too,will give you req result.

Still need to solve this issue. If you have any other info/insight let me know.

Thanks,
Cogdev4u

 

[CognosProfessional]

SAME: I get that error too. No resolve yet. Opened call to Cognos, they are getting back to me.
QE-DEF-0459 CCLException
RQP-DEF-0328 The FOR-clause in expression 'if ([ID] starts with '10' ) then ( ' ') else ([ID])' must not contain multiple facts.

CP

 

[cogdev4u]

hi CognosProfessional,

did u try with dimensional modeling and determinants?

Please let me know what response u got from cognos..

Cogdev4u

 

[misscognos]

this sounds like a bug to me...