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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Procedure

Started by esanray, 01 Nov 2011 11:35:41 PM

Previous topic - Next topic

esanray

My database is oracle I want to know creating procedure is good or I will use framework manager to get the information which is required my reporting. I mean to say is there any advantages to create procedure at database level or I will create the attribute at FM. I never create procedure that's why I want to know.

blom0344

The primary reason for creating a database procedure is that you need some sort of non-set based logic (procedural logic) which does not 'fit'  into FM. If you can fetch the data through regular expressions within the framework, then a DB Procedure may you mean just overhead. (as in worse performance and unwanted complexity)