Search found 55 matches

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: 48

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: 210

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: 168

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: 725

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: 725

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: 130

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: 334

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: 568

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: 568

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: 568

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: 306

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: 306

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: 306

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: 451

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: 451

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: 264

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: 2861

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: 1028

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...
by chewza
Sat Jun 10, 2017 1:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1RptRow - Mdx Expression with sorting on Alias
Replies: 2
Views: 532

Tm1RptRow - Mdx Expression with sorting on Alias

Hi there I have a Tm1RptRow expression with the mdx parameter. Problem: I need the rows returned by the Mdx to be sorted according to an ALIAS. Using the Tm1Sort function in the mdx will sort according to the original elements - doesn't allow you to specify alias. I know that in the Tm1RptRow functi...