Tag Archive for: Dimensional Reporting

,

Ironside Tech Tip: Leveraging Time and Aggregate Functions in Dimensional Reporting to Create Low Maintenance Cognos Reports

/by

Over the years I have successfully used the ancestor(), parallelPeriods(), periodToDate(), aggregate(), and set() dimensional functions to develop robust and durable dimensional reporting solutions in IBM Cognos BI.

I had the opportunity to go to lunch the other day with one of my clients from a few years ago and they told me that the profit and loss reports that I wrote for them were still in use. These reports used no year or month members (directly) and required little if any maintenance over the last two years, despite daily refreshes of the source PowerCube. Read more

,

Ironside Tech Tip: Change Transformer File and Server Locations Using an MDL Script

/by

When creating multidimensional models with IBM Cognos Transformer, many different types of data sources can be utilized such as reports, packages, Excel, and comma delimited files to design the model. Also various work environments may be used such as TEST, DEV, and PROD all of which have different server locations. Read more