Oracle Transactional Business Intelligence

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

OTBI Performance tiles for non measure fields

Received Response
32
Views
2
Comments

Hi,

We would like to create a performance tile in OTBI analysis that will count distinct SR references that were opened in the last 2 days. Meaning, we want to use a dimension for calculation and a measure.

I can't "pull" the relevant field into the function dialog.

How can this be done?


Thank you

Tagged:

Answers

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 5 - Community Champion

    Hi @User_SUWGA,
    Your question isn't clear, can you please provide more details with some screenshots to explain the problem

    Regards,

    Gaurav

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited May 1

    Hi, Good news! Yes this can be done. In the presentation tables in your subject areas as you say you have 2 types or presentation columns; blue ones "attributes" (known as a dimension) and "yellow rulers" "measures" (known as facts). It is true that in the view type a of Performance Tile you can only select measures not attributes. But the good news is that if you edit the formula of a column in your query with a function such as count(distinct "t"."attribute column") then you have created your very own custom "measure" column, as it is no longer an attribute, so you CAN include it in a view of type performance tile. You can also use it as a measure in chart views and use it in totals and subtotals in your tables and pivot views etc.