Search found 757 matches

by paulsimon
Thu Oct 08, 2020 9:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Asymmetric Views with MDX
Replies: 1
Views: 85

Re: Asymmetric Views with MDX

Hi

You can create an MDX View in TI.

Start by looking at the MDX for the Asymmetric Axis in PAX. Copy the MDX and then work out how to generate it in TI. It is just a text processing job.

Regards

Paul Simon
by paulsimon
Fri Sep 25, 2020 8:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX views, where / how are they evaluated?
Replies: 6
Views: 285

Re: MDX views, where / how are they evaluated?

Hi Steve What I am wondering is whether the MDX is doing all the Cross Joins and then only applying the NONEMPTY at the end. I use a slightly different form SELECT NON EMPTY CROSSJOIN( {[actvsbud].[Actual],[actvsbud].[Budget] }, { [month].[Jan],[month].[Feb] } ) on columns FROM PNLCube I haven't exp...
by paulsimon
Thu Sep 10, 2020 8:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Free Excel-to-Text converter
Replies: 20
Views: 2538

Re: Free Excel-to-Text converter

Hi I think I hit a similar problem with the quotes recently. I traced the problem to the fact that when you output a string from textoutput/asciioutput it will always enclose that string in double quotes so if you put double quotes around every bit of text it doesn't work. The answer is just to omit...
by paulsimon
Mon Aug 24, 2020 9:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA Cubes recalculating different values
Replies: 1
Views: 323

Re: PA Cubes recalculating different values

Hi I have not seen this in a cube that has no rules. One possible cause might be that the formatting that gets applied can vary depending on the position of the dimensions. Do you possibly have formatting in the Version dimension on a Variance Ratio as well as on the Measures dimension? Could this p...
by paulsimon
Wed Aug 05, 2020 6:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Spreading customisation
Replies: 2
Views: 242

Re: Spreading customisation

Hi This probably only answers part of your question, but you can control spreading as follows : In Architect/Perspectives, Right click on the Server and select Capability Assignments. You can Grant or Deny the right to Consolidation TypeIn Spreading by Group. I am not sure what else you are trying t...
by paulsimon
Wed Jul 29, 2020 8:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subnm index change
Replies: 6
Views: 422

Re: Subnm index change

Hi So there is a M:N between Entity and Branch. However, you could still create an Entity_Branch dimension. That would then allow you have a dimension where a Branch could be linked to more than one Entity and you could then use the expand approach. If you are more familiar with TI than VBA that mig...
by paulsimon
Wed Jul 29, 2020 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subnm index change
Replies: 6
Views: 422

Re: Subnm index change

Hi I think what you are actually trying to do is some sort of cascading selection, so the user looks up the Entity, in the Entity dimension and then looks up Branches related to that Entity in the Branch dimension and picks a Branch. Is that you are trying to do? The problem that you are seeing is a...
by paulsimon
Wed Jul 29, 2020 5:12 pm
Forum: General
Topic: Amazon Interview
Replies: 1
Views: 1019

Re: Amazon Interview

Hi I have just spent most of my last two days interviewing candidates (not for Amazon), however, I would guess that Amazon follow a similar process. There are only so many questions that they can ask, and if they published those there is a chance that someone could look up the answers in advance, me...
by paulsimon
Mon Jul 13, 2020 9:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web Websheet Snapshot to Excel taking too long
Replies: 2
Views: 340

Re: TM1Web Websheet Snapshot to Excel taking too long

Hi Yes we have the same issue. We deploy Perspectives via Citrix and tell our users to export any big sheets using that. TM1 Web was built for small data capture sheets, not big exports. You might want to make sure that they aren't ticking any boxes in TM1 Web and effectively generating a print repo...
by paulsimon
Fri Jul 10, 2020 6:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning & Analytics Local Server Startup
Replies: 3
Views: 289

Re: Planning & Analytics Local Server Startup

Hi You can start a Local Server for development purposes, if that is all you want? You probably won't be able to use Performance Modeler against it, but you can use Perspectives and Architect. I tend to agree with the previous poster - don't use Performance Modeler. AFAIK IBM are going to drop it an...
by paulsimon
Wed Jul 01, 2020 8:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 20
Views: 3892

Re: Automating TM1 in VBA

Hi Wim Looking at my code the key thing is that for the VBS to work you need to have the following folder C:\Windows\SysWOW64\config\systemprofile\desktop Below is some DOS Batch that creates this if it doesn't exist. We found that it worked better to get the TI to run a DOS Batch (.BAT) file which ...
by paulsimon
Tue Jun 30, 2020 10:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automating TM1 in VBA
Replies: 20
Views: 3892

Re: Automating TM1 in VBA

Hi Wim I will have a look tomorrow. We have the following working as part of our system a) TI Process uses ExecuteCommand to run a DOS Batch b) The DOS Batch runs a VB Script c) The VB Script opens an Excel .xlsm and runs a macro, passing parameters In our case, the macro only merges a CSV file outp...
by paulsimon
Tue Jun 30, 2020 10:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Experience with PAW and its future prospects
Replies: 12
Views: 1229

Re: Experience with PAW and its future prospects

Hi I would agree with the comment about the usefulness of Named Hierarchies. However, I use PAX for that rather than PAW because I find it easier to use, apart from the issue of half the buttons not showing in the Set Editor, which is still an issue in 2.0.9. Some people have this issue and some don...
by paulsimon
Thu Jun 18, 2020 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Millennium Bug
Replies: 8
Views: 750

Re: Millennium Bug

Hi Jim That was just an example - the important thing is the conversion factor. Date serial numbers in Excel start at 1900, and in TM1 they start at 1960. That conversion factor of - 21916 is the number of days different between 1st Jan 1900 and 1st Jan 1960. I suspect that you might be hitting a pr...
by paulsimon
Thu Jun 18, 2020 8:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Millennium Bug
Replies: 8
Views: 750

Re: Millennium Bug

Hi Jim I am not sure that I understand the point you are making and I haven't read your rules but I am wondering if the issue is because of an anomaly between Excel's base date and TM1's base date for date values? # Adjust using Max and Min so we can rely on what goes into Date 1 YYYY-MM-DD being th...
by paulsimon
Sun May 31, 2020 11:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Process Self Triggering
Replies: 10
Views: 1064

Re: TM1 Process Self Triggering

Hi Just as a gut feel, a process that runs for 9 hours seems excessive. Are the processes perhaps reading from a SQL data source that is delivering data very slowly? I have certainly seen cases where concentrating on the data source has brought more benefits than any tinkering with TM1. Are the SQL ...
by paulsimon
Sat May 23, 2020 2:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Synchronise Action Button parameters with Sheet Selections
Replies: 8
Views: 1099

PAW Synchronise Action Button parameters with Sheet Selections

Hi As far as I am aware there is no way to synchronise the parameters to a TI Process on an Action Button with selections made in PAW (short of embedding a Web Sheet which for me anyone defeats the purpose of PAW). For us this is absolutely critical. Without this, we will not be able to do most of t...
by paulsimon
Fri May 22, 2020 10:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 1348

Re: User driven security

Hi Yes a SecurityRefresh is only needed if you have rule driven security in }ElementSecurity cubes or }CubeSecurity. If you use TI there is no need for a SecurityRefresh. Yes Rules in }CellSecurity do not need a SecurityRefresh. Changes take effect immediately. However, in my experience, }CellSecuri...
by paulsimon
Thu May 21, 2020 10:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 1348

Re: User driven security

By the way, the way to avoid the need for a SecurityRefresh is to use ElementSecurityPut. I typically do a CellPutS to the relevant }security cube which keeps the display up to date followed by an ElementSecurityPut which actually makes the security take effect. That way you get edit security for an...
by paulsimon
Thu May 21, 2020 9:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User driven security
Replies: 10
Views: 1348

Re: User driven security

Hi I agree with what the others have said. A complex approach using Cell Security is not the right way to do. Create a Security Group per User. I have done this in the past. It is relatively easy to create a cascading process so that someone who has access to a higher level in the hierarchy automati...