Search found 2592 matches

by tomok
Fri Sep 20, 2019 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What should I do now?
Replies: 1
Views: 621

Re: What should I do now?

Sounds suspiciously to me like you didn't perform a SaveData, to flush all the in memory values to disk, before copying the files from Prod to Dev OR you copied into a folder on DEV that was not empty beforehand. I can think of no other reason why they wouldn't match.
by tomok
Thu Sep 19, 2019 3:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Changing constant value with effective date
Replies: 2
Views: 155

Re: Changing constant value with effective date

Like anything in TM1, there are probably a dozen or more ways to do it. The obvious choice is rules but I wouldn’t rule out a TI process because that is going to be the easiest to maintain and you won’t need feeders. In the form that has the available beds data you could have an action button the ma...
by tomok
Wed Sep 18, 2019 8:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passing values from excel to TI
Replies: 3
Views: 211

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 . You realize, of course, that a date in Excel is a number so when passing it to a TI process it is g...
by tomok
Wed Sep 18, 2019 3:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passing values from excel to TI
Replies: 3
Views: 211

Re: Passing values from excel to TI

Have you tried anything yet? Try changing the formatting of the cell in Excel and see what it does. Don't always run to someone else for help. Be inquisitive and try things. It's the only way you are going to learn,
by tomok
Fri Sep 13, 2019 8:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: adding button to pax sheet and publish in paw
Replies: 7
Views: 841

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 Action butto...
by tomok
Fri Sep 13, 2019 6:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: adding button to pax sheet and publish in paw
Replies: 7
Views: 841

Re: adding button to pax sheet and publish in paw

So on the process option for failure instead of static text , you would reference a cell like M5 . Yes. And then this M5 would read value from a look up cube ,where the error is written via ti ? Yes How or when do we clear this once a error is written In the same TI prolog you clear the value in th...
by tomok
Wed Sep 11, 2019 6:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Forms with Filters
Replies: 5
Views: 206

Re: Active Forms with Filters

For the TM1RPTROW formula you provide either a subset OR an MDX statement parameter. This is an MDX parameter. Use the function editor in Excel to help you get the syntax correct.
by tomok
Wed Sep 11, 2019 4:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Load issue even after viewzero out
Replies: 1
Views: 70

Re: Data Load issue even after viewzero out

There is no concept of "records" in TM1. So, you are loading both passes from the datamart into the same intersections in the cube and after the second pass you have intersections left in the cube with balances that don't have records in the datamart? If that is the case your VIEWZEROOUT routine is ...
by tomok
Tue Sep 10, 2019 10:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Forms with Filters
Replies: 5
Views: 206

Re: Active Forms with Filters

This MDX statement:

Code: Select all

{TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {[YourDimension].["&A1&"]}, ALL, RECURSIVE )},0)}
placed in your TM1RPTROW formula will filter to all the leaf elements of the parent contained in cell A1. In A1 you could put a SUBNM formula or a data validation Excel drop down formula.
by tomok
Tue Sep 10, 2019 10:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DB function is not pulling data from the source cube
Replies: 5
Views: 468

Re: DB function is not pulling data from the source cube

You say:
lynnsong986 wrote:
Tue Sep 10, 2019 9:13 pm
I have a cube (source cube "Submetering Building Number of Units") with 3 dimentions:
Yet your rule:
lynnsong986 wrote:
Tue Sep 10, 2019 9:13 pm
['Number of Units']=N:DB('Submetering Building Number of Units',!Submetering Projects,!Submetering Services);
Has only two dimensions listed.
by tomok
Tue Sep 10, 2019 7:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Vba code in tm1 active sheets
Replies: 4
Views: 204

Re: Vba code in tm1 active sheets

So if we use the active sheets in tm1 web, we can not use macros in them?? So the answer would ba a No. Or is their any other possibility. The answer is unequivocally no. TM1Web can not run VBA code. If you can't do it through a combination of Excel formulas and action buttons then it cannot be done.
by tomok
Fri Sep 06, 2019 7:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Not Loading All Values
Replies: 9
Views: 1105

Re: TI Process Not Loading All Values

A rule was the culprit. Owner of rule stated should not be impact but not the case. Thanks for leading me in that direction! If indeed it was a rule stopping the update you should have gotten an error log message which would have told you that you were attempting to write to a rule valued cell. How...
by tomok
Fri Sep 06, 2019 5:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Not Loading All Values
Replies: 9
Views: 1105

Re: TI Process Not Loading All Values

So you used ASCIIOutput to get a text file containing the variable values as defined by your code. Did you zero in on a few of the exact records that represent cells in the cube that you say are not updating? Did you check each of the columns from those records in the ASCIOutput to make sure they re...
by tomok
Wed Sep 04, 2019 11:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1s-log.properties file
Replies: 3
Views: 274

Re: Tm1s-log.properties file

Thanks for the help. I had initially tried that and it didn't work (we're on the IBM Cloud) but I went back and removed everything except that statement and I got the list. Now to figure out what all those options actually do. :?
by tomok
Tue Sep 03, 2019 4:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1s-log.properties file
Replies: 3
Views: 274

Tm1s-log.properties file

Does anyone know of a document that lists all the options that can be used in the tm1s-log.properties file? I have made several requests to IBM for this and all they keep sending me back is a link to the documentation that only shows what is in the sample file. I know there are dozens of options tha...
by tomok
Tue Sep 03, 2019 11:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted
Replies: 7
Views: 253

Re: [PA Express 2.0.6] [TM1Web] websheets: number format corrupted

What number format are you using in Excel, General? Make sure you select the proper number format in Excel then republish.
by tomok
Fri Aug 30, 2019 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionAttrs
Replies: 15
Views: 2563

Re: DimensionAttrs

You can state what you would like to do until you are blue in the face but it's not going to change what is possible in TM1. TM1 is not SQL. There is no UPDATE function in TM1 like there is in SQL where you can update multiple rows (in TM1 we call them intersections) at one time by specifying where ...
by tomok
Thu Aug 29, 2019 10:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Leading zeros in AsciiOutPut being dropped
Replies: 4
Views: 1777

Re: Leading zeros in AsciiOutPut being dropped

Here's a better idea (at least I think so). Don't give your output file the .csv extension, use .txt or anything else. That way when you open it in Excel it will ask you how you want all the columns defined and then you can say "Text" for the Account column, which will leave your leading zeros. When...
by tomok
Wed Aug 28, 2019 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess explanation
Replies: 4
Views: 1502

Re: RunProcess explanation

It's up to you how you use it but I think the general concept is that you would have a master process that has the RunProcess commands in it. You could call those from the Prolog but I think the real power is in calling them from the Data tab. For example, we have a number of Oracle ledgers we have ...
by tomok
Wed Aug 28, 2019 12:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to make a closing balance from a previous month an opening balance in the next month?
Replies: 5
Views: 1600

Re: How to make a closing balance from a previous month an opening balance in the next month?

What the guys didn't tell you is that while this linking of periods is a very useful feature in TM1, it is not without it's caveats and challenges. The biggest issue is going to be linking too many periods into the future and ending up with a stack overflow error because you have too many dependent ...