TM1 Forum

PavoGa, If you refer to my previous post, it would give you an idea of what I did last time and I have replicated the situation, the only thing I am doing this time round is instead of taking the easy way out and doing whats already been a success the TI way, I want to do something different which i...

Hey. For this, I would personally create a view, do my variables, in prolog, specify the cube, and the dimensions and asciioutput the data into a txt. Only to check what data is actually coming out. If the txt is generated, then you know your data is fine and you can use that file to create a new ti...

Hello all. I was suppose to relax and watch football but instead thinking about intersections that are not fed. So I have two cubes, one which is the data cube, second which is analysis cube. Previously I had used a TI that allowed me to input numeric values against any periods that were between sta...

Hello Declan

Thank you for that advise. It was very useful and was able to adapt to the advise that was given on this thread by all members that contributed. Much appreciated.

Regards
Mithun

Hello Thank you so much for all your help guys. I have learnt alot technically and I have received so much support from you all. Jules, thank you so much for coming onto the forum on my request, I appeciate all the help you've given me. I have done both solutions and they both work. Again, thank you...

Hello Wim The format is the same - both strings and Month Period nodes. Cube 1 - dim1 - UniqueID dim2 - Place dim3 - Type dim4 - unit dim5 - model dim6- Measure Dim7 - Details ( 2 elements, startdate (Intersection: Jan-15), finishdate (intersection: Dec-34)) Cube 2 - dim1 - UniqueID dim2 - Place dim...

Hello Wim Apologies for that. I will ensure that I dont do that again :) In regards to your response to the problem, thank you for the suggestion. I thought of doing a while loop, the only thing that discouraged mewas the following details: My script is: #vstartdate=cellgets(); #vfinishdate=cellgets...

Hello I have been able to post 1 against two dates, Jan-15, Dec-34 via ti, but how do I put 1 against any dates between Jan-15 and dec-34 as they are strings, and im sure you cant do <= and => between strings. Can anyone offer any advise to what I could do to get round this issue? Thanks in advanced...

Hello After doing some testing on a different environment, I have seen that disconnecting the simple nodes from the consolidation node will allow the consolidation node to naturally become a simple node. This would mean, when you update web app, it will not confuse the security and will update the h...

Hello All I have now been able to resolve this issue. The solution is to look at the following files: - <Cognos TM1 Application Server Install>\webapps\pmpsvc\WEB-INF\configuration\fpmsvc_config.xml - <Cognos BI Gateway Install Dir>\webcontent\planning.html - <Cognos BI Gateway Install Dir>\webconte...

@BariAbdul So MyVariable is a dimension name but also the variable name which is an element type in the TI. It is full of unique ID's for individual records. In the excel sheet, I have 1-1000 records with ID 1-1000 BUt also has records that dont have ID's which due to no ID match, my TI will always ...

Hello Paul Yes it is. just so you have more information, il give you a brief of what I want to achieve. I have 4 element type and lots of data type being fed in from an excel sheet. I have MyVariable which is the dimension that has unique id per invidivial record. Bui some records dont have a unique...

Hello Not sure if I am missing a trick here because I thought I did this correctly; I am trying to skip load of data that is against a non existing element in excel when I try to import the data into a cube. This is the code I am using. If (MyVariable @=''); ItemSkip; EndIf; This is not working for ...

Hello @elessar

The ti is fine, there are no errors and I cant take ownership and that is the issue. But I think I know what happens and how I naturally get round it, but I need to test that, once I have solved my contributor issue I am having.

Hello I am having the same issue now and I have tried the same solution but it hasnt worked for me. For me, everytime I put credentials in, it doesnt work. Again, the password is the same as its S-S'on. I can open up the models, just cant get to my Contributor models because I just cant pass the AD ...

hELLO 1. It's 10.2.1 2. All the rights for that node have been aligned to another simple node that works. write in relevant groups and read in other groups. See, I looked into the tp_tasks cube and the dimensions it uses and the shadow dimension reflected the changes I made which is why it took me b...

Hello In one of the dimensions I have, I had a consolidation with 2 simple nodes. I have deleted those 2 simple nodes and turned the consolidated node into a simple node. All my export and import data TI's worked well, the dimension and the security cubes showed the change, the subset that was used ...

Hello friends I am running out of idea's on a issue. Basically, we want to control when and who is creating views/attributes in a cube. If there are one or two developers, its fine but when we have many users having tm1, we will lose control. Can anyone advise how we can control that? Maybe not with...

Hello BrianL The 25 hours was actually the time I scheduled for the shutdown. It wasnt the chore that was running 25 hrs.. although a chore was active when the shutdown was due to happen. Now I was thinking, if a shutdown had to take place, it would stop the process and shut down peacefully. or shut...

hello BariAbdul The stop service command tries to shut the TM1 service down in an orderly manner. However I believe that the stop service command has a time out and does not wait until the shutdown is complete. This could have been the case as the time I had it to wait before shutdown was 25 hours b...