Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have been given a spread sheet that contains fields(plant_name, close_period,prod_rpt_classification) from three different tables and a budget number that is associated it. I have gone back and forth trying different things to get it to load and either I get a circular reference or it restricts my dash board to just the data that exists in the file. I'm a newbie so I'm sure it's something simple that I do not know. I have listed the three tables below with the spreadsheet being the last line in the script. Any help you could give would greatly be appreciated. By the way, I have validated that the data in file matches up to the data in the three fields.
SQL SELECT
"record_id" as plant_record,
"plant_code",
"plant_name",
address1 as plant_address,
city as plant_city,
state as plant_state,
"bl_printed" as plant_blprinted,
country as plant_country,
"cut_off_days" as plant_cutoffdays,
"cut_off_time" as plant_custofftime,
"display_name" as plant_display_name,
faxnumber as plant_fax,
inactive as plant_inactive ,
"max_trucks_per_day" as plant_trkperday,
"phone_day" as plant_phone_day,
"phone_evening" as plant_phone_evening,
"production_plant" as plant_prodflg,
"vmi_flag" as plant_vmiflg,
"warehouse_num" as plant_whse,
zip
FROM "DBA"."order_plant";
SQL SELECT
cast("plant_record" as varchar(10)) +
'/' + cast("close_period" as varchar(10)) +
'/' + "product_code" as BalanceKey,
year("close_period") as trans_year,
month("close_period") as trans_month,
quarter("close_period") as trans_quarter,
"plant_record",
"close_period",
"beg_balance",
"product_code" as product,
"quantity" as end_balance
FROM "DBA"."fg_inventory_balances"
SQL SELECT "approval_required",
"bag_id",
bagpieces,
"bags_per_bundle",
"barcode_id",
"changed_by",
/* comments, */
density,
"desc" as prod_desc,
facing as facing_code,
/* "gp_item_number", */
inactive as prod_inactive,
incompletemasters,
label as label_code,
"last_updated" as prod_last_update,
length as prod_length,
"length_uom" as prod_lengthuom,
loadfact ,
masterbags,
pkgtype as package_id,
pricetyp,
"prod_rpt_classification",
product,
"production_rvalue",
rvalue,
sku,
sqftpkg,
thickness,
"thickness_uom",
upc,
weight,
width as prod_width,
"width_uom" as prod_widthuom
FROM "DBA".productlist;
budget:
LOAD budget_plant as plant_name,
budget_month as close_period,
budget_category as prod_rpt_classification,
budget_lbs
FROM
E:\01.Repository\EXTERNAL\PlantBudget\PlantBudget2012.xls
(biff, embedded labels, table is ProductionData$);