Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

XML Publisher Heading Suffixed With Date

Received Response
111
Views
16
Comments
Jacobelia S
Jacobelia S Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

Summary

XML Publisher Heading Suffixed With Date

Content

Hello,

I have a report with parameter, heading and data as shown in the enclosed screenshot

1.JPG

Could it possible to have the date concatenated with the heading based on the parameter? Let me elaborate,

if the parameter is 13-Sep-2017, then heading should be suffixed with the date as shown in the below screenshot

2.JPG

Appreciate any insight or help.

​

«1

Answers

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Could you please upload/send mail...the rtf and sample xml

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    ohh...then you can just add <?format-date:ParameterName;'dd';'Asia/India'?>

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    Yes...you can subscribe to any country and region.

    for the format 'day-dd' if date is 25-Sep-2017. it will return Monday-25. You may need to do substr to get Mon-25

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    you can user <?format-date:ParameterName;'day-dd';'Asia/India'?>

  • Brajesh Shukla-95078
    Brajesh Shukla-95078 Rank 7 - Analytics Coach

    If I understand you problem correctly...you are passing one Date as a parameter and from that date you are displaying the data two days back and two days in future.

    I mean if I pass date as 25-Sep-2017 what you are expecting in output?

  • Jacobelia S
    Jacobelia S Rank 5 - Community Champion

    I have emailed you the sample test data and rtf.

    Thanks

  • Jacobelia S
    Jacobelia S Rank 5 - Community Champion

    I have tried as shown in the enclosed screenshot, however, the date is getting displayed along with the heading.

    4.JPG

  • Jacobelia S
    Jacobelia S Rank 5 - Community Champion 
    for the format 'day-dd' if date is 25-Sep-2017. it will return Monday-25. You may need to do substr to get Mon-25

    The heading already exist, all I need to do is concatenate 'dd'.

  • Jacobelia S
    Jacobelia S Rank 5 - Community Champion 
    you can user <?format-date:ParameterName;'day-dd';'Asia/India'?>

    I presume that I can exclude the day as I need only the date which is 'dd' and second question is do I need Asia/India? Can I substitute with any Country/Region?

  • Jacobelia S
    Jacobelia S Rank 5 - Community Champion

    Hello,

    My expected output is shown in the enclosed screenshot,

    3.JPG