Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11g Table Totals

Received Response
11
Views
5
Comments
3256445
3256445 Rank 1 - Community Starter
edited Aug 13, 2024 6:05PM in Oracle Analytics Forum

I'm looking for some advice on OBIEE Tables I've an issue where I bring in a date field and the Total line tries to aggregate the dates.

I've so far tried unchecking Report Based Total (when applicable) and setting the filed to an Attribute with no success

I've also tried looking at the XML in the Advanced tab of the reports editor but have been unable to adjust the formatting there.

Can anyone give some insight on how to tackle the issue?

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    What kind of model do you have? If the table give you a total for your date it means it's a measure and so it can be right but it can also (often) be wrong ...

  • 3256445
    3256445 Rank 1 - Community Starter

    Thanks for the reply.

    It's set up as a measure as in some instance we are required to find the difference between a baseline and forecast date however in this instance we just need it to display the date with no aggregation certainly not in the Total line.

  • FTisiot
    FTisiot Rank 6 - Analytics & AI Lead

    Can you set the Aggregation to "None" in the Criteria tab?

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    Difference in dates is a measure

    Date itself is an attribute - get it into a dimension where it belongs.

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

    THANK you.