How do you use SQL in developing cognos solutions?

From: "findu_2005@xxxxxxxxx" <findu_2005@xxxxxxxxx>
Date: 15 Dec 2006 15:12:45 -0800

Hi, When developing solutions using Cognos Impromptu and Powerplay, how
do you take advantage of database objects such as views, triggers,
stored procedures, user defined functions?

Is there a time that you have to develop those database objects
yourself ? for what reason?
Thank you.

.

Prev by Date: Re: UDM approach/concept in real
Next by Date: Crystal Report from Stored Proc?
Previous by thread: Re: SQL Server -- Bulk Insert from Excel to SQL Server
Next by thread: Crystal Report from Stored Proc?
Index(es):
- Date
- Thread

Relevant Pages

Re: Is there a way to view Stored Procedure, Trigger andFunction Usage in SQL Server?
... It is considered good practice to have your database objects scripted ... and in source code control. ... this post with a util stored proc that you may find useful (don't know ... Triggers, Stored Procedures and User Defined Functions. ...
(comp.databases.ms-sqlserver)
Re: Granting GRANT permissions
... they can create stored procedures owned by dbo. ... process as they can add, modify, drop database objects, not ... >> Creators of stored procedures (standard users with CREATE PROCEDURE rights) ...
(microsoft.public.sqlserver.security)
MSDE no access on database objects
... I have installed MSDE 2000 A, but I can't edit the database objects (tables, ... stored procedures, etc.) in Access 2000. ... If I try, the window appears only ...
(microsoft.public.sqlserver.msde)
Whats the fastest way to assign read/write/execute right to a user?
... But db_writer and db_reader don't have permission to run ... stored procedures nor user defined functions. ... >>rights to all tables/views and execute rights to all ... >>create any new database objects. ...
(microsoft.public.sqlserver.security)