Search found 128 matches

by Analytics123
Sat Jun 10, 2017 2:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assigning string value in a rule
Replies: 8
Views: 5080

Re: Assigning string value in a rule

Yes feederstrings;
Skipcheck;
and feeders:
by Analytics123
Fri Jun 09, 2017 9:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assigning string value in a rule
Replies: 8
Views: 5080

Re: Assigning string value in a rule

Yeah that works now !! But when a zero supression is done all values for that string measure disappears to No Values .

I tried giving FEEDSTRINGS; at the top of the rule , but that doesnt fix the issue .

Any help to overcome this is appreciated .

Thanks,
by Analytics123
Fri Jun 09, 2017 6:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Assigning string value in a rule
Replies: 8
Views: 5080

Assigning string value in a rule

Hi I have certain calculations on measures and a I have a measure called total points that is calculated in a rule .Now based on the value of this calculated Measure called total points I need to assign letter grades . Say if total points is >75 then "B" etc.. Is it possible to set values ...
by Analytics123
Thu Jun 08, 2017 12:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule to exclude consolidation element values for a measure that is related to only lower level element in a hierarchy
Replies: 3
Views: 3131

Re: Rule to exclude consolidation element values for a measure that is related to only lower level element in a hierarch

okay , I used this and it looks okay now , not sure if I need to use any other checks here .

['Days Since Payment' ] = IF ( ELLEV('Customers SoldTo Only', !Customers SoldTo Only) <> 0,0,Continue );

Thanks for your help .
by Analytics123
Wed Jun 07, 2017 9:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule to exclude consolidation element values for a measure that is related to only lower level element in a hierarchy
Replies: 3
Views: 3131

Rule to exclude consolidation element values for a measure that is related to only lower level element in a hierarchy

Hi All, I got stuck at this point and not sure if there is any way possible to achieve this . I have a customer dimension with a hierarchy Region, Agency, Reps and Customer . And the other dimension in cube are currency , months and Gl Account. Now I am having a measure loaded to the cube via a TI P...
by Analytics123
Tue Jun 06, 2017 3:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Complex Rule
Replies: 2
Views: 2093

Tm1 Complex Rule

Hi , I have a Account Receivable cube (AR Cube)which has customers and balances by month . I also have a sales cube which has customers with sales data by months . I need to calculate the last 3 month sales and last 6 month sales in AR cube using a rule from sales cube based on the value selected fr...
by Analytics123
Tue May 23, 2017 8:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Data folder backup
Replies: 9
Views: 6604

Re: Server Data folder backup

No the file copying starts immediately the process runs . I am able to see file size being increased . I dont think so savedata all is causing an issue .

However i can try doing the same bu directly not copying live folder , but taking a back up and then see if its the same .

Thanks,
by Analytics123
Tue May 23, 2017 1:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Data folder backup
Replies: 9
Views: 6604

Server Data folder backup

Hi All, I am using the below code to create a data folder back up . My data folder size is 25 gb. SaveDataAll(); sExec = 'C:\Program Files\7-Zip\7z.exe'; sBackupDir = 'D:\Backups\Data\Backups\'; sDataDir = 'D:\Data\'; sFileName = 'Data ' | TIMST(NOW(), '\Y\m\d \h.\i', 1) | '.zip'; sArgs = ' a -tzip ...