Search found 26 matches
- Tue Oct 30, 2018 6:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Rules - Request your guidance please!
- Replies: 4
- Views: 2913
Re: TM1 Rules - Request your guidance please!
I would greatly appreciate on any kind pointers to start with.
- Fri Oct 26, 2018 4:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Rules - Request your guidance please!
- Replies: 4
- Views: 2913
TM1 Rules - Request your guidance please!
Hi Forum members, Requesting your valuable guidance as i am not skilled enough. We have a cube named EMS_Employee Salary_HC_FTE cube . This cube is a rule driven cube for multiple scenarios. Requirement was to add a new " Job Level " dimension to the existing cube. Here Job Level denotes t...
- Thu Jul 05, 2018 5:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Transfer TI Process
- Replies: 13
- Views: 7164
Re: Cube Transfer TI Process
Hello Wim, 1. Yes, I am trying to write a ZeroOut code and most of the Prolog has been taken from exsiting TI process. Infact almost all the exsting TI processes are using Bedrock processes and i am trying to use the same since i do not have a deep understanding now being new. 2. Thanks for pointing...
- Thu Jul 05, 2018 3:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Transfer TI Process
- Replies: 13
- Views: 7164
Re: Cube Transfer TI Process
Thanks Wim and Orlando. Please take a look into the below code to what i have written. DataSource is ExpenseReporting cube. Variables are vScenario, vVersion, vYear, vProjects, vCurrency, vDivision, vBusinessUnits, vExpenseAccounts, vMonth, Value . Parameters are pScenario, pYear,pVersion, pDivision...
- Thu Jul 05, 2018 7:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Transfer TI Process
- Replies: 13
- Views: 7164
Re: Cube Transfer TI Process
Thanks much orlando for replying!You do not know how much i appreciate it. You could create an alias or attribute in your month dimension eg. "month_no" Jan = 01 Feb = 02 Then vYM = vYear | '-' | ATTRSL('Month', 'Jan', 'month_no'); I understood the above but here, i have a Snapshot dimensi...
- Thu Jul 05, 2018 6:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Transfer TI Process
- Replies: 13
- Views: 7164
Re: Cube Transfer TI Process
Hi Wim, Thanks so much for replying. I understood what the pseudocode is implying but the problem is Month dimension i.e. vMonth variable coming from source cube contains data in form of Jan, Feb, Mar and so on and not in form of 01, 02 , 03 ... What to do in this case ? (P.S. I have already created...
- Wed Jul 04, 2018 5:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Transfer TI Process
- Replies: 13
- Views: 7164
Cube Transfer TI Process
Hi Members, I request your guidance for my below problem: I have to create a Cube transfer TI process which has to copy the data from Source cube : ExpRep to Destination cube: ExpRepForecast . Now the problem is both the cubes contain same set of dimensions except Source Cube contains Year and Month...
- Tue May 22, 2018 10:12 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Transfer data within cubes for a particular month and future set of months in a year
- Replies: 12
- Views: 7886
Re: Transfer data within cubes for a particular month and future set of months in a year
Thanks Edward and lotsaram for replying. Sorry i was a bit unwell and was unable to see your updates. I will work on what you folks have suggested and will get back with the results. @lotsaram, actually there are some very old Ti processes present in the application which were and are still using Be...
- Fri May 18, 2018 3:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Transfer data within cubes for a particular month and future set of months in a year
- Replies: 12
- Views: 7886
Re: Transfer data within cubes for a particular month and future set of months in a year
Thanks for replying Edward! 1. In line 148 of the process B edrock.Cube.Data.ZeroOut which is erroring out, following code(commented line #148) is present: sDimension = Trim( SubSt( sArgument, 1, nDelimElemIndex - 1 ) ); sElements = Trim( SubSt( sArgument, nDelimElemIndex + 1, Long( sArgument ) ) );...
- Wed May 16, 2018 10:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Transfer data within cubes for a particular month and future set of months in a year
- Replies: 12
- Views: 7886
Re: Transfer data within cubes for a particular month and future set of months in a year
Hi Wim,
I very well understand that and I am very sorry if my post was taken wrongly. I cannot be thankful enough to this forum members who are much helpful with their time and knowledge to other members.
I very well understand that and I am very sorry if my post was taken wrongly. I cannot be thankful enough to this forum members who are much helpful with their time and knowledge to other members.
- Wed May 16, 2018 4:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Transfer data within cubes for a particular month and future set of months in a year
- Replies: 12
- Views: 7886
Re: Transfer data within cubes for a particular month and future set of months in a year
Hi friends,
I would greatly appreciate any and all pointers/suggestions.
Thanks,
srp
I would greatly appreciate any and all pointers/suggestions.
Thanks,
srp
- Tue May 15, 2018 1:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Transfer data within cubes for a particular month and future set of months in a year
- Replies: 12
- Views: 7886
Re: Transfer data within cubes for a particular month and future set of months in a year
Hi Wim and other members, I have an update after trying working on this and i request your guidance . Please see below the details: I have modified the exsiting TI process pCTSalaryToExpensePlan Prolog and Data tab as mentioned below: Prolog Tab Code Change #vDimName = 'Month'; # ExecuteProcess('Bed...
- Mon May 14, 2018 11:26 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Transfer data within cubes for a particular month and future set of months in a year
- Replies: 12
- Views: 7886
Re: Transfer data within cubes for a particular month and future set of months in a year
Thanks Wim for the valuable suggestions. I am trying to work on them although i am finding it very difficult to proceed with the code.
- Sat May 12, 2018 2:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Transfer data within cubes for a particular month and future set of months in a year
- Replies: 12
- Views: 7886
Transfer data within cubes for a particular month and future set of months in a year
Hi all, I have 2 cubes where business wants to transfer the data from 1st cube( Salarycube ) to 2nd cube( ExpensePlan cube) for a particular Month (user passed parameter) and its further future months in a particular year (user passed parameter). Application has an existing TI process pCTSalaryToExp...
- Sat May 12, 2018 1:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Copy TI Process
- Replies: 9
- Views: 5375
Re: Cube Copy TI Process
Thank you so much Tom and Wim for your pointers. I am now trying to find out more ways to learn mdx.
- Thu May 03, 2018 9:53 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Copy TI Process
- Replies: 9
- Views: 5375
Re: Cube Copy TI Process
Thanks macsir for replying! I understood what you have mentioned - could you please let me know more on why we need to suppress zeroes and skip consolidations as you have mentioned. On top of this, I have a new requirement where business has asked to modify this TI Process to implement the copying o...
- Wed May 02, 2018 12:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Copy TI Process
- Replies: 9
- Views: 5375
Re: Cube Copy TI Process
I am so sorry Tom for the mistake. In a hurry to implement it, i missed out uncommenting the Year Code. Thanks much for pointing it out! Now the values are being copied correctly for an individual month :) - one more question to you please Tom? Assuming a requirement is to copy data for a particular...
- Wed May 02, 2018 11:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Copy TI Process
- Replies: 9
- Views: 5375
Re: Cube Copy TI Process
Thanks so much @tomok for replying! i. I have created 2 new parameters pSourceMonth and pTargetMonth. ii. Under Prolog, since it is copying data within the same cube, i have added the below code (Code for Year subset was existing and i have added the Month Subset as mentioned below) #------------BEG...
- Wed May 02, 2018 8:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Copy TI Process
- Replies: 9
- Views: 5375
Cube Copy TI Process
Hi friends, I am still fairly new to TM1 and am requesting your earnest guidance in solving the below problem of mine. I have a Cube upon which there is a TI Process defined for copying data within the cube for the whole year based on the Scenario, Version and Division selected by the user (from a s...
- Tue Dec 12, 2017 6:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
- Replies: 10
- Views: 7075
Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!
Thanks gtonkin and STeve for the replies! @gtonkin - its a wonderful suggestion you have given me and i got the meaning of it. I am definitely implementing them from now on. @Steve - I have now deleted very action button and have created all of them again. This has solved the problem for the time be...