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

OBIEE 11g Table Totals

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

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 Lead

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

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics 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.