Search found 56 matches

by chewza
Tue Oct 02, 2018 9:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ti Variable for Model Name
Replies: 1
Views: 110

Ti Variable for Model Name

Hi there

Does anyone know how I can "grab" the model name in a Ti process?

Many thanks!

Chris
by chewza
Thu Aug 16, 2018 11:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax - can you spread?
Replies: 0
Views: 401

Pax - can you spread?

Hi there

From what I can see, you can only spread in an Exploration, but not in a Dynamic Report or Customer report..??
Is this true? Am I missing something?

Regards
Chris
by chewza
Tue Aug 14, 2018 2:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax - Dynamic Subset possible?
Replies: 1
Views: 306

Pax - Dynamic Subset possible?

Hi there

Can you create a dynamic subset in Pax, similar to how you can record them in Perspectives/Architect?

Many thanks!!

Regards
Chris
by chewza
Tue Jul 31, 2018 10:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Paw - dashboard Backups
Replies: 1
Views: 236

Paw - dashboard Backups

Hi there

Anyone know where all content behind paw dashboards is stored?
How does one back up?

Many thanks!

Regards
Chris
by chewza
Fri Jul 27, 2018 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax & Perspectives => Active Forms not working
Replies: 4
Views: 834

Re: Pax & Perspectives => Active Forms not working

Hi Thanks for you reply. For now I don't want to launch perspectives, so opening Excel (which has PA) is good. I don't have any action buttons in my active forms. They just return #VALUE. Slicer reports open fine. I took this model from my laptop, and it was all done in perspectives. Copies to a new...
by chewza
Fri Jul 27, 2018 12:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax & Perspectives => Active Forms not working
Replies: 4
Views: 834

Pax & Perspectives => Active Forms not working

Hi There I'm trying our PA on a test server, and playing around with Pax. Model and reports was originally developed with perspectives. Only hassle is that active reports written in Perspectives don’t render in Pax. Slicers work fine. I installed tm1 server and Perspectives installed as part of it. ...
by chewza
Tue Jul 24, 2018 12:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Workflow - Getting Started
Replies: 0
Views: 411

PA Workflow - Getting Started

Hi there

Would appreciate it if someone could point me in the direction of links/resources that explain how to set-up and use workflow with planning analytics.
I never used this in Tm1 (ie before PA release), so I am starting from a zero base.

Much appreciated!!

Regards
Chris
by chewza
Fri Jun 15, 2018 9:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics 2 - Can Pax & Perspectives Co-exist?
Replies: 3
Views: 404

Planning Analytics 2 - Can Pax & Perspectives Co-exist?

Hi there We want to convert some users to Pax, but we want them to have continued access to Perspectives until we are satisfied that all reports are working properly and all users are comfortable with Pax. I've heard that Perspectives & Pax cannot co-exist? Is there no way around this? Eg enable,/di...
by chewza
Mon Apr 16, 2018 7:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transaction Logs - Access Rights Required
Replies: 6
Views: 748

Re: Transaction Logs - Access Rights Required

ok thanks. I'm thinking of designing an approach where a TI loops through all log files that are date stamped between required range, and writes values to a cube. This could then be used as the query source. Will need to see if there is a loop through log files, and dynamically change the test file ...
by chewza
Mon Apr 16, 2018 6:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transaction Logs - Access Rights Required
Replies: 6
Views: 748

Re: Transaction Logs - Access Rights Required

Hi Alan Thanks very much for your feedback. Your approach with TIs sounds interesting. Do you not have challenges with this approach, when for example, you want to back out all transactions for a specific date ranges, user, element etc. I guess one would need a TI that read through all log files tha...
by chewza
Sun Apr 15, 2018 4:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transaction Logs - Access Rights Required
Replies: 6
Views: 748

Transaction Logs - Access Rights Required

Hi there

From what I can see, only users in one of the 3 admin roles can view the transaction log and roll back if required.
Is this correct? Is there any way around this?

Regards
Chris
by chewza
Fri Feb 09, 2018 3:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset Create With Mdx
Replies: 2
Views: 381

Re: Subset Create With Mdx

Ps

Not to worry - All sorted. Found my issue.Thx!!!!!!
by chewza
Fri Feb 09, 2018 3:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset Create With Mdx
Replies: 2
Views: 381

Re: Subset Create With Mdx

PS

Paste into expression editor WITHOUT the double quotes works fine
by chewza
Fri Feb 09, 2018 3:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset Create With Mdx
Replies: 2
Views: 381

Subset Create With Mdx

Hi there I am struggling with this My process below fails: vMdx1 = '{TM1DRILLDOWNMEMBER( {TM1FILTERBYPATTERN( {TM1SUBSETALL( [Customer] )}, "'; vMdx2 = vCustomer; vMdx3 = '")}, ALL, RECURSIVE )}'; vMdxTotal = vMdx1 | vMdx2 | vMdx3; SubsetCreateByMdx('SYS - Dynamic Mdx', vMdxTotal); So instead to tro...
by chewza
Thu Feb 08, 2018 7:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Login History of users
Replies: 3
Views: 531

Re: Login History of users

Many thanks Guys!
by chewza
Wed Feb 07, 2018 4:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Login History of users
Replies: 3
Views: 531

Login History of users

Hi there

Is there anyway to get ingormation about how often users have logged in??

Many thanks
Chris
by chewza
Fri Feb 02, 2018 2:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is Hierarchy Sort?
Replies: 1
Views: 305

What is Hierarchy Sort?

Hi Guys

Please can someone remind me what the "hierarchy sort" option does in the Subset Editor?


Regards
Chris
by chewza
Tue Jul 25, 2017 9:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Whate the IRR and Rate Function in TM1 Rule use?
Replies: 9
Views: 2962

Re: Whate the IRR and Rate Function in TM1 Rule use?

Thanks very much - really appreciate sharing this solution!! One big issue though is when trying to implement feeders. I notice that in the sample this is switched off. In a real-life situation, implementing feeders seems to make performance unworkable. Reason is really to do with having to feed eve...
by chewza
Mon Jun 12, 2017 7:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Ribbon Disappears
Replies: 5
Views: 1137

Re: Excel Ribbon Disappears

Hi Guys Thanks for the feedback. It's not just the ribbon that disappears, but also the menus. Everything above the spreadsheet rows/columns section is blank. Please refer attached. Any one else have the same issue? The only option is to kill Excel, and try again. Sometimes it is fine, other times n...