![]() These sql statements will not be visible to the universe or reporting tool. This allows the sql statements such as CREATE, DROP, INSERT, UPDATE statements to be used, where it is not permitted in the universe structure. A universe is a read only object and a database stored procedure provides the possibility of manipulating the data before it is consumed by the universe or reporting tool. A stored procedure is an encapsulated set of sql statements that is stored and run on a database. What is a Stored Procedure?īI version XI 3.1 introduced the option to create a universe on a stored procedure. This is an explanation of a stored procedure universe and some of the benefits and limits of its use. While a Stored Procedure provides some performance improvement the feature has restrictions that should be considered before designing the universe. With the release of BI 4.2 SP6 it can now be created as a UNX universe with the Information Design Tool. OverviewĪ stored procedure can be created as a UNV universe created in the Universe Design Tool. ![]() What are the benefits and the limitations of a stored procedure universe. This is to describe how a stored procedure universe is created at the semantic layer and how Web Intelligence will consume this type of universe.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |