Search found 648 matches

by paulsimon
Tue Dec 04, 2018 11:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Database Insert
Replies: 4
Views: 646

Re: Database Insert

Hi Here is some sample TI # Delete Bad Character from line vText = ; vBadCh = '' ; vPos = Long( vText ) ; WHILE( vPos > 0 ) ; vPos = vPos - 1 ; vCh = subst( vText , vPos , 1 ) ; IF( vCh @= vBadCh ) ; vText = DELET( vText , vPos , 1 ) ; ENDIF ; END ; # Replace Character in line vText = ; vFindCh = '/...
by paulsimon
Tue Dec 04, 2018 11:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: One vs Two Time Dimensions
Replies: 8
Views: 540

Re: One vs Two Time Dimensions

Hi Be very careful about upgrading if you are short on RAM. PA can easily use 50 to 100%+ more than it did in previous versions. I have used a single time dimension for many years. This is because I have spent a lot of time working in insurance which needs time dimensions with different meanings suc...
by paulsimon
Tue Dec 04, 2018 11:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetFilterBySecurity - Rule [threads/tm1top]
Replies: 2
Views: 82

Re: SubsetFilterBySecurity - Rule [threads/tm1top]

Hi Can't say for sure by I would guess that you have rules in an }ElementSecurity cube, that vary the security rights to see elements in the dimension by Security Group. This implies that it is taking a while to evaluate these rules so that it can filter down the list of elements that it will show a...
by paulsimon
Thu Nov 15, 2018 11:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX using OR
Replies: 5
Views: 375

Re: MDX using OR

Hi While you can do this using MDX to reference another cube, this can get fairly complex. Another approach is as follows: Add an attribute to the time dimension eg Curr or Prev Year (Y/) Then add a Rule in the }ElementAttribute_<dimension> cube that references the control cube and sets either a Y o...
by paulsimon
Mon Nov 12, 2018 10:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Top does not cancel process while waiting Database - Batch Process
Replies: 3
Views: 349

Re: TM1Top does not cancel process while waiting Database - Batch Process

Hi For info, TM1Top (or for that matter Ops Console) can only cancel a process after the current API call has been completed. Check the TM1 API documentation for a list of API functions. In this case it is probably TM1ProcessExecuteSQLQuery. Since the SQL that you send is all getting executed within...
by paulsimon
Sat Nov 03, 2018 10:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to programmatically open files from Application folder
Replies: 9
Views: 1043

Re: How to programmatically open files from Application folder

Hi Ashleigh It depends on what you are trying to do. If you are able to run your VBA on the TM1 Server itself, then the simplest approach assuming that all files have been uploaded to the server would be to loop though all files in the }Externals folder under the main cubes folder. If you want to do...
by paulsimon
Fri Nov 02, 2018 10:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HierarchySubsetElementDelete odd behavior
Replies: 4
Views: 545

Re: HierarchySubsetElementDelete odd behavior

Hi I haven't tried it but RefreshMdxHierarchy(dimensionName, hierarchy) might be an alternative. I suspect that what Michel says is right. The two statements that you have added force the MDX to be evaluated to populate the subset. We used to have to put in an RefreshMDXHierarchy(Dim) to get BI Repo...
by paulsimon
Thu Nov 01, 2018 10:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Retaining lock on file
Replies: 3
Views: 343

Re: TI Retaining lock on file

Hi We encountered some similar sounding issues during our upgrade to PA 2.0.5. Because our Server operating system was also old, at the same time we upgraded to Windows Server 2016. We had repeated problems with files being locked. We eventually traced this to an erroneous implementation of User Acc...
by paulsimon
Wed Oct 31, 2018 12:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube }StatsByProcess - any documentation?
Replies: 1
Views: 259

Re: Cube }StatsByProcess - any documentation?

Hi The downside that most of us find with turning on the population of the }Stats cubes is that it does add quite a performance overhead to the system so I would do this on the Dev server but probably not Production and even then only to investigate a particular issue. Unfortunately there is no way ...
by paulsimon
Tue Oct 30, 2018 11:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 807

Re: ViewZeroOut with Hierarchies in PA2.0

Hi So you have mentioned two reasons a) historic hierarchies b) scenario planning Another case might be c) Like for like sales in retail. However, that would typically be a subset of all stores, eg only those stores that were open this year and last year. For maintaining past hierarchies at one clie...
by paulsimon
Tue Oct 30, 2018 10:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchies and element attributes
Replies: 4
Views: 334

Re: Hierarchies and element attributes

Hi Just to confirm - I tried an experiment. I created an extra ByWD hierarchy on the model dimension in SDATA and built a hierarchy according to whether the description had 2WD, 4WD or something else. I then created an Attribute 'Wheels' using ElementAttrInsert, which requires a Hierarchy parameter....
by paulsimon
Mon Oct 29, 2018 10:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 807

Re: ViewZeroOut with Hierarchies in PA2.0

Hi From my thinking, I tend to agree with lotsaram. I cannot see why you would want to have leaf level elements that only exist in a Hierarchy. I am genuinely interested to know what advantage that gives you? I think that Hierarchies are still quite new to most of us and aren't necessarily deliverin...
by paulsimon
Mon Oct 29, 2018 10:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: subnm with variable overriden
Replies: 7
Views: 395

Re: subnm with variable overriden

Hi

I think you are going to need to explain a lot more about what you are doing before anyone can help you.

Regards

Paul Simon
by paulsimon
Mon Oct 29, 2018 10:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchies and element attributes
Replies: 4
Views: 163

Re: Hierarchies and element attributes

Hi Try HierarchyAttrPutS and see if that works better. I haven't tried it myself though. I am still sticking with the approach of having the same value in all hierarchies for the same element. Having different attributes for the same element in different hierarchies seems to me like it could cause s...
by paulsimon
Sun Oct 28, 2018 8:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewZeroOut with Hierarchies in PA2.0
Replies: 17
Views: 807

Re: ViewZeroOut with Hierarchies in PA2.0

Hi I am not sure why you need to build an Other Elements consolidation. If you can identify the base level elements of the hierarchy, then you can just use those elements to directly build a subset on the main dimension and use that in ViewZeroOut. Having said that, the approach that I currently int...
by paulsimon
Thu Oct 25, 2018 6:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to change port numbers in tm1
Replies: 6
Views: 272

Re: How to change port numbers in tm1

Hi The previous post gave the answer as to how to change the port numbers. However, you said that your servers are going down. Does that mean crashing or failing to start up? The unable to listen on port X may be a symptom of your problem rather than the cause. Eg are your servers running out of mem...
by paulsimon
Sat Oct 20, 2018 7:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0 - TM1Web reboot
Replies: 5
Views: 291

Re: PA 2.0 - TM1Web reboot

Hi For your original question, assuming you are using Windows, you can also go to Services and it is the Service called IBM Cognos TM1. Why IBM couldn't have called it IBM Cognos TM1 Web I don't know. The advantage is that getting into Services is a lot quicker than getting in to IBM Cognos Configur...
by paulsimon
Thu Oct 18, 2018 8:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule to find Leaf Level of all dimensions in cube
Replies: 3
Views: 170

Re: Rule to find Leaf Level of all dimensions in cube

Hi

The leaf level is always level 0. Do you actually mean the maximum number of levels in each dimension? Please bear in mind that dimensions don't necessarily have the same number of levels in each leg of the hierarchy

Regards

Paul Simon
by paulsimon
Wed Oct 17, 2018 8:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 100% Stacked Bar Chart based on Active Form?
Replies: 3
Views: 233

Re: 100% Stacked Bar Chart based on Active Form?

Hi macsir Not sure if you have already answered your own question. We had similar issues with a Waterfall chart. However, as the user only wanted to see the Top 6, we recorded MDX for this and then pasted it in to Excel and concatenated in the appropriate variables, and used this in the Active Form....
by paulsimon
Wed Oct 17, 2018 8:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monthly forecast phasing
Replies: 2
Views: 259

Re: Monthly forecast phasing

Hi Sorry but I am with Lotsaram on this. You need to provide more information on what you are trying to do eg cubes and dimension elements. It is certainly possible. If I understand you correctly, this seems to be a rather unusual phasing requirement. It would be more usual to forecast a full year f...