Search found 163 matches

by ascheevel
Mon Jul 27, 2020 2:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax - Commit
Replies: 2
Views: 101

Re: Pax - Commit

Quick Reports have a type-in refresh option but that is only for automatically refreshing data after a metadata change. I'm not aware of type-in commit as a radial option. In the couple cases I've had where the end user asked for auto-commit after entry, I've used VBA to commit the active quick repo...
by ascheevel
Mon Jul 13, 2020 5:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 13
Views: 454

Re: Expand function with numbers

I shouldn't have posted multiple definitions of n1 in my example. I see now it's an unnecessary distraction. Your example makes sense and performs as I would expect, but not because there's anything special about the variable s. EXPAND(s) in your example is the exact same as writing EXPAND('%n%'). I...
by ascheevel
Mon Jul 13, 2020 3:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 13
Views: 454

Re: Expand function with numbers

Hence, the string variable "s" is not recalculated a second time, even though I explicitly assign the current time of Now to nStart right before calling it in the last line. Isn't this expected behavior of the EXPAND function? My understanding of EXPAND is that it can only return the value computed...
by ascheevel
Fri Jul 10, 2020 7:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Expand function with numbers
Replies: 13
Views: 454

Re: Expand function with numbers

It would be nice if you could define callable functions in TI script. You could set up a separate TI for this function, but I'm sure you're already thought of that and perhaps you don't want the additional process start/finishes muddying up the log entries you're trying to make. It's not quite what ...
by ascheevel
Fri Jul 10, 2020 2:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculate minutes
Replies: 10
Views: 286

Re: Calculate minutes

Are you doing this via rule or TI process? If TI process, you can use the ParseDate function to convert your datetime strings to serial numbers and then take the difference times 1440. I didn't specify a NewDateFormatter, so the below example uses the default but you can specify one as well. # initi...
by ascheevel
Thu Jul 09, 2020 2:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 C# RestAPI - Recive Passport from BI Gateway?
Replies: 2
Views: 145

Re: TM1 C# RestAPI - Recive Passport from BI Gateway?

I know C# is in the header so this might not be what you're looking for, but TM1PY can authenticate with SSO if you supply a gateway parameter in the connection string. There are some prerequisites like only being supported with Windows though. Looking at your post history, it looks like you have ex...
by ascheevel
Sat Jul 04, 2020 8:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1py Use Case
Replies: 3
Views: 216

Re: TM1py Use Case

Did you check out the responses when you asked about TM1PY here?
by ascheevel
Thu Jun 25, 2020 5:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue on PAX 44
Replies: 11
Views: 600

Re: Issue on PAX 44

Did you have the user enable logging and pull the PAX log files?
by ascheevel
Thu Jun 25, 2020 5:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue on PAX 44
Replies: 11
Views: 600

Re: Issue on PAX 44

I see QA in the connection name. Have you confirmed the user is in the users list for the QA PAX environment? You could try having them log in through PAW in browser and see if they're able to get in. User list in PAW is different than }Clients dim on TM1 server.
by ascheevel
Thu Jun 25, 2020 3:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue on PAX 44
Replies: 11
Views: 600

Re: Issue on PAX 44

Not seeing cubes in the task pane is related to that issue, selecting "Optimize for Compatibility" fixes it. I wasn't able to replicate the open dialog with servers not visible when switching to "Optimize for best appearance", but it could be causing OP's issue.
by ascheevel
Thu Jun 25, 2020 2:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue on PAX 44
Replies: 11
Views: 600

Re: Issue on PAX 44

Bhavana wrote:
Thu Jun 25, 2020 1:10 pm
It shows complete blank when user click on Open icon on PAX
Do they have any items to choose from in the dropdown "Select an IBM Connection..."? Are there any cubes visible in their task pane after establishing a connection?
by ascheevel
Thu Jun 25, 2020 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue on PAX 44
Replies: 11
Views: 600

Re: Issue on PAX 44

Have you confirmed the user can actually connect to TM1 server in PAX? Did you check the connection URLs and test the connections in the user's PAX options?
by ascheevel
Wed Jun 24, 2020 2:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Not Moving to Cell
Replies: 13
Views: 456

Re: Data Not Moving to Cell

Good. One test you could do is recreate the cube view from your initial screenshot with only the measures Adjusted Wage Calc, Adjusted Daily Rate, Current Daily Rate, Base Salary, and Annual Salary selected and then move your time dimension up to the context filter and turn zero suppression on. When...
by ascheevel
Wed Jun 24, 2020 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Not Moving to Cell
Replies: 13
Views: 456

Re: Data Not Moving to Cell

['Amount', 'Forecast','time_mqy':'comment', 'Annual Salary' ] => DB('Payroll Model', 'Amount', !Version, 'Total of Time_MQY', !regioncc, !cc_emp,'Base Salary'), DB('Payroll Model', 'Amount', !Version, 'Total of Time_MQY', !regioncc, !cc_emp,'H_Base Salary Days in Payroll') ; Is the element Jan 2022...
by ascheevel
Wed Jun 24, 2020 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Functions
Replies: 3
Views: 360

Re: Hierarchy Functions

For modifying the base hierarchy of the dim, you can continue to use the original functions. For modifying the alternate hierarchies, you'll absolutely need to use the hierarchy functions.
by ascheevel
Wed Jun 17, 2020 7:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Some icons missing on set editor
Replies: 10
Views: 806

Re: Some icons missing on set editor

Duly noted Lotsaram, thanks. One question: how is PAfE pronounced, is it like cafe but with a P? I think I'll stick with calling it PAX for now, but will owe the first person who hears me using PAfE a modestly priced beverage of their choosing whenever we have in-person conferences again.
by ascheevel
Wed Jun 17, 2020 4:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Some icons missing on set editor
Replies: 10
Views: 806

Re: Some icons missing on set editor

Sorry OP, I shouldn't start a PAX/PAfE argument in your thread without at least offering a comment on your issue. PAX version is 2.0.6 That sounds like a PA version, not PAX version. The most recent PAX version released on June 12th was 2.0.54. Double check your PAW and PAX versions and validate aga...
by ascheevel
Wed Jun 17, 2020 3:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Some icons missing on set editor
Replies: 10
Views: 806

Re: Some icons missing on set editor

scrumthing wrote:
Wed Jun 17, 2020 2:56 pm
Everybody calls it PAfE nowadays. Sorry.
I would argue PAX is the generally accepted abbreviation.
by ascheevel
Tue Jun 02, 2020 8:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upload file via PAW?
Replies: 1
Views: 214

Re: Upload file via PAW?

I don't think you can do that in PAW, but you can with PAX using the publish feature: https://www.ibm.com/support/knowledgece ... h_tm1.html
by ascheevel
Thu May 21, 2020 7:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: import file from a specific network
Replies: 6
Views: 299

Re: import file from a specific network

try replacing "\\data\s\" with "s:\"