Home > > Business Explorer code

Business Explorer code

Hi Guys,
Is there any way that we can control BEx (SAP Business Explorer) VBA Code... ? I am able to login to business Explorer with BWLogon() code and i am able to refresh query using "Run "SAPBEX.XLA!SAPBEXrefresh", False, myRange". but as soon as this code executed i am getting a form where i need to give some input like Period number, Fisical Year number or Employee number like that and then i have to click on Execute (Manually). what i am looking is , is there any VBA code through which i can do click on Execute button in the form or entering values in to required fields of the form ... ?
please do let me know ... as soon as possible.
thanks in advance,
Hi Shakaran,
What version of GUI r u using?
use GUI 710 - it will solve your problem.
ask your basis guy to install the patch or reinstall the GUI 710 on your system so that you will get the BEX options.
Read the other 6 answers
Hi All,     how to create a report in business explorer after creating the information spaces   then how to operate the exploration view sets please if anyone knows can you explain me step by step... Thanks...what exactly you want to do tell me 1.in
Hi gurus: I have a continuous problem while Publishing and Overwriting a Universe from IDT, new measures UPDATES quickly in Business Explorer / Information Spaces but taking time in dashboard to be updated. it approximately takes half an hour to be u
Hi Experts we have installed  SAP GUI 7.10 successfully and there seems to be an error on Business Explorer.. while processing some of the queries in designer it gives out an error message " critical program error occured.The program has to close.Ple
Hi All BW Experts, I would like to have some sample of BW Reporting issue (Data Discrepancies)and how to solve them in General including its solution. Like on Navigation Display and etc, any input is very highly regarded. Thank You in Advance KumarHi
Good Afternoon, I am attempting to allow certain users to save their workbooks in a certain role in Business Explorer, where they can share their workbooks with others that wish to see them (those who have access). But I don’t want the users to be ab
Can someone answer the following questions about these 2 roles: Business Explorer pcd:portal_content/com.sap.pct/platform_add_ons/com.sap.ip.bi/Roles/com.sap.ip.bi.business_explorer_showcase Business Intelligence pcd:portal_content/com.sap.pct/platfo
Hi, I have installed SAP GUI 7.1 and BI 7.0 Add on. When I tried to open Business  Explorer after opening this screen, when I am trying to open the queries  here it was showing the language is German. I am not able to open the queries in Business Exp
Hi all, In Business Partner code when the user want's to see all Business Partner and makes "*" appears the BP code, BP Name and Foreign Name. All user see this information except one that doesn't see the Foreign Name. Why?Hi Ad, Thank you for y
Hi,experts I installed SAP GUI 710 with Business Explorer. My actions are Business Explorer->Anylzer->Find-><search my query and select> There are three variables in my query, and an error message arised when I selected values for variables
Hi experts, I'm facing an issue in BI 70 SP 10. I'm using Business Explorer release 3500.11.051. In a query, when I set a filter value on a hierarchy node, all the hierarchy is available and i can choose my node. Now, i want to change of filter value
Hi Experts, How to convert currencies from CAD to USD using the “Current exchange rate 0011” for a particular record in the Business Explorer (Query Design). Any useful answer will be rewarded with suitable points. Thanks! RohanCreate a currency cove
Hi all, Are all the BW add ons, including Business Explorer, available for the Mac platform? ie: Mac OS X + Excel for Mac. Any help will be appreciated. Best regardsDoes not look like it will be supported for MAC. See the attached link for Product Av
Hi, I'm using BEx Analyzer and tring to disable some controls in BEx toolbar. I got some helpful information from the following thread Bex Analyzer Toolbar in Excel and now I can grey out some toolbar buttons. But I found there is also a "Business Ex
Hi When opening  BEX(Business Explorer) Queries from Excel  ,  it asks for System to choose. But business doesn't want to see this option. It should go directly to open query selection for the system it has logged in. Say , it has logged in BIQ  , it
Recently we have successfully federated some reports for some business users.  Now another business group is interested in federating the Business explorer role.  They would like to take advantage of the BexWebanayzer iview and a few of its features.
Dear Moderators, This is to have some advice regarding the problem in my system for Business Explorer. I am not able to open SAP Business Explorer's Query Designer, Report Designer and Web Application Designer. Error Descriptions: 1. SAP BEx  Query D
Hi people,       I'm trying to execute a report with the transaction RRMX in BW but when I execute it in the business explorer I receive this error: internal error Problem when writing table: C_T_VARIABLES Abort system error in program SAPLRRK0 and f
Hello all, I am currently trying to update our existing Business Explorer 3.5 (patch level 11) to the latest patch version 13 with the sapadmin tool. The installation works fine but when we try to open a query in business explorer excel addin I get t
Dear All,          I have a unique requirement. My client wants autogeneration of Business Partner Code in the Business Partner Master.          Please guide me in regard to this. Regards Hitesh ParsawalaWe normally have customer code generated as 'C