Managing Custom Series
Posted
by user702295
on Oracle Blogs
See other posts from Oracle Blogs
or by user702295
Published on Tue, 12 Nov 2013 15:55:19 +0000
Indexed on
2013/11/12
21:59 UTC
Read the original article
Hit count: 267
/General
Custom series that have been added should be done with client Defined Prefix, ex. ACME Final Forecast, so they are can be identified as non-standard series. With that said, it is not always done, so beginning in v7.3.0 there is a new column called Application_Id in the Computed_Fields table. This is the table that stores the Series information.
Standard Series will have have a prefix similar to COMPUTED_FIELD, while a custom series will have an Application_Id value similar to 9041128B99FC454DB8E8A289E5E8F0C5.
So a SQL that will return the list of custom series in your database might look something like this:
select computed_title Series_Name, application_id
from computed_fields where application_id not like '%COMPUTED_FIELD%' order by 1;
© Oracle Blogs or respective owner