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
13»

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Trust me, I really prefer to be able to help people instead of proving them wrong ...

    This is OBIEE 12.2.1.3 (the exact same works on all the 12.2.1.x and also on 12.2.2.x)

    Capture.PNG

    So, now that we all agree that OBIEE always supported (at least for the last 10 years) the "by" syntax in aggregations I guess it's time to make a step back and start from the beginning:

    You are replicating/migrating a Brio report and you are doing it in OBIEE. Give more details on what you used as approach, how are you doing it, what kind of model you are working on. Thomas asked about it earlier already: how are you doing your migration? Report to report or by first building a model supporting the analysis you will need?

    The forum is glad to help if you do your part of the job (and trust me one more time when I say that many of us here exactly know why we asked these questions "been there, done that" ...).

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

    Beaten to it by Gianni so I can shut down my VM again.

    This is almost ancient functionality and works perfectly fine in the front-end.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Like in good fiction, on this board do not tell, show.

    Show the forum; -

    Your function.

    Your answers analysis and presentation format.

    Your physical sql.

    Your error.

    Otherwise we are stuck with those of us who know that 'By' works and you who cannot get 'By' to work - help us bridge that gap, we need to see through your eyes to help you resolve this.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    "It is not a problem of modeling, it is as simple as wanting to place a calculated column"

    "Simply wanting to place a calculated column" -- success depends on the model ... ALWAYS

  • User_15J6I
    User_15J6I Rank 5 - Community Champion

    Hi Gianni! You are right, Maybe I didn´t express my doubt in the right way, I was trying to do than on the rpd, the image that you shared in an online example?  I think it can be useful to me, Could you share the technical reference that support the example of the image please?

    Thanks a lot

    ESM

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

    If you look at the column header you see two things

    a) that he used a formula in the analysis and

    b) the formula: MAX("Facttable"."Revenue" by "Dimensiontable"."Brand")

    Note the "tables" are not the actual names of the tables since I dont have OBI in front of me. I guess it's "Measures" and "Product" respectively.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Just what Christian said

    And if you were trying to do it in the RPD, you don't need the "by" syntax there as you have full access to all the properties of your model, so you set things by using content levels etc.

    That's why many on here had doubts about your model. As soon as you have a proper model with dimensions and hierarchies defined you have full access to the power of content levels.

  • User_15J6I
    User_15J6I Rank 5 - Community Champion

    Hi Gianni do you have information about how to do this (amount by state) like the picture that you share with me, on the RPD?

    You said that I  can use content level, where can I get information about that?

    Thanks a lot

    ESM

  • Gianni Ceresa
    Gianni Ceresa Mod

    You can read about "content level" in the doc and if you google it you must find some blog posts as well. It's an extremely powerful feature of OBIEE which needs to be tested and understood. If you don't get the expected result the first time check again the settings and try again.