Search found 711 matches

by paulsimon
Mon Sep 16, 2019 10:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Working with dimension Leaves
Replies: 4
Views: 342

Re: Working with dimension Leaves

@Lotsaram What I was getting at is that from what I have seen TI functions such as DimensionElementInsert operate on the Main Hierarchy, or the Default Hierarchy, what most of us think of as the traditional dimension, but of course, the idea of a traditional dimension goes as soon as you introduce a...
by paulsimon
Sun Sep 15, 2019 11:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Working with dimension Leaves
Replies: 4
Views: 342

Re: Working with dimension Leaves

Hi When using Real Named Hierarchies, any of the Dimension TI Functions actually apply to the Main aka Default Hierarchy of the Dimension - What we traditionally think of as the Dimension. So I would guess that what you are seeing is that DimensionDeleteAllElements is clearing all elements from the ...
by paulsimon
Fri Sep 13, 2019 1:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source
Replies: 7
Views: 538

Re: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source

Hi

Just an update on this. We have now got data coming in the correct columns. However, the problem is now that any text attribute values are being read in as numbers instead of as text. IBM have re-produced this and are investigating.

Regards

Paul Simon
by paulsimon
Tue Sep 10, 2019 6:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source
Replies: 7
Views: 538

Re: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source

Hi Wim

Thanks for the offer but we should have our own test server with 2.0.8 up in a week or so.

I have referred the issue over to IBM.

Regards

Paul Simon
by paulsimon
Mon Sep 09, 2019 7:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source
Replies: 7
Views: 538

Re: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source

Hi Lotsaram

Maybe it is because we are on 2.0.5 and you are on a later version, but that is not what is happening. It is reading the view with columns across, and not reading it as though it was a ViewExtract.

Regards

Paul Simon
by paulsimon
Mon Sep 09, 2019 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source
Replies: 7
Views: 538

Re: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source

Hi Lotsaram The problem with having the hierarchy or ElementAttributes on columns is that you then have a variable number of columns coming in to the TI. I want to create something re-usuable so it can be used against any dimension hierarchy all of which can have different numbers of attributes. So ...
by paulsimon
Mon Sep 09, 2019 10:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX View with Hierarchy on }ElementAttributes cube as TI Data Source
Replies: 7
Views: 538

MDX View with Hierarchy on }ElementAttributes cube as TI Data Source

Hi I want to read all attribute values from the consolidated members of a Named Hierarchy. I understand that the only way to create a source view for a TI process that references Named Hierarchies in one or more dimensions is to use an MDX View. I can generate the MDX easily enough to show this in P...
by paulsimon
Thu Sep 05, 2019 9:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA upgrade & TM1Web reports not working
Replies: 4
Views: 450

Re: PA upgrade & TM1Web reports not working

Hi Jed In Server Explorer, go to the Applications folders, right click on a folder, and select Convert Excel files to Open XML format. In theory this converts old xls to xlsx, but in practice it does other things as well that might cure your issue. It does operate on xlsx files even though the docum...
by paulsimon
Mon Sep 02, 2019 9:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA upgrade & TM1Web reports not working
Replies: 4
Views: 450

Re: PA upgrade & TM1Web reports not working

Hi Jed We have Charts that are working in TM1 Web on Planning Analytics 2.0.5. We upgraded from 10.1.1 so that was an even more radical upgrade than from 10.2. You might want to try running the workbook upgrade utility again. We found that it does not always work. We also found that it does more tha...
by paulsimon
Wed Aug 28, 2019 9:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives Ribbon Missing on Excel 2016 (Office 365)
Replies: 1
Views: 1209

Re: Perspectives Ribbon Missing on Excel 2016 (Office 365)

Hi One thing you could try is renaming the TM1PRibbon.xlam file to add a .DISABLED to the end and then restart. If you get an Add Ins Menu showing in the Ribbon, then check to see if you can access TM1 from that. At our site we gave up trying to use the Ribbon years ago and only use this method now,...
by paulsimon
Thu Aug 08, 2019 9:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ATTRPUTS much slower on Planning Analytics vs 10.2.2
Replies: 6
Views: 618

Re: ATTRPUTS much slower on Planning Analytics vs 10.2.2

Hi It looks like your problem is more related to feeders However, I have seen cases where using CellPutS to the }ElementAttrbutes cube can be faster than AttrPutS to the Dim. One other thing to check is whether you have turned off logging on the }ElementAttributes cube during the update as logging w...
by paulsimon
Wed Aug 07, 2019 11:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 2351

Re: automation import users from active directory

@Drg I am not clear as to whether you don't use AD Groups at all, or whether you use a mix of AD and TM1 Groups. Either way it doesn't matter since the main issue in your question is about creating the users, which you can do in the manner that I described. I don't know how you then decide which TM1...
by paulsimon
Wed Aug 07, 2019 10:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 2351

Re: automation import users from active directory

@Drg The CAMID is definitely related to an ID in Active Directory. Check an existing TM1 user that has signed in via CAM. Look at their CAMID, and then go to Active Directory and look at their profile, and you should be able to match the CAMID number to one of the IDs there. The number in the CAMID ...
by paulsimon
Tue Aug 06, 2019 8:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: automation import users from active directory
Replies: 18
Views: 2351

Re: automation import users from active directory

Hi You can import the AD Groups from Server Explorer. If you are using CAM then the Users are automatically created and assigned to Groups according to their AD profile when they first sign in, but the Groups must be created first. Not sure how many Groups you need to create. The standard default in...
by paulsimon
Fri Aug 02, 2019 7:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Web File upload
Replies: 2
Views: 186

Re: Tm1 Web File upload

Hi The file upload facility you will need to do yourself. A bit of googling should provide an answer. JavaScript is an option. C# with ASP.Net is another option. We use a hyperlink function on our TM1 Web Sheets to launch this and to pass params to the upload facility. The upload actually goes to an...
by paulsimon
Fri Jul 26, 2019 8:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Display message in TM1 web
Replies: 7
Views: 351

Re: Display message in TM1 web

Hi

Not sure if it will work, but try the process completion message instead of the confirmation message

Paul
by paulsimon
Fri Jul 26, 2019 8:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replace an element with same name and different case
Replies: 7
Views: 416

Re: Replace an element with same name and different case

Hi Declan I was thinking along the same lines with swapping the alias. However, a potential problem is that TM1 will not store the capitalised alias because it will think that it is the same as the element name. Therefore it will probably be necessary to swap the alias to a completely different name...
by paulsimon
Thu Jul 25, 2019 9:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Display message in TM1 web
Replies: 7
Views: 351

Re: Display message in TM1 web

Hi If you want a message to display when the user clicks the button to run the process, you can tick the box for a confirmation message in the Action Button and then override the standard confirmation message by entering a formula as = Range Name, and then you put the message you want to display in ...
by paulsimon
Wed Jul 24, 2019 9:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SaveDataAll PA 2.06 Deadlocks
Replies: 4
Views: 333

Re: SaveDataAll PA 2.06 Deadlocks

Hi If your system does not need to be up 24 hours a day, then you could do something similar to our approach. We use a Windows Scheduled Task which needs to run under an Admin Profile with Highest Privileges. This task runs a DOS Batch File. The Batch File checks to see if the TM1 Service is running...
by paulsimon
Tue Jul 23, 2019 9:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SaveDataAll PA 2.06 Deadlocks
Replies: 4
Views: 333

Re: SaveDataAll PA 2.06 Deadlocks

Hi Neil You said that the SaveDataAll is in a process by itself, but is that process being called by other processes? If there is a top level process then any locks obtained by it or other processes that it calls will only be released when the top level process completes. I would recommend putting t...