"fname" || ' ' || "lname" fname + ' ' + lname "fname" || ' ' || "lname" CONCAT(`customer`.`fname`, ' ', `customer`.`lname`) fname + ' ' + lname "customer"."fullname" CONCAT(CONCAT("customer"."fname", ' '), "customer"."lname") "fname" || ' ' || "lname" "fname" || ' ' || "lname" "fname" "fname" || ' ' || "lname" fname + ' ' + lname "fname" || ' ' || "lname" CONCAT(`customer`.`fname`, ' ', `customer`.`lname`) fname + ' ' + lname "customer"."fullname" CONCAT(CONCAT("customer"."fname", ' '), "customer"."lname") "fname" || ' ' || "lname" "fname"

Iif("sales_fact_1997"."promotion_id" = 0, 0, "sales_fact_1997"."store_sales") (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end) (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end) (case when `sales_fact_1997`.`promotion_id` = 0 then 0 else `sales_fact_1997`.`store_sales` end) `sales_fact_1997`.`store_sales` (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end) (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end) (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end) (case when "sales_fact_1997"."promotion_id" = 0 then 0 else "sales_fact_1997"."store_sales" end) [Measures].[Store Sales] - [Measures].[Store Cost]

`warehouse_sales` - `inventory_fact_1997`.`warehouse_cost` `warehouse_sales` - `inventory_fact_1997`.`warehouse_cost` "warehouse_sales" - "inventory_fact_1997"."warehouse_cost" [Measures].[Warehouse Sales] / [Measures].[Warehouse Cost] TopCount([Warehouse].[Warehouse Name].MEMBERS, 5, [Measures].[Warehouse Sales])

[Measures].[Store Sales] - [Measures].[Store Cost] [Measures].[Profit] / [Measures].[Units Shipped]