Cognos Vs SSIS

We are trying to investigate the ETL tools available in the market and have narrowed down to two

COGNOS - ETL (Data Manager Tool)

Microsoft - SSIS

Is there a comparison study out there which would help us in this process. Also a list of things we need to look out for in a ETL tool will also help.

Thanks

http://www.180systems.com/BI-Comparison2006.xls

Looks like someone has done the research for you.

Is this what you are looking for?

Cognos to RS

Hi all!

I am taking a cognos report and created an identical one in RS. Can anyone tell me what this means and help figure out how to do it in RS?
cognos
TO_DATE(SUBSTR(DATE_TIME_STAMP,1,14),'YYYYMMDDHH24MISS')

RS (i am guessing)
CONVERT(SUBSTRING(DATE_TIME_STAMP,1,14),yyyyMMddhh?m?ss)

can anyone help?

Thanks in avance,
KerrieIs this a SQL function or a function in the report? If it is the latter, the function for SUBSTR is Mid() (http://whidbey.msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vbalr/html/8b6caa3e-973a-4f18-b0e4-93956a9dee9b.asp). You probably want to use the Format() function (http://whidbey.msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vbalr/html/c6f5bdda-a7c3-4f38-86cc-1cf47aa940b3.asp) in place of the TO_DATE.|||you could try :

http://www.sqlobserver.com

SQLobSERVER is a new independent forum specialising in BI/ETL including across the vendors (ie., Cognos)

Sorry about the blurb, but thought it might to be useful..

Cognos to RS

Hi all!

I am taking a cognos report and created an identical one in RS. Can anyone tell me what this means and help figure out how to do it in RS?
cognos
TO_DATE(SUBSTR(DATE_TIME_STAMP,1,14),'YYYYMMDDHH24MISS')

RS (i am guessing)
CONVERT(SUBSTRING(DATE_TIME_STAMP,1,14),yyyyMMddhh?m?ss)

can anyone help?

Thanks in avance,
KerrieIs this a SQL function or a function in the report? If it is the latter, the function for SUBSTR is Mid() (http://whidbey.msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vbalr/html/8b6caa3e-973a-4f18-b0e4-93956a9dee9b.asp). You probably want to use the Format() function (http://whidbey.msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_vbalr/html/c6f5bdda-a7c3-4f38-86cc-1cf47aa940b3.asp) in place of the TO_DATE.|||you could try :

http://www.sqlobserver.com

SQLobSERVER is a new independent forum specialising in BI/ETL including across the vendors (ie., Cognos)

Sorry about the blurb, but thought it might to be useful..

Cognos Powerplay and Analysis 2005

Hi everybody,

we have an AS2000 cube and we use Cognos Powerplay for reporting.
We are investigating about migrating to AS2005 and we are looking for information about compatibility between 2005 and Powerplay.

If anyone can help us.
Thank you.We are also using PowerPlay to deliver MSAS 2000 cubes. According to Cognos Support: "At this time, MS SAS 2005 is not supported with Cognos including the latest version Cognos 8." I have not attempted to install PTS9.exe and SQL Native Client on our production server to test the connections. I have verified it does not work with the older version.

cognos OLAP conversion to ms analysis service

Hello All,
I am new to this group. I am looking for a tool that will convert cognos
OLAp cubes into ms OLAP cubes. Anybody has an idea?
Thanks a lot
Angie..
Won't work using Replication - I'd repost in the Analysis Services/OLAP
groups....
Paul Ibison

Cognos IWR Server

Our disk drive died, and we were able to backup most of the files (all
the reports, the shuttled, pending, etc)

But when we open the administrator, we get a blank. none of our
catalogues are listed in there.

I don't want to recreate all the catalogues and reports- does anyone
know how we can "import" them in there? The database that contains all
the "data" was not backed up, sicne it was in use during backup (bad
Network admin)

If anyone can help, PLEASE email. trying to get an answer from cognos,
but who knows?!!!Bliss <eternalbliss@.techie.com> wrote in message news:<400f1786$1@.obsidian.gov.bc.ca>...
> Our disk drive died, and we were able to backup most of the files (all
> the reports, the shuttled, pending, etc)
> But when we open the administrator, we get a blank. none of our
> catalogues are listed in there.
> I don't want to recreate all the catalogues and reports- does anyone
> know how we can "import" them in there? The database that contains all
> the "data" was not backed up, sicne it was in use during backup (bad
> Network admin)
> If anyone can help, PLEASE email. trying to get an answer from cognos,
> but who knows?!!!

I have no idea about the Cognos side of things, but if still have the
..mdf and .ldf files for your MSSQL databases, you can try using
sp_attach_db or sp_attach_single_file_db to attach them again. If this
doesn't work, and you have no backups, then all you can really do is
contact Microsoft PSS. They may be able to help recover data from the
files.

By the way, MSSQL databases can be backed up while in use - this is
usually how backups are done.

Simon|||Thanks! But Cognos, apparently (to the dismay of the network admin) was
skipping open files.

And we have all the reports/databases. We were more interested in the
cogno's side of things. We can't import into the admin program.

But thanks for the info!

Simon Hayes wrote:
> Bliss <eternalbliss@.techie.com> wrote in message news:<400f1786$1@.obsidian.gov.bc.ca>...
>>Our disk drive died, and we were able to backup most of the files (all
>>the reports, the shuttled, pending, etc)
>>
>>But when we open the administrator, we get a blank. none of our
>>catalogues are listed in there.
>>
>>I don't want to recreate all the catalogues and reports- does anyone
>>know how we can "import" them in there? The database that contains all
>>the "data" was not backed up, sicne it was in use during backup (bad
>>Network admin)
>>
>>If anyone can help, PLEASE email. trying to get an answer from cognos,
>>but who knows?!!!
>
> I have no idea about the Cognos side of things, but if still have the
> .mdf and .ldf files for your MSSQL databases, you can try using
> sp_attach_db or sp_attach_single_file_db to attach them again. If this
> doesn't work, and you have no backups, then all you can really do is
> contact Microsoft PSS. They may be able to help recover data from the
> files.
> By the way, MSSQL databases can be backed up while in use - this is
> usually how backups are done.
> Simon

Cognos Comparison

Hello Everyone,
Does anyone have a comparison of Cognos with SSRS?
regards,
Abhishek.I think there really isn't a whole lot where you can even compare them.
Sure SSRS can report from BI (Cubes) - but even that is very limitted to the
real analysis your users will want - it's not a true end to end tool - just
a pretty good well rounded inexpensive (nearly free - but relative)
reporting tool.
Cognos and Proclarity type tools are true end to end tools for the BI stuff.
We were quoted under $30k for Proclarity - we haven't even tried to look at
Cognos as we understand them to be more near the $100k area. Proclarity got
bought up by M$ and integrates well with SSRS - not sure how Cognos does it.
The Proclarity stuff is really cool and does some really neat stuff.
"Abhishek" <Abhishek@.discussions.microsoft.com> wrote in message
news:748932B6-D2CD-4A03-82B0-F684985BFEEB@.microsoft.com...
> Hello Everyone,
> Does anyone have a comparison of Cognos with SSRS?
> regards,
> Abhishek.|||I don't know about the back-end, but I do know that Cognos is $800 US
per end user license.
Proclarity has been rebranded by MS as Performance Point and is
currently in beta. If you're thinking that it might have pretty good
hooks into SQL 2005 and SharePoint, you would be correct. I haven't seen
any pricing info on the 2007 release.
Garth H
webdev511@.spamcop.net
Microsoft Certified Technology Specialist
Microsoft Certified Professional
Macromedia Certified Developer

Cognos and SQL Server 2005 Reporting Services

Hi,

I would like to get the differences between Cognos and SQL Server 2005 Reporting Services.One of the client is planning to Use Cognos and I am supporting SQL server 2005 Reporting Services.

Details regarding the pros and cons of SQL Server 2005 Reporting Services would be great.

I am looking for the details like this.

Cost of Cognos licencing Vs SQL Server Reporting services licensing?

Usability issues?,etc.

Any link to the comparision study between SQL server Reporting services and Cognos?

Thanks!

Raju

http://expertanswercenter.techtarget.com/eac/knowledgebaseAnswer/0,295199,sid63_gci1141747,00.html

try this link

COGNOS = CRAP

I cant wait for Microsoft to put these idiots out of business
so i can stop working on the crapIt'll be a while, won't it? In the recent "Ready Set Go" webcast, I asked
if they were going to have more functionality in Reporting Services than
what I get with OWC and the accompanying field list, and they
private-messaged me saying that for now, at least, there would be less.
I know we can do cool stuff with Excel hooked up to cubes, but what my
customers want is a web-based report that shows a few charts together on one
page, and the ability to slice the cube from any of those charts. Right now
Office Web Components won't show just achart (a flattened one can be shown,
without interactivity, via ADO), and I can't show multiple slices of a cube
(unless I'm willing to do clunky frames), and even if I'm willing to show
the table with the chart, the chart formatting issues are untenable.
I agree with you that I would much rather use MS tools for data warehousing,
but on the presentation end, even with the new Reporting Services, there
seems to be room for improvement. That is my impression. I certainly don't
know everything, so if I've got my facts wrong, I hope someone here will
straighten 'em out for me.
"Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
news:aLGdnZ5fWrlBhiLdRVn-ig@.is.co.za...
> I cant wait for Microsoft to put these idiots out of business
> so i can stop working on the crap
>|||Try checking out a XLCubed!
"J O Holloway" <respond.to.group@.your.convenience> wrote in message
news:e0$aanXSEHA.1172@.TK2MSFTNGP11.phx.gbl...
> It'll be a while, won't it? In the recent "Ready Set Go" webcast, I
asked
> if they were going to have more functionality in Reporting Services than
> what I get with OWC and the accompanying field list, and they
> private-messaged me saying that for now, at least, there would be less.
> I know we can do cool stuff with Excel hooked up to cubes, but what my
> customers want is a web-based report that shows a few charts together on
one
> page, and the ability to slice the cube from any of those charts. Right
now
> Office Web Components won't show just achart (a flattened one can be
shown,
> without interactivity, via ADO), and I can't show multiple slices of a
cube
> (unless I'm willing to do clunky frames), and even if I'm willing to
show
> the table with the chart, the chart formatting issues are untenable.
> I agree with you that I would much rather use MS tools for data
warehousing,
> but on the presentation end, even with the new Reporting Services, there
> seems to be room for improvement. That is my impression. I certainly
don't
> know everything, so if I've got my facts wrong, I hope someone here will
> straighten 'em out for me.
>
> "Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
> news:aLGdnZ5fWrlBhiLdRVn-ig@.is.co.za...
>

COGNOS = CRAP

I cant wait for Microsoft to put these idiots out of business
so i can stop working on the crap
It'll be a while, won't it? In the recent "Ready Set Go" webcast, I asked
if they were going to have more functionality in Reporting Services than
what I get with OWC and the accompanying field list, and they
private-messaged me saying that for now, at least, there would be less.
I know we can do cool stuff with Excel hooked up to cubes, but what my
customers want is a web-based report that shows a few charts together on one
page, and the ability to slice the cube from any of those charts. Right now
Office Web Components won't show just achart (a flattened one can be shown,
without interactivity, via ADO), and I can't show multiple slices of a cube
(unless I'm willing to do clunky frames), and even if I'm willing to show
the table with the chart, the chart formatting issues are untenable.
I agree with you that I would much rather use MS tools for data warehousing,
but on the presentation end, even with the new Reporting Services, there
seems to be room for improvement. That is my impression. I certainly don't
know everything, so if I've got my facts wrong, I hope someone here will
straighten 'em out for me.
"Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
news:aLGdnZ5fWrlBhiLdRVn-ig@.is.co.za...
> I cant wait for Microsoft to put these idiots out of business
> so i can stop working on the crap
>
|||Try checking out a XLCubed!
"J O Holloway" <respond.to.group@.your.convenience> wrote in message
news:e0$aanXSEHA.1172@.TK2MSFTNGP11.phx.gbl...
> It'll be a while, won't it? In the recent "Ready Set Go" webcast, I
asked
> if they were going to have more functionality in Reporting Services than
> what I get with OWC and the accompanying field list, and they
> private-messaged me saying that for now, at least, there would be less.
> I know we can do cool stuff with Excel hooked up to cubes, but what my
> customers want is a web-based report that shows a few charts together on
one
> page, and the ability to slice the cube from any of those charts. Right
now
> Office Web Components won't show just achart (a flattened one can be
shown,
> without interactivity, via ADO), and I can't show multiple slices of a
cube
> (unless I'm willing to do clunky frames), and even if I'm willing to
show
> the table with the chart, the chart formatting issues are untenable.
> I agree with you that I would much rather use MS tools for data
warehousing,
> but on the presentation end, even with the new Reporting Services, there
> seems to be room for improvement. That is my impression. I certainly
don't
> know everything, so if I've got my facts wrong, I hope someone here will
> straighten 'em out for me.
>
> "Reg Besseling" <reg.usenet.nospam@.epic-sc.com> wrote in message
> news:aLGdnZ5fWrlBhiLdRVn-ig@.is.co.za...
>