Calculation with more than 1 Fact table

[budbeth]

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

 

[MDXer]

you create a calculated Member within the cube definition.

[Measures].[Price]*[Measures].[Quantity]

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck