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

UNAVAILABLE FUNCTIONS FROM BRIO TO OBIEE 12c

Received Response
32
Views
29
Comments
2

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    You could also use evaluate_aggregate function to plumb into your database functions to get this - assuming your DB supports sum by...

  • Gianni Ceresa
    Gianni Ceresa Mod 
    3744064 wrote:Thanks Angel but OBIEE 12c doesn´t aloud the syntax (by)

    OBIEE 12c perfectly accept and allow the "by" syntax.

    The question is more where and how you are using it. Did you build a proper model and is your analysis based on that? Because the "by" implies dimensions etc. to exists (or OBIEE will struggle in understanding how to translate that thing into SQL).

    And depending on how you migrated your BRIO report into OBIEE is that you maybe skipped some steps or took some shortcuts instead of properly modelling sources.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Thanks for this - was trying to find a reference that confirmed the opinion that sum( ...by ) was no longer supported - was failing - thanks for confirming why!!

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    You've got a few posts on Brio to OBIEE ...

    ONE question:  are you doing a report to report conversion OR are you developing an information model that supports the decisions made from the sun-setting Brio reports?

    If the former - good luck (I've turned down a lot of work and $$ because it isn't worth it) ... if the latter, then good for you on doing it right (doing it right means most of your work is being done in a database, ETL/ELT and the BI Layer)

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

    What? Impossible. It works 100% fine.

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

    Good point, but looking at the threads - probably a waste of electronic ink having spelled it out aloud

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Could help someone down the road if not today ... i'm optimistically belligerent

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    I think you may have a side interest in BRIO?

    Gianni's Brio

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

    Hopefully that Gianni cooks better :-P

  • User_15J6I
    User_15J6I Rank 5 - Community Champion

    It is not a problem of modeling, it is as simple as wanting to place a calculated column like in the example that I showed in the post, if I put the sentence you suggest, it marks me a syntax error, it is not the first column that I calculate but I have problems with the cume and the colmax, in fact the syntax that you suggest I had already found it on the internet but since it does not work for me, I entered the forum, maybe it works for an older version I don´t know, thanks anyway