Application management : Business intelligence & reporting : Connect for Analytics : Working with... : Finding Planon data in the data lake : Finding the right column
Finding the right column
Suppose you are interested in the field Time to fix, which column should you use?
Time to fix field.Time to fix field.
The BaseBOFieldDefinition table stores all the field translations.
1. In the following sample PowerBI chart, go to the Fields tab and filter on BO PNname "ServiceLevelAgreement" and find "Time to fix" in the AME column
Fields tab.Fields tab.
The PNname of the field is TimeToFixRef. This means it is a reference to another table, which you will need to find.
2. Click Edit queries.
Edit Queries button.Edit Queries button.
3. Scroll to the right until you find a column that contains "records" that starts with "TimeToFixRef".
TimeToFix column.TimeToFix column.
You will find that the column is called TimeToFixRef_Priority. This means it is a reference to the Priority table. You do not need to load the Priority table, you can click the "expand button" to the right of the column.
List of available fields.
4. Select the fields of the Priority table you need.
Column with filtered fields.Column with filtered fields.
Now you have the Time to fix fields you wanted to report on.