Search found 42 matches

by AnthonyT
Thu Feb 23, 2012 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.1 - Trace Calculation behaviour
Replies: 16
Views: 12698

TM1 10.1 - Trace Calculation behaviour

Afternoon all I am doing some parallel testing of TM1 version 10.1 against 9.4 (both 64bit) I have found some calculation differences, and fully expected them to be down to the volumes of data that I am working through, but I have stumbled upon something odd When I try to right-click on a calculated...
by AnthonyT
Thu Jan 19, 2012 7:53 am
Forum: Enhancements
Topic: Client last log-in date
Replies: 11
Views: 87370

Re: Client last log-in date

You can find this out by importing the Audit log file (provided that you have them enabled), and you can see what has happened by day With some TI manipulation you see when a client logged in last, changed passwords, changed groups, as well as server shutdowns / restarts, and process / dim / cube ch...
by AnthonyT
Thu Jan 12, 2012 2:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Clearing Out Rules during Run Time
Replies: 5
Views: 3865

Re: Clearing Out Rules during Run Time

Size isn't everything ! I do something similar - clearing out multiple rule files, and rewriting the rules ( and inter-cube feeders ) again based on an Excel spreadsheet loaded into a Data Warehouse, via a cube that holds dimensional mappings For your problem, I'd start with the blb scenario first A...
by AnthonyT
Tue Jan 10, 2012 9:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Not Fed
Replies: 7
Views: 5950

Re: Not Fed

Providing that you have a "Next Period" attribute on the Periods dimension
by AnthonyT
Thu Jan 05, 2012 9:34 am
Forum: Oracle OBIEE
Topic: Oracle OLAP
Replies: 4
Views: 52419

Re: Oracle OLAP

Hi Jim

I mean "Oracle OLAP is a world class multidimensional analytic engine embedded in Oracle Database 11g" from the Oracle Technology Network website - definately not Essbase - accesed using the Analytic Workspace Manager

I think.....

Thanks
by AnthonyT
Tue Jan 03, 2012 10:32 am
Forum: Oracle OBIEE
Topic: Oracle OLAP
Replies: 4
Views: 52419

Oracle OLAP

Hi all

Hope this is the correct place for this post

Can anyone point me in the direction of finding out, or let me know their own experience in, the difference between Oracle OLAP and TM1?

Thanks

Anthony
by AnthonyT
Tue Jul 12, 2011 7:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 9.4 export to Oracle speed
Replies: 3
Views: 2548

Re: 9.4 export to Oracle speed

Thanks for the replies David - that was the way I was thinking I was going to go unfortunately, though there is talk of trying to use TM1 as a datasource and suck the data back into Oracle instead of push it out Afshin - I will pass on your message to the people who have more Oracle knowledge than m...
by AnthonyT
Fri Jul 08, 2011 9:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 9.4 export to Oracle speed
Replies: 3
Views: 2548

9.4 export to Oracle speed

Morning all I am exporting data from a 7 dimension cube (pulling in ruled data from around 15 other 6/7/8 dimension cubes) to an Oracle 10g database. (TM1 version 9.4 MR1 64bit, 40Gb memory, 24 Core 2.8Ghz Six-Core AMD Opteron 8439 SE processor) Depending on the time of day I get anywhere between 30...
by AnthonyT
Mon Feb 28, 2011 9:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 64 bit Access ODBC connection
Replies: 6
Views: 4606

Re: 64 bit Access ODBC connection

Apologies, but I was told that we were using a 64 bit driver.

That possibly doesn't seem to be the issue really - it's more why can I connect to the database on the same server, and not on another one?
by AnthonyT
Fri Feb 25, 2011 12:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 64 bit Access ODBC connection
Replies: 6
Views: 4606

64 bit Access ODBC connection

Apologies if this is a basic question, but it's something I have not come up against before On Server A, I have 64 bit TM1 9.4 MR1 installed. I have configured a 64-bit ODBC Access driver and can quite happilly connect to a database on the same server If I move the Access DB to Server B, and reconfi...
by AnthonyT
Fri Oct 15, 2010 11:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server connectivity - or rather, a lack of it
Replies: 3
Views: 2923

Re: Server connectivity - or rather, a lack of it

Everything for both servers - ini / cfg / security / cubes / account used to run services is exactly the same

When you use Perspectives, and click on the server name, nothing happens bar the spinning egg-timer. You do not get the username / password prompt appearing
by AnthonyT
Fri Oct 15, 2010 7:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server connectivity - or rather, a lack of it
Replies: 3
Views: 2923

Server connectivity - or rather, a lack of it

I have installed a 9.4 MR1 version of TM1 onto a server. This is in addition to the 2 servers we already have successfully up and running. From a 9.4 client I can happilly see the databases - 2 copies of existing databases to check installation. When I open the databases on the server itself, everyt...
by AnthonyT
Fri Jun 04, 2010 8:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ETLDAP Config
Replies: 0
Views: 1339

ETLDAP Config

I am working on trying to get the ETLDAP tool correctly configured and have hit a wall I have managed to connect to the LDAP server, and the TM1 server - both giving connection succesful messages - but the <Search> button is still greyed out. Also, would anyone be able to point me in the direction i...
by AnthonyT
Thu May 27, 2010 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Another Feeder Question
Replies: 2
Views: 1807

Re: Another Feeder Question

Hi David Thanks for the reply - hope things are well? Cube 2 is being used as a staging area, so that some metrics can be expanded to fill the reporting dates. Cube 3 then uses these values by date, and applies them to another dimension. I was thinking of doing away with Cube 2, thus reducing one lo...
by AnthonyT
Thu May 27, 2010 10:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Another Feeder Question
Replies: 2
Views: 1807

Another Feeder Question

Apologies if this a basic question

Which below scenario would be "better"?

Scenario A:
One cell in cube A, used to calculate 10 in Cube B, which in turn are used to calculate 10 in Cube C

Or....

Scenario B:
One cell in cube A, used to calculate 100 in Cube C

Thanks
by AnthonyT
Mon Aug 04, 2008 10:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: EV Connectivity
Replies: 5
Views: 5291

Re: EV Connectivity

Hi and thanks for the help so far

Being not quite that technical - how would I go about checking / doing the above (I do have admin rights to the server)

Thanks
by AnthonyT
Mon Aug 04, 2008 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: EV Connectivity
Replies: 5
Views: 5291

Re: EV Connectivity

TM1 Version 9.1.2.49 EV Version 9.3.1.1 When opening the EV Client, looking at the Shared Views tab I get a message telling me that I am unable to connect to Server (servername) using TCP-IP port 7112. Please make sure EV is running and that the port is not blocked by a firewall or any proxy server....
by AnthonyT
Mon Aug 04, 2008 8:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: EV Connectivity
Replies: 5
Views: 5291

EV Connectivity

Morning all I have an EV connection problem, and I am hoping somebody here can help I have my EV server (named EVServer whislst on the LAN) in Australia. On it is an html file that I use as an EV Report. If I am on the LAN the roport works fine I need to access the same file whilst in the UK. The se...
by AnthonyT
Thu Jul 10, 2008 2:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Question
Replies: 6
Views: 6134

Re: MDX Question

Not that I am in any way proficient with MDX, but I think that your example will only do a UNION between the first two statements, if at all I would either try to limit the FILTERBYPATTERN to look for anything that starts with an "l" or try the following TM1SORT( UNION( UNION( UNION( UNION...
by AnthonyT
Wed Jul 09, 2008 6:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 9.1 API - ASP.NET / VB.NET
Replies: 3
Views: 5060

Re: 9.1 API - ASP.NET / VB.NET

Here is what I do Using the code behind page, I create the EV object as a new Literal Control, setting a few variables along the way Partial Class ClientCostReport Inherits System.Web.UI.Page Dim ControlPlaceHolder As PlaceHolder Dim litObjectTag As LiteralControl Dim arrObjectTag() As Byte Dim evSe...