Search found 67 matches

by Herman Moller
Thu Apr 04, 2019 3:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Drill - PAX - bug (And workaround)
Replies: 2
Views: 256

Cube Drill - PAX - bug (And workaround)

Hello All, We have been doing some work on Cube Drills in PAX and have noticed the following bug : If you have a cube drill and only have a row defined in the cube view it will return the right view but will be blank. To get a drill through to work in PAX you need to have at least 1 dimension define...
by Herman Moller
Thu Apr 28, 2011 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Internal Rules Using DB
Replies: 10
Views: 2722

Re: Internal Rules Using DB

Jim, Been working with TM1 for a number of years and have never heard this argument. My colleague comments are: " I found it five or more years ago, and at the time the practice did indeed produce favourable results in testing, but I have since lost track of the original source of the information. I...
by Herman Moller
Thu Apr 28, 2011 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Internal Rules Using DB
Replies: 10
Views: 2722

Internal Rules Using DB

All, I am having a debate with a colleague regarding writing TM1 rules in a internal cube. We have a Demand cube: Version, Year, Month, Products, Cost_Centre, Measures: Operating Volumes, Operating Units and Demand I would write a internal rule the following way: ['Demand']=n:['Operating Volumes']*[...
by Herman Moller
Tue Apr 12, 2011 2:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: BI Reporting From TM1
Replies: 27
Views: 7696

Re: BI Reporting From TM1

I have seen that issue with BI in the past as it doesnt like ragged hierarchies. Try the following test: a) Create a TM1 Attribute call = Nlevel in TM1. b) Manually 1st add all the codes you want to see eventhrough they are at different levels (You can use a attribute rule at a later stage) These sh...
by Herman Moller
Mon Oct 11, 2010 10:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process Sheets and TM1 9.5.1
Replies: 1
Views: 636

Re: Process Sheets and TM1 9.5.1

I would suggest using TI as I think the log files are lost somewhere..... Also when 9.4 was released process worksheets had degraded in performance from 9.1 and 9.4 which loaded data incredibly slow. Testing also missed this problem and we ended up having taking all the process worksheets files and ...
by Herman Moller
Mon Jul 19, 2010 3:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBO and MSAS
Replies: 2
Views: 2243

ODBO and MSAS

Hello, Connect to ODBO to extract MSAS data to TM1 I found the following so far.... Problem 1) CAM Security and MSAS - ODBO is a nightmare to connect with TM1. I am still working around getting MSAS and loading into TM1 cube with CAM Security. IBM have the following note: "Connecting to an OLE DB fo...
by Herman Moller
Mon Jul 12, 2010 1:24 pm
Forum: Bugs
Topic: Missing title elements in a view, TM1 9.5 and up
Replies: 21
Views: 30635

Re: Missing title elements in a view, TM1 9.5 and up

Wim,

I have noticed that before with a client running Windows 7. The client installed the client on another machine and it worked(non windows 7). I had thought afterwards they could have deleted the tm1p.ini file and this could have cured the problem.

Herman
by Herman Moller
Wed Jul 07, 2010 8:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1TransactionLogBufferList Error
Replies: 5
Views: 2147

Re: TM1TransactionLogBufferList Error

Interesting..... Its seems like this will cure the problem.

Hopefully they have fixed this in 9.5 FP1
by Herman Moller
Fri Jun 25, 2010 1:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do feeders actually work?
Replies: 19
Views: 17645

Re: How do feeders actually work?

To feed or not to feed..... If you don't feed a system it starts up time will be lighting fast but when doing calculations it will take a long time to cache. If you have feeders in a system the start up time is slower but the response time for the calculations is much faster. “Some small, simple r...
by Herman Moller
Thu Jun 03, 2010 1:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1TransactionLogBufferList Error
Replies: 5
Views: 2147

TM1TransactionLogBufferList Error

Hello, I am running TM1 9.5 64 bit. Windows Server 2003 x 64 SP2 Is this a known bug in the TM1server.log? 235472 ERROR 2010-06-02 16:55:31.149 TM1.Transaction TM1TransactionLogBufferList::DumpBuffers: Failed to write tm1s.log. I delete the server log and bounce the server and it behaves but I dont ...
by Herman Moller
Mon May 10, 2010 8:49 am
Forum: Cognos Planning and BI
Topic: Limited TM1 attribute functionality in C8 report studio
Replies: 5
Views: 3912

Re: Limited TM1 attribute functionality in C8 report studio

In TM1 world you have to be specific names for your dimensional hierarchy. If you consider a 2 Level Time dimension : - Year / Month it would look the following: 2010 Jan 10 Feb 10 Mar 10 . . . etc What you could do is the following : a) Create 2 attributes on your time dimension: Month Year Element...
by Herman Moller
Fri Mar 12, 2010 4:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Controller & TM1
Replies: 7
Views: 8585

Re: Cognos Controller & TM1

A side thought on Controller & TM1. You can create a linkage between Controller and TM1 if you are working with Controller 8.4 or less. How is this done........ 1) Write a number of Views in SQL to extract the Controller Tables to specific views that can be used in 2). 2) Uses these views to a) Buil...
by Herman Moller
Fri Mar 05, 2010 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Tracer Window
Replies: 3
Views: 1019

Re: Rules Tracer Window

It could be that your Rules Tracer window has been corrupted. I would suggest the following: 1) Exit TM1 on your machine 2) Delete the TM1p.ini file 3) re-start TM1 and in doing so will re-create the TM1p.ini file. This should solve your rules tracer issue. BTW what version of TM1 are you running? H...
by Herman Moller
Fri Mar 05, 2010 12:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Help
Replies: 10
Views: 2837

Re: TM1 Help

I think its safe to say the file can stay in the current location. I think the problem could be somewhere else.

Is this a new process or a process that has been running for a while without a problem?

What TM1 version are you running at the moment?

Herman
by Herman Moller
Thu Mar 04, 2010 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Help
Replies: 10
Views: 2837

Re: TM1 Help

Just to take Paul comments a step further..... In your TI process the file you mapping to has 2 data source areas: Data Source Name = Data Source Name on Server = You are logging onto your machine on TM1 Perspectives and not the physical TM1 box. Your TI would look the following in the data source t...
by Herman Moller
Thu Mar 04, 2010 1:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Express
Replies: 2
Views: 1231

Re: Cognos Express

Jackie,

Report Studio show all attributes (Non - Alias) in the viewer.

When you are importing the cube in FrameWork manager there is an option to load an alias. You should be able this in framework manager.

HTH

Herman
by Herman Moller
Mon Mar 01, 2010 3:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: tm1sd.exe file mysteriously re-executed
Replies: 4
Views: 2249

Re: tm1sd.exe file mysteriously re-executed

I see the last action prior to the server restarting was :

"2472 INFO 2010-03-01 13:51:23,758 TM1.Process Process "}Drill_FS Source" finished executing normally, elapsed time 0.08 seconds"

Was this drill through run the previous month when you had a similar restart?

Herman
by Herman Moller
Fri Feb 26, 2010 10:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 9.5 - Re-order of a cube
Replies: 0
Views: 564

9.5 - Re-order of a cube

Hello, Been working with 9.5 and so far so good except for the following: It seems that you can not re-order a cube with more then 2 of the same measure dimension. ie Cube 1 with KPI Measures works fine, but once I try and re-order cube 2 with the same KPI Measures it fails. I have seen this in Expr...
by Herman Moller
Tue Feb 09, 2010 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1sd 9.5 install
Replies: 1
Views: 1185

TM1sd 9.5 install

Installing a TM1 service in 9.5 has changed slightly..... Historically you would need to write the following code in Command Prompt world TM1sd.exe -install TM1Server "c:\Dev\Tm1server" NOW IN 9.5 TM1sd.exe -install -n TM1Server -z "c:\Dev\Tm1server" It has new parameters of -n and -z that was not n...
by Herman Moller
Thu Feb 04, 2010 9:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Express 64 - Admin can't create objects in Xcelerator (TM1)
Replies: 13
Views: 4935

Re: Express 64 - Admin can't create objects in Xcelerator (TM1)

The security side of express can be a pain..... How I see express security working is the following: 1) User sets up the initial security for Cognos Express Manager world. Sets up the user and the groups 2) User sets up internal TM1 Security in the good old fashioned way of right click on Tm1 server...