Hi everybody,
I have a crosstab and a chart, and use member set of regions where I exclude one region, group 2 into custom set, and there are several more regions.
It seems to work fine, except there are no values for the custom group in the crosstab, all other regions are okay, the total is correct, and the chart is okay (has values).
HELP!
Hi Julia,
did u check the generated SQL? I have made the experience that cognos has its issues with crosstabs in general, from buildin a temp. cube (in case of an relational or dmr modell) up to performance issues.
What i do in case of unexpected behaviour, im breaking my queries and my logics down into small pieces and check them for correct results.
So in your case, you might wanne try to extract the regions of your custom group, check with some SQL on your db for reference values, and then check if your package delivers correctly. Then build a custom group without any other dimensions in cognos and so on..
good luck :P