BI Publisher (MOSC)

MOSC Banner

How to reference summary colum for same data set in BI Publisher's data model?

edited Apr 11, 2012 12:40AM in BI Publisher (MOSC) 7 commentsAnswered
 In BI Publisher, it do not support add element by PL/SQL in the data set. In order to add this kind of element (column) in data set, we should create function in the report package and call this function in the SQL of the data set. Now we the function created in above is required to refer the summary column in the same data set. I find that the column summary in the SQL is consider as null.
 For example,
 
 The below is the data model created for test. We use the :CS_PREFIX_COUNT in the SQL of data set to get the value of summary column, CS_PREFIX_COUNT.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center