Create a report over a cube dimension, say Brand, and zero suppress. Currently there are only 3 Brands A, B, C in the source data. Report looks great. Save it and schedule for production. In a few weeks, business changes and a new Brand D is added. The Brand D sales dollars show in the total, but Brand D does NOT show in the report.
Created a Cognos ticket and they say this is normal behavior and that we need to unapply and reapply zero suppression. Seems that this can not be the case, but so far the only way we've been to get around it. Any ideas?
That is indeed strange if it is the normal behavior. I cant think of any other way to go about in AS. You could try creating a report in RS with MDX functions as a workaround.