BEX e136 sumgt

Advertisement
  • Unable to carry out calculation of keyfigure with it's total summation taken on keyfigure

    Hi, For a requirement, we are trying to calculate division of a keyfigure with it's total summation of key figure. For example: Sales Office Order Reason Invoice Volume MRV Volume % of MRV Volume to total invoice volume % of MRV Volume to total MRV v

    October 11

  • Problem regarding data function 'SUMGT' (Overall Result) in BEx query desig

    Hi, I have created one query where I want to see the inventory data month wise. That's why at first I have placed 0calmonth (with variable) in column, secondly kept all the key figures which I want to see month wise under one structure, then placed t

    November 30

  • How to Get SUMCT SUMGT functionality in WEBI reports.

    Hello All, How to get the SUMCT SUMGT functionality in WebI reports using variables/formulates, as these fictions cant be used in Bex if we are developing a BO report on top of that. We are developing BO WebI reports on top of BeX query. nd we are on

    November 30

  • How to Caculate Substraction of only for result rows in BEx

    Hi, I have a issue  in BEx Report. The scenario is like this. Invoice Amount             Invoice Paid Amount       Pending Payment Amount 17.90 INR                             3,472.00 INR                      -3,454.10 INR 524.50 INR             3,4

    November 30

  • IF and ABS condition statement in BEX query designer

    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

    October 11

  • Inconsistency between Bex and Back end

    Hello, I have a query about bex issue. I have few fields in my DSO/Cube which has data showing correctly in the back end but in Bex it shows partial of those values. like if i have something like this: ZField 000000000000000000008 It shows correct in

    October 11

  • Error while trying to Open and Delete a BEx Query in Query Designer.

    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

    October 11

  • Report performance while creating report on BEx

    All all! I am creating a report on BOE 4.0 on top of BEx connection as a source. I have developed reports on top of universe in the past and i know that if we keep calculations on reporting end it hampers the report performance. Is this the same case

    October 11

  • Bex-report issue

    Hi I created a query in Bex-Query Designer - 3.5.. Then publish that report in the Web by using Bex-Analyzer. Suppose i have columns in the report like 'vendor' and 'PO Number'. When the cursor goes to 'vendor' column heading then im getting as <b>&

    October 11

  • How can we remove the commas from the Formula value in SAP BW BEx query

    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

    October 11

  • Concatenation of Data from 4 infoobjects into a single cell in Bex Report

    Hi, I have loaded ODS with the description data. The source system for loading the ODS is the flat file. The ODS data should be a replica of the flat file. In the flat file, there is a description field corresponding to a particular ID. This Descript

    October 11

  • Variable screeen popup with button in bex

    Hi , When I try to display variable screen using a button in bex, I get the following error. has anyone come across this. pls advise. BExItemButton.RenderData01: Unable to get the Item property of the OLEObjects classErr: Unable to get the Item prope

    October 11

  • Error while running query in BEx

    Hi Experts, when i am running a query i am getting this error in BEx: "Value 'First NameAPPROVER1' (hex. '004600690072007300740020004E0061006D00650041005000') of characteristic ZZNAME1 contains invalid characters,Error while reading data; navigation

    October 11

  • Error while Activating / running Bex queries/reports

    Hello I have following ERRORs while activating / running BEx reports/queries. 1. While Activating BEx reports, I keel getting following ERRORS Object directory entry R3TR ELEM E341OIR6G715GUMGN0MRXP3MA does not exist Error when activating element BX7

    October 11

  • Error while generating PDF - in Bex Web

    Hi Experts, I am currently having the issue that I receive the error "Error while generating PDF" when using the "Print Version" functionality. This problem only occurrs for the Bex Web Query. I know that the ADS service is configured

    October 11

  • Error when starting Bex analyzer

    Hi All! We have a world wide BW-SEM application. In one country they get the following error message when starting Bex analyzer: <install error> Missing ActiveX component: Business Explorer Global Services Does anyone have a hint on what to do? Than

    October 11

  • I am not getting the data in Bex from the cube

    Hi Experts, i am not getting the data from the cube to Bex, cube having the data, but i am not able to see this data in the Bex result area. Can  any one help me. Best regards, BhaskarHi In the manage cube, is reporting symbol is there for your reque

    October 11

  • Field Explorer in Crystal Reports does not show the same names as Bex Query

    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

    October 11

  • Two problmes between  Crystal Reports 2008 and Bex Query

    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

    October 11

  • Status of data in Bex query shows wrong date

    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

    October 11