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

Add division parameter to OTBI Report

Received Response
383
Views
14
Comments
2»

Answers

  • Sovitendu Jalli-Oracle
    Sovitendu Jalli-Oracle Rank 3 - Community Apprentice

    Hi Trent,

    Please follow the below steps,

    Add a new column to the analysis (It can be any column from the subject area)

    Click the Properties button & then click on Edit formula

    Copy & paste the expression which I have provided as per the below screenshot (i.e SUBSTRING('450.100.16300.7500002.000.00000' FROM 5 FOR 3)

    **Replace '450.100.16300.7500002.000.00000' with the actual column name.


    Click OK to come to the analysis workspace.


    Hope this helps, please let me know if you have any further questions.

    Regards,

    Sovi

  • Trent M
    Trent M Rank 3 - Community Apprentice

    Thank you Sovi. That worked great.

    Appreciate your help with this!

    Trent

  • Sovitendu Jalli-Oracle
    Sovitendu Jalli-Oracle Rank 3 - Community Apprentice

    Hi Trent,

    Glad to hear it worked for you & happy to help you.

    Regards,

    Sovi

  • Ajeez K-Oracle
    Ajeez K-Oracle Rank 1 - Community Starter

    Hi Trent,

    From where did you got the Department column in the "Expenses - Expense Transaction Real Time" Subject area. Please share your thoughts.

    Appreciate your help.

    Regards,

    Ajeez