Oracle Analytics Publisher Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Publisher Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to Modify the Asset State Parameter in Property Tax Report

Accepted answer
21
Views
1
Comments
Jyotsna A
Jyotsna A Rank 1 - Community Starter
in Oracle Analytics Publisher Forum

Hi ,

PFB details -

1) We want to pass 'All' Values in Asset State Parameter of Property Tax Report. However, by default there is no option to select 'All values' in the parameter in ESS Job of standard report. (PFA Screenshot of ESS Job)

2) When we try to customize the report and modify the ESS Job, We have to make changes in the parameter used in the seeded data model as well in order to pass 'All' but we found that this parameter has been used in the package only which is not accessible by us. (PFA Screenshot of Standard Data Model)

So, the request here is - Is there any alternative to modify the parameter to pass 'All' Values in this report?

Screenshot_2024-06-10_Parameter_used_in_Package.jpg
Screenshot_2024-06-10_ESS_Job_Parameter.jpg

Best Answer

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics & AI Strategist
    Answer ✓

    Hi @User_Jyotsna

    By default existing logic won't allow to modify the design . Refer below MOS doc -

    Add New Parameter To Custom Report 'Property Tax Report' (Doc ID 2756443.1)

    Workaround (Customization)-

    1) removing the dependency of having the existing plsql xmlp package
    2) converting the xmlp package's corresponding logic to multiple subqueries in the xdm.

    Regards,

    Arjun