may 2016.

BEx Query Average vs. Excel Average

When I was recently creating a new query at a customer, I have found a strange phenomenon. The query should show the average ticket number of a department. First you see the explanation and then I provide the solution of the problem.

 

The query should show the individual, cumulative and average monthly values, as you can see in the screenshot.

Read More 0 Comments

Analysis Office 2.3 features

Here is a short overview about the new features of Analysis Office 2.3

  • The Analysis Office API has been extended. It is now possible to save data and to open workbooks.  So you are now able to open workbooks via VBA macro, as then with sapbex.xla!SAPBExReadWorkbook or BExAnalyzer.xla!runWorkbook .
  • It is now possible to cancel long-running queries
  • You can now rename dimensions, attributes and measures
  • There is now an option in the context menu of the components tab, which allows you to logoff from a BW system. This was previously only via VBA API possible. According to this SCN thread it isn't the identical as in Bex Analyzer 3.5/7.0 because you have to replace the system and then reconnect to another system.
  • It is now possible to add filter values via upload of a text file. I believe it was already in Analysis Office 2.2 SP3 available. I will create a detailed post soon.
  • You can create restricted measures on the fly in Analysis Office, but you need BW 7.5 SP4 to do this
  • The sheet protection is provided for the next release in Q4
  • There is a new report type in the transaction RSBBS called "Analysis Office" available, which allows you to jump from Design Studio into an Analysis Office workbook.
  • There is also a new Table Design Rule Editor.

I think there is some cool new stuff in AO 2.3 available. Can't wait to see the next version.

Read More 0 Comments

Analysis Office 2.3 is available

Since yesterday Analysis Office 2.3 is available. You can download it here, to download it you need a S-User with download credentials.

 

The admin and user guide isn't available at the moment. I hope SAP will release it in the next days. First impressions can be made at this SCN article from Tammy Powlas.

 

I just download the version and hope to write more in the next days.

Read More 0 Comments

Analysis Office Save Query View

As in the BEx Analyzer you can save also query views in Analysis Office. Currently in version 2.2 SP2 you can find this option under Tools >> Save View.

Read More 0 Comments

Analysis Office Data Analysis Advanced Calculations

Since Analysis Office 2.1 you have a formula editor. You can find this function in the group Data Analysis >> Calculations >> Add Advanced Calculation.

Read More 2 Comments

Change Requests after release

  1. Open transaction se38
  2. Open program RDDIT076
  3. Execute (F8)
  4. Enter a request or task number
  5. Execute (F8)
  6. Doubleclick on a selected entry
  7. Switch between Display and Change (F9)
  8. Change your request
  9. Save (CTRL + S)
Read More 0 Comments