TM1 Forum

Sorry for not following the rules. I will attempt to comply from now on. And the second, which I consider to be the more likely of the two, is that your data source is actually returning both the new and old hierarchies, and the TI Process is therefore recreating them each time you run it. I have al...

I think I am confused about what actually is happening when I recreate a dimension (Action: Recreate under the Dimensions tab in TI). I assumed that the entire dimension is being recreated from the ground up. In other words, the elements (and consolidations) are deleted and the entire hierarchy is r...

I also have days consolidated into Months. So, really what I am trying to do I guess is to find today's date and translate it into format yyyymm (for Current Month & Previous Month). So, in essence, all I want is to translate today's date into the current and previous month in yyyymm format. My ...

Thanks declanr, I will give this a shot. I am using the viewzeroout function. Essentially this was my simple code for zeroing out a day with the day hard coded in: sCube='Margin_Cube'; sObjName='sys_' | getprocessname(); if(viewexists(sCube, sObjName)=1); viewdestroy(sCube, sObjName); endif; ViewCre...

I want to zero out the current and previous month's data from a cube on a nightly basis before I load it again. The leaf level date is in string format, i.e., '2013-01-01'. I have the code for zeroing out data properly but am having difficulty figuring out how to zero out the current and previous mo...

I have the same question. I have created a dimension that is currently being used in a cube. But I do not see that dimension in the {HierarchyProperties control cube to name the levels. I have tried EVERYTHING I can think of, and the dimension still is not visible in the control cube. Thanks in adva...