Oracle Transactional Business Intelligence

Products Banner

OTBI Performance tiles for non measure fields

Received Response
31
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

  • 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 ✭✭✭✭✭
    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.