Price Levels

Modified on Tue, 28 Jul at 12:26 PM

Model Summary

The QQube Price Level Lookup Data Model shows the original rate and effective rate for each item for each customer.

Model Type	Price level lookup
Lookup Table	Price Level Details
Primary Result	Original and effective item rates by customer
Power BI Measure	Price Level Rate

Best Used For

Reviewing the rate available to a customer for an item.
Comparing standard item pricing with the effective customer price.
Analyzing price-level assignments by company, customer, item, job, or representative.
Reviewing customer and job pricing across relevant date dimensions.

QuickBooks Source

Price levels are maintained in QuickBooks and synchronized into QQube for use in the prepared lookup model.

Price Level List

QuickBooks Price Level list

Price Level Example

QuickBooks Price Level example

QuickBooks Price Level item pricing details

Price Level Details Lookup

The Price Level Details lookup table supplies the lookup context and the calculated rate used by the model.

Lookup Field	Lookup Type
Measure	Price Level Rate

Price Level Dimension

The Price Level Dimension describes the QuickBooks price level used by the lookup.

Display Order	Field Name
1	Price Level Active
2	Price Level Name
3	Price Level Type
4	Price Level Fixed Percentage

Included Dimensions

The following nine dimensions are included for filtering and analyzing the Price Level Details lookup.

Company	Customer	Customer Rep
Item	Job	Job Rep
Calendar - Job End Date	Calendar - Job Proj End Date	Calendar - Job Start Date

Expected Result

Open the prepared Price Level Lookup example and select the customer, item, job, or other included dimensions needed for the analysis.

The Price Level Rate measure returns the effective rate for the selected lookup context. The lookup table, Price Level Dimension, and related dimensions are already included.