Why this field is empty?

Question

I have created a report from the subject area "Workforce Performance - Performance Rating Real Time", in which it's extracted the field "- Rating Level"."Rating Level Code".

How come this is empty if I also add the fields "- Performance Document Item"."Competency Name" and "- Performance Document Item"."Proficiency Rating Model Name" and presents values if I take them off? How can I view the data in "Workforce Performance - Performance Rating Real Time" with the other two columns also present?

Sivakumaran Muthusamy-Oracle · Answer

Hi @Gian Luca Triglia ,

In Performance Document the Rating is captured at a section name called, "OverAll Summary", so you need to apply a filter on "- Performance Document Section"."Name" ='OverAll Summary'.

To fetch the the Manager's Final Rating, you have  to apply a filter on "Performance Document Participant"."Role"='Manager'.

Now when you add the "- Rating Level"."Rating Level Name" and "- Rating Level"."Rating Level" you'll get the final Rating and its associated Code/Numerical value.

Request to try this method and share your response.

Attached the sample catalog for your reference.

Performance Rating.catalog

AnishaPatra-Oracle · Answer

Have you used any fields from Worker dimension? Are you trying to fetch the above stated three fields based on an employee level? Can you share the full list of fields you trying to pull in the Analysis?

Nathan CCC · Answer

Hi,

In general terms for any subject area all subject areas are designed using the same pattern of facts and dimensions arranged as a star schema to answer business question "I need measure X by dimension A, B". All queries must have a fact unless you just want a simple list of values of what is in a single dimension like in a prompt. If you do not select a fact the the system will select a default one on your behalf which might be the wrong one so it is good practice to select the one you want to use.

So if you have blue "attribute" columns from 2+ different "dimensions" then you need to include in your query a yellow "measure" fact column that is conformed for both dimensions. Conformed means that the fact has a foreign key reference relationship to both dimensions as a "star" schema.

So in your case what is the fact table that is common between dimension presentation columns "Rating Level" and "Competency Name" and "Proficiency Rating". To answer this question read your session log the look at the joins in the sql generated by the metadata repository database to answer your logical query from your subject area. So on page /analytics/saw.dll?sessions or /analytics/saw.dll?issuerawsql having cut paste the logical sql from the advanced tab of your analysis.