Search found 1828 matches

by Wim Gielis
Fri Dec 14, 2018 9:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives - Prompt when closing Excel?
Replies: 3
Views: 40

Re: TM1 Perspectives - Prompt when closing Excel?

Natively and out of the box: no.
You would need to add VBA code to intercept events, like Workbook_Close, Workbook_Deactivate.
Actually Application level events. Knowing that TM1 hijacks a number of events too, this will not be easy at all.
by Wim Gielis
Fri Dec 14, 2018 4:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to import a CSV file to a cube with two extra dimensions
Replies: 2
Views: 198

Re: How to import a CSV file to a cube with two extra dimensions

Please explain the logic to put the same value on every cell on a quadrant, being the multiplication of x * y cells. Not: x + y cells but x * y cells. x leaf level elements from the 5th dimension, y leaf level elements from the 6th dimension. What is the reasoning ? You could also load the value in ...
by Wim Gielis
Thu Dec 13, 2018 9:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 SAP Connector on 10.2.2 and PAX
Replies: 2
Views: 360

Re: TM1 SAP Connector on 10.2.2 and PAX

Personally I am the lead of a TM1 model where SAP BW is one of the data sources. I am not aware of all the technical details, but at least I can say that: - you create packages in Framework Manager - you consume those packages in TI processes, either entirely, either in a filtered way - 1 package in...
by Wim Gielis
Wed Dec 12, 2018 11:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Holds via a Ti
Replies: 7
Views: 124

Re: Holds via a Ti

Hello, I guess that Tom is confusing holds and locks. A hold can be applied through TI by placing a 'C' or 'H' in the relevant control cube. TM1 creates a control cube for any cube where holds are applied. When holds are released that cube is cleared, but not thrown away. When a fold is applied, TM1...
by Wim Gielis
Tue Dec 11, 2018 7:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Notepad++ 7.6 for TM1 process and Rules
Replies: 8
Views: 372

Re: Notepad++ 7.6 for TM1 process and Rules

Rtel,

There is a language add-on for TM1 (in fact, there are a couple of them).
In Notepad++, go to Language > Define your language and import such an XML file.
After the restart of Notepad++ the new language will be available.
by Wim Gielis
Tue Dec 11, 2018 7:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Notepad++ 7.6 for TM1 process and Rules
Replies: 8
Views: 372

Re: Notepad++ 7.6 for TM1 process and Rules

The fact that you have to bounce the server in order to use any of the TI code changes you make in Notepad++ make it a non-starter for me. That negates any benefit you get from a better search and replace, etc. I haven't seen the new TI editor in PA but it can't possibly be worse than what has been...
by Wim Gielis
Tue Dec 11, 2018 4:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Notepad++ 7.6 for TM1 process and Rules
Replies: 8
Views: 372

Re: Notepad++ 7.6 for TM1 process and Rules

Hello, 1) You can edit a PRO file straight away, but be very careful. TM1 keeps line numbers of parameters and code in the Prolog/Metadata/Data/Epilog tabs. If you change lines there, or you change parameters, you definitely have to update certain property values. Also, if a TI process also has a co...
by Wim Gielis
Sun Dec 09, 2018 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.6 Temporary Subset Unable To Register
Replies: 5
Views: 748

Re: PA 2.0.6 Temporary Subset Unable To Register

kenship wrote:
Sun Dec 09, 2018 1:04 pm
Thanks for your reply.

I just want to confirm that I'm not the only one who has this problem.

Ken
Confirmed ;)
And thanks for confirming my suspicions about the subject.
by Wim Gielis
Sat Dec 08, 2018 11:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.6 Temporary Subset Unable To Register
Replies: 5
Views: 748

Re: PA 2.0.6 Temporary Subset Unable To Register

Hi Kenneth, I can relate to this problem. But I have no solution. 2 weeks ago after upgrading a TM1 model, I had to rewrite certain view and subset creations because of this issue with temporary objects. It was most of the time a mother process looping over 12 periods and within the loop a second pr...
by Wim Gielis
Fri Dec 07, 2018 12:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: issues with moving TI processes
Replies: 9
Views: 408

Re: issues with moving TI processes

Try setting up a new temporary TM1 server with just the processes, not cubes and dimensions. That should be quick. You can include the control objects but not the regular application objects like cubes. Does this work ? If not, do you see messages in the TM1 server message log ?
by Wim Gielis
Fri Nov 30, 2018 11:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rules Query
Replies: 6
Views: 485

Re: TM1 Rules Query

Hi Wim, I was trying to ensure that this model was not reliant on too many processes as I preferred the model to be fully automated and not to have any buttons to press for the user. However, after thinking about this again, I put too much emphasis on it being an automated model, than actually deli...
by Wim Gielis
Thu Nov 29, 2018 11:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How Do I Protect Password on ODBCOpen
Replies: 14
Views: 2454

Re: How Do I Protect Password on ODBCOpen

I hadn't thought setting datasourcepassword worked for ODBCOutput, rather for data loading. But it still needs to be populated from somewhere, surely :) Sorry, I should've been more explicit. I was trying to suggest that one could specify the password in the DatasourcePassword in the datasource def...
by Wim Gielis
Thu Nov 29, 2018 4:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rules Query
Replies: 6
Views: 485

Re: TM1 Rules Query

DavidP wrote:
Thu Nov 29, 2018 4:36 pm
Is it possible to amend dimension structure without using a T.I?
Dimensions can be changed manually but TI is a much better solution, for obvious reasons.
DavidP wrote:
Thu Nov 29, 2018 4:36 pm
I have that are only mapping data with no other function.
That’s not bad at all. What is it that you dislike about this solution ?
by Wim Gielis
Tue Nov 27, 2018 7:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drills - Not working for users
Replies: 9
Views: 1421

Re: Drills - Not working for users

Spot on ! We need !Hierarchy for rules and also something similar for TI. Hopefully IBM is reading along.
by Wim Gielis
Sun Nov 25, 2018 8:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drills - Not working for users
Replies: 9
Views: 1421

Re: Drills - Not working for users

Hi all, On a related note (drills), I noticed that they work fine in PAW and PAX - provided we have at least 1 dimension in the rows AND in the columns. Frankly I don't see why this would be a requirement if this worked fine in TM1 Architect. Another more difficult one: starting the drill from a cel...
by Wim Gielis
Wed Nov 21, 2018 9:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drills - Not working for users
Replies: 9
Views: 1421

Re: Drills - Not working for users

Hector,

Do you allow users READ access to the }cubeDrill cube ?
SImilarly, READ access to the }Drill process ?

Wim
by Wim Gielis
Mon Nov 19, 2018 8:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Work-around for granting access when there is no admin??
Replies: 5
Views: 208

Re: Work-around for granting access when there is no admin??

Did you already test if you have admin access? It’s much quicker then asking a bunch of other people.
by Wim Gielis
Mon Nov 19, 2018 4:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Work-around for granting access when there is no admin??
Replies: 5
Views: 208

Re: Work-around for granting access when there is no admin??

You should ask the person(s) that are part of the admin group, not just with admin access to the cube.
by Wim Gielis
Sun Nov 18, 2018 10:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet function: find the Group of a user
Replies: 7
Views: 1437

Re: Websheet function: find the Group of a user

Can you still be more specific ? How do you check the rights by group ? Do you use some kind of lookup table with a selection of groups and their associated rights ?