Hi there!

Is it possible to quickly check in R12 how a perspective is constructed and to determine its data path quickly like we do in Metrics? I'm troubleshooting a couple of OOTB reports and I'm a little stuck there. Any help is appreciated

Andrés

The best way to do this is to bring the perspective into a table, you can then either see the formula in the formula bar, or if you click the column, then Data, Edit, you will also see the formula

Does this help?

Hi Michael,

Thank you for your response. I have tried that and it perfectly works. Just one more thing, there is a couple cases where I click on a column and the formula bar does not come down. In this case it is not a problem because I can clearly see where the values are coming from, but it concerns me because it might not be the same in the future. Why could it be? The edit icon also appears greyed out.

Thank you again!

If the formula does not come down it generally means it is either a metric or numeric column directly from the Master Dataset

Shouldn't in that case at least the formula bar just come down anyway and be i.e ''Labor Master Data.Labor Headcount''?

well I see where you are going with this, but I think not. In this case it is not a formula and not something that can be changed, it is native content.

However, If you look at the datapath of the report, you'll see in here where the datapoint has come from

Should we save the table that we used to edit the formula for the perspective as a separate report for the changes to reflect?