when i'm trying to run a query on 0COOM_CO2 cube, the system is throwing a error msg.
No value could be determined for variable 0P_FVAEX.
Message no. BRAIN632
This error diagnosis is specific only to the variables 0P_FVAEX or
Termination message BRAIN 632 appears:
Could not determine value for variable 0P_FVAEX (or 0P_CTPCA).
1. Operation method of SAP-Exit-Variables 0P_FVAEX or 0P_CTPCA
With queries from the CO application, both SAP-Exit-Variables look for
an entry for 'controlling area'. With this controlling area from the
selection screen, the SAP-Exit-Variables program reads the attributes
for InfoObject 0CO_AREA (controlling area).
With queries from the FI application, the SAP Exit Variable 0P_FVAEX
looks for an entry for 'company code'. With this company code from the
selection screen, the SAP Exit Variables program reads the attributes
for InfoObject 0COMP_CODE (Company Code).
0P_FVAEX determines the fiscal year variant (attribute 0FISCVARNT) from
the attributes for 0CO_AREA (CO queries) or 0COMP_CODE (FI queries).
0P_CTPCA determines the currency type of the profit center local
currency (attribute 0CURTP_PCA) from the attributes for 0CO_AREA.
2. Cause of Error
The attributes for the controlling area (InfoObject 0CO_AREA) or company
code (InfoObject 0COMP_CODE) were not loaded into the BW system, or the
attributes for the controlling area are not active in the BW system.
Check whether this is the cause of the error in your BW system. Display
the contents of table /bi0/mco_area or /bi0/mcomp_code using transaction
Check whether the attributes 'fiscal year variant' (field FISCVARNT) and
'profit center local currency currency type' (field CURTP_PCA) are
filled in the 'A' version (field OBJVERS) for the selected controlling
area. If the fiscal year variant in the OBJVERS = 'A' is empty, then the
error is with variable 0P_FVAEX. If the currency type of the profit
center's local currency in OBJVERS = 'A' is empty, then the error is
with variable 0P_CTPCA.
Check whether or not the attribute 'fiscal year variant' (field
FISCVARNT) is filled in the 'A' version (field OBJVERS) for the selected
controlling area. If the fiscal year variant is empty in OBJVERS= 'A',
then the error is with variable 0P_FVAEX.
Using InfoSource 0CO_AREA, load the attributes for the controlling area
or company code into your BW system.
Afterwards, activate the attribute changes in your BW system. To do
this, use transaction rsa1, path 'Tools > Hierarchy/Attribute changes',
functions button 'InfoObject list'. Choose InfoObject 0CO_AREA or
0COMP_CODE from this list, and activate the attribute changes.
Procedure for System Administration
where do i start to debug it.
Thanks in advance,