Search found 58 matches

by manu0521
Tue Nov 19, 2019 9:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count distinct rows
Replies: 2
Views: 298

Count distinct rows

Hi , I have a transaction file that i load in ti , user is asking for a requirement to count the number of distinct invoices by customer and report as a measure. I have done this by loading in sql and then doing a distint count by invoice for each customer and then loaded that to tm1. But is there a...
by manu0521
Fri Oct 11, 2019 1:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data is not getting updated on cubes and logs looks fine
Replies: 1
Views: 1780

Re: Data is not getting updated on cubes and logs looks fine

this was fixed. sorry my bad . the load files were not getting updated at the right time .
by manu0521
Fri Oct 11, 2019 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data is not getting updated on cubes and logs looks fine
Replies: 1
Views: 1780

Data is not getting updated on cubes and logs looks fine

Hi , We are having a weird issue were our data is not getting updated on the cubes when it is run through scheduled chores . If we come manually and run the chores the data is getting updated. Looking at the logs on scheduled chores everything looks like it was loaded on the right time, We are in pl...
by manu0521
Wed Oct 02, 2019 9:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: check if a parameter value is numeric
Replies: 2
Views: 1620

check if a parameter value is numeric

Pass a cell value from excel to tm1 ti process.

User can enter any value and submit an action button , in ti ,I have to check if the passed value is numeric .

Is there a function in tm1 which can check if the parameter value is numeric.

Thanks,
by manu0521
Wed Sep 18, 2019 7:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passing values from excel to TI
Replies: 3
Views: 499

Re: Passing values from excel to TI

I did change the format as text and it would work ,but then the data validation on excel sheet would not work . So then i have to do a validation on to see if its a date in excel from a text column .
by manu0521
Wed Sep 18, 2019 3:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passing values from excel to TI
Replies: 3
Views: 499

Passing values from excel to TI

Hi , I am having an excel where dates are filled and passed to a TI using the action button . Data validation is done on excel and requires a date to be entered. So I enter 04/14/2017 and then I hit action button , but the value thats read in ti is 4/14/2017 12:00:00 AM comes with time , is there a ...
by manu0521
Wed Sep 18, 2019 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: adding button to pax sheet and publish in paw
Replies: 7
Views: 2100

Re: adding button to pax sheet and publish in paw

Thanks , i found it int eh right pane under Workbook and I can edit it .
by manu0521
Fri Sep 13, 2019 7:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: adding button to pax sheet and publish in paw
Replies: 7
Views: 2100

Re: adding button to pax sheet and publish in paw

Also one omre question in perspectives i am able to edit the action button properties by right clicking the button and properties .But in PAX once I add the button ,I am not able to edit to change any settings. I checked in design mode and also right clicking not giving the same option
by manu0521
Fri Sep 13, 2019 4:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: adding button to pax sheet and publish in paw
Replies: 7
Views: 2100

Re: adding button to pax sheet and publish in paw

Can you please elaborate on this .

So on the process option for failure instead of static text , you would reference a cell like M5 .

And then this M5 would read value from a look up cube ,where the error is written via ti ?

How or when do we clear this once a error is written
by manu0521
Mon Sep 09, 2019 1:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: adding button to pax sheet and publish in paw
Replies: 7
Views: 2100

adding button to pax sheet and publish in paw

Hi , I have an excel uploaded where user can enter some information about lease and I have a button which runs a ti , which in turn stores the results. For now there are few validations done in excel using excel functions ,but i dont have an option to enable or disable a button based on the user ent...
by manu0521
Wed Aug 14, 2019 2:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Issue Help Needed
Replies: 7
Views: 2016

Re: Feeder Issue Help Needed

Thanks for the suggestions went through some code you guys provided. ['Full Revenue'] => DB( sCube, ..., !Month, 'Last 3 Month Sales'); so for above feeder in my rule I have taken values for 3 months and added . like db(month1)+db(month2) etc.. so in my feeder for the month parameter can I just give...
by manu0521
Wed Aug 07, 2019 3:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Issue Help Needed
Replies: 7
Views: 2016

Re: Feeder Issue Help Needed

so does this feeder has to be in AR Cube rules or sales cube rules
['Full Revenue'] => ['Last 3 Month Sales'];
by manu0521
Wed Aug 07, 2019 2:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Issue Help Needed
Replies: 7
Views: 2016

Feeder Issue Help Needed

Hi Guys, Need an help with how to write the feeders for the below rule . I have a accounts recieveable cube which goes to sales cube to grab sales values for the common customer . The values are not being fetched when the balance for the account in AR cube is zero . Below is my rule. ['Last 3 Month ...
by manu0521
Fri Jul 26, 2019 7:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replace an element with same name and different case
Replies: 7
Views: 913

Re: Replace an element with same name and different case

If that element is not at the lowest level then should i back up the data . I am renaming Region 1. Will I be able to delete Region1 with out deleting the customer data under it ?

So hierarchy is like All Regions-> Region 1 ->Agency ->Customer
by manu0521
Fri Jul 26, 2019 6:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replace an element with same name and different case
Replies: 7
Views: 913

Replace an element with same name and different case

Hi Gurus, I have an issue wher emy current dimension element for region levels are Region 001 ,Region 002 etc. Now in the source we had update some hierarchy changes and we first unwind all the higher levels and then reupdate in ti . The source is having value REGION 001 ... But TM1 since is case un...
by manu0521
Fri Jun 14, 2019 2:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Form Uploaded in PAX
Replies: 2
Views: 450

Re: Excel Form Uploaded in PAX

Yes this is helpful . Thanks !! I will give it a try and let you know how it goes.
by manu0521
Thu Jun 13, 2019 8:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Form Uploaded in PAX
Replies: 2
Views: 450

Excel Form Uploaded in PAX

Hi Guys, I have like an excel form created in excel with some basic validations on the sheet and loaded it to paw as a book . Users will be able to enter the details in the form and I plan to have a submit button which write the value in a TI Process from the sheet in to a attribute cube . I wanted ...
by manu0521
Sun Jun 02, 2019 12:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Rules with Date and month
Replies: 3
Views: 741

Re: Tm1 Rules with Date and month

so you are asking me store an attribute at day level .

so for 2018-01-01 i store an attribute value of 201807 right?

That should work ,let me try that.

Thanks,
by manu0521
Sun Jun 02, 2019 12:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Rules with Date and month
Replies: 3
Views: 741

Tm1 Rules with Date and month

Hi Guys, I wanted to know how to perform the below task . I have a cube with months dimension like Year - 2018 Month - 201801 Date - 2018-01-01 Now this is calendar year and values are stored in day level. Now there is a rule in the cube which goes to exchange rate cube which has a different month d...
by manu0521
Thu Apr 25, 2019 4:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need VBA Code to tm1 ti
Replies: 1
Views: 263

Need VBA Code to tm1 ti

I have this code in vba macro , need to convert in ti For i = k To n If k > incFreq Then myPmt = myPmt * (1 + incRate) k = 1 End If discnt = discnt * (1 + discntRate) escPV = escPV + myPmt / discnt k = k + 1 Next Having issue where it says i =k to n , they assign K again as 1 when its greater than i...