SAP Analytics Cloud Restricted measure not having option for Date Range

[charles_braybrook]

Hi,

I've just reloaded a planning model which has 3 Dates. 2 are Fiscal, one is not. And now on the two Fiscal Dates whenever I create a Restricted Measure or Account if I select either of the Fiscal Dates I only get the option of either Select by Member or Input Control. No Date Range selection is available. 

This is a critical problem. Anybody who has experienced this or knows how to fix it. Would be greatly appreciated.

Thanks,

Charles

[N1kh1l]

@charles_braybrook 

The 2 Fiscal dates are of date type right? If its Date Type you should see an option like below.

Nikhil

[charles_braybrook]

Hi, yes they are. I've created a number of the restricted measures using Date Range on this model in the past. But recently after a data load it appears that I can no longer use date ranges in Restricted measures. I can use them in filters and input controls. But not Restricted measures. The old ones I created prior to this problem are still working and I can edit them. Just can't create new ones.

[N1kh1l]

Try re deploying the model from model preferences and see if resolves the issue.

[charles_braybrook]

I tried that. And it didn't work. I'm not entire sure how this happened. But it appears that the none fiscal Date had a a Fiscal hierarchy. Despite a non-fiscal hierarchy. Not sure what caused this.