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

Help in finding difference of two dates

Received Response
52
Views
14
Comments
2»

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    I'm joining the party a bit late but reading through what has been posted it sounds like a really inefficient way of solving the problem ...

    @Thomas Dodds suggested in his post to manage this requirement in the database directly, the options wasn't really discussed and you end up in the end asking for LAG/LEAD functions (so bypassing OBIEE itself and ask the DB to the do the job).

    Isn't really the best option to just add a column in your DB with that value?

    Alternatives plans :

    - what about using a view (or even an opaque view , yes@"Christian Berg", I'm suggesting that )

    - model it in your RPD to just put the 2 dates one next to each other on the same row directly and make any calculation between these 2 extremely simple without going outside of standard OBIEE solution (modelling in RPD is what the tool is done for)

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    I didn't say a word ;-)

    But in all honesty I'd also push this to the DB so that you only ever use a result in OBI. Either by your one-row-approach or by doing the calc in ETL/ELT and then use that physical result.

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello, maybe is not the efficent in the time of response, however the first advice solve the requeriment, this requirement its a little tricky because we have to deal with two rows, to get a metric, as a the best answer I also have the idea to push it with ETL or ELT process.

    Kind Regards,

  • user11394485
    user11394485 Rank 3 - Community Apprentice

    Hi,

    Is there any way to limit the result to one row in 'MetricCalculated' column for each project.

    Cesar,I have tried your approach to eliminate the duplicates but didn't go well.

    Regards,

    Laxman