Dimension Path
When your database has complicated joining paths between tables and each joining path gives you a different result with different need, you can change to the needed path on Presight.
You can check the sample schema below:
In the example, if you need to breakdown Invoice Amount by city, which path you want it to breakdown? City through Customer table or City through Seller table. Presight allows you to choose the needed one. If you want to see if the amount coming from which Seller City, choose the path going through Seller table, if you want to check how much from Customer City, choose the path going through Customer table.
How to use
Case 1: when there are more than one path with the same table numbers to go through
When there are more than one path with the same table numbers to go through, a pop up will appear to ask which path you want to use. Then just choose the one you need and click Select Dimension
Case 2: when the dimension path is automatically choosen by Presight, the pop-up does not show up.
Most of the time, Presight will automatically choose the shortest path for you when breaking down a metric. However, you can choose another path based on your certain needs. Then, you can right click on the dimension name, and choose Change to a different [Dimension name].
A dimension path list will pop up and allow you to choose to another one.
Last updated
