vba bex analyzer refresh

Advertisement
  • Macro not working in BEx Analyzer (Refresh selection Screen)

    Hi All, We have migrated work book for 3.x to 7.x and work book having lot of macros calculated and using multiple quires in single work books for inpt selection screen written Macro same macro is not working after Migration to 7.x 7.X Macro code bel

    November 30

  • The BEx Analyzer cannot generate VBA code due to the security settings

    Hello experts, when I try to open a query in BEx Analyser I get this error message for each Item of the Query: Diagnosis The BEx Analyzer cannot generate VBA code due to the security settings. System Response VBA code is not generated. Procedure Choo

    October 11

  • BEx Analyzer workbook cannot be refreshed

    When i create an BEx analyzer workbook using the 'insert analysis grid' option as opposed to the 'open query' option, i cannot refresh the workbook when i reopen it. The steps i am taking to reproduce this error are 1) Open analyzer 2) Open new excel

    November 30

  • Error in Bex Analyzer including the filter button command in Callback macro

    Hello, I have the following problem with the function filter button in the Bex Analyzer included in the callback macro: Because of using 2 hierarchies in the filter the setting drill down to level 2 in the query gives no right output in the Bex Analy

    October 11

  • Macro not working in BEx Analyzer

    Can you please explain why my Macro is not working? We're on BI 7 with Excel 2007. I have done the following: 1) Open Workbook from BEx Analyzer and the result display on the worksheet. The was inserted in C10 and therefore, the result was display fr

    November 30

  • Excel 2002 with BEx Analyzer NW2004s

    Hi, can I use Excel 2002 with BEx Analyzer NW2004s? I read somewhere, it is possible only with Office 2003. It's true? Thanks!Hi, for some reason the BI FAQs on SDN are not up-to-date. I will investigate and make sure they are refreshed asap. You alw

    October 11

  • Create local view with Bex Analyzer 7.0

    Hi, with the Bex Analyzer 3.5 it was possible to create and use a local views based on a query in a workbook. With this "workaround" it was possible to create just one Query for different views and charts. Is there something similar in BI 7.0???

    October 11

  • BEx Analyzer Not showing report result in canceling "Change variable Icon"

    Hi Experts, Do we have any settings in BEx Analyzer for retrive the Result set even after I click 'Change variable Icon' in Toolbar and cancel the variable pop-up window?? Eg: My query Result is displayed in Analyzer selecting some vaues in Selection

    October 11

  • Change the layout of a query items in BEx analyzer

    Hi, I had developed a query, so when it is viewed in BEx analyzer the items(Char and Keyfigures) that i had used in rows and columns are displayed in analyzer. Apart from this in report i can see the items i had used, in top corner. So i need to chan

    November 30

  • BEx Analyzer workbook working strangely with reset_area functionality

    Hi Experts, In my BEx Analyzer I have got an input ready query for planning. It displays data correctly. In my workbook I have a button for variables, a button to save the data to planned cube and a button for reset. For the reset button i have used

    November 30

  • Problems with dynamic data slices and BEx Analyzer

    Hello experts, we use a data slice to lock released data. This data slice contains an exit-variable which selects all plan that are already released out of a ABAP dictionary table. The user can release data via planning function. He can start this fu

    November 30

  • BEx Analyzer - Convert to formula - Dynamics of a hierarchy

    Hi BI-Experts, I have a question regarding the BEx Analyzer built in functionality "convert to formula". Once I have done this, the report is more ore less static, establishing a fixed link between the cell and the query result. (BExGetData(u201

    November 30

  • Bex Analyzer 7.0 - BexEventHandler in Netweaver 2004s

    Hi, I noticed that in Bex Analyzer 7.0, there is a new class called BexEventHandler which gets hit each time I select a cell or a worksheet within my VBA code.  This did not happen in Analyzer 3.5.  And because of this, I am experiencing major perfor

    November 30

  • BEx Analyzer - dynamic  charts

    Environment: BW 3.5 Hi all together, I have a query with the following presentation hierarchy: top level are the continents and second level are the countries belonging to the specific continents. Now I want to display the results in a chart as follo

    November 30

  • Charts in BEx Analyzer - What are the Options in Excel 2007?

    Hi Gurus! The client wants to generate Tables and Charts in BEx Analyzer and e-mail to users. We are using BEx 3.5 queries with on BW 7.0 and Excel 2007. We are not allowed to convert to 7.0 queries, but can convert Workbooks from 3.5 to 7.0 , leavin

    November 30

  • Workbook in BEx Analyzer

    Hello, Can someone tell me how to create workbook in BEx Analyzer? My workbook should be accessible by other users and should have several tabs which should update itself when refreshed. Thanks, SuriyaHi Suriya, Please go through the below doc for cr

    November 30

  • Subtotals in BEx Analyzer

    Hey! How can I create subtotals in BEx Analyzer? Thanks a lot, SabineSo you want a subtotal row for every 10 customers and there is no additional information to determine these customers (for example the 10 customers are all customers with a specific

    November 30

  • BEx Analyzer 7.0 formatting

    Hi Experts, I have an issue when creating workbooks in BEx Analyzer 7.0. Most of the times when I include a query in the workbook (with the Analysis Table) everything is fine with the formatting. But for some queries the formatting in BEx Analyzer do

    November 30

  • BeX Analyzer 7.0 dynamic formatting

    Hello, we have the BeX Analyzer 7.0 and want to format the workbook like highliting the Characteristic names. It is okay when the grid stay as during the formatting. But if someone will change the view by adding anothe characteristic the formatting i

    November 30

  • Bex analyzer - internal error problem with table c_t_variable

    HI All,      When ever I try to refresh a query in Bex-Analyzer ,Iam getting "internal error problem with table c_t_variable".      Please advise Edited by: Aparna Duvvuri on Jan 13, 2010 10:53 AMHi Aparna, try to open the query in RSRT and debu

    November 30