ODS in multiprovider: Can not create aggregation level

[Former Member]

Hi Gurus,

we have a multiprovider which consists of several infocubes (standard and realtime) and a standard ODS. Our problem is that we can not create an aggregation level on this multiprovider. We get an error "infoprovider can not be used for definition". Is the problem that the ODS is not transactional or do we need to setup something else regarding the ODS. If we delete the ODS from the multiprovider, everything goes OK.

Thanks for any advice.

Jan

[Former Member · Accepted solution]

Finally I was able to solve the problem - there was a mistake in assigning the characteristics. Now I am able to create the aggregation level.

Thank you all for your contribution and help.

Jan

[Former Member · Accepted solution]

Jan,

Can you explain how you fixed it. even i am facing the problem i have no clue to fix it.

thanks

sanjay.