If you are unable to create a new account, please email support@bspsoftware.com

 

Displaying custom page when reporting DB connection is unavailable

Started by kommireddy, 14 Nov 2008 03:48:48 PM

Previous topic - Next topic

kommireddy

Hello All,

We have a following business requirement in our project,

The data mart (reporting DB) gets refreshed by ETL three times a day. In data mart there are two sets of tables _x and _y. Cognos reports always point to views based on table _y. But when ETL completes delta load into _x tables, DBA will close all connections to database and drop/recreate views and point them to _x table and it follows ETL load to _y tables and vice versa. So by default, during this flip duration (in other words, database connection unavailable), end users who ever running the reports will be prompted to enter user id and password (signon)for datasource connection. So instead of showing this default prompt page, we should display a custom page with custom message to them saying "reporting application is temporarily unavailable, etc... I am able to show custom message by changing some strings in file "ClientPromptingStrings_en.xml" under c8/templates/ps/prompting. But since this prompt page gets rendered dynamically, I am unable to hide user id and password boxes.

So please suggest any workaround for this problem, even with SDK if possible.

Environment: Cognos 8 BI 8.3, DB2

Thank you,
Kommireddy.