OBIEE count — Oracle Analytics

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 count

Received Response
206
Views
7
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead
edited Aug 13, 2024 5:47PM in Oracle Analytics Cloud and Server

Hi i am using OBIEE 1c

What i want to know is is there a possibility to count different unuque values in the table.

For example i want to count something like this

ID          Decision id

100            1

100            2

101            1

100            1

So i want to count how many unique combinations od ID and Decision ID are there

Best regards Matija...

Answers

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Count(Distinct ) will do that. Either set it as aggregation rule or use it in the formula depending on your exact requirement

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    If you want to count the unique conbinations then you should do something like count(distinct concat(Concat("ID",'~'),"Decision ID"))

    The ~ is use as a separator to make sure that for instance 10 and 11  are not counted as the same as 101 and 1

    EDIT: If the ID's are numbers then use Cast as Char to convert them to chars

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    If you can display both ID, Decision_ID column, then you can have a ID, Decision_ID and COUNT(*) because group by will be applied on ID and Decision_ID, giving you distinct combinations.

    Obviously a shorter format will be Count Distinct in RPD Aggregation or CountDistinct in Analysis (please note the presence of SPACE in RPD formula)

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Yes that is correct, I was thinking too complicated :/

  • Gianni Ceresa
    Gianni Ceresa Mod 
    Martin van Donselaar wrote:Yes that is correct, I was thinking too complicated :/

    Or thinking right when other columns get in the analysis (or the 2 mentioned aren't there). Never ever imagine the OP will do just what he asked for on the thread

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Yes it depends on the exact requirement. At least the OP now has multiple solutions to choose from :-)

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Seems like he is very famous....