Remove Version from table

[daniel_weisblut86]

Hi

I am Building a story to plan this year sales

I have Actual 1-9 and forecast 10-12

I build restricted measure for actual period with time select and the same for forecast period

When i want to show Full Year "Actual+Forecast"

there is a problem to show the sum

Because version is inside

[N1kh1l · Accepted solution]

daniel_weisblut

Enable constant selection in your measures and then you can remove the version.

Nikhil

[nagend4652 · Accepted solution]

We are facing a similar situation, but our story is based on a BW live data model, where the constant selection checkbox does not appear, as it is an unspported feature. Do we have any workaround on considering the forecast values in the calculation under Actuals column

[daniel_weisblut86]

You are the king of SAC

Thank you very very much

[N1kh1l]

daniel_weisblut

🙂 Please close the thread accepting the helpful answer.

Nikhil

[daniel_weisblut86]

Thank you for your quick respond

Yes I have created 2 restricted measures

one for actual

one for Forecast

when i remove the version from column its asking to choose a filter

[N1kh1l]

daniel_weisblut

daniel_weisblutIf you have restricted your measures on both version and date , you can remove version from columns in the table

from the designer.

Br.

Nikhil

[Akshay_Bhandari]

Hello Nikhil,

In case of Account based model we are able to remove the version , But in case of Measure based model where in dimension is not an account, We are unable to remove it . Are we missing any setting. 

Many Thanks 

Akshay Bhandari