Search found 48 matches

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

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

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

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

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

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

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

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

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

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

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

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

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...
by chewza
Sat Jun 10, 2017 10:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Web Not Working
Replies: 3
Views: 701

Re: Tm1 Web Not Working

Hi

Yes, I did indeed try http://localhost:9510/tm1web

This is actually where I go the error message

Regards
Chris
by chewza
Fri Jun 09, 2017 3:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Ribbon Disappears
Replies: 5
Views: 841

Excel Ribbon Disappears

Hi there Very often we have an issue on a Citrix/thin client session whereby the Excel Ribbon disappears completely at the top when opening a Tm1 Report. Perspectives opens fine, but when opening some reports this is what happens. It's also not consistent - sometimes happens, and sometimes not. We a...
by chewza
Fri Jun 09, 2017 3:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Web Not Working
Replies: 3
Views: 701

Tm1 Web Not Working

Hi there When we try an open tm1 web (http://localhost:9510) we get a Tomcat error message saying "The requested Resource is Not Available". Any ideas why? We have never used web before, so not sure if this was always a problem We are running Tm1 10.2.2 and FP6. In Cognos configuration, the Admin se...
by chewza
Mon May 22, 2017 10:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Latest Palo/Jedox v Tm1
Replies: 1
Views: 501

Latest Palo/Jedox v Tm1

Hi Guys Do you know anything about Palo (now known as Jedox)? Apparently it is very similar to Tm1, and open-source/free? Hopefully there is a paid (but still cheap) version which has product support? I have seen posts on this forum RE Palo, but they are quite a few years old. Seems to have quite a ...
by chewza
Mon May 15, 2017 7:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sandbox Transactions
Replies: 1
Views: 406

Sandbox Transactions

Hi there

Would appreciate it if someone can tell me how sandbox transactions are logged/saved etc.

They will obviously be saved by the "CXTM1SaveDataAll" command, but will transaction logging happen automatically if transaction logging is turned on for the cube concerned?

Many thanks!

Chris
by chewza
Fri Apr 21, 2017 2:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pasting values in Excel to DBRW
Replies: 9
Views: 3732

Re: Pasting values in Excel to DBRW

Hi Guys

Any further news/developments RE pasting into an Active Form?

Many thanks!!

Chris
by chewza
Thu Apr 20, 2017 8:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Feeder Issues
Replies: 2
Views: 463

Re: String Feeder Issues

Hi Wim

Works perfectly now - thanks very much!!!

Regards
Chris :D