Entries by Wayne Estrada

,

Ironside Tech Tip: Show Cube Sizes in BI Reports

Cubes (including Cognos PowerCubes and Dynamic Cubes, as well as other file-based cube technologies) are well-known, commonly used, and valuable data sources in reporting.  As specially indexed binary files, report performance with cubes is generally robust, however when cube files grow very large (or there is high simultaneous demand reading from the cube), response time can […]

,

Ironside Tech Tip: Where to Apply Filter Strategies – In the Database, in the Package, or in the Report?

Guarding the security of and defining access to data is often a necessary business requirement. Not all users can or should have access to a total data set, so filter strategies need to be applied to restrict what appears to different users running reports. As Cognos developers, the first question we should ask when faced […]

,

Ironside Tech Tip: Dynamically Selecting Filters Utilizing Before or After Aggregation via a Prompt

Synopsis: Enable a user via a prompt to pre-select if a value will be filtered before or after aggregation. Overview: Normally, the report author hard codes filters placed on facts in the Properties pane as before or after aggregation. While this is adequate in most report scenarios, hard coding can be limiting if the executing […]

,

Ironside Tech Tip: Conditional Blocks – Applications and Usages

Synopsis How to create, implement and use conditional blocks in Cognos reports. Overview Conditional blocks show different display results based on user interaction or parameters read in when a report is run. They provide a creative method for presenting either the same report data in various formats or executing several completely different reports from one […]