OAS - Incomplete syntax documentation for TRENDLINE function

Michal Zima

Description

We are struggling with incomplete syntax documentation for Advanced Analytics function TRENDLINE.
Documentation (see : https://docs.oracle.com/en/middleware/bi/analytics-server/user-oas/functions.html#GUID-A1A6563A-4B60-471A-87DA-C999CFDFA630 or Blog : https://blogs.oracle.com/analytics/how-to-add-functions-with-a-simple-right-click-in-oracle-analytics).
is stating, that argument model_type can be one of those 2 values: 'LINEAR', 'EXPONENTIAL'.
But when you add "Analytics" into visalization in DV project, representing Trendline, there is also Polynomial method (where you specify degree of polynom - for example 3).
When using Polynomial trendline in DV visualization, BI server (on the background) generates logical SQL statement for this visualization, where TRENDLINE function is used with following argument:
TRENDLINE(numeric_expr, ([series]) BY ([partitionBy]),,'POLYNOMIAL','MODEL',3).
So apparently there is another (third) possible value for model_type argument = 'POLYNOMIAL', calculating polynomial trendline, and last argument (3) , representing degree of polynom.
So I am asking  following:
1) Provide correct and complete syntax of TRENDLINE function with all possible arguments and their values (including this polynomial method) - if those is missing for other analytical functions (FORECAST, OUTLIERS etc...), provide update for those functions as well
2) Amend standard OAS product documentation set to cover those incosistencies (2 documents : "Visualizing Data in Oracle Analytics Server" + "Managing Metadata Repositories for Oracle Analytics Server").
I have also another question to TRENDLINE function - in DV visualization for Trendline you can also set confidence interval - can be the value of confidence interval passed also as argument to TRENDLINE function ?

Use Case and Business Need

Be able to leverage/use analytics function (TRENDLINE, FORECAST, OUTLIER etc...) in a full extent in own calculation (in DV and as well as in Asnwers)

Original Idea Number: fef82d1c6f