July 7, 2010 at 4:01 am
Dear All,
I Would ask you for a help in the SSAS.
I have three tables. Based on them, I build a report.
How can I create measures like (Exp1, Exp2 , EXP3.... EXP8) Measure columns in SSAS.
They are not direct colums but a combination of 3 tables.
I want one measure (Expr1) to be created in SSAS which show as below requirement:
For more clarification, kindly check my code example. I think it needs enhancements to works properly.
COUNT(CASE WHEN (dbo.DIM_EMPLOYEES.CNT_NAT_CODE <> '000001' AND dbo.FCT_EMP_SPECS.CURRENT_QUAL = 'C' AND
dbo.DIM_EMPLOYEES.CATEGORY_ID IN (4, 5) AND dbo.DIM_EMP_QUALIFICATIONS.CLASS_ID = 4) THEN 1 ELSE NULL END) AS Expr1,
I really appreciate your helpful support.
Thank you in advance.
Sincerely,
--Shaaban
“The dictionary is the only place where success comes before work.”
July 16, 2010 at 3:45 pm
If you are wanting this to be an actual Measure within the FACT table then you should perform this during/after load time on a per-row basis. If it can be a Calculated Member than try what you have posted (after converting it to MDX of course)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply