TM1 Forum

Thanks Edward. That did it. The adjusted code is below. Prolog #****Begin: Generated Statements*** #****End: Generated Statements**** DIMENSIONDESTROY('unbalanced'); DIMENSIONCREATE('unbalanced'); DIMENSIONSORTORDER('unbalanced','ByInput','ASCENDING','ByHierarchy ','ASCENDING');'' Metadata #****Begi...

Thanks again Alan for the response. I really appreciate you taking time to explain and help. I believe I get it. While both you and Matt warned against thinking of it in similar terms as relational databases, what finally made it click for me was the comparison between Fields in a Table and Elements...

I've fully gone through and tested the script in the documentation. After going through it several times. It's not working as expected. It's creating the hierarchy well enough, but a lot of the elements and parents show up more than once. For example: G1 --Total ----North ------TK1 --------G1 ------...

Thanks everyone. I'll give it a shot.

I'm a TM1 newbie and just coming off the heels of another post where I was experiencing an "cell type is string" error (see link below) related to how I defined the Element Types for each Element in my Dimension . Since that post it dawned on me that I may not be understanding what an Elem...

Thank you lotsaram, Wim, and gtonkin. After piecing it all together, I think I get it. And... the problem has been fixed! The problem and associated fix was staring in my face (as lotsaram mentioned and Alan tried to explain) which was to change the "Element Type" to "Numeric" in...

I went through the post and reached the documentation. Thank you for that. Are you saying the only way to create this type of hierarchy is to do it through code on the Advanced tab? In other words, TM1 Architect cannot naturally handle it by, for example, method of importing/loading data and through...

I've re-read both of your replies a few times and believe I understand the concept of "Measures" in TM1. I also understand that trying to place in a numeric value in a string cell type in TM1 will generate an error. However, I still don't understand why/how I'm getting an error in my desig...

I've seen some resources on how to do this in Performance Modeler, but need to know how to do this in TM1 Architect using an ODBC database source (e.g. not using manual editing or cut/copy and pates). Can someone direct me to how to do this? Simple database source example. Either using Parent-Child ...

First thanks for taking the time to respond. Much appreciated! And, great info. You are correct. I only have 5 dimensions: Version, Year, Period, Center, Account. I don’t have any other dimensions or measures defined (I couldn't figure out how to create or define a measure - see more about that belo...

Just started learning and am creating my first cube. When running my TI process to create the cube I'm getting a "Cell type is string" error on every row from by data source. I'm not sure what you will need to help, so forgive me if this is long. My data source is from a SQL Server ODBC co...