Hi,
I'm attempting to create a dimension with a dynamic calculation.
The dimension is a "Scenario" with a member titled "Q1 Forecast". "Q1 Forecast" is a child of a parent Scenario dimension titled "Earnings Forecast". There are two dimensions that must be added together to get "Q1 Forecast". One is another child of "Earnings Forecast", titled "Q1 Assessment". Another is a separate parent member in the Scenario dimension titled "Budget". The outline below shows the relationships I just outlined:
Dimension: Scenario
- Budget
- Earnings Forecast
- Q1 Forecast
- Q1 Assessment
- Q2 Forecast
- Q2 Assessment
I set the member formula for "Q1 Forecast" to: "Budget" + "Q1 Assessment" = "Q1 Forecast"
I use SmartView to submit data to "Q1 Assessment", but unfortunately "Q1 Forecast" does not find any data for "Budget".
So the dynamic calc works, but it only adds "Q1 Assessment" to "Q1 Forecast".
I know there is data in "Budget", because I can pull it down in SmartView. I also tested changing the formula in "Q1 Forecast" to:
"Q2 Assessment" + "Q1 Assessment" = "Q1 Forecast"
This does properly add up "Q2 Assessment" and "Q1 Assessment", but that's not the formula I actually want for "Q1 Forecast". I did this just to test if adding up two child members worked.
So does anyone know why the formula below doesn't recognize any data in "Budget" when I know for a fact that the data is in PBCS?
"Budget" + "Q1 Assessment" = "Q1 Forecast"