I'm looking for guidance (and possibly a sanity check!) on using Data Modules in a Report. Business Intelligence was recently introduced to our organisation when Cognos 10 landed on our desks. I only managed to get a fundamental understanding of it's use when we 'upgraded' to Cognos Analytics, so now I'm trying to apply what I'd already learned..... and struggling!
Unfortunately I can't access our the data stored Data Warehouse just yet, so uploading external data files and loading them into a Data Module seemed like an idea interim solution. I can successfully create a new Data Module and build the required Relationships but when I try to use it in a Report it doesn't behave as I expect......
The first thing I noticed was that once a Data Item had been used in a Report Object, and quite rightly appears in the Data Items list under the associated Query, it can't be re-used from the Query in subsequent Report Objects, even though they are using the same Query. I recall from my brief time using Packages in Cognos 10 that this was possible? Certainly all the help documentation I've read suggests it is and that it's often essential in complex reports.
Adding the same Data Item from the Source list does work but the Query gets another Data Item with the same name appended with a number, clearly two Data Items with identical names would cause chaos. Following this I tried to edit the Query in order to thin out the multiple Data Items it now contained but it appears I can't - the 'Edit' option is greyed out. From my understanding this also makes filtering challenging, if not impossible?
To add insult to injury, despite the above issues reports using Data Modules I've created actually run fine. I'm not sure whether this is an installation / set-up issue, an Analytics bug or my lack of understanding but hope someone out there with more experience than me can help?!?