Hands on experience with IBM 10

Loads to explore on IBM 10 especially with all the hype and the ads that they have been showing I was very eager to explore it. It has been only couple of hours since I installed IBM 10 but here are some of the things I found that were interesting.

1. ODBC --- Loads of new ODBC options ex….Netezza – one of their latest acquisition
2. COGNOS Insight should get a top rating, my experience on it has be minimal but I am sure I will get to get a lot on it.
3. New installation (default)path has changed --- in comes IBM -->ibm/cognos/c10
4. Yet to explore report studio which is presently missing or is it in a different manner now. (May be it required a separate installation / package)
5. Lotus Connections software
6. From the internet ---- “Cognos Active Reports, allows Cognos users who find themselves--heaven forbid--disconnected from the network to still consume interactive reports. The product is a tool for developers to create these reports. Large data sets are not supported, but even so, Cognos users have been asking for such a product (already available from Cognos' big-name rivals) for years. “
7. Info about another acquisition --- SPSS ---- “from the internet” renowned statistical engine is now included in the Cognos suite as Cognos Statistics. As an optional and integrated component of the Cognos Report Studio, Cognos Statistics provides analysts with the capability to build reports that contain statistical analysis. No longer must they leave the comfy world of the Report Studio to extract data from the data warehouse, load it into the statistical engine, and then distribute the resulting reports. It can all be done centrally.We would love to have SPSS; but I guess it will cost us more.
8. Small things like --- web colors, web icons

I will get back on this very soon.

IBM COGNOS 8.4 – aggregate currentMeasure within detail error / not totaling properly

One of my friend called me the other day and explained me a situation where the sum of a row wasn’t right. It wasn’t very clear when he initially explained the issue to me and so I asked him to email me a screen shot (the image I have put up here.)
When I first looked at the screen shot, it looked fishy to me but flashed to me instantly that this should be a report studio error and that they would have changed the property of the data item. So I emailed him back with a screen shot of the property column that should be updated
Solution  Change the property of the Summary / Aggregate (Appointment Date)
Aggregate Function --- Calculated
Roll Up Aggregate --- Total
That did the trick !!!!!