Search found 578 matches

by paulsimon
Sat Jun 16, 2018 10:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Public Subset Alias Turned Off After Dimension Rebuild
Replies: 4
Views: 331

Re: Public Subset Alias Turned Off After Dimension Rebuild

Hi If you look at the subset - has the Alias switch actually been turned off, or is it the case that the Alias switch is still set to show Aliases, but the Aliases are not present? If it is the former then the dim build must have re-created the subset and not used SubsetSetAlias to assign the Alias....
by paulsimon
Wed Jun 06, 2018 8:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Checking Element Level Security in a TI processes
Replies: 6
Views: 239

Re: Checking Element Level Security in a TI processes

Hi I have used some other approaches to do this. a) Have a Security Group per user. Then you don't get the issue since you can just add eg '-Grp' to the user name to get the name of their group and then check from the }ElementSecurity cube whether they have access to the Entity, Cost Centre or whate...
by paulsimon
Mon May 21, 2018 9:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error on view creation
Replies: 7
Views: 286

Re: Error on view creation

Hi Sorry I cannot help you with Performance Modeler. I don't know anyone who uses it. However, if you have a Production environment then presumably you have a Development environment and a mechanism for copying in changes from Development to Production. If you can use Architect in the Development en...
by paulsimon
Mon May 21, 2018 9:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Block TM1 usage during upgrade / migration
Replies: 3
Views: 230

Re: Block TM1 usage during upgrade / migration

Hi In our case, all the security in the main security cubes such as }CubeSecurity and }ProcessSecurity is rule derived. We find that this is easier to manage when it comes to promoting changes than promoting data values such as READ, etc. We then have a central control cube with a flag for Make TM1 ...
by paulsimon
Tue May 08, 2018 8:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 web active form speed issue
Replies: 5
Views: 333

Re: TM1 web active form speed issue

Hi Mark If you do pull budget to the actuals cube and the actuals cube has more dimensions, then if you use rules, you want to avoid feeding from one to many. Therefore I would suggest that you adopt the _Input idea and for other dimensions pick one element to which you are going to feed. Depending ...
by paulsimon
Sun May 06, 2018 6:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In pop up window - After successful login into Cognos BI redirect to c# application
Replies: 7
Views: 506

Re: In pop up window - After successful login into Cognos BI redirect to c# application

Hi Kavita It is possible because at one client where they used a version of SiteMinder for authentication we brought in an IBM consultant to get the connection via CAM. However, it took him a few days to get it working. So yes this sort of thing is possible, but I am not sure that it is that well do...
by paulsimon
Sat May 05, 2018 6:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 web active form speed issue
Replies: 5
Views: 333

Re: TM1 web active form speed issue

Hi Mark I think your fundamental issue is that your active form is based on your actuals cube. You might somehow be referencing budget but it won't be efficient. I would suggest a rule in the budget cube that pulls data up from the actuals cube to its own, presumably more summarised level. We do som...
by paulsimon
Sat May 05, 2018 11:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation help
Replies: 17
Views: 2041

Re: PAW installation help

Hi At present the server only has 8GB so I cannot use the default of 8GB for Docker. I was trying with 4GB but that still will not work. I have persuaded the client to buy another 8GB of RAM. When this arrives and gets installed I will try again but given the lead times at this client that might be ...
by paulsimon
Thu May 03, 2018 11:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation help
Replies: 17
Views: 2041

Re: PAW installation help

Hi Sorry this is very long. I am hoping that there is someone out there who is curious enough to try to diagnose the problem. I upped the memory to be allocated to the virtual machine to 4096MB ie 4GB. I then got This machine has been allocated an IP address, but Docker Machine could not reach it su...
by paulsimon
Thu May 03, 2018 10:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation help
Replies: 17
Views: 2041

Re: PAW installation help

Hi Thanks for replying 4GB seems very excessive for what is supposedly a cut down operating system. Windows Server itself only takes about 1.5 GB. I did have PAW Admin Tool running at one time and was able to specify the FQDN but now it won't run. I suspect that the problem is related to some sort o...
by paulsimon
Wed May 02, 2018 10:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation help
Replies: 17
Views: 2041

Re: PAW installation help

Hi The things I am reading on here are scary. Why do we suddenly need to become network engineers just to get a piece of software running? I don't know anyone who uses TM1 on anything other than a Windows server so why did we need Docker in the first place. From searching the internet lots of people...
by paulsimon
Sat Apr 28, 2018 5:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Putting Expand function to a good use
Replies: 11
Views: 3687

Re: Putting Expand function to a good use

Hi An alternative to this approach that I have used in the past is to make the levels conform to a Child-Parent format in SQL. This can be done by UNIONing distinct pairs of each of the levels. The advantage of this approach is that you can then use one generic TI process to build the hierarchy for ...
by paulsimon
Thu Apr 19, 2018 9:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Direct version of dimension updates
Replies: 5
Views: 398

Re: Direct version of dimension updates

Hi Steve I have probably not gone into it as much as Kamil, but I seemed to get away without putting the DimensionUpdateDirect statement in the Epilog. We had rules for currency conversion so I think we would have noticed if rules were not working correctly. I left the DimenionUpdateDirect to the ov...
by paulsimon
Wed Apr 18, 2018 7:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Direct version of dimension updates
Replies: 5
Views: 398

Re: Direct version of dimension updates

Hi Steve I haven't noticed any performance issues in using them. However, I have never left things go that long without a conventional update. At one client they had a cube with two large dimensions of over 100,000 elements. There were data loads running several times a day and any new elements need...
by paulsimon
Wed Apr 04, 2018 9:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add new dimension to existing cube
Replies: 5
Views: 462

Re: Add new dimension to existing cube

Hi This is potentially quite a lot of work as you will see below. The amount of work will depend on how much you have built on top of the existing cube. Firstly consider whether you can accommodate the new split by an alternate hierarchy in an existing dimension, or whether there are unused dimensio...
by paulsimon
Sun Mar 18, 2018 11:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Model setup
Replies: 2
Views: 404

Re: Model setup

Hi I couldn't tell what varies month by month so I have assumed that the number of units is the number of units in use and that this and the Building's Monthly Admin Fee per Unit that can vary over time. Firstly, don't have separate year and month dimensions. Just have a single time dimension with m...
by paulsimon
Mon Mar 12, 2018 10:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Improve TI Processing Time
Replies: 8
Views: 852

Re: Improve TI Processing Time

Hi Does your source view have all three skips? Particularly if it is not skipping Consol values then performance may be slow. It is often better to read from base level data and accumulate using CellIncrementN My guess would be that the Source View will not be built if there is nothing on the Data T...
by paulsimon
Fri Mar 02, 2018 6:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HierarchyProperties
Replies: 5
Views: 513

Re: HierarchyProperties

Hi Jorge

You are naming the level in the hierarchy within the dimension. The dimension is what you select in }Dimensions which is one of the dimensions of the }HierarchyProperties cube.

This level name will appear in Cognos Analytics previously known as Cognos BI.

Regards

Paul Simon
by paulsimon
Thu Mar 01, 2018 11:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: HierarchyProperties
Replies: 5
Views: 513

Re: HierarchyProperties

Hi

Is the problem possibly more related to alternate hierarchies in the TM1 dimension, which means that level naming can vary according to which alternate hierarchy you are viewing the element in?

Regards

Paul Simon
by paulsimon
Thu Mar 01, 2018 5:16 pm
Forum: Useful code, tips and tricks
Topic: Recovering when an N element has been made a consol
Replies: 5
Views: 707

Recovering when an N element has been made a consol

Hi We had a situation today where some old code meant that our base level Balance Sheet Cost Centre had another element inserted under it making it a consolidation and we lost all our Balance Sheet data. To recover I did the following a) Amended the process to get the Balance Sheet element back to a...