Search found 691 matches

by paulsimon
Tue Jul 16, 2019 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Export Cube data in CSV file, with all Months as columns
Replies: 31
Views: 4789

Re: Export Cube data in CSV file, with all Months as columns

Hi Jorge If by flag you are referring to the cFlag in the 6th post, that is actually nothing to do with getting the 12 months. Read the posts for that. The cFlag is only there to output a heading row. Personally I wouldn't use a c prefix since that implies that it is a constant to be but it is being...
by paulsimon
Sat Jul 13, 2019 10:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM Usage much larger than Cubes
Replies: 3
Views: 179

Re: RAM Usage much larger than Cubes

Hi Mark Have you recently upgraded to PA? If so, it is probably due to MUNs. From memory the topic that I raised on this was called something like Planning Analytics using twice the memory. Do a search and you should find it. Unfortunately there is nothing you can do about it other than buy more RAM...
by paulsimon
Wed Jul 10, 2019 10:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sandboxes in Dynamic Reports?
Replies: 8
Views: 230

Re: Sandboxes in Dynamic Reports?

Hi Garry Not tried it myself but I wonder if the recent ability to view the Sandbox as an additional dimension might be a way around the issue? However, in general i am of the same opinion as you. Neither PAX nor PAW are ready for production use. In particular in PAW until you can select a title ele...
by paulsimon
Thu Jul 04, 2019 9:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX local - Mac install?
Replies: 1
Views: 101

Re: PAX local - Mac install?

Hi

As far as I am aware it is not possible. Perspectives is a windows code base. It won't run on a Mac. If you want to develop on a Mac then one option is to start a Remote Desktop Session on a Windows box.

Regards

Paul Simon
by paulsimon
Thu Jul 04, 2019 9:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder statement cleanup
Replies: 6
Views: 171

Re: Feeder statement cleanup

Hi Memory is only released when you restart the TM1 Service. So delete the feeder files, and restart the TM1 Service. You might find that if you have optiimised your feeders to reduce over-feeding that you no longer need to use feeder files, so you can turn them off. I used feeder files briefly once...
by paulsimon
Sat Jun 29, 2019 3:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Service Access Issues - New Box
Replies: 2
Views: 102

Re: Service Access Issues - New Box

Hi When we upgraded to PA local we also upgraded from Windows Server 2008 to 2016. The UAC (User Account Control) is a lot more aggressive on 2016 than it was on previous versions of WIndows Server. It seems that the IT guys had been a bit over-zealous in locking things down, so even with permission...
by paulsimon
Sun Jun 23, 2019 10:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automated TM1 Regression Testing Framework like nUnit?
Replies: 8
Views: 2618

Re: Automated TM1 Regression Testing Framework like nUnit?

Hi Cathy It looks like you are more interested in comparing Excel workbook reports? If so, then we use a utility to do this. If you are looking at doing regression testing after a version upgrade, then we use the following approach: Start the old and new versions on two different servers with identi...
by paulsimon
Fri May 31, 2019 8:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI Issue
Replies: 11
Views: 486

Re: RunTI Issue

Hi I would check the TM1Server log to see whether the processes are running but failing or whether they are never being run at all. I suggest that you make the process output a last time completed to a cube so that you can tell whether they were run or not. Perhaps make the process that triggers the...
by paulsimon
Fri May 31, 2019 8:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: display Dimension dialog box from TI process
Replies: 3
Views: 193

Re: display Dimension dialog box from TI process

Hi As a side note in PAW the Action Button does prompt you to pick something at the time you click the button if the process has parameters. However, in practice most users prefer to pick the element via something like a SUBNM and then click a button to run the process at a later time. This is becau...
by paulsimon
Mon May 13, 2019 9:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Good Practice on Attributes
Replies: 1
Views: 227

Re: Good Practice on Attributes

Hi I suggest you search this forum on attribute hierarchies. They are probably best regarded as demo-ware. You will be better building hierarchies explicitly using the new TI functions such as HierarchyElementAdd. You essentially follow the same approach that you did with DimensionElementInsert and ...
by paulsimon
Thu May 09, 2019 8:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access denied to cells for non admin users in TI Logs
Replies: 3
Views: 213

Re: Access denied to cells for non admin users in TI Logs

Hi We frequently get this sort of issue. I therefore developed a utility that lets you pick a user, it then works out which groups they are in and then checks the security at cube, dimension, and element level as well as cell security, and also checks for other reasons, such as consolidated cells, r...
by paulsimon
Fri Apr 12, 2019 8:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load
Replies: 9
Views: 556

Re: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load

Hi Paul TM1 You might want to take a look at the IBM Planning Analytics Community (Seems to go by the name Business Analytics but heading is Planning Analytics) https://community.ibm.com/community/user/businessanalytics There have been some recent posts on that related to this. Good luck. It took ou...
by paulsimon
Mon Apr 08, 2019 9:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load
Replies: 9
Views: 556

Re: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load

Hi Paul

If you are making TM1 visible on an External URL then you really should have your own certificate, rather than using the default Applix one.

Regards

Paul SImon
by paulsimon
Sun Apr 07, 2019 11:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: EOMonth Function
Replies: 3
Views: 276

Re: EOMonth Function

Hi You can use pretty much any of the Rule Functions in TI. Look at the Date and Time Rules Functions section of the TM1 Reference Guide. DAYNO will get you the Date Serial Number of a string date which should be in the form YYYY-MM-DD So if you have a date in string format such as '15-06-2019' then...
by paulsimon
Sat Apr 06, 2019 9:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation of Elements
Replies: 1
Views: 197

Re: Consolidation of Elements

Hi If it just a few elements, use the Dimension Editor If there are more elements than that, define the hierarchy in Parent-Child format and save as a CSV file, then import it using a Turbo Integrator (TI) Process. You don't need any coding the wizard in TI will guide you through that. Make the Chil...
by paulsimon
Thu Apr 04, 2019 7:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load
Replies: 9
Views: 556

Re: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load

Hi I have never used contributor since no client has ever wanted the default workflow. However, we also struggled to get TM1 Web to work with an External URL. The documentation misses out a number of steps and ports that need to be opened. I suggest that you raise a PMR with IBM as that was the only...
by paulsimon
Wed Mar 27, 2019 11:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Dimensions
Replies: 9
Views: 814

Re: TM1 Dimensions

Hi As well as CellGetNs you will also need to re-create any views on the cube with the extra dimensions. I have a utility that generates the TI script necessary to create all views on the current cube and then this can be manipulated in Excel to add a reference to the appropriate subset on the new d...
by paulsimon
Mon Mar 25, 2019 11:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security
Replies: 4
Views: 324

Re: TM1 Security

Hi Peter First check that the element is a base level element and not a consolidation. Right click on the cell that you are trying to write to and check that no rules apply to the cell In Perspectives on the View Menu ensure that Display Control Objects is ticked Expand Cubes and look for }ElementPr...
by paulsimon
Tue Mar 19, 2019 10:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1WEB 2.0.6 Number Issue
Replies: 7
Views: 452

Re: TM1WEB 2.0.6 Number Issue

Hi I think what Tom is getting at is that if you have a Web Sheet that is really an Excel Sheet with an Active Form then it will always display values according to the Format Area of the Active Form. Have you just upgraded from a 10.x version to PA? It is possible that the conversion of the web shee...
by paulsimon
Sat Mar 16, 2019 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 11
Views: 1458

Re: Automating TM1 in VBA

Hi Wim

We do a similar thing with a Scheduled Task. Have you ticked the run with Highest Privileges flag? That is equivalent to saying Run as Administrator, which might cure your problem.

Regards

Paul Simon