Customized SQL Query Anlaysis Services | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Customized SQL Query Anlaysis Services


Dear All, Can we have a customized query like this in analysis services.
SELECT "dbo"."ProductionCompliance"."Category Description",
left("dbo"."ProductionCompliance"."Adexa Code",5),
"dbo"."ProductionCompliance"."Production Year-Week",
"dbo"."ProductionCompliance"."Source Site",
"dbo"."ProductionCompliance"."Planned", "dbo"."ProductionCompliance"."Confirmed",
"dbo"."ProductionCompliance"."Adexa Plan", "dbo"."ProductionCompliance"."Actual",
sum("dbo"."ProductionCompliance"."Min" ) FROM "dbo"."ProductionCompliance"
GROUP BY "dbo"."ProductionCompliance"."Production Year-Week", "dbo"."ProductionCompliance"."Source Site", left("dbo"."ProductionCompliance"."Adexa Code",5)
Thanks, Hemanth Hemanth
Yeah, and probably a lot more.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx for information.
HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>