OTBI Performance tiles for non measure fields

Question

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

Nathan CCC · Answer

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.

Gaurav Bharadwaj-Oracle · Answer

Hi @User_SUWGA,

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

Regards,

Gaurav