Hello,
We are still primarily using the client until I get all the customizations, dashboards, etc moved over.
We are also a cloud gov customer so no access to servers…
I created a kinetic dashboard that automatically shows the BAQ data when opened.
When I open it in company A, it shows the data but a manager opens the same dashboard in the same company and gets no records…
If he opens the dashboard in a different company, it pulls in the data fine.
If the manager opens the BAQ direct, it works fine.
I have tried clearing the client cache and even manually deleting the cache folders, no help.
If I open a browser session as him, it does the same.
Is there a way to clear the kinetic cache also?
I am posting the BAQ Query Phrase to see if anyone has an idea.
If any more information is needed, please let meknow and I will get it posted here.
I appreciate all the help this site gives!
* Disclaimer!!!
* This is not a real query being executed, but a simplified version for general vision.
* Executing it with any other tool may produce a different result.
*/
select
[Part].[PartNum] as [Part_PartNum],
[Part].[PartDescription] as [Part_PartDescription],
[PartCost].[StdMaterialCost] as [PartCost_StdMaterialCost],
[PartCost].[StdMtlBurCost] as [PartCost_StdMtlBurCost],
[PartCost].[StdLaborCost] as [PartCost_StdLaborCost],
[PartCost].[StdBurdenCost] as [PartCost_StdBurdenCost],
[PartCost].[StdSubContCost] as [PartCost_StdSubContCost],
[PartBin].[OnhandQty] as [PartBin_OnhandQty],
(PartCost.StdMaterialCost + PartCost.StdMtlBurCost + PartCost.StdSubContCost + PartCost.StdBurdenCost + PartCost.StdLaborCost) as [Calculated_Cost],
((PartCost.StdMaterialCost + PartCost.StdMtlBurCost + PartCost.StdSubContCost + PartCost.StdBurdenCost + PartCost.StdLaborCost) * PartBin.OnhandQty) as [Calculated_ExtCost],
[Part].[ClassID] as [Part_ClassID],
[Part].[TypeCode] as [Part_TypeCode],
[Part].[NonStock] as [Part_NonStock],
[Part].[ProdCode] as [Part_ProdCode],
[PartBin].[Company] as [PartBin_Company],
[PartBin].[WarehouseCode] as [PartBin_WarehouseCode],
[PartBin].[BinNum] as [PartBin_BinNum],
[Part].[Durometer] as [Part_Durometer],
[Part].[IUM] as [Part_IUM],
(PartCost.LastLaborCost + PartCost.LastBurdenCost + PartCost.LastMaterialCost + PartCost.LastSubContCost + PartCost.LastMtlBurCost) as [Calculated_LastCost],
[PartPlant].[MinimumQty] as [PartPlant_MinimumQty],
[PartPlant].[MaximumQty] as [PartPlant_MaximumQty],
[PartPlant].[SafetyQty] as [PartPlant_SafetyQty],
[PurAgent].[BuyerID] as [PurAgent_BuyerID],
[PurAgent].[Name] as [PurAgent_Name]
from Erp.PartCost as PartCost
inner join Erp.PartBin as PartBin on
PartBin.Company = PartCost.Company
and PartBin.PartNum = PartCost.PartNum
inner join Erp.Part as Part on
Part.Company = PartBin.Company
and Part.PartNum = PartBin.PartNum
inner join Erp.PartPlant as PartPlant on
Part.Company = PartPlant.Company
and Part.PartNum = PartPlant.PartNum
left outer join Erp.PurAgent as PurAgent on
PartPlant.Company = PurAgent.Company
and PartPlant.BuyerID = PurAgent.BuyerID