You can approach it in multiple ways

1. Unified Metric View

Build a single unified view by joining Sales and Product tables. It allows to expose State and Maker as dimensions within one metric view.

CREATE VIEW sales_product_view AS
SELECT 
 s.state,
 s.sales_amount,
 p.maker
FROM sales s
JOIN product p 
ON s.product_id = p.product_id;

2. Modular Metric Views with Joins

Create separate modular metric views based on purpose

• Sales by State - Metric View with a join between sales and state dimension
• Sales by Maker - Metric view with a join between sales and product dimension.

It aligns well with domain driven design and easy to manage

3. Star Schema Approach

Adopt a star schema (Fact & Dimension) design as it simplifies metric view creation with easier governance and extensibility if it supports the case.