|
|
|
|
|  | 
Metadata Manager is an easy to use software product that allows you to parse your existing Impromptu reports and .iqd files and document them. The report SQL is parsed into Elements, which become “building blocks” for reports. Then a Report Spec is created which shows which Elements are used in the report.
This approach has many benefits when managing Impromptu reports and Powerplay cubes:
1. Metadata Manager allows you to collect and document all of the Impromptu Report Specs in your organization, quickly and easily. You now have a central repository, which spans catalogs, that allows you to understand which tables and columns are most frequently reported on.
2. With a central repository, you can now develop standardized naming conventions, which are consistent and clear, across the organization. Metadata Manager creates Element Definitions for each Element, and the report the Element Definition came from. The Element Definitions describe whether the Element is a straight column pull or a calculation, and what the calculation logic is.
3. You can document your Powerplay cubes, too. Transformer MDL parsing is not yet available, but by parsing the Transactional query .iqd’s, you can then produce a report spec for Powerplay cubes, which are accounted for with all the Impact management features of the product.
4. Metadata Manager provides Excel outputs of all the technical information needed to model properly in Framework Manager, when you are ready to migrate to Cognos8. Metadata Manager is invaluable at doing "housekeeping" on your existing Impromptu catalogs and reports, before migration. This provides an "Object Mapping" approach to the migration, which gives developers much more control over the migration, in a fraction of the effort.
5. With a tool like Metadata Manager, you can now encourage users to “register” their Impromptu reports with IT, if they would like to be notified of underlying database changes. In a distributed reporting environment where users develop their own reports, managing the reporting environment can be extremely difficult.
Maintaining your Impromptu report and .iqd metadata is easy with Metadata Manager's powerful automation features, which can document your entire deployment at once, and update only changed files and reports going forward. A full suite of administrative reports is included. In addition, an Impromptu catalog is included with the software, which allows you to create custom reports for IT and/or consumers, and publish them to the Web using IWR.
Initial Release: 6/25/04
|
|
|
 |
| Search
SNCL |
|
|
|
| Success
Stories |
| Time Warner Cable –
The Marketing Department needed a visual breakdown of demographics and penetration across the geographic area of NYC by zip code and census tract. |
|
Harry Fox – wanted to create an automated procedure that would allow b-to-b companies to run IWR reports pertaining to the status of their business.
|
|
| NYC Board of Education – needed to provide vital educational statistics on students, test scores, demographics, salaried positions, and teacher certifications to its superintendants over a Web-based interface. |
|
| Orix – A leasing company for trucks and construction equipment needed to consolidate its lease portfolio across its decentralized subsidiaries, and provide mission critical Risk Management reporting. |
|
|
More Success Stories
|
|
|
|
Success Stories by Company
|
|
|
|
|
|
