Entries by Robert Rosen

,

Ironside Tech Tip: Using Macros in Cognos

Difficulty: Easy Required Ingredients: Prompt macros and static values within a prompt parameter. Scenario: You have some existing reports that prompt on Year and Month. Users would like a better experience by having default selections provided for them. For scheduling purposes you’d also like to set relative time so the report can run based on […]

,

Performing Data Warehouse Validation with IBM Cognos Report Studio

Reporting should start with a “single source of truth” and end with a “single version of truth.” Delivery of accurate reporting information is paramount in the day-to-day operations of every organization. Some of the methods for maintaining data Integrity (within the data warehouse) would be to apply referential integrity and maintain primary keys on tables. […]