on 2009 Jan 19 11:20 AM
Hi ,
We are running a report on multi provider, it works fine for 2008 data. but it is not showing any data for 2009, even we have data in in 2009 cube.
I checked the query with rsrt excute + debug mode. there is it giving error message like below
Access to ZGAM1_CO7 was skipped. (MPR filter) , please give me solution for this problem.
Thanks
Regards
Rajani
HI,
Assigne the fields for 2009 cube also in MP................see that any restriction is there for 0INFOPROVIDER field in the query......If it has 2008 cube then add 2009 cube too.................
Thanks/Tarak
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes, Tarak..
OSS Note 489135 describes messages in more detail
I dont have access to OSS notes. Can you please refer this oss notes and let me know what is the reason for this problem.
0CURTYPE: General restriction for InfoProvider ZVEGA_C01 not possible
ZVEGA_C01 - 0000 0CURTYPE = 10
- Access to ZVEGA_C01 was excluded
MultiProvider ZPA_MC01: InfoProvider ZGAM1_CO2 ***
- ZVRRW: this key figure was excluded for InfoProvider ZGAM1_CO2
MultiProvider ZPA_MC01: InfoProvider ZGAM1_CO3 ***
MultiProvider ZPA_MC01: InfoProvider ZGAM1_CO4 ***
MultiProvider ZPA_MC01: InfoProvider ZGAM1_CO1 ***
MultiProvider ZPA_MC01: InfoProvider ZGAM1_CO6 ***
MultiProvider ZPA_MC01: InfoProvider ZGAM1_CO5 ***
MultiProvider ZPA_MC01: InfoProvider ZGAM1_CO7 ***
- Access to ZGAM1_CO7 was skipped. (MPR filter)
The MultiProvider query is executed in parallel (DEGREE = 9)
No Data Found. Dummy Record created for Key Figure Definition
Regards
Rajini
User | Count |
---|---|
70 | |
11 | |
10 | |
10 | |
9 | |
8 | |
7 | |
6 | |
6 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.