COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => COGNOS Connection => Topic started by: ReportWriter on 09 Jan 2008 02:09:46 AM

Title: Portal tab with text
Post by: ReportWriter on 09 Jan 2008 02:09:46 AM
Hello all,

I need to create a simple portal tab, which would consist of information of data loads. How can I create a portal tab with text? What is the easiest way?

Is it possible to create a tab with embedded xls file? Xls would just be on server where I could update it. I just need to write messages to users, e.g. "2008-01-09 Data load successful".

Thanks in advance!
Title: Re: Portal tab with text
Post by: biejorrun on 09 Jan 2008 02:28:30 AM
The easiest way would be a report.

Example 1: at the end of your data load, write a record in a small table containing a timestamp. Query that table in your report and display the last data load timestamp.

Example 2: if you don't want to create/write a small table, and if you use SQL Server with DTS, then query the msdb database to retrieve the last successful run of your DTS script.

Hope my "early-morning-inspiration-mood" helps you further ;)

Björn