Posted by Darren Nelson on Wed, Dec 03, 2008
Wow, two blogs in one night! I'm wrapping up an engagement where a client was effectively looking for Framework Manager functionality on the web. That is to say, the ability to augment a model without using the FM application.
THe solution? Its been around since the beginning of Report Net: Report Studio. That's right, we're using Report Studio to modify models. Here's the scenario the client was looking at:
- Dynamically publish a model based on an ever-changing database schema (no problem, we do Metadata Automation all the time)
- Client wanted to add new query items to specific query subjects frequently
We showed the client a project from our past where we performed similar actions using Report Studio. The end result for the client: A report author can create calculations and data items, and have them automatically added to the model!
Ingredients: a little Report Studio, a dash of SDK, a mouse click, and stand back for about 2 seconds while the process completes!
Next time they go into a studio, the new data items are there! Oh yeah, did I mention that we also allowed the client to implement security on those new items?
Would like to hear from anyone who thinks this might be useful for their Cognos deployments.
Kudos to Ling T. and Chris T. on this project!
- Darren