Archive for June, 2010
Visual Studio 2010 Cannot Create The Windows
I have this problem once I have installed Office 2010 and Visual Studio 2010. The result I searched from the internet is that to remove some .dll file in order to fix it, however, my problem is not because of this.
After surfing further again, the problem finally is found. The reason is the machine.confing in following path was corrupted, and which is disobey the XML rules. After fixing this XML file, the VS 2010 can start again.
“C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config
\machine.config”
Xcelsius Connect to SAP BW through SAP Web Service
Posted by allenkwc in Business Objects on June 4, 2010
Reference following document to connect to SAP BW Web Service
How to integrate Xcelsius 2008 with SAP NetWeaver BI without Integration Kit
Using Filter
Following is the step to pass filter parameter / values to the query:
GetQueryViewData <- function
Parameter: <- type: W3Query
NAME = FILTER_IOBJNM
VALUE = <Filter Name, e.g. Z3COMPANY>
NAME = FILTER_VALUE
VALUE = <Filter Value, e.g. ERHK>
Please note that in order to pass the filter value to the query, following have to be done,
GetQueryViewData <- function
Parameter: <- type: W3Query
NAME = FILTER_IOBJNM
VALUE = <Filter Name, e.g. Z3COMPANY>
NAME = FILTER_VALUE
VALUE = <Filter Value, e.g. ERHK>
*Note: if you have more than 1 variable have to pass to web services, append the under stroke and sequence no. behind, such as,
NAME = FILTER_IOBJNM_1
VALUE = <Filter Name, e.g. Z3COMPANY>
NAME = FILTER_VALUE_1
VALUE = <Filter Value, e.g. ERHK>
*Tricky Tips: When making a filter for month, set it as “Free Characteristics” rather than “filter”, otherwise, it can’t be passed successfully to the web services.
Structure
|
Parameter |
Description |
|
FILTER_IOBJNM FILTER_IOBJNM_N (optional)
|
Name of the characteristic / structure by which the system is to filter Specify the technical name of the characteristic (for example, 0COUNTRY) or the structure (25 characters) |
|
FILTER_COLLAPSE (optional)
‘X’ = Yes, ‘ ’ = No |
Removing filter characteristics from the drilldown The characteristics that are specified under FILTER_IOBJNM are taken from the axes after the filter has been applied. If you do not specify the parameters, the system assumes you want to use the value ‘X’ = Yes. |
|
FILTER _SIGN_N (optional) |
Row properties ‘I’ found values are added, ‘E’ found values are removed.
If the parameter is not specified, then the system assumes you want to use the value ‘I’. |
If FILTER_IOBJNM_N is not specified for index n, the value from FILTER_IOBJNM is used, if available.
For filtering individual values, the following parameters are also specified:
|
Parameter |
Description |
|
FILTER_VALUE FILTER_VALUE_N FILTER_VALUE_EXT FILTER_VALUE_EXT_N
|
Filter Value Value, by which the system is to filter. If the variant with ending ‘EXT’ is selected, the fully compounded value has to be entered in the external format, for example, 24.12.2000. If the ending ‘EXT’ is not used, the fully compounded value has to be entered in the internal format, for example, 20001224 for 24.12.2000. |
|
FILTER_VALUE_TYPE (optional) FILTER_VALUE_TYPE_N (optional) |
Type of value specified under FILTER_VALUE ‘VALUE’ : Characteristic value key ‘VARIABLE_EXIT’ : Exit variable name. The filter is set using the values returned by the variable exit. Parameter, interval, and selection option variables are allowed for customer and SAP exit variables, as well as for default values. |
|
FILTER_OPERATOR (optional) FILTER_OPERATOR_N (optional) |
An operator ‘EQ’ = Individual value ‘LT’ = Less than ‘LE’ = Less than or equal to ‘GT’ = Greater than ‘GE’ = Greater than or equal to If no operator is specified, then the system assumes you want to use the value ‘EQ’. |
The following parameters are also accepted for filtering intervals:
|
Parameter |
Description |
|
FILTER_VALUE_LOW FILTER_VALUE_LOW_N FILTER_VALUE_LOW_EXT FILTER_VALUE_LOW_EXT_N
|
Filter value – lower limit (not compounded)
|
|
FILTER_VALUE_HIGH FILTER_VALUE_HIGH_N FILTER_VALUE_HIGH_EXT FILTER_VALUE_HIGH_EXT_N
|
Filter value – upper limit (not compounded)
|
Example
Ref: http://help.sap.com/saphelp_sm32/helpdata/en/59/edfe395dd76846e10000000a114084/content.htm
Filter Data Provider ’View1’ by Country: Germany
<SAP_BW_URL DATA_PROVIDER=’View1′ FILTER_IOBJNM=’0COUNTRY’ FILTER_VALUE=’DE’>
Filter Data Provider ’View1’ by First 3 Months
<SAP_BW_URL DATA_PROVIDER=’View1′ FILTER_IOBJNM=’0CALMONTH’ FILTER_VALUE_LOW_EXT=’1′ FILTER_VALUE_HIGH_EXT=’3′>
Filter All Data Providers by Costs and Countries: Germany and USA
<SAP_BW_URL DATA_PROVIDER=’*’ MULTI=’X’ FILTER_IOBJNM_1=’DRB9ZVVMBCHVX4F04Z1JGKYVC’ FILTER_VALUE_1=’DTG057U7OQ8K2ALKCMR2AWM14′ FILTER_IOBJNM_2=’0COUNTRY’ FILTER_VALUE_2=’DE’ FILTER_IOBJNM_3=’0COUNTRY’ FILTER_VALUE_3=’US’>
Filter All Data Providers by Current Month
<SAP_BW_URL DATA_PROVIDER=’*’ MULTI=’X’ FILTER_IOBJNM=’0CALMONTH’ FILTER_VALUE=’0CMONTH’ FILTER_VALUE_TYPE=’VARIABLE_EXIT’>
Changing Variable
Ref: http://help.sap.com/saphelp_crm60/helpdata/ja/47/a8bcfa73b12fe2e10000000a42189d/content.htm
Characteristic Value Variables
Characteristic Value Variables: Parameter Variables or Variables for Multiple Single Values
|
Parameter |
Description |
|
VAR_NAME_x |
Technical name of the variable |
|
VAR_VALUE_EXT_x |
Characteristic values in external format Key for characteristic value in external display |
Characteristic Value Variables: Interval Variables
|
Parameter |
Description |
|
VAR_NAME_x |
Technical name of the variable |
|
VAR_VALUE_LOW_EXT_x |
“From” characteristic value in external display Key for characteristic value in external display |
|
VAR_VALUE_HIGH_EXT_x |
“To” characteristic value in external display Key for characteristic value in external display |
Xcelsius Error #2170
Posted by allenkwc in Business Objects on June 1, 2010
Here is what you need to do
–>Export your visualization to swf
–>Run the Swf, right click on visualization and got to settings.
OR
Click
http://www.macromedia.com/support/documentation/en/flashplayer/help/settings_manager04.html
In 3rd Tab (Global Security Settings)
–> Check box “Always Allow”
–> In the Drop down (Edit location… select Add Location
–>Browse the swf file
That is it…now reopen the .swf file, it should not throw error.