Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Pivot table in RTF Template

1665
Views
14
Comments
2»

Comments

  • Luis Villagomez - IMMI
    Luis Villagomez - IMMI Rank 2 - Community Beginner

    Hello dear experts, I am looking for some help with this pivot RTF template, I am almost done with my template however I am not able to figure out the error I am getting, in below screenshot I have colored in yellow two projects, T002220 and T002221, for this couple of projects amounts should be displayed from Nov-24 to May-25, however the amounts start displaying from Oct-24 to Apr-25.

    For this couple of projects column Oct-24 should be blank and column May-25 should have value instead of blank.

    Do you have any insights about it ?

    image.png

    Thanks.

    Luis.

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Dec 6, 2024 2:51PM

    Hi Luis, What does your data look like for these 2 projects as a normal table not pivot table. That is what does your data look like in the XML from your data model before you do any data visualisation. For example, if you download your report as output format data CSV. What is the grain of your query? Is it 1 row per project per month. For project T00220 do you have 7 rows. What are the months in each of the rows?

    I guess I am asking why is it that you expect Oct-24 to be blank? The answer I assume is in the data but you have not shared the data. What are these amounts of money by the way. Are these perhaps cost distributions or revenue distributions from a project expenditure items? What date field on the transaction are you using to group by calendar month?

  • Luis Villagomez - IMMI
    Luis Villagomez - IMMI Rank 2 - Community Beginner

    Hello Nathan.

    Very good morning, I am attaching in a spreadsheet the results of my query.

    Within the file project C001599 return 2 rows from Oct-24 to Nov-24.

    Project T002220 returns 7 rows from Nov-24 to May-25.

    Project T002221 returns 7 rows from Nov-24 to May-25.

    Project T002224 returns 3 rows from Nov-24 to Jan-25

    and finally T002225 returns 1 row for Dec-24

    I am using the column PROJ_PERIOD_NAME within the spreadsheet to group the data, and I am using below syntax within the RTF template to display the amounts.

    <?for-each-group@cell:current-group();./PROJ_PERIOD_NAME?>

    <?format-number:CST_PERIOD;’999G999D99’?>

    <?end for-each-group?>

    Thanks so much.

    Excel File to test Pivot_A.xlsx
  • User_E2AKU
    User_E2AKU Rank 1 - Community Starter

    same issue i am facing in oracle R12 RDBMS : 12.1.0.2.0
    Oracle Applications : 12.2.6
    Report working fine in workstation but goes into warning in application