COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS PowerPlay => Topic started by: ShilpaHonnavara on 19 Dec 2010 09:00:00 PM

Title: Issue with subsets in Powerplay report- Version 7.3
Post by: ShilpaHonnavara on 19 Dec 2010 09:00:00 PM
Hi,

We are using Cognos Powerplay for creating reports using advanced subsets(Version 7.3)

The report is sourcing a cube. There is an issue with one of the subsets. Only on some occasions, this subset does not display all the categories after cube refresh. But when it is deleted and dragged again into the report, it shows the values of the categories that were missing previously. Is this an issue with the version?
One observation though, is that when I open the report as it is, this particular category shows 'Subset not executed' under 'Explain'. All other categories show the category count. Could this be any cause for the issue? If so, are there any solutions for this?

Note that this issue of missing values happens only sometimes.

Thanks!