-
Caculated member ?
am newbie to analysis services although a veteran in
DW/BI space. It is a little bit challenging trying to
express queries in MDX since I am new to the language.
Here is what I am trying to do:
EMP_FACT(Fact Table)
---------------
EMPID
DEPTID
LOCATIONID
BEGDTID (JOINS TO D_DAY)
ENDDTID (JOINS TO D_DAY, REALLY AN ALIAS OF D_DAY)
YEARVAL (contains year values like 1997,1998,1999,..)
DIM_EMP
-------
EMPID
EMPNAME
EMPKEY
DIM_DEPT
------
DEPTID
DEPTNAME
DEPTKEY
D_DAY
------
DAY_ID
DAY_DATE(CONTAINS ACTUAL DATE VALUES)
here is what I want to do:
count(distinct emp_id)
where BEGDTID.day_date <=
year_val.properties("fst_day_of_year")<=
ENDDTID.day_date
As you can see I have tried to setup a member
property fst_day_of_year for year_val.
How do I build a calculated member to accomplish this ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|