Skip to Content
0
Former Member
Jun 08, 2014 at 04:00 PM

Local Members disappearing and rolling forecast columns keep repeating after refresh

16 Views

Folks,

I am creating a rolling forecast/ budget. Time and Category will be picked up from Row1 and 2. I am doing budget for 5 years. I am using local members to calculate q1,q2,q3,q4 for current year since it will be mix of actuals and forecast. future years is always budget.

When I use EPM Pane to add a new row member, my first year data gets repeated multiple times at the end of the report and also local members disappear, also the cell reference from Time and Category to Row 1 and 2 of excel sheet gets into disarray.

Anyone has experienced this before ? Any suggestions would be appreciated.

Thanks,

Vivek