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

From to period is not working in OTBI report

Received Response
2
Views
1
Comments
Omran Zeaiter
Omran Zeaiter Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

When i am trying to add a parameter, for budget period name , i am using between in the prompts but it's not giving the from to period.
Sometimes it's giving error and sometimes its just giving based on first letter (January June July if from jan to July).
If anyone knwos how to make the from to working.

Thanks in advance

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach

    Hi Omran,

    Period name is a string not time. You could perhaps change it to a prompt on a date like where "Period Start Date" or "Period End Date" between X and Y?

    The decision on what period of time a period name represents using what naming convention was a choice made by your application implementation consultant. Your general ledger may be setup with any periods of time such as 7 day sun-mon weeks periods like in a 445 months calendar or most likely a year of 12 calendar months with 28-31 days maybe with a 13th adjustment period.

    So on a string column between will work I think based on the alphabet numeric of the text in your period names. So this will not work as time unless perhaps your period names are in a format like international organization for standards format "yyyy-mm". But your period names are likely Mon-YY like "Dec-99".