Search found 2145 matches

by jim wood
Mon Feb 12, 2018 1:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: General Data Protection Regulation (GDPR) and TM1
Replies: 5
Views: 246

Re: General Data Protection Regulation (GDPR) and TM1

I've not come across this myself (been onsite for the last 4 years) but other guys working for IBM partners may have come across it. I guess we'll see....
by jim wood
Fri Feb 09, 2018 12:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: General Data Protection Regulation (GDPR) and TM1
Replies: 5
Views: 246

Re: General Data Protection Regulation (GDPR) and TM1

I asked as this is a specific questions which would normally be asked at the point of purchase, usually answered by the vendor.
by jim wood
Thu Feb 08, 2018 3:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: General Data Protection Regulation (GDPR) and TM1
Replies: 5
Views: 246

Re: General Data Protection Regulation (GDPR) and TM1

Have you asked IBM? Also moved to correct forum.
by jim wood
Mon Jan 29, 2018 8:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User Set Up in Cognos Administration update TM1 User Group
Replies: 3
Views: 168

Re: User Set Up in Cognos Administration update TM1 User Group

You need to manually add any new groups to TM1. Their group status is not then reflected until the logon when the link for the user is refreshed,

Jim.
by jim wood
Thu Jan 25, 2018 8:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Set ODBO Datasource in Prolog
Replies: 10
Views: 1179

Re: Set ODBO Datasource in Prolog

Taxi for me. Sussed it. I had my override code below the query generated code in the prolog. Thanks for all your help PowerDim,

Jim.
by jim wood
Thu Jan 25, 2018 6:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Set ODBO Datasource in Prolog
Replies: 10
Views: 1179

Re: Set ODBO Datasource in Prolog

I tried to simplify the query:

Code: Select all

DatasourceQuery = 
'SELECT NON EMPTY
  { [OnBoarding - Projects].[?pProject?] } * { [OnBoarding - Version].[Forecast] } * { TM1SUBSETALL( [OnBoarding - Attribute Measures] ) }
ON COLUMNS
FROM [OnBoarding Attributes]';
But still not working
by jim wood
Thu Jan 25, 2018 6:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Set ODBO Datasource in Prolog
Replies: 10
Views: 1179

Re: Set ODBO Datasource in Prolog

So it looks like the query I've specified is not running in the Data Tab. It is still running the original query. I can only guess that I'm missing something from data source overrides: DataSourceType='ODBOMDXQUERY'; DataSourceODBOProvider='TM1OLAP'; DataSourceODBOLocation=''; DataSourceNameForServe...
by jim wood
Thu Jan 25, 2018 5:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Set ODBO Datasource in Prolog
Replies: 10
Views: 1179

Re: Set ODBO Datasource in Prolog

Ah ok, so it behaves in the same way as passing a parameter to a query in the data source tab. Nice and thanks,

Jim.
by jim wood
Wed Jan 24, 2018 8:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Set ODBO Datasource in Prolog
Replies: 10
Views: 1179

Re: Set ODBO Datasource in Prolog

Hey Wim, I'm having a play around with ODBO and I've tried passing a parameter to the code as follows: DataSourceQuery= '"WITH SET [Capital - Version Set] AS '' { [OnBoarding - Version].[Forecast] } '' SET Capital - Projects] AS '' { [OnBoarding - Projects].['|pProject|'] } '' SET [Capital - Attribu...
by jim wood
Tue Jan 16, 2018 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Alias update and stargate view
Replies: 5
Views: 293

Re: Alias update and stargate view

I'm pretty certain that the system regards an alias change as meta change and would lock down the system. It may be taking longer as it will wait for any user activity to end before executing where as a data load (unless you're updating a dimension) will go in as a thread and will not halt user acti...
by jim wood
Wed Jan 10, 2018 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Poll : Which version of Excel is used in your business
Replies: 8
Views: 384

Re: Poll : Which version of Excel is used in your business

tomok wrote:
Wed Jan 10, 2018 11:57 am
Alan Kirk wrote:
Tue Jan 09, 2018 8:20 pm
I addressed this on my YouTube channel last week.
I'd love to watch your shows/webisodes/whatever they're called. Not just to learn more about this topic but also to see if you really do look just like Mark Harmon.
Right hair colour
by jim wood
Tue Jan 09, 2018 8:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Poll : Which version of Excel is used in your business
Replies: 8
Views: 384

Re: Poll : Which version of Excel is used in your business

Just to throw a spanner in the works I use Office 2011 on my mac :oops:
by jim wood
Fri Dec 22, 2017 1:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Date Validation
Replies: 1
Views: 354

Re: Date Validation

Make sure the date fields are numeric. The format them as dates. That way it shouldn't take anything else,

Jim.
by jim wood
Wed Dec 06, 2017 2:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom Workflow
Replies: 10
Views: 558

Re: Custom Workflow

I would:

1) Create a test service (Containing copy of production)
2) Connect Application web to the test service
3) Open PM and create an application using whatever hierarchy option you want
4) See how the web forms come through from the application folders etc
5) Decide if this is a good fit

Jim.
by jim wood
Wed Dec 06, 2017 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom Workflow
Replies: 10
Views: 558

Re: Custom Workflow

You only need to use PM to setup the hierarchy, security and which forms are used for data entry etc. It shouldn't screw anything up as it won't deploy any rules or anything like that.
by jim wood
Mon Nov 13, 2017 4:23 pm
Forum: Useful code, tips and tricks
Topic: Inspecting views
Replies: 3
Views: 522

Re: Inspecting views

Thanks Wim. Will be very handy for anybody inheriting a system that has (how should I say) evolved over time.
by jim wood
Thu Nov 02, 2017 12:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Subsets & BI
Replies: 2
Views: 187

Re: MDX Subsets & BI

Thanks for getting back to Mac. As it turns out the issue was with a filter rather than a subset coming through in BI but thanks your reply,

Jim.
by jim wood
Wed Nov 01, 2017 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unusual Problems with Text Files in TI Processes
Replies: 3
Views: 229

Re: Unusual Problems with Text Files in TI Processes

Are there any free form text fields within the Data? If there are, within this field there may carriage returns or ". If there are if would throw everything off.
by jim wood
Wed Nov 01, 2017 12:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Subsets & BI
Replies: 2
Views: 187

MDX Subsets & BI

Guys,

We are seeing different numbers of elements in subsets in BI than in architect. Does BI run with the last subset size or does it refresh the subset?

Jim.
by jim wood
Wed Nov 01, 2017 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 process in chore starts with 2 min delay
Replies: 2
Views: 187

Re: TM1 process in chore starts with 2 min delay

Are there any other chores running at the time? Are there any meta updates happening? Have you checked top (or whatever the modern fangled thingie is) when it is happening to see if anything else is running?