I'm new to AS 2005 and am not sure the proper place to put
this.... I need to be able to access the following in other cube calculations:
Previous Month Current Balance:
SELECT CURR_BAL
FROM PERFORMANCE P INNER JOIN MASTER M ON
P.ACCT_OID = M.ACCT_OID
WHERE M.PROCESS_DT = DATEADD(MONTH, DATEDIFF(MONTH, 30, GETDATE()) -
1, - 1)
Process date is a month-end date. I have a Time.dim based on Process_Dt.
I tried using the ParrallelPeriod function with no success.
The "big picture" question I have is where do you create stuff that uses more than one fact table and/or dimension?
(I'm trying to convert Excel Pivot table formulas to be used in the cube instead.)
Thanx for any help,
Beth
this.... I need to be able to access the following in other cube calculations:
Previous Month Current Balance:
SELECT CURR_BAL
FROM PERFORMANCE P INNER JOIN MASTER M ON
P.ACCT_OID = M.ACCT_OID
WHERE M.PROCESS_DT = DATEADD(MONTH, DATEDIFF(MONTH, 30, GETDATE()) -
1, - 1)
Process date is a month-end date. I have a Time.dim based on Process_Dt.
I tried using the ParrallelPeriod function with no success.
The "big picture" question I have is where do you create stuff that uses more than one fact table and/or dimension?
(I'm trying to convert Excel Pivot table formulas to be used in the cube instead.)
Thanx for any help,
Beth
