Browse by Tags

• Benefits
• BEx
• BEx Analyzer
• BExAnalyzer
• BI
• BI 7.0
• BOARD
• BPC
• Business Objects
• Cost
• IP
• Microsoft
• Performance Management
• Planning
• Reporting
• SAP
• SAP GUI
• SharePoint
• Transaction Code
• Value
• Workbooks

• Budget BI: Three Frugal Examples

  There are ways to implement a BI initiative without investing a fortune in expensive technology. Savvy IT and business leaders learn to leverage existing software and choose affordable alternatives. Key Considerations We have analyzed a broad range of... Posted Mar 24 2010, 07:16 PM by GlenChambers with | with 1 comment(s) Filed under: Microsoft, Excel, BI, Reporting, Performance Management, BOARD, SharePoint

• Reining in spreadsheets and using them better

  Spreadsheets are ubiquitous, perhaps the most used application in the workplace for a large majority of people and definitely not going away. However sometimes they can also be, well, dangerous and secretly costing you plenty of cash so it is worth looking... Posted Nov 11 2008, 09:38 AM by GlenChambers with | with no comments Filed under: SAP, Excel, BI, Reporting, Performance Management, IP, BPC, Planning, Business Objects, Value, Benefits, Cost, Workbooks

• Listing all queries within a workbook

  I have been working on an unusual and complex planning workbook that has 32 separate queries embedded in it and was recently shown a quick and easy way to list all of them. We have a naming convention to identify all the queries that should be in the... Posted Jun 18 2008, 04:17 PM by GlenChambers with | with no comments Filed under: BI 7.0, SAP, BExAnalyzer, Excel, BEx, Planning, Transaction Code, BEx Analyzer, Workbooks

• A BEx input query formula bug, a patch too far and an inelegant solution

  In the past week I created a input enabled query in BEx Analyzer to save back long term plan data over a 10 year period. To accomplish this I used an offset variable range from the current year to current year +10, simple enough. I then inserted the query... Posted Jun 08 2008, 08:18 PM by GlenChambers with | with no comments Filed under: SAP, BExAnalyzer, Excel, BEx, Reporting

• Upgrading SAP GUI 7.10 breaks BEx formulas created in SAP GUI 6.40

  This week I experienced an issue in BEx enabled workbook that used formulas after upgrading our SAP GUI from 6.40 to 7.10. In 6.40 the BEx add-in file resides in the following directory: C:\Program Files\SAP\FrontEnd\Bw\BExAnalyzer.xla however in 7.10... Posted Apr 25 2008, 02:38 PM by GlenChambers with | with no comments Filed under: BI 7.0, SAP, SAP GUI, BExAnalyzer, Excel, BEx