Save option is disabled in planning group in analysis office for input enable query

[Former Member]

Hi Team,

Save option is disabled in planning group in analysis office for input enable query on Aggregation level-> Composite provider->ADSO

I configured all settings as in attachment, kindly review and let me know how to enable save option.

Also please let me know if I can use /CPMB objects in ADSO for planning purpose.

Summary of settings:

1.ADSO

1.1Enabled planning mode

adso-settings.jpg

1.2.used /CPMB info objects in ADSO

cpmb-objects-used-in-adso.jpg

2.Composite provider:

Composite provider on top of above ADSO

3.Aggregation level:

4.Query:

4.1 Key figure: input ready

query-settings2.jpg

4.2 All characteristics: extended –master dataquery-settings1.jpg

5.Analysis office excel client:

5.1Enable planning option in components section of Analysis for office.

Save is disabled in AO as below

[Former Member · Accepted solution]

Thanks for Reply and info about using /CPMB objects Greg!

This issue got resolved by adding info provider characteristic object to filter and restristicing it to one member(ADSO) as Composite provider is created on top of ADSO and rea time cube.

And learned that

1.Info objects in fixed and default filters should be fixed to single members , if they are not part of row or columns , if infoobjects are part of rows and columns we can have multi select for same in fixed and default filters.

2.All dimensions of aggregation level sould be part of query either in( rows, columns, fixed or default filters).

Thanks,

Siva

[gregor_dieckmann · Accepted solution]

Hi,

not correct in all cases: the aggregation level determines the characteristics used to write records back into the persistence layer. Without disaggregation aggregated cells with respect to this level are not input-ready. But this is not the case if disaggregation is enabled in the query: in this case the query also allows to change cells that are aggregated with respect to the aggregation level. You can find this information also in the documentation.

The only characteristics that have to be uniquely determined for input-ready cells in all cases are currency/unit characteristics for amounts/quantities, respectively and 0INFOPROV (if relevant).

Regards,

Gregor

[gregor_dieckmann]

Hi,

as long as you have not changed data the save button is inactive; change a value of some input-ready cell then you can see that the save button and the recalculate button become active.

Technically you can use /CPMB/ objects (generated BW objects by BPC Standard), but you should not do this since then all BPC Standard logic is not considered and thus you may create inconsistent data (with respect to BPC Standard logic).

Regards,

Gregor