Cognos TM1

[gsrsrinivas]

Hi ALL,

I am migrating the cube from cognos TM1 8.3.2 version to Microsoft sql server 2012.
Please let me know how to see the structure of the dimensions in cognos, rules in tm1 server, measures in tm1, structure of the cube, data types of dimensions columns, etcc...

thanks in advance.

[gsrsrinivas]

Hi ALL,

How to find the structure of the dimensation tables. how can we relate the Cognos TM1 cube with SQL Server?

thanks in advance.

[gsrsrinivas]

Hi ALL,

I am new to cognos tm1 cube. please let me know to see the structure of the dimensations, cube, measures, rules, etc.. in TM1 server. basically I want to retrieve the structure of the cube, dimension so that I can create a new cube with "as-is" in sql server.

thanks in advance.

srinivas.

[David Usherwood]

I am new to cognos tm1 cube

Clearly.
SQL server is a relational database. TM1 is an OLAP database. The structures are completely different. You may be thinking of MS Analysis Services, which is a distinct (though bundled) OLAP database. But from what you have written (and making full allowances for language barriers) you need to get some training in OLAP and/or buy some knowledgeable resource before going any further.

[Alan Kirk]

How to find the structure of the dimensation tables.

1 map, 1 compass, 1 or 2 metal detectors, and some indication of what on Earth you are talking about when you say "the structure of a dimension table" since dimensions are not tables. Are you talking about which dimensions appear within a cube? Are you talking about the element hierarchy structure(s) within a dimension? Your question needs to be clear before anyone can answer it. Please refer to the Request For Assistance Guidelines. (Which also request that you give each thread an appropriate subject heading. Naming every thread that you start as "Cognos TM1" is not such a heading.)

how can we relate the Cognos TM1 cube with SQL Server?

Again, what exactly do you mean by "relate"? Do you mean "in what way can a cube be compared to an SQL data table"? If so, please watch this and pay close attention from about 5 minutes in.

Do you mean "how can you pull data from an SQL Server table or query into a cube"? You can use an ODBC data source. You should refer to the relevant part of the manuals to give you an indication of how to do that. You could also export the table or query into a text file and load that. Again, refer to the manuals. Do you mean how can you push data from TM1 cubes to an SQL server? The ODBCOutput command which will, once again, be found in the manuals.

Edit: Nor is it appropriate to create two threads 6 minutes apart which appear to ask the same question. Maybe. The threads have been merged.

[Alan Kirk]

I am migrating the cube from cognos TM1 8.3.2 version to Microsoft sql server 2012.
Please let me know how to see the structure of the dimensions in cognos, rules in tm1 server, measures in tm1, structure of the cube, data types of dimensions columns, etcc...

thanks in advance.

And it's even less appropriate to create THREE threads in the space of a quarter of an hour, all seemingly asking the same question in different incomplete, convoluted fashions, and all of which seem to lack pretty much every requirement in the Request for Assistance guidelines. (In particular, without any indication that you've consulted the manuals or made some attempt to try to find the solution yourself first; refer to guideline #6.) Please knock it off.

This one is also being merged into your other threads.

[gsrsrinivas]

Hi ALL,

I want to migrate the cognos cube to microsoft analysis service. what are the basic objects i need to gather from cognos tm1 server.

thanks in advance.

[stephen waters]

I am migrating the cube from cognos TM1 8.3.2

Are you sure it is a TM1 cube? I can't remember a TM1 8.3.2 ( would have been Applix at the time).

[Alan Kirk]

I am migrating the cube from cognos TM1 8.3.2

Are you sure it is a TM1 cube? I can't remember a TM1 8.3.2 ( would have been Applix at the time).

There was one; it was released in January 2005. I can send you a copy of the release notes if you like, for this was back in the days when there were release notes.

[stephen waters]

There was one; it was released in January 2005. I can send you a copy of the release notes if you like, for this was back in the days when there were release notes.

I checked our old "version update" and have the notes on 8.3 ( headed "Interim release") before they released the triumph that was Dynamic slices in version 8.4. We must have omitted the smaller point releases (fix packs, hot fixes, service packs, service releases or whatever they were calling them that quarter). Sorry, I am getting too old and my brain is overstretched by version numbers and revised licensing names and roles. Maybe I should go back to the old days when they released a new version of DOS every couple of years and you could skip every other one because the even numbered releases were crap...

Having said that, I am surprised to find you pining for the days of Applix (non) documentation. i remember battling to persuade them to compile a pdf manual\release notes form the on-line html stuff.

The stuff we get from IBM tends to be much more thorough, including release notes. Though I am disappointed that the docs for 10.2 install only in English. I really miss having the 10.1 install providing me with every possible language from Azerbijani to Zulu, keeping my hard disk nicely full and giving me a fascinating , slowly moving progress bar to watch for 45 mins while wondering how to fill my time before I go home.

[stephen waters]

I want to migrate the cognos cube to microsoft analysis service. what are the basic objects i need to gather from cognos tm1 server.

You need to gather the cubes, dimensions, hierarchies and a few other things.

But why would you want to that anyway? TM1 is much, much better than Analysis services. Why not migrate your MSAS cubes to TM1? Several of our clients have and they really love the improved flexibility, ease of use and response times!

[Alan Kirk]

There was one; it was released in January 2005. I can send you a copy of the release notes if you like, for this was back in the days when there were release notes.

I checked our old "version update" and have the notes on 8.3 ( headed "Interim release") before they released the triumph that was Dynamic slices in version 8.4.

Hey, those babies had dynamic columns too, remember!

(The fact that they were about as stable as an ISB after a night of doing vodka shot competitions with Boris Yeltsin's ghost is neither here nor there.)

We must have omitted the smaller point releases (fix packs, hot fixes, service packs, service releases or whatever they were calling them that quarter).

A tradition that IBM proudly continues with Fix Central, er, hot fix, er, what's this one called and which random place do you get it from this week?

Sorry, I am getting too old and my brain is overstretched by version numbers and revised licensing names and roles.

I know that feeling.

Maybe I should go back to the old days when they released a new version of DOS every couple of years and you could skip every other one because the even numbered releases were crap...

I thought that was the pre-Abrams Star Trek films, but then I remembered that those were the odd numbered releases.

Having said that, I am surprised to find you pining for the days of Applix (non) documentation. i remember battling to persuade them to compile a pdf manual\release notes form the on-line html stuff.

Roger that, but at least they did finally start doing it, kinda sorta. I was just grateful when they standardised on PDFs and stopped sending out release documentation in a melange of .pdfs, Word documents and Excel sheets, each in a different format to the preceding release. Ah, those were(n't) the days.

The stuff we get from IBM tends to be much more thorough, including release notes.

Weeeellll... yes and no. They release the New Features Guide (NFG) in .pdf format, which was the front half of the old Applix release notes. The back half of the Applix ones was the bug fixes which in the later Applix versions were getting to where they needed to be. There was actually a useful synopsis telling you what the nature of the bug was, how and when it could affect you and so on. The 8.4.5 U2 one shows how far along they got with this.

The first thing about IBM is that they don't release a .pdf set of release notes, just the NFG. The supposed "Release Notes" as such are web only. The actual Release Notes page is a largely content-free exercise in verbosity. (An art at which IBM excels, of course.) For an example, see the 10.1.1 one here. It contains little useful content itself, but redirects you to a couple of other pages such as the Fix List. Which is again no longer in .pdf format but is only on line. And more to the point is an online page where the error descriptions are so perfunctory that they could be rewritten in Gibberish without too much content being lost. ("PM52889 the base version is the major release number". Yeah. And?) There are links to the PMRs but the only people who have access to them is the people who raised them, so that's pretty much useless. Unlike the later Applix days nobody is taking the time to summarise the bugs to explain exactly what the issue being fixed is.

And why do I care about the things not being available in .pdf format? Because I used to keep the release notes in a folder where I could use Adobe Acrobat's search in files feature to locate certain keywords. Granted, Adobe's search functionality in Acrobat chews great big meaty meatballs; it's not QUITE as bad as the find and replace functionality in Muddler's TI Facileeditor, but it's in no way good or flexible. However for a basic search, it works. "You can still search for things on the Web", I hear people say? Yeah, maybe you can but the chances of being able to filter out the cr@p ain't good. If you look for certain keywords (especially common ones) through a search engine you'll probably come up with 4,258,000 hits, of which the first 4,257,000 are blogs or tweets and the one that you want is maybe, possibly, buried somewhere in that last thousand. When you search a collection of documents, you know that your search will be limited to relevant content only, and won't go looking at web pages that you'll get no value from.

That's the closest I come to nostalgia; the fact that the whole of the release notes, both new features and bug fixes, were in .a single document in pdf format and searchable as opposed to scattered over random pages at random locations within the digital jungle that IBM passes off as a web site.

Though I am disappointed that the docs for 10.2 install only in English. I really miss having the 10.1 install providing me with every possible language from Azerbijani to Zulu, keeping my hard disk nicely full and giving me a fascinating , slowly moving progress bar to watch for 45 mins while wondering how to fill my time before I go home.

You can always do a custom install and put the whole lot back on. I love the smell of burning hard disk drives in the morning, it smells like {sniffs the air} IBM install packages!

"The horror, the horror..."