New IBM Cognos TM1 Video published on YouTube
Kirk Wiseman, VP of Training for PerformanceG2
I just uploaded a new video on YouTube which examines the issues of managing Slowly Changing Dimension in TM1.
As we know, data that we want to keep track of within a TM1 dimension can change over time. For example, sales reps become responsible for different geographies; Products are rebranded or reformulated and so on. These types of slow changes are appropriately named Slowly Changing Dimensions or SCD’s.
There are several types of SCD’s but the two most common are Type 1′s (we don’t care about history) and Type 2′s (we care about and wish to track historical changes). An example of a Type 1 change would be if a product, say tents, rolled up to a product type of camping equipment, however a change was made to consolidate tents into the product type of Outdoors equipment. In this case, we want to see all data, including history, roll-up to the new product type of outdoors equipment.
On the other-hand a type 2 change would be if we wanted to see the historical data for tents roll-up into Camping equipment and any new data for tents to rollup to Outdoor Equipment. This can be useful for trending analysis, etc.
To watch this example applied to TM1 — check out the video on YouTube:
http://www.youtube.com/watch?v=KD3QwRHPZ38
For more information on how PerformanceG2 can assist you in your TM1 needs, click here.
May 11th, 2010 at 8:29 pm
Nice post! Here’s one for ya… In a hierarchical organization, the higher the level, the greater the confusion.
May 24th, 2010 at 3:35 pm
People said IBM was dead a while ago but from what I can see now, they are going nowhere but up
September 19th, 2010 at 4:43 am
Great post. Are you kowing a websites where is possbile to download youtube clips?
September 20th, 2010 at 9:53 am
I am not sure of any Web site where you can download the videos, but I do know that you if you search for Cognos in YouTube, you will see a lot of videos related to Cognos and BI. Hope that helps.