MongoDb

Purpose : To modify stored procedure  scripts to combine data between MITECS + CAMSTAR to support SSRS report  

Report name                                    Description                                         Stored procedure name
HGA_WIP_FG_Inventory_Report                    HGA WIP summary Finish good inventory report        REP_HGA_WIP_FG_REPORT
LotInformation_SubReport (sub report)          Drill down to see detail                            REP_HGA_WIP_FG_SUB_REPORT


Option select data to generate report 
  1. CAMSTAR
  2. MITECS
  3. CAMSTAR + MITECS

SQL Server Information :

WDTBMITECSDEV01.tb.asia.wdc.com\WDBMITECS3TRAIN
DB : User_datatemp
User : repuser
P/W : rep27090*

Link server to get data from CAMSTAR : DV_THO_DEV

Example : to query camstar inventory status from DV  
select * from openquery (DV_THO_DEV,'SELECT TOP 10 * FROM CAMSTAR_INVENTORY_LOT_STATUS')



require to show existing report compete get data from DV 


Note... Pls. donot delete any data in table or view....  


https://westerndigital.metricstream.com/metricstream/systemi/Userloginsso