Current Position:Home > BEx Query TargetlnvocationEception

BEx Query TargetlnvocationEception

  • IF and ABS condition statement in BEX query designer Updated:10-11

    Hi, I would like to ask the best way for me to produce an acceptable result from Excel IF and ABS Condition statement. The condition statement that I have on my Excel file is =IF((A2-B2)>0,ABS(A2-B2),0) I'm trying multiple times to reproduce this in

  • Error while trying to Open and Delete a BEx Query in Query Designer. Updated:10-11

    Hi Experts, I have been facing this issue with BEx Query in Designer mode for a couple of days now in Development Environment in BI 7.0. I would like to Delete an unwanted BEx Query because I need to give it's name to another BEx Query. Whenever I tr

  • How can we remove the commas from the Formula value in SAP BW BEx query Updated:10-11

    Hi All, How can we remove the commas from the Formula value in SAP BW BEx query We are using the formula replacing with characteristic.The characteristic value needs to be display as number with out commas. Regards Venkat.Do you want to remove the co

  • Field Explorer in Crystal Reports does not show the same names as Bex Query Updated:10-11

    Hi I have crystal reports, I can retrieve data from BW Bex Query. But in the field explorer it does not show the names as in the Bex query designer. In the Bex query designer a field will have the following technical name 0Debitor and the description

  • Two problmes between  Crystal Reports 2008 and Bex Query Updated:10-11

    Hi Gurus. I have two problems with Crystal Reports 2008 when It obtains data from a Bex Query (SAP MDX query connection). 1)     I have defined some Parameters Fields using the follow options: Type: String List of Values: Dynamic Value Options Level1

  • Status of data in Bex query shows wrong date Updated:10-11

    Dear Experts, The Bex qurey after sucessful execution, show the Status of data as old date i.e. feb 2012. but we observed that the data uplaod happens regularly and sucessful. we tried executing the same query using RSRT/Bex Analyzer/Portal. the resu

  • Message in BEx Query Designer Formula Updated:10-11

    Hi Experts, I need to display message based on the value of the formula result. For Example: If K.F1 =<2.5 Then <Message: ODD> ElseIF K.F1 >2.5 Then <Message: Even> Else <Message: Determine the value> EndIF Thease above messages wo

  • Drilldown in BeX Query Designer Updated:10-11

    Hello, I am new in SAP. I am having problem creating Drill down. I have this report where all the data is Transactional data. So I haven't created any Master Data. So I won't be able to use Navigational Attribute for Drill down purpose and I don't wa

  • Division in bex query designer Updated:10-11

    Hi experts, I have a strange problem in bex query designer. I am trying to calculate margin in % but the calculation gives the wrong result. The two figures I try to calculate are -25124 and -91248 (figures in 1000 NOK) The result should be (-25124/-

  • % Calculactions in Bex Query Designer Updated:10-11

    Hi Experts, Could you please on how can i perform the below % Calculactions in Bex Query Designer.     Vendor No line item Not = L category =A  status =RFQ :for items Example : I have 8 items for vendorNo 200274 and only 4 as above condition and 5 it

  • Where to write IF THEN ELASE statements in BEX Query Designer Updated:10-11

    Hi All, I need to write a formula in query designer... saying that to display the all Quantities in KGs.. Now articles are in Grams and KGs... So here i need to perform calculation like... if article is in KGs divide by 1, else if article is in Grams

  • Results based on From and To value in Bex query designer. Updated:10-11

    Dear all, We are using BI7.00. In one of our report which pertains to PM user wants to get the details of number of breakdowns which falls in the value range 0 to 1 hours. I created a condition which has 2 variables, one is From value and the other i

  • Difference between  aggregation and calculation tab in BEx Query Designer Updated:10-11

    HI, I am using BEx Query Designer for my report, for the key figures in the coloumn area i slected one numeric key figures, in  the properties tab i found aggregation tab and calculation tab. I need to sum up the total values for that particualar col

  • New ratio doesn't appear in Bex Query designer Updated:10-11

    Hello Experts, I added 2 ratios to my infocube. It activated without any problem. I then added these 2 ratios to my multiprovider and activated it after affecting them to the previous infocube. Then I connected to the Bex query designer and loaded a

  • Usage of formulas in conditions in BEx Query Designer Updated:10-11

    Hi guys, does anybody of you guys know, if it's possible to use the results of formulas in conditions? I tried it, but the result of the query was "No applicable data found", but there are data for the selection. When I'm defining the condition

  • Problem with Queries Structures in Bex Query Designer and Universe Designer Updated:10-11

    Hi everyone, I have a problem when i try to do a Universe from a Bex Query Designer. When I use a Characteristic Restrictions in a Structure, the universe only show me the structure without the objects inside it. EJ: 1) Bex Query Designer Colunms (St

  • Doubt on Rows and Coloums in BEx Query Designer. Updated:10-11

    Hello, Experts. I have a Doubt in BEx Query Designer. In the Rows I have a Fiscal year Period,  if the user enters the Fiscal year period for e.g. : 001/2006  .   in the columns i have  forecast for the Fiscal year period which user entered ( 001/200

  • Options in Assignment of Condition in BEX Query Designer Updated:10-11

    Hi Experts,   I am trying to define a condition in BEX Query Designer. I defined my condition and bit confused with Characterstic Assignment What Happens if is select 9What is the difference) 1) All Characterstic in the Drilldown Independtly 2)Most D

  • In Bex Query designer - Flat is not supported Updated:10-11

    Hi all, In Bex query designer, While execution of the query, the following error is coming . Failed to process request; contact your system administrator Error Summary Exception occured while processing the current request; this exception cannot be h

  • IF ELSE Statement in BEx Query based on the results Updated:10-11

    Hi experts, I want to realize the following IF/ELSE statement in a BEx Query in respect to the result values If the result of KF1 equals 0, than set the KF2 to 0, Else (KF1 NE 0) show the value of KF2 Background: I want to report the order backlog. I