[Advanced] 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:

Example for many dimension paths

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.

Preferred Path

You can set a preferred path to be the default each time you break down a dimension by ticking on "Set this as Preferred Path from Orders to Customers".

Some dimension paths are complicated, going through many tables. Setting Preferred Path can help your team members quickly breakdown to the correct dimension path.