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”

No Comments

Xcelsius Connect to SAP BW through SAP Web Service

Reference following document to connect to SAP BW Web Service

Web Services within BI Part 1

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>

ScreenHunter_04 Jun. 04 18.25

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.

ScreenHunter_01 Jun. 07 18.10

ScreenHunter_02 Jun. 07 18.10

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

No Comments

Xcelsius Error #2170

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.

No Comments