Can TM1 be used as Transactional Database

[Tm1andTm1]

Hi,
Can TM1 be used as Transnational Database...?

[declanr]

Hi,
Can TM1 be used as Transnational Database...?

TM1 can be used for pretty much anything... whether or not that is the correct course of action is another matter.

Could you perhaps elaborate on what you actually mean/want?
http://www.tm1forum.com/viewtopic.php?f=3&t=1037

[declanr]

Hi Declan,

I am trying to build an application where data is entered from different locations and put into common database.
from common database it is loaded into reporting cube, where Planning and budgeting can be done.

I have completed the major part of the application. Want to know from you if my approach is correct or I am head towards wrong direction.

Thanks

TM1andTM1,

I have copied and pasted your message here as Private Messages and emails are primarily for things that need to be kept private for certain reasons (commercially sensitive etc), it is best to have it in here so that other users can benefit from the answers and also so that you can get other responses from different users... as much as I'd like to always be right... other contributors may have a better answer for you.


I'm still not 100% on exactly what you are doing.

data is entered from different locations and put into common database

If by this you mean that TI is picking up data from multiple source databases (e.g. sql) and putting it into a TM1 cube then it all depends on the detail of exactly how your network set-up works and how "far" you have to go to get this data... however since you say that you have completed the major part of the application the simple test would be "Does it run quickly enough and give you the results you want?"

If you are referring to users entering data from various parts of the globe then you would benefit from researching the performance of TM1 over a WAN, there will be many discussions about it on here and how to overcome the difficulties. Again it will be largely dependent on your users and network infrastructure set-up.
And again you can have a simple test of getting the users to use it and seeing if it performs acceptably.

HTH, If I have completely misinterpreted the question then you can ignore everything I've said.


EDIT - Actually on re-read I would take it as meaning that you move from multiple source system databases into 1 database and then just use TM1 to pull data in from 1 place.
That would be a perfectly acceptable solution. However having multiple TIs to pull from various sources is also usually a perfectly acceptable solution. You could also look into setting up specific SQL views or stored procedures to get TM1 to query on. Basically it all depends on your setup, if you and your users are happy with the results then you have essentially done a good enough job.

[Tm1andTm1]

Hi Declan,

I have read on this forum that TM1 is not a transactional database.
I have made an application, where each sales transaction is recorded and kept in particular location database (For modification or alteration, if any) once confirm that all transaction are correct, it can be stored in common database of company. From common database it can be further transfer to reporting cube, for reporting and Planning, Budgeting application.(Same concept of any ERP).
I have done most of the part successfully but still application is not completed adding some more features like TM1 workflow to make it more presentable and more effective use.
I would be needing help in making it more usable, will let you know once I complete it.

[declanr]

I see you edited the topic title from "Transnational" to "Transactional"... now I think I understand.

The basic reason people suggest TM1 shouldn't be used at this detail is that it is very unlikely you will need all of that detail for what you are doing in TM1 (so why waste the memory) & you probably already hold the data somewhere else so standard practice would be to just bring in what you do need.

I normally however bring in a little bit extra to allow users to analyse it out further if they are intrigued by their "base" forecast numbers.

Again, as with anything in TM1, you can probably do it from a capability stand point and if it meets the requirements of your customer and functions well... then job's a good'un.