Hi All
Firstly, I am hoping that I have posted this request in the correct part of the forum as this is a TM1 BI question !!
I have recently needed to create a new TM1 Model/Instance, fortunately the cubes are all the same as an old one. For the old one, I had a data source connection for the packages used by my Report Studio reports which pointed to the old TM1 instance, but I now can't seem to modify these packages to look at the new TM1 instance.
I don't seem to be provided any options to modify the data source connection at all, despite creating a new one, which I would like the existing packages to use.
Does anyone know how this can be done ? or am I staring down the barrel of recreating new packages against the new data source connection ?
Cheers
Ajay
TM1 BI Package Change
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: TM1 BI Package Change
Hi Ajay
a) In Framework Manager see if you can use the existing Package Name but re-point it at your new model
b) If you export the package, you will find that it exports as XML. I think in the past I did edit the XML to make it point to a different server location and then re-imported the package and this worked. However, from what I can remember the XML needed to be edited in 2-3 places. However, this was quite a few years ago now. When using Framework Manager, you will probably find that you need to run it under the main Cognos Admin user, eg CognosADM, as running it under a general member of the Cognos Administrator Group will not work.
Regards
Paul Simon
There may be people who have a better knowledge of BI querying TM1 than I do. We have phased out all use of BI for querying TM1. From what I know it is not particularly easy to change the package on which a BI report is based. However, I would try the following :I have recently needed to create a new TM1 Model/Instance, fortunately the cubes are all the same as an old one. For the old one, I had a data source connection for the packages used by my Report Studio reports which pointed to the old TM1 instance, but I now can't seem to modify these packages to look at the new TM1 instance.
I don't seem to be provided any options to modify the data source connection at all, despite creating a new one, which I would like the existing packages to use.
Does anyone know how this can be done ? or am I staring down the barrel of recreating new packages against the new data source connection ?
a) In Framework Manager see if you can use the existing Package Name but re-point it at your new model
b) If you export the package, you will find that it exports as XML. I think in the past I did edit the XML to make it point to a different server location and then re-imported the package and this worked. However, from what I can remember the XML needed to be edited in 2-3 places. However, this was quite a few years ago now. When using Framework Manager, you will probably find that you need to run it under the main Cognos Admin user, eg CognosADM, as running it under a general member of the Cognos Administrator Group will not work.
Regards
Paul Simon
- Ajay
- Regular Participant
- Posts: 183
- Joined: Wed May 14, 2008 8:27 am
- OLAP Product: TM1
- Version: 10.2.0, PA 2.0.9
- Excel Version: 2016
- Location: London
Re: TM1 BI Package Change
Thanks Paul for getting back to me.
It turned out to be a bit of a PITA using FM and so I abandoned it.
It took a couple of hours to recreate the Packages manually, and copied out each report as an XML and did a find/replace for the instance name, before saving the reports back down again.
Very manual, but it proved less frustrating....just mundane.....you'd think IBM would have provided an easy way of doing this.
Cheers
Ajay
It turned out to be a bit of a PITA using FM and so I abandoned it.
It took a couple of hours to recreate the Packages manually, and copied out each report as an XML and did a find/replace for the instance name, before saving the reports back down again.
Very manual, but it proved less frustrating....just mundane.....you'd think IBM would have provided an easy way of doing this.
Cheers
Ajay
-
- Posts: 58
- Joined: Thu Jul 03, 2014 1:14 pm
- OLAP Product: cognos
- Version: 10.2.2
- Excel Version: 2010
Re: TM1 BI Package Change
Ajay.
Hope your well? The easiest way for this is to go to the data source within the connections in BI and change the details there. This would pinpoint you to the rigt source. But ensure the cube names are the same.
Mithun
Hope your well? The easiest way for this is to go to the data source within the connections in BI and change the details there. This would pinpoint you to the rigt source. But ensure the cube names are the same.
Mithun