cancel
Showing results for 
Search instead for 
Did you mean: 

Target values are greyed out during Entry and Approval in SSM

Former Member
0 Kudos

hello all

we have designed our model in such a way that we built it using normal procedures but the target values have to be entered using entry and Approval via Excel ad-in..

the problem we are facing is that if we select both the actual and the target measures to load the data via Excel login then the column TARGET is getting greyed out. When we build the same model using cube builder , the column TARGET is not getting greyed out and we are able to enter data there.

Is there any setting changes we need to make inorder to make the Entry and Approval process via Excel behave the same way when the model is built using the Cube builder ? Are there any new notes or a newer version of Excel ad in to resolve this ?

Vijay

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Vijay,

To troubleshoot this situation, I would advise you to go through the following steps:

1- make sure that the TARGET measure is included in the metric set you are planning.

2- If so, go to the E&A defaults for that model. Check if the "Input/Overwrite Current Period Target Data" is option is active (in case you were trying to plan for the Current Period and not for Historical Data).

3- Check the target measures' descriptions in PAS. Make sure each of the target measures description ends with the text "Target". This might be what failed if you created those measures manually. Creating measures through Cube Builder or BICA, this suffix is always added.

Hope this helps!

Best regards,

Ricardo

Former Member
0 Kudos

thank you Ricardo

The mistake I made was given in the third point of yours. The label did not end with the word Target. After adding it, the problem got resolved. Thanks again.

Vijay

Answers (0)