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

Cannot display totals in OBIEE report

Received Response
122
Views
9
Comments
Wm Peck 1958
Wm Peck 1958 Rank 2 - Community Beginner
edited August 2024 in Oracle Analytics Cloud and Server

How do you display simple totals of a list view in OBIEE? 🤔

I tried the steps here but I don't see the totals ... 😒 ... If I scroll to the bottom, there are no totals ... 

Here is the setup ...

Obviously I'm a newbie, but I have no one to ask ... 😭

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    What are you trying to aggregate/sum into a total?

    From the screenshots you posted, none of your columns is a measure by default. Still by setting the aggregation rule in the column formula you let OBIEE know how that thing could be aggregated.

    But many of your columns looks like text more than number, so not sure what you are trying to see in a total.

  • Wm Peck 1958
    Wm Peck 1958 Rank 2 - Community Beginner

    I'm looking for a simple record count, thanks.

  • Gianni Ceresa
    Gianni Ceresa Mod

    In that case it should work if you did set the aggregation on at least one column and selected to display totals.



    This isn't on your same version (I believe) but should work the same way.

  • Wm Peck 1958
    Wm Peck 1958 Rank 2 - Community Beginner

    I did the count but don't see it ... I'm looking for record count at the end of the list ... I created a section for Year Group 15, but still don't see the record count like you show ... it looks like you have a "break" but I couldn't figure that out ...

    *I do Business Objects and trying to learn OBIEE, but starting essentially from scratch.

    I don't see a total ...

  • Gianni Ceresa
    Gianni Ceresa Mod

    It has to be said that his is the wrong way to do this. In OBIEE there are measures for a reason: a counting should also be a measure and by defining it as such in the RPD, OBIEE will know exactly how to generate queries.

    It's very difficult to know why you don't see totals, exactly for the reason that OBIEE generate queries based on the RPD and everything works based on that model. But the model is personal, you have an environment with a RPD that nobody else has. So difficult to guess what could influence the lack of totals in your analysis.

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

    This is all you need. It's basic functionality of counting dimension members inside an attribute. But Gianni's point is extremely valid: That's not a measure, it's just counted dimension members.

  • Gianni Ceresa
    Gianni Ceresa Mod

    Do you also enable displaying totals in the table view? (The "edit view" pencil icon of the table view)


  • Wm Peck 1958
    Wm Peck 1958 Rank 2 - Community Beginner

    Gentlemen, thank you for the replies ... I will pick this up on Monday ...

  • Wm Peck 1958
    Wm Peck 1958 Rank 2 - Community Beginner

    Ok, I got it ... I'm bring a Business Objects mentality to OBIEE, and there's a lot to learn.

    thank you both! 😀😎