Search found 644 matches

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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...
by paulsimon
Wed Oct 17, 2018 8:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing user when using CAM security
Replies: 4
Views: 249

Re: Removing user when using CAM security

Hi You will need to remove the user from both TM1 and from Active Directory. If you think about it, if you remove a user from AD, how will AD know that that user exists in TM1 to delete them - it is not really in Microsoft's interests to provide support for an IBM product. Similarly if you remove a ...
by paulsimon
Wed Oct 17, 2018 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 BI Package Change
Replies: 2
Views: 113

Re: TM1 BI Package Change

Hi Ajay I have recently needed to create a new TM1 Model/Instance, fortunately the cubes are all the same as an old one. For the old one, I had a data source connection for the packages used by my Report Studio reports which pointed to the old TM1 instance, but I now can't seem to modify these packa...
by paulsimon
Fri Oct 12, 2018 7:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bug with HierarchyAttrPutS
Replies: 4
Views: 136

Re: Bug with HierarchyAttrPutS

Hi I suggest that you try the following in the order given to see if any of them works around this. a) Swap the order of the attrputs and the SubsetCreateByMDX so the AttrPutS comes second b) Do the SubsetCreateByMDX on the Prolog and the AttrPutS on the Epilog c) Put the SubsetCreateByMDX and the A...
by paulsimon
Tue Oct 02, 2018 9:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot Open Application URL Entries in TM1Web
Replies: 6
Views: 258

Re: Cannot Open Application URL Entries in TM1Web

Hi Just to let you know that we have been able to open a TM1 Web Sheet via the URL API in PA 2.0.5 and pass parameters using the Sheet-Row-Column approach. The issue that we had was related to Cognos BI variables rather than the URL API. When we hard-coded in the Entity that we wanted to pass, it wa...