TM1 Forum

Hi Wims, Thanks for your response. Yes i did test the same SQL Query in the relational database but that was at the initial stage and it returned the expected number of records. I can still see my records in the preview. I set the SQL Query in my Prolog Tab after but at the bottom after defineing my...

Hi Everyone, I have just built a REPORT ONLY cube and used Advanced Scripting to write the data load T1 for this cube. I have successfully saved the TI but when i run it, it gives an error : Error: Data procedure line (0): Error executing SQL query: "select pos.position_id as salary_position, e...

Thanks for the pointers guys.Checked it out myself by creating a private subset and then right clicked on that particular private subset and chose 'delete' and issue was resolved.Went ahead to convey the same steps mentioned to my user.Still awaiting a response but believe that the steps mentioned w...

Hi everyone, I am getting this message "Error: Data procedure line (52): Rule applies to cell" for some of my users in my salary cube.I ran an update to staging TI for my employee and active positions,then ran a TI process to Dim_create salary position and employee.After the successful run...

Thanks Steve for the reply,could you please elaborate the steps the user needs to follow to do the delete?
Thanks.
Segun

Hi everybody,
I would appreciate it if anyone could show me the steps to use in deleting a 'private subset' in tm1.I have gone through the TM1 online documents and all it shows are the functions to call but not the steps on how to go about doing the delete.Pointers anyone?
Thanks
Segun

Thank you guys for all your advice and help so far.I still haven't resolved the issue though.More pointers to the resolution of this problem, will be highly appreciated.Thanks.

A user of mine is getting this meassage after accessing TM1 web when she clicks on any of the INPUT MENU'S on it.What may be the problem?
'Fail to navigate to target websheet'.
Thanks.

Hi everybody, I recently added a new element to a dimension that appears in three different look up cubes.The new element appeared in the look up cubes as desired.I then added new values into the new element in only one of the look up cubes. After saving and closing,i noticed that a new }Hold_Userna...

FEEDERS; ['Actual'] => ['Scenario':'Q2 Projection'],['Scenario':'Q4 Projection']; ['Currency'] => ['CAD Consolidated']; ['Scenario':'Budget', 'Final Version', 'Amount' ] => ['Scenario':'Q2 Projection', 'Non_Final_Version', 'Amount']; ['Scenario':'Budget', 'Final Version', 'Amount' ] => ['Scenario':'...

Thanks lotsaram,your reply is highly appreciated.Could you please write out the rule for me please?From reply,i will have to create a cube(must it be a control cube?)with 2 dimensions being the version dimension and which other one?I am relatively very new to TM1 hence i need all the help i can get....

How can i allow my expense cube to show actuals from nov to feb and show budget data values from march to october for our second quarter projection?Presently,the cube is showing the actuals data values for nov to feb.I want it to show the actuals values from nov to feb and show budget values from ma...

web.