Search found 26 matches

by srp313
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: 2889

Re: TM1 Rules - Request your guidance please!

I would greatly appreciate on any kind pointers to start with.
by srp313
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: 2889

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...
by srp313
Thu Jul 05, 2018 5:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Transfer TI Process
Replies: 13
Views: 7073

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...
by srp313
Thu Jul 05, 2018 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Transfer TI Process
Replies: 13
Views: 7073

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...
by srp313
Thu Jul 05, 2018 7:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Transfer TI Process
Replies: 13
Views: 7073

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...
by srp313
Thu Jul 05, 2018 6:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Transfer TI Process
Replies: 13
Views: 7073

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...
by srp313
Wed Jul 04, 2018 5:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Transfer TI Process
Replies: 13
Views: 7073

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...
by srp313
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: 7326

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...
by srp313
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: 7326

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 ) ) );...
by srp313
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: 7326

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.
by srp313
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: 7326

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
by srp313
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: 7326

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...
by srp313
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: 7326

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.
by srp313
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: 7326

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...
by srp313
Sat May 12, 2018 1:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Copy TI Process
Replies: 9
Views: 5307

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.
by srp313
Thu May 03, 2018 9:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Copy TI Process
Replies: 9
Views: 5307

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...
by srp313
Wed May 02, 2018 12:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Copy TI Process
Replies: 9
Views: 5307

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...
by srp313
Wed May 02, 2018 11:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Copy TI Process
Replies: 9
Views: 5307

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...
by srp313
Wed May 02, 2018 8:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Copy TI Process
Replies: 9
Views: 5307

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...
by srp313
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: 6816

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...