on 03-23-2010 6:25 PM
Hello
I'm trying to RUN a report (0OPA_C11_Q0001), but I'm keep getting this ERROR message
ERROR - Variable 0FYEAR could not be replaced
When I was trying to find out what was the cause of this ERROR, all I found that this variable was defined on characteristics (0FISCYEAR)...
1. Can we LOAD data in to time related characteristics ?
2. DO I need to check whether or not cube contains this 2010 YEAR ?
3. what could be other ERRORS, that I need to check ?
Thanks for your help
BI
Hello,
Is the query restricted on a fiscal year variant? If you would like to use the variable 0FYEAR, the fiscal year variant
must be in the filter of the query, that is valid for the whole query. Otherwise the period cannot be found, please see note 141842.
Please note as well If you want to use these variables in queries you have to restrict 0FISCVARNT in the global filter of
the query to a single value. You should not use 0FISCVARNT inside structure elements or restricted key figures.
I hope the above helps.
Best Regards,
Des
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi BI I believe your talking about the query [Internal Orders (List): Plan/Actual(0OPAC11_Q0001)|http://help.sap.com/saphelp_sm32/helpdata/en/d4/a1ab399960594ee10000000a114084/frameset.htm]_ in this you should have to maintain the filter criteria variable 0FYEAR and if you want to modify it then probably you have to remove this variable and replace it with the appropriate properties Hope its clear a little..! Thanks K M R
>
> Hello
>
> I'm trying to RUN a report (0OPA_C11_Q0001), but I'm keep getting this ERROR message
>
> ERROR - Variable 0FYEAR could not be replaced
>
> When I was trying to find out what was the cause of this ERROR, all I found that this variable was defined on characteristics (0FISCYEAR)...
>
> 1. Can we LOAD data in to time related characteristics ?
>
> 2. DO I need to check whether or not cube contains this 2010 YEAR ?
>
> 3. what could be other ERRORS, that I need to check ?
>
> Thanks for your help
>
> BI
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You have to include Fiscal year variant to your query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.