Tag Archives: Training

TM1 Tutorials Consultation – Ben Hill

When I started this site as a freelancer I was happy to cater to the need for non biased technical resources which solve real world problems. Back in Jul 2012 I joined InfoCube Consulting (Australia) as Director and Principal Consultant with the intention of creating something bigger than myself. I’m happy to say that now we are a team of over 10 expert consultants and we are growing quickly. So… … Continue Reading

This entry was posted in Cognos Express, IBM Cognos TM1, TM1 10.1, TM1 10.2, Training Material and tagged Consulting, IBM Cognos TM1, Training. Bookmark the permalink. | Tagged Consulting, IBM Cognos TM1, Training | 1 Comment

Neglected Functionality – Custom Rollups & Subset Consolidations

In this blog segment, we’ll look at value add features of the IBM Business Analytics software which are often overlooked and underused. In this article I’m going to explain Custom Rollups and Subset Consolidations within IBM Cognos TM1. Custom rollups are used to create a temporary user-defined consolidation element. It is a very useful, but somewhat underused functionality. With custom rollups, you won’t be able to save the subset but … Continue Reading

This entry was posted in Cognos Express, Cognos Insight, IBM Cognos TM1, TM1 10.1, TM1 pre 10.1, Training Material and tagged Cube View, Cube Viewer, Custom Rollup, IBM Cognos Express, IBM Cognos TM1, Subset Editor, Tips and Tricks, Training. Bookmark the permalink. | Tagged Cube View, Cube Viewer, Custom Rollup, IBM Cognos Express, IBM Cognos TM1, Subset Editor, Tips and Tricks, Training | 3 Comments

Exercise: TM1 Sales Cube Challenge

Design and build a cube to report on Sales based on the given file. Exercise Sales Data: Sales Sample Data.xls The solution design must cater for the following objectives: Enables reporting of Units Sold, Gross and Net Sales Revenue, Cost of Goods Sold and Gross Margin as a Percentage of Gross Sales. Enables reporting by Month, Country, Continent, Product, Brand and Sales Channel. (Day is Optional) Descriptive Aliases should be added to … Continue Reading

This entry was posted in IBM Cognos TM1, Training Material and tagged IBM Cognos TM1, TM1 Consulting, TM1 Sales, TM1 Training, Training. Bookmark the permalink. | Tagged IBM Cognos TM1, TM1 Consulting, TM1 Sales, TM1 Training, Training | Leave a comment