Skip to Content

IP Aggregation Level says infoprovider not available when executing planning sequence.

Feb 17, 2017 at 12:32 PM


avatar image
Former Member

Hi experts,

I am doing a planning application in SAP BW and I have first created two infocubes (1 actual witih data) and (1 realtime where the planned data is supposed to be written). They have the same structure. I then union them in the multiprovider and then use the this multiprovider as a basis for creating the aggregation level. I have already defined the aggregation level, filter, planning function and planning sequence as below and still it gives me error. Please see the figures below.

here the error says that the aggregation doesnt not the infocube with the actual data, however I have built the aggregation level based on multiprovider which is indeed built on the actual data and plan infocubes.

On the other hand, even though I have created the Input-queries with the right settings in BEx query definition, still it doesnt enable the value entering . Could you please let me know if I have forgotten to add something?

Thank you,


filter.png (21.4 kB)
324.png (23.2 kB)
afda.png (34.6 kB)
asfafa.png (46.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Cornelia Lezoch Feb 21, 2017 at 12:20 PM

Hi Ragys,

check your multi provider definition and chek, that the key figures and characteristics are properly identified.

if a char does not exist in either of the providers but you use it in your function, set its value = # for the missing provider.

check, what your filter ist selecting - if the actual data is not included in the filter selection, you need to treat it as reference data.

for the query - check the multi provider and then chaek, that all char from aggregation level are used in the query, either as single selections or in row or column drilldoan.



Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Cornelia, thank you for your reply. I checked the definition of the aggregation levels and I have fixed the settings for forecasting. However, for the query input, I still cannot. I also created another planning function (Set KF Value) but still when I run the query in RSRT-ABAP BICS, I see the option when I right click to save and transfer values, but i just cannot input the values on it.

Please see the figure below.

I want to replace the zero values with other values but it doesnt allow me the option even though my query settigns are correct. Do you have a suggestion for this?

Thank you

capture.png (20.5 kB)
captur23e.png (37.0 kB)
Cornelia Lezoch Feb 23, 2017 at 01:35 PM

Hi Regys,

the cube needs to be planning enabled

the key figures in the query need to be plannign enabled

the query needs to be started in change mode

you need to have authorization to change data

each entry cell needs a single definition for each char within the aggregation level.

If all issues above are met, your query will be entry enabled.

So if you still can not enter data, check all those issues.

if you want, post pictures of your query - I need to see each char in the aggregation level, filter values, what is in rows, what is in columnes, what is selected in restricted key figures.



10 |10000 characters needed characters left characters exceeded