TM1 Forum

Hi!

We are exposing TM1 Cubes through Framework Manager packages to the Cognos Content Store in order to consume them in Cogos BI Report Studio.

This is working fine, however, we are having some discussions on whether defining multiple data source connections in FM (Framework Manager) to the same TM1 instance for different packages (cubes) actually have any effect at all (e.g. on performance).

Creating new data sources in FM for each package quickly makes it messy in my opinion, and I would avoid it unless there would be any good reasons not to.

I have been reading the user manual for FM 10.2, and searching this and other forums, but with few improvements to my understanding.

I was therefore hoping, despite this being a TM1 forum, whether you guys have any input.

Thanks in advance for any POV!

I take it your TM1 version is also 10.2? I've not tried multiple connections to the same cube set. I would guess however that each access would get a thread and as long as you enough threads for each connections it should run pretty well. The reason I asked the first question was related to multi-threaded queries in 10.2 which would of course run even faster,

Jim.

Hi Jim!

Version: TM1 10.1.1

Thanks for your input!

May I interpret your answer this way: You do not see an explicit need for defining multiple data sources to the same TM1 instance, however, you do not see any problems with defining multiple sources as long as the configuration is correct?

Thanks again!

You can use one Data Source definition for all cubes on the TM1 server. I can't think of many reasons why you would use more than one datasource in an FM Model for TM1 cubes. In fact the only reason I can think of right now would be if login/security settings needed to be different based on the package. However this could be solved by creating multiple sign ons an assigning BI groups to each sign on. Really it would only matter if you wanted to use BI CAM Authentication with one package and use a provided login credential for another.

Thanks for your input, PlanningDev!