nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Cannot display totals in OBIEE report

Wm Peck 1958

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 ... 😭

Find more posts tagged with

OBIEE

Accepted answers

All comments

Gianni Ceresa

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

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

Gianni Ceresa

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

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

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]

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

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

Wm Peck 1958

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

Wm Peck 1958

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

thank you both! 😀😎