IBPF - Planning Tab Disabled

[Former Member]

Hi Experts,

I am working on IBPF solution for our latest system S/4 HANA -1511 E.

I am able to retrieve correct data from back end S/4 system  through Analysis for Excel by using Query.

But when i change planning data & try to save / recalculate/ Lock it in AO for Excel - Planning Tab is disabled.

i checked all the possibilities on Excel settings for Add -on Services - all are as per Config document but even i am not enabling Planning tab in AO for Excel as below screen

Can any one having the idea what was missing & how to enable this tab for planned data?

Thanks,

Br,

Chandar

[former_member200327]

Hi Chandar,

Can you please check that Key Figures in your Query are enabled for Planning. Additionally, you have to make sure that you drilled down to base members in that report on all Dimension of your cube. If some Dimension in the report is not at base level it should be restricted to a single value in the Filter of Free Characteristics.

Regards,

Gersh

[Former Member]

Hi Gersh,

Thanks for you suggestion., Yes we did the same already as you suggested.

But still same issue which we are facing that Planning tab is disabled as below.

Thanks.,!

Br,

P

[former_member200327]

Hi Chandar,

Can you try running that Query in t/a RSRT and check if you can enter data there?

Regards,

Gersh