Search found 109 matches

by iansdigby
Wed Jul 18, 2012 9:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SKIPCHECK in inter-cube FEEDER only rule?
Replies: 3
Views: 2319

Re: SKIPCHECK in inter-cube FEEDER only rule?

Thanks for the feedback all. asutcliffe, there isn't any reason for me to avoid putting skipcheck in: I was just posing the question: - out of interest because I couldn't see the logic one way or the other - because I wanted to eliminate that as a possible reason for some issues I am working through...
by iansdigby
Wed Jul 18, 2012 9:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SKIPCHECK in inter-cube FEEDER only rule?
Replies: 3
Views: 2319

SKIPCHECK in inter-cube FEEDER only rule?

Does anyone know the answer to this? I would be grateful for guidance.

In a rule which has no statements other than an inter-cube feeder, is "SKIPCHECK" still required?

Regards, Ian
by iansdigby
Mon Jun 25, 2012 4:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DBS formulae issues
Replies: 2
Views: 2736

Re: DBS formulae issues

Ah Mr Kirk, something had indeed changed in my similarly problematic sheet.
Danke
by iansdigby
Fri Jun 22, 2012 12:04 pm
Forum: Enhancements
Topic: If You Could ask the TM1 Development Team a Question.......
Replies: 81
Views: 82798

Re: If You Could ask the TM1 Development Team a Question....

I would say dedicate a full release to UI enhancements/corrections. For example: 1. Fix the copying and pasting behaviour in the Advanced Rules Editor and the TI editor (and doubtless elsewhere) to match the Windows standards. 2. Fix drop-downs (e.g. TI Variable type, Pick Lists and doubtless in oth...
by iansdigby
Wed Apr 25, 2012 10:42 am
Forum: Useful code, tips and tricks
Topic: Visio OLAP stencils
Replies: 0
Views: 9237

Visio OLAP stencils

Found a great set of free Visio stencils for diagramming cubes & dimensions etc. Go to here: http://www.symcorp.com/tech_expertise_design.html and click "Free ADAPT Visio Stencil" I haven't got round to using them in earnest yet but the shapes look good. You get cube, dimension , attri...
by iansdigby
Thu Apr 19, 2012 8:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Strange dimension corruption
Replies: 4
Views: 2558

Re: Strange dimension corruption

Could someone have accessed the dimension via an .xdi file, illegitimately or accidentally, and overwritten it without your realising?
by iansdigby
Tue Mar 20, 2012 8:15 am
Forum: Enhancements
Topic: If You Could ask the TM1 Development Team a Question.......
Replies: 81
Views: 82798

Re: If You Could ask the TM1 Development Team a Question....

"Have you ever tried to persuade the IBM customer support web site development team to socialise with real humans more often? That way we might get a web experience that approaches user-friendliness."

Ian
by iansdigby
Mon Mar 19, 2012 4:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI two dimensions into one
Replies: 8
Views: 4183

Re: TI two dimensions into one

To Kamil,

Utterly brilliant and much appreciated.

Thank you

Ian
by iansdigby
Mon Mar 19, 2012 4:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI two dimensions into one
Replies: 8
Views: 4183

TI two dimensions into one

Greetings all, Could anyone kindly help please with this: I have a cube containing accounting data, that I wish to pump into another cube. For example: In Cube 1, the value £10 is located at the conjunction of Cost Centre "110" and Expense Code "225" In Cube 2, the same value nee...
by iansdigby
Thu Feb 09, 2012 12:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Input spreadsheet errors
Replies: 0
Views: 2434

Input spreadsheet errors

We have a spreadsheet stored in a TM1 Application folder with an Active Form and lots of DBRW in it. In certain circumstances, opening more than one instance of the same spreadsheet concurrently results in the latterly opened instances having missing data. Sometimes the DBRWs are still there but not...
by iansdigby
Thu Jan 26, 2012 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Data validation bug in 9.5.2?
Replies: 1
Views: 1677

Excel Data validation bug in 9.5.2?

Has anyone else seen this issue? In an Excel sheet, we have a cell with a TM1 DBRW formula and also an Excel custom Data Validation which points to a list on another worksheet. In TM1 9.5.1 this scenario works fine; in TM1 9.5.2 it returns "TM1 Error". We reproduced this repeatedly so it i...
by iansdigby
Mon Jan 23, 2012 11:43 am
Forum: Enhancements
Topic: If You Could ask the TM1 Development Team a Question.......
Replies: 81
Views: 82798

Re: If You Could ask the TM1 Development Team a Question....

Or, you could use WordPad if you want to be able to actually see the text and punctuation (such as the comma that looks like a period, but isn't or vice versa) on a high resolution screen because the code, in its unchangeable and small font, is reduced to microdots. Heartily agree.It is also frustr...
by iansdigby
Mon Jan 23, 2012 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory bloat issue
Replies: 6
Views: 3398

Re: Memory bloat issue

Thanks to all who took the trouble to post a reply. Whilst never solving the original problem, I worked around it as follows: 1. In the Proglog code, unload the }ElementAttributes cube using CubeUnload() 2. In the Data code, populate the attributes: TM1 then automatically loads the }ElementAttribute...
by iansdigby
Tue Jan 10, 2012 1:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why duplicate elements
Replies: 3
Views: 2456

Re: Why duplicate elements

Alan and Christoper,
Thank you both for taking the trouble to reply and for so succinctly and brilliantly explaining this. Now I understand!
Regards, Ian
by iansdigby
Tue Jan 10, 2012 12:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory bloat issue
Replies: 6
Views: 3398

Memory bloat issue

I have a weird issue with some memory doubling itself each time a TI process is run. The process builds a dimension with 15,000 elements and 4 attributes. The Dimension attributes are created each time: ATTRDELETE('BI_LabBk_JobNo','BkType'); ATTRINSERT('BI_LabBk_JobNo','','BkType','S'); ATTRDELETE('...
by iansdigby
Mon Dec 19, 2011 8:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why duplicate elements
Replies: 3
Views: 2456

Why duplicate elements

One thing has puzzled me since we got TM1. When creating a dimension hierarchy, why should elements be created at the N level as well as being created as children of their parent? See below for example. Does this not result in the unnecessary duplication of dimension elements? Am I missing something...
by iansdigby
Mon Dec 19, 2011 8:46 am
Forum: Enhancements
Topic: If You Could ask the TM1 Development Team a Question.......
Replies: 81
Views: 82798

Conditional formatting

The one thing we all want here is the ability to colour a cell e.g. red when negative, within the cube viewer. So, conditional formatting please a la Excel?
by iansdigby
Fri Sep 16, 2011 7:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is TM1 concurrent licensing honour-based?
Replies: 8
Views: 4664

Is TM1 concurrent licensing honour-based?

Hello fellow TM1-ers. I have two questions, any answers to which would be highly appreciated (what else can I say to justify asking for free information? I love you all! - no wait, that sounds even worse...): 1. When the number of people logged on equals the number of your licensed concurrent users ...
by iansdigby
Wed Dec 15, 2010 9:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Citrix/Terminal Services
Replies: 5
Views: 3467

Re: Citrix/Terminal Services

You may find this information useful. Our busiest user found the TM1 9.4.1 client too slow to work remotely over a VPN, so he used TM1 over Citrix and found this very acceptable. However, the 9.5.1 client seems to work much faster than 9.4.1, making this a feasible option without using Citrix. Not s...
by iansdigby
Thu Apr 15, 2010 9:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating TM1 Objects in C# and ASP.NET
Replies: 20
Views: 148854

Re: Creating TM1 Objects in C# and ASP.NET

I am just now getting in to the TM1 .NET API and would deeply appreciate any tutorials Brandon or anyone else is generous enough to post here. Actually quivering with anticipation at the possibilities of the (TM1 API + .NET + MDX) package.
Regards
Ian Digby