Search found 162 matches

by asutcliffe
Tue Feb 05, 2013 10:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can't preview SQL data for some columns in TI?
Replies: 8
Views: 1784

Re: Can't preview SQL data for some columns in TI?

Hello Very recently, I encountered a similar issue. Certain columns (3 out of 7 or so) showed up as blank, with a purple background in the Preview window. While the other columns where fine. TM1 presented a helpful popup that it could not interpret certain fields (loosely translated). Database is S...
by asutcliffe
Tue Jan 08, 2013 1:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: cube to cube-Feeder
Replies: 7
Views: 1425

Re: cube to cube-Feeder

simple example: Cube 'cActual' with Dimensions Year, Month, Keys Cube 'cPlan' with Dimensions Year, Keys Cube 'cDistribution' with Dimensions Year, Month, Type Rule in Actual: ['plan']=DB('cPlan', !Year, !Keys)*DB('cDistribution', !Year, !Month, 'typeLinear'); but how to feeder? At first, it's obvi...
by asutcliffe
Tue Jan 08, 2013 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMIX rule calculation
Replies: 5
Views: 1414

Re: DIMIX rule calculation

I'd be wary of using indexes for this. As well as the problem you're facing, indexes can change if changes are made to the dimension. I would suggest using attributes or a simple lookup cube to answer questions like "yesterday's date", "last week's date", "next month's date" etc. It can take a bit o...
by asutcliffe
Thu Dec 06, 2012 2:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: is cell data being deleted by overriding by rules?
Replies: 3
Views: 720

Re: is cell data being deleted by overriding by rules?

I think the precise behaviour depends on your version. At least on my 9.5.2 setup, applying a rule to a cell does delete any data in the cell. In earlier versions, the opposite was true.
by asutcliffe
Tue Nov 27, 2012 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder Issue
Replies: 8
Views: 1884

Re: Feeder Issue

Hi All, When i am trying to copy the data from one version to another using TI Process ...I am able to copy data only for input cells but not for derived cells. I have defined the VIEWEXTRACTSKIPRULEVALUESSET =1 and CellIsUpdateable(Cube, e1, e2 [,...en]) in the TI but still i could not copy or exp...
by asutcliffe
Tue Nov 20, 2012 8:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disagreement between statsbycube and taskmanager
Replies: 2
Views: 939

Re: Disagreement between statsbycube and taskmanager

The }StatsByCube cube shows the memory consumed by cubes only. The total memory used by the server will include other memory consumed by the server, notably TM1's garbage pile. Have a look at Memory In Garbage in the }StatsForServer cube for this. I'd wager that most of the difference you're seeing ...
by asutcliffe
Wed Nov 14, 2012 2:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: redirect Admin host
Replies: 13
Views: 3615

Re: redirect Admin host

You're not using Citrix are you? It sounds a bit like this - http://www.tm1forum.com/viewtopic.php?p=31847.
by asutcliffe
Wed Nov 14, 2012 2:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: redirect Admin host
Replies: 13
Views: 3615

Re: redirect Admin host

(they're identically named so tm1.1 (sales) actually has the same name as tm2.1 (Sales) on admin2, tm1.2 (HR) is also HR on tm2.2...) What I was getting at was that if the client has a list of two admin servers specified, you will see a list of all the tm1 servers registered with those admin server...
by asutcliffe
Wed Nov 14, 2012 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: redirect Admin host
Replies: 13
Views: 3615

Re: redirect Admin host

What is your admin host set to in the client? Is it "admin2" or is something like "admin2; admin1"?
by asutcliffe
Wed Nov 14, 2012 11:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: redirect Admin host
Replies: 13
Views: 3615

Re: redirect Admin host

Hi all, I have two admin servers and would like to take one offline but appear to users to still be online. Lets says admin1 and admin2 are the servers. Each admin server has local TM1 instances running on them. Can I take admin2 offline (along with the TM1 data servers) and then any clients trying...
by asutcliffe
Tue Nov 13, 2012 8:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express Subsets
Replies: 3
Views: 1345

Re: Cognos Express Subsets

Hi Tim,

This sounds as though the problem is with element security rather than the subset. How are your reports built exactly?

Cheers,
Alex

edit: Tim, not Ian. I haven't even started on the wine yet.
by asutcliffe
Fri Nov 09, 2012 6:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: List Account Hierarchy In Excel
Replies: 18
Views: 3588

Re: List Account Hierarchy In Excel

Would it be possible to show me how/what I need to change here to make it happen? Or guide me to a site that would explain it well enough so I should understand it without knowing too much about the MDX language? I would suggest experimenting with the record feature in the subset editor with the ex...
by asutcliffe
Fri Nov 09, 2012 3:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: List Account Hierarchy In Excel
Replies: 18
Views: 3588

Re: List Account Hierarchy In Excel

I think I got my answer. It doesn't look like I can create an active form from a dimension, only from a cube. If that is correct, I will have to go by SUBNM. Thanks everyone for your help! This has taught me a lot! You can create a simple active form from a cube that contains the dimension though. ...
by asutcliffe
Fri Nov 09, 2012 3:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: List Account Hierarchy In Excel
Replies: 18
Views: 3588

Re: List Account Hierarchy In Excel

One major problem here, is that I don't have access to creating public subsets, I just do the reporting, and our "TM1 guy" does the subsets. This might change but we want as little as possible tampering, thus handing it over to one person. The TM1RptRow function (that drives the list of elements in...
by asutcliffe
Fri Nov 09, 2012 3:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension elements selection
Replies: 1
Views: 587

Re: Dimension elements selection

You can only select a single element in a title dimension in a view. As you've said this can be a consolidation element so depending on your requirement, creating some new hierarchies might give you what you want. It sort of sounds as though the dimension in question should be on one of the axes tho...
by asutcliffe
Fri Nov 09, 2012 2:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SecurityRefresh cause restrart TI process
Replies: 5
Views: 1230

Re: SecurityRefresh cause restrart TI process

Hi, I'm afraid I don't really understand what you mean by this: Hello, Community! We got a trouble - we start TI process with SecurityRefresh command in the code, but when this string is executed all process starting from the first string. Has anybody met this issue ever? Maybe you can elaborate or ...
by asutcliffe
Fri Nov 09, 2012 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Text output from TI
Replies: 2
Views: 1341

Re: Text output from TI

There's a discussion of this here - http://www.tm1forum.com/viewtopic.php?f=19&t=516 - including a couple of workarounds.
by asutcliffe
Fri Nov 09, 2012 12:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Reports- Decimals
Replies: 4
Views: 1053

Re: TM1 Reports- Decimals

Hi Yes- It is active form reports. Can use worksheet function of any ? Instead of using decimals places as 0 in format cells in active forms. Please advise Ravi The way to achieve this is to apply formatting properly. Are you changing the number formats in the report's format range or just the form...
by asutcliffe
Fri Nov 09, 2012 9:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Reports- Decimals
Replies: 4
Views: 1053

Re: TM1 Reports- Decimals

Hi, Is there a way to format the TM1 Reports so it doesn’t show the pennies? The default would be decimals hidden but then,I can format and add 2 decimals if needed. If I do this manually to all the reports and tabs I have each month it adds another 30 min or so of time. Is there a way to do dynami...
by asutcliffe
Fri Nov 09, 2012 9:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Duplication of data amounts in cube
Replies: 3
Views: 727

Re: Duplication of data amounts in cube

What do you mean by "duplication" exactly?
afullex wrote:The Data Action is set to Accumulate Values.
This means the process will add the value to the value already in the cube. Is that what you want?