Category: CubewiseSource

  • We old-schoolers need to revisit the language we use to talk about dimension structures

    Back Then … In the TM1 world, many people have for many years been used to saying “hierarchies” when referring to hierarchical dimension structures e.g. Ancestor > direct children (consolidated) > intermediate consolidations > ultimate leaf descendants When TM1 was just TM1 and dimensions didn’t have named hierarchies this was OK as it was still…

  • Cloud versus On-Premise Deployment

    Which solution suits us best? Reviewing your Software environment can result in many questions. Which is the best option? How would it change the way we manage our systems? Can the cloud environment be managed by an internal IT team? Both environments have benefits, therefore the best question to find an answer to is “Which…

  • Attributes in TM1. More things to be aware of

    We all know that attributes are a very useful feature of TM1 with many uses for lookups in modeling as well as providing context for reporting. In a recent post, we talked about the Caption attribute as a potential default attribute for all dimensions and how the attribute is linked to the intrinsic MEMBER_CAPTION MDX…

  • Using hierarchies for PickLists

    PickLists, a quick recap. As we know PickLists in Planning Analytics can be defined in 3 ways: as static lists using the form static::item1:item2:item3 based on dimensions using the form dimension:dimName based on subsets using the form subset:dimName:subName PickLists can be defined either via naming a dimension attribute “PickList” and defining a string value for…

  • The (increased) importance of attributes in Planning Analytics

    The importance of attributes in PA Attributes have always been very useful when developing a TM1 model but until now have never been an essential component of development. With Planning Analytics this changes. This is a forgotten or little known point that all TM1 developers should be aware of and is relevant for anyone with…

  • Upgrade from TM1 10.x to Planning Analytics

    Upgrade TM1 to Planning Analytics Planning Analytics (PA) is the next step to provide a complete planning solution on the powerful, multi-dimensional technology of TM1. With PA available in the cloud and on-premise, including various new front ends – the upgrade could seem daunting. Make use of the above roadmap to find the most suitable…

  • What is the Cubewise EDU TM1 and Planning Analytics Developer Credential?

    With growing interest, I keep getting asked: “what exactly is the ‘Cubewise EDU TM1 and Planning Analytics Developer Credential’”? The Credential was developed in partnership with DeakinCo. and is another initiative in Cubewise’s ongoing contribution to the ideals of #DoGoodTM1. At Cubewise, we had a growing list of TM1 and Planning Analytics customers that were…

  • Let’s talk about element and attribute naming

    This article isn’t about naming conventions. My opinion on naming conventions is that they are necessary both for end-users and developers to assist in making a system understandable and navigable. But I don’t have an opinion on what the best naming convention is other than it doesn’t exist. Whether a naming convention uses spaces, underscores,…

  • Moving from TM1 to Planning Analytics is NOT complicated

    First of all, Planning Analytics is just a new name for TM1. Over the last few months, a number of customers have started planning the upgrade to Planning Analytics Local. There seems to be the perception that this process is more complicated than any other upgrade done before with TM1. In this article, I try to…