Search found 164 matches
- Sat Aug 01, 2020 10:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: A Simple Architect Replacement for Linux
- Replies: 3
- Views: 1936
Re: A Simple Architect Replacement for Linux
So I cloned it, and it compiled once I'd installed the relevant gtk headers. I was able to authenticate and get a list of cubes for a server, not processes though. Be careful with storing the credentials like that and make sure you at least keep them out version control with a sensible .gitignore. I...
- Sat Aug 01, 2020 8:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: A Simple Architect Replacement for Linux
- Replies: 3
- Views: 1936
Re: A Simple Architect Replacement for Linux
OpenCubes is a cool name, I'm going to have a look
- 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: 6369
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...
- Tue Jan 08, 2013 1:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: cube to cube-Feeder
- Replies: 7
- Views: 5438
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...
- Tue Jan 08, 2013 10:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DIMIX rule calculation
- Replies: 5
- Views: 4573
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&...
- 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: 2723
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.
- Tue Nov 27, 2012 12:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder Issue
- Replies: 8
- Views: 5674
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...
- Tue Nov 20, 2012 8:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Disagreement between statsbycube and taskmanager
- Replies: 2
- Views: 2782
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 ...
- Wed Nov 14, 2012 2:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: redirect Admin host
- Replies: 13
- Views: 9268
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.
- Wed Nov 14, 2012 2:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: redirect Admin host
- Replies: 13
- Views: 9268
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...
- Wed Nov 14, 2012 12:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: redirect Admin host
- Replies: 13
- Views: 9268
Re: redirect Admin host
What is your admin host set to in the client? Is it "admin2" or is something like "admin2; admin1"?
- Wed Nov 14, 2012 11:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: redirect Admin host
- Replies: 13
- Views: 9268
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...
- Tue Nov 13, 2012 8:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos Express Subsets
- Replies: 3
- Views: 3967
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.
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.
- Fri Nov 09, 2012 6:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: List Account Hierarchy In Excel
- Replies: 18
- Views: 12649
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...
- Fri Nov 09, 2012 3:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: List Account Hierarchy In Excel
- Replies: 18
- Views: 12649
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. ...
- Fri Nov 09, 2012 3:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: List Account Hierarchy In Excel
- Replies: 18
- Views: 12649
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 e...
- Fri Nov 09, 2012 3:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension elements selection
- Replies: 1
- Views: 2257
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...
- Fri Nov 09, 2012 2:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SecurityRefresh cause restrart TI process
- Replies: 5
- Views: 4028
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 ...
- Fri Nov 09, 2012 12:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Text output from TI
- Replies: 2
- Views: 3115
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.
- Fri Nov 09, 2012 12:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Reports- Decimals
- Replies: 4
- Views: 3540
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...