Search found 168 matches

by AmbPin
Thu Mar 16, 2017 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 18091

Re: TM1 10.2.2 FP6

Thanks Alan, I just built a test to try the call to another process. I started down this route because of the new FP6 bug, mentioned in this thread, that crashes the service if you dynamically set an empty source view. I use a generic TI to create my views, so I have amended that to:- * Set the view...
by AmbPin
Thu Mar 16, 2017 7:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 18091

Re: TM1 10.2.2 FP6

considering that it is possible to check in the Prolog if your source view will return at least one value Please could you explain how you might do this? I have seen a technique used with a generic process that sets the data view and initializes a counter in the prolog, in the data tab the variable...
by AmbPin
Wed Mar 15, 2017 3:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 18091

Re: TM1 10.2.2 FP6

qml wrote:considering that it is possible to check in the Prolog if your source view will return at least one value
Please could you tell me how you can check?
by AmbPin
Fri Feb 19, 2016 1:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 'Set Dimension Order' Not Working
Replies: 13
Views: 2532

Re: TM1 'Set Dimension Order' Not Working

There are various sorting options available to you via MDX also if you wanted to create some dynamic subsets.
by AmbPin
Fri Feb 19, 2016 11:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 'Set Dimension Order' Not Working
Replies: 13
Views: 2532

Re: TM1 'Set Dimension Order' Not Working

Hello,
I think the order that you are seeing is the order in which elements were added to the dimension (The index) and therefore this will not generally be affected by you moving them around in the editor.
by AmbPin
Thu Sep 17, 2015 10:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1ServerLogDirectory
Replies: 9
Views: 1426

Re: TM1ServerLogDirectory

tomok wrote: I normally put a cube in all my models that stores all this type of data
Good idea, thanks.
by AmbPin
Wed Sep 16, 2015 3:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1ServerLogDirectory
Replies: 9
Views: 1426

Re: TM1ServerLogDirectory

Hmm, I have kind of done that.
I have a TI that sucks the contents of the tm1s.cfg file into a cube so I can get at all of the values that way.
Thanks again Trevor
by AmbPin
Wed Sep 16, 2015 2:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1ServerLogDirectory
Replies: 9
Views: 1426

Re: TM1ServerLogDirectory

Thanks Trevor
I am trying to cater for situaltions where the TM1 services are on different hosts and physical servers. Also the possibility that the folder structures on these physical servers may be different.
by AmbPin
Wed Sep 16, 2015 1:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1ServerLogDirectory
Replies: 9
Views: 1426

Re: TM1ServerLogDirectory

Sorry, Looking fo a way to determine the URL path to the log or data files folder for a specified server. A VBA equivilant of the TI function GetProcessErrorFileDirectory() I am trying to build a VBA UI that can be connected to more than one TM1 service at the same time and need to know the folder p...
by AmbPin
Wed Sep 16, 2015 1:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1ServerLogDirectory
Replies: 9
Views: 1426

TM1ServerLogDirectory

Hello,
I am looking for a way to get the data or log files directory for a specified server in VBA code. Does anyone know if the above APi functionis the right thing to use and if so have any pointers on how to call it.
Many thanks.
by AmbPin
Tue Sep 08, 2015 2:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disappearing values
Replies: 22
Views: 3129

Re: Disappearing values

I don't see why it should be either but the pick-list values do disappear a soon as I run the process, no other data cubes are affected. Not sure if I have mentioned that the pick-lists are created by rules on the pick-list cube. My thinking is unloading the cube was that these rules need to be re-t...
by AmbPin
Tue Sep 08, 2015 1:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sum in TM1 Rules based on Attribute
Replies: 4
Views: 1206

Re: Sum in TM1 Rules based on Attribute

Depends on how the "client" is changing the attribute but my preference would be for an alternative dimension hierarchy.
by AmbPin
Tue Sep 08, 2015 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disappearing values
Replies: 22
Views: 3129

Re: Disappearing values

AmbPin wrote:no elements are deleted and then added back.
Thanks lotsaram
The way you suggest is how my process works, elements are moved to a temporary bucket within the dimension and the structure re-assembled - no elements are deleted.
Sorry for not making that clear.
by AmbPin
Tue Sep 08, 2015 7:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get rollup in MDX
Replies: 5
Views: 1673

Re: How to get rollup in MDX

Have you looked at the MDX Primer document that I am sure you will find quite easily on the interweb. It is an excellent reference.
by AmbPin
Tue Sep 08, 2015 7:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disappearing values
Replies: 22
Views: 3129

Re: Disappearing values

Hello, Thanks again for all contributions. It seems that my disappearing values are being caused by an overnight process which performs dimanesion maintenance which flattens the structure, rebuilds and adds new elements. None of the "real" data cubes are affected in this way, although I am not using...
by AmbPin
Thu Sep 03, 2015 1:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disappearing values
Replies: 22
Views: 3129

Re: Disappearing values

Thanks for all of the input.

I created the "}MapSettings" subset with a "}" so it would not normally be visible to ordinary users and less easy for admins to amend

Have created a duplicated set without the "}" so will let you know what happens.
by AmbPin
Thu Sep 03, 2015 7:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disappearing values
Replies: 22
Views: 3129

Re: Disappearing values

Thanks for your input Jim. I tend to use control subsets for anything that the "system" depends upon so it protects even admins from changing things inadvertently. I would have thought that if using a control subset was a problem then the picklist would not have worked at all, on the other hand you ...
by AmbPin
Wed Sep 02, 2015 1:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disappearing values
Replies: 22
Views: 3129

Disappearing values

Hello, I have a simple mapping cube to map dimension elements when integrating data from a very granular system to a more consolidated legacy reporting system. My mapping cube [MyMapCube] has two dimensions [MyGranularDim] & [Measure] which has a single string element called "Note". This cube will m...
by AmbPin
Mon Feb 09, 2015 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element Security
Replies: 6
Views: 2263

Re: Element Security

Only thing I can think of is that if your security is rule driven it might not actually have been applied until now. Did you restart the server recently?
by AmbPin
Fri Jan 09, 2015 3:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Views that use a particular subset
Replies: 1
Views: 1134

Views that use a particular subset

Hi, I am sure the gurus will already know this but I had been looking for a way to locate a view that is using a subset that I wanted to delete. There is a DOS command that can help:- FindStr /si "NameOfYourSubset" *.vue > YourOutputFile.txt if you execute this in a DOS CMD window, probably after ma...