hello two newbie questions for OLAP. I'm looking at my cube from Visual Studio ...
(a) Edit Dimension
I want to basically add a new Dimension level - under Design view of "Dimension Structure" ...
I can see Data Source View tabs containing two existing tables which make up my original dimension. Trouble is, how can I add the third? Can I add a table for this dimension?
(b) Delete Partitiion
I can find from under Cube's Design view there's one tab "Partitions" - and I can delete partition manually one-by-one right click + select "Delete" from Context Menu. Is there a quicker way of doing this?
Table1 having products and serial number information, and Table2 having set of 32 check points to say that product having defect or not, i want to get only total number of non defected products for each month,
say example i have 3 products in march month and only 2 products satisfy set of 32 check points and having non defect, so for this problem result will be Total Number of non defected product will be 2. i want this in query.
I tried it but it giving each product defect count, i want only total number of non defect product
here is my query
WITH months (num) as(
WHERE num<12)SELECT m.num as Month,
--isnull(t.count,0) as Total,
isnull(t.resolved,0) as Totalresolved,
t.YearValue as YearData FROM months m
leftjoin (SELECT month(ProgramStartedDate) as Month,YEAR(ProgramStartedDate) as YearValue,
--count(*) as count,
sum(casewhen (ProgrammerStatus = 1OR ReviewerStatus = 1) THEN1ELSE0END)as resolved
LEFTJOIN dbo.tb_ProgramDetails on
tb_ProgramDetails.ProgramID =tb_ProgramCheckList.ProgramID AND tb_ProgramDetails.Version=tb_ProgramCheckList.VersionID
WHERE ProgramStartedDate >='10/1/2012'and ProgramStartedDate <'10/01/2013'--AND month(ProgramStartedDate)=m.num GROUPBY month(ProgramStartedDate),YEAR(ProgramStartedDate)
If any body help me to solve this issue will be appreciated,