Skip to Content
0
Jan 13, 2023 at 07:24 AM

[SAC] how to make layout forecast with fixed dimensions

133 Views

Hi I'm very new to SAC then sorry about less knowledge.

I hope professional delelopers will help me.

1.Point: how to make layout forecast with fixed dimensions

User want fixed layout that combination between version and month should not be changed.

(Cycle1 always show Actual: April-July, Budget_Cycle1: August-March. Cycle2 always show Actual: April-August, Budget_Cycle2: September-March)

I tried to control by cut-off date setting and advantage filter but didnt work well.

2.Image of screen

image.png

3.Model concept 3 versions to 1 model 3 versions: Actual, Revison budget1, Revison budget2 measure = Amount(no calculation)4.Forecast schedule

Cycle1

Inputing revesion budget_cycle1 start and finish in July

Subject: August to March

Refer to actual data April to July

Cyle2

Inputing revesion budget_cycle2 start and finish in August

Subject: September to March

Refer to actual data April to August

Forecast action will be done every year: 2022Cycle1 -> 2022Cycle2 -> 2023Cycle1 -> 2023Cycle2…

Thanks in advance.

Attachments

image.png (29.5 kB)