Monday, April 30, 2012

LIST OF ALL POSTS

Books
How to make Cognos report reusable   

Solutions
How to achieve a comprehensive BI solution using Cognos with SQL server
How to customize reports tailored to individual customer with table of contents
How to simplify and centralize date logic in ETL and Report
How to improve Cognos report performance (4 Tiers)
How to turn Cognos BI reports into “Web forms” without using JavaScript
How to handle relative time (relational model focused)
How to make a single report to be shared for bursting, scheduling and running interactively
How to burst complicated reports with multiple parameters without using SDK
How to make cognos reports reusable - Explore the new idea of authoring Cognos reports – Part 1
How to improve master detail report performance
How to handle relative time (relational model focused) - Update 01
How to make Cognos reports reusable - Explore the new idea of authoring Cognos reports – part 2
How to make Cognos reports reusable - Explore the new idea of authoring Cognos reports – part 3
How to make Cognos reports reusable - Explore the new idea of authoring Cognos reports – part 4
How to dynamically set up default value, or initialize parameters in Cognos report
How to make Cognos reports reusable - Explore the new idea of authoring Cognos reports – part 5
The Cognos Report Toolkit
Unleash the power of UNION QUERY at report level to achieve the same functionality of "stitch query" at framework manager level
How to handle relative time (relational model focused) - Update 02
How to handle DMR relative time
How to make Cognos report reusable
How to model DMR relative time
How to improve Cognos report performance
How to resolve crosstab performance issue with DMR model for sparse data
Cognos report authoring techniques
How to achieve a most cost effective BI solution using SQL server express edition
How to make a dynamic date DMR dimension

How to design Cognos interactive reports
How to design Cognos interactive reports 01 - Make columns flexible
How to design Cognos interactive reports 02 - Make columns flexible with ID and description
How to design Cognos interactive reports 03 - Make filters flexible
How to design Cognos interactive reports 04 - Make filters flexible with ID and description
How to design Cognos interactive reports 05 - Make filters flexible with operators
How to design Cognos interactive reports 06 - Make filters flexible with search prompt
How to design Cognos interactive reports 07 - Make Group by flexible
How to design Cognos interactive reports 08 - Make measures flexible
How to design Cognos interactive reports 09 - Make a filter flexible without page refresh
How to design Cognos interactive reports 10 - Make multiple filters flexible without page refresh
How to design Cognos interactive reports 11 - Make report view for interactive reports
How to design Cognos interactive reports 12 - Make report with count condition
How to design Cognos interactive reports 13 - Make report element show and hide
How to design Cognos interactive reports 14 - Make report freeze column
How to design Cognos interactive reports 15 - Make columns flexible with TM1 cube
How to design Cognos interactive reports 16 - Make measures flexible with better performance

TM1
How to do drill through in Active Reports without connection to the Cognos environment
How to pass variable values to List, Crosstab and Chart in Active Reports
Howis publish - subscribe architecture used to communicate in Active Reports 
How to show or hide a block in Active Reports – a generic approach
How to efficiently pass variable values in Active Reports using data deck and direct pass
How to leverage HTML layout DIV Element in normal and active report – popup window
How to handle nested data deck with total in active report
How to speed up active report development
How to document Cognos active report
What are impacts of visualization in term of active report size and generation speed
How to make a nested crosstab selectable in Active reports
How to make active report reusable - 01
How to identify active report performance issues
Data deck with default card in active report does NOT work
How to make use of Cognos RAVE visualization tag cloud‬
How to setup a dynamic default value for an active report (Dimensional based)
How to improve Active report performance by using local classes
How to setup a dynamic default value for an active report (Relational based)
How to use a single list to set more than one parameters in Active report performance
How to burst active report on iPAD
How to pass two or more than one variables from crosstab in active report


Cognos report performance tuning
Overview  - 4 tiers concept
Database tier - Slice a single big fact table into multiple small measure oriented tables – “horizontal partition”
Framework tier - Model relative time as measures for relational
Framework tier - Use parameter maps based on existing query
Report tier - Use optional parameter to filter data in detail query for master detail report
Report tier - Force Cognos engine to generate a single query for master detail report
Report tier – Use Prompt Token macro in report studio to enhance performance
Report tier – Stitch multiple crosstabs together
Report tier – Transform nested Crosstab to single-edge Crosstab with much better performance (relational only)
How to improve report performance by Integrating prompt macros in framework manager query
How to build summary tables to improve performance at database level
How to apply minimized SQL concept
How to improve crosstab performance by removing default measure

Lists/Crosstabs/Charts/Maps
How to make bullet chart flexible in report studio
How to make a crosstab intersection drill through to different reports
How to keep colors consistent within report pages
How to create a chart inside a crosstab with summary
How to make conditional format in Crosstabs at Crosstab node member and Crosstab intersection
How to dynamically stitch chart into a list at different level
How to add a conditional summary filter
How to dynamically resize a chart
How to avoid duplicated entries in Table of Contents
How to make query reusable (how to reduce the number of queries)
How to use prompt token macro to make report more interactive and user friendly
How to make whole report (or dashboard) appear on the same page
How to display a customized time ruler using line chart
How to place data item anywhere you want with background effect
How to creating highly interactive Reports with jQuery
How to allow user to add comments using stored procedure
How to document, comment and organize query for a complicated report
How to display different images and styles without using variables
How to control font size in chart formatting for consistence between graph and text
How to keep PDF size of list or crosstab not be impacted by chart on same page
How to keep scale dynamic and consistent between chart and List
How to make conditional Table of Contents Entry
How to make conditional Table of Contents Entry with multiple Table of Contents
How to make use of Cognos summary function in relational mode
How to avoid a few "common errors" that are difficult to be identified in Cognos report authoring
How to use query item from another query without using join in relational mode (re# Cognos release 10.2.2. with Filter Join Optimization)
How to show top N values and others in a chart
How to understand Cognos Summary functions - Compare FOR option in relational package, TUPLE function for dimensional package and OVER option for database
How to use summary filter and AT clause to develop rolling average report much more efficient
How to make conditional indicator in crosstab node member area
How to compare Chart with Crosstab
How to export crosstab into user friendly Excel
How to embed cascade prompt in report without refresh page
How to achieve dynamic operator using Cognos Macros in report studio
How to handle single report based on two cubes with shared prompts and combined data
How to handle date related relational and dimensional functions  (Relational, Dimensional, Oracle and SQL server)
How to create optional slicers
How to handle "All Others" in dimensional reporting
How to create customized date dimension properties to speed up report development (DMR)
How to author Cognos complicated crosstab with multiple measures and different calculation based on DMR

Framework Manager
How to dynamically change schema name in Framework Manager
How to make prompt optional with default value in Cognos Framework manager
How to handle “dynamic fact table” using #prompt in framework manger
How to use “Alias Shortcut” for role playing dimensions in Framework Manager
How to build a business user friendly framework manager package for query studio
How to handle bridge table in framework manager (for unbalanced hierarchy and multi-valued dimensions) (re# Cognos release 10.2.2 with Bridge Query Subjects)
How to avoid problems with parameter maps
How to make relative period without using relative function
How to build a business user friendly framework manager package for query studio – options
How to handle Cognos data security multiple user groups based on sales alignment
How to make Cognos connection dynamic based on selected environment
How does suppression work with DMR on CQM or DQM
How to model a effective date dimension in DMR with alias shortcut
how to model dimensions with cognos DMR in real life
How to develop light weighted ETL using Cognos Framework Manager
How to extract Datawarehouse Bus Matrix from Cognos Framework Manager Model

Administration
How to make global filter work with multi pages
How to synchronize Drill up and Down of multiple Objects in the Page (DMR)
How to make multi-page dashboard with global filters and synchronized drill up and down
How to eliminate unused space in portal page
How to build dynamic dashboard with burst reports for multiple purposes
How to make prompt page run on portal pages same as in report studio
How to develop interactive reports (portal page) based on report view
How to implement row level security in framework manager (all options)
How to create a personalized and powerful experience with portal pages
How to find impacted reports and data lineage
How to avoid breaking report link for drill through, portal page and scheduled job when changing report
How to use Cognos trigger (windows based)
How to use the same security dimension table to allow users to access their own data and their manager’s data
How to resolve to the Cognos Go! Office connection issue
How to setup the default email sender in Cognos server
How to embed a Cognos report in an email message body
How to migrate reports into different directory with different package name

Transformer/Dynamic Cube
How to design transformer Cube with Inventory management
How to copy and paste shared dimensions for IBM cubing services
How to handle degenerate dimension in IBM Cubing services
How to define a semi-additive MDX measure in cubing services (conditional distinct and then average based on date dimension)
How to determine level keys for a hierarchy in Cubing services
How to take advantage of Cognos Transformer custom view

Scorecards
How to handle different metric types with same name
How to remove data of invalid qualifiers in metric studio
How to generate Year to Date (YTD) data for scorecard using SQL statement – an practical approach
How to prepare fact data for metrics in Cognos scorecarding (Design approach)
How to create data for all periods in scorecard including most recent period, YTD, Quarter and Annual
How to resolve report issue based on metrics package from version 10.1.0 to version 10.1.1

Dimensional Modeling
How to handle inferred member for “Late Arriving Dimension”
How to handle slowly changing dimension type 2 (SCD 2) – a practical approach for big data
How to use create dynamic schedule for a ETL job
How to run SQL server stored procedure remotely to control ETL job
How to pass variable from child package to parent package using SSIS or vice versa
How to transform a single concatenated string into individual rows and vice versa
How to make percent label for 100% stacked bar or area chart (SSRS)
How to align Table with Chart in report (SSRS and Cognos)
How to customize label for pie chart (SSRS)
How to make color consistency across whole report (SSRS)
How to handle parameters specified by end user for SSRS reporting
How to highlight a chart area to show guideline (SSRS)
How to develop multilingual SSRS reports (Static)
How to develop multilingual SSRS reports (Dynamic)
How to generate SSRS distribution chart
How to use SSRS strip line to highlight chart data and draw vertical target line
How to quickly validate data and apply case statement by using SSIS expression
How to make SSRS report configurable based on individual customer requirement
How to make SSRS spider chart with clear color range

OpenPages
How to Report against OpenPages Business Entities (hierarchical data modeling)
What is RDL (Report Definition Language) in OpenPages
How to aggregate loss in case when single loss associates with two business entities in OpenPages
How to understand object type relationship in OpenPages
How to understand an association on report in IBM OpenPages
How to load large fastmap file into OpenPages
How to model OpenPages Reporting Framework with one single namespace only
How to define OpenPages security with AURA
How to avoid problem with currency data load in IBM OpenPages
How to enable custom report by business users
How to create different filters (Home Page Filtered List, Public Filter, Private filter)

Others
MDX Based Investment Analytics Engine
End user oriented information system based on open system architecture using algorithms, rules and fuzzy logic





No comments:

Post a Comment