by Jacquelyn M. Howard, Senior Managing Editor, BI Expert
If Julie Andrews (or Oprah, for that matter) were a BI analyst, design architect, or team lead, chances are the following topics might have made it to her “Favorite Things” list. So instead, I’ll step in and share some of our readers’ favorite articles on the hot topics they searched on this past year.
At the top of the list, is “workbooks.” With more than 45 articles on this topic, it can be tough to pick just one or two favorites. However, I’d have to recommend the following two articles to those who want to know more about workbooks:
Learn how to create custom workbooks in SAP NetWeaver BI 7.0. Also, find out about other enhancements, including creating company default workbooks for logos and corporate formatting.
Find out how to apply themes to your BEx Analyzer workbooks. In addition, see how you can use advanced Microsoft Excel options to further format your workbooks.
The next most popular search term is “BEx,” which is not surprising as many of our readers are in the process of determining what they can do with BEx while they are evaluating the SAP BusinessObjects BI applications. Did you know we have more than 170 articles about BEx? Two of our readers’ favorite articles about BEx are:
SAP NetWeaver BW has all the tools necessary to deploy a dynamic dashboard that shows custom content for each user. Discover some of the concepts inherent to making a dashboard successful and how you can use BEx to deliver them.
Companies often want their reports to have a certain look and feel. Using an example of formatting your BEx reports so that negative numbers appear red, find out how you can easily modify your report parameters. You can use this three-step process for other reporting needs, such as changing the exception icon.
Rounding out the top 3 is “hierarchies.” We currently offer 70 articles about hierarchies. Two of the most popular are:
Find out how you can use formula variables with hierarchies to define individual cells in a report. This six-step process offers a low-maintenance alternative to developing custom query structures in BEx Query Designer, a pre-requisite for the cell definition feature.
A hierarchy variable enables users to simply select the desired hierarchy when running reports. Find out how to create one in both SAP BW 3.5 and SAP NetWeaver BW 7.0 using BEx Query Designer.
Overall, I’d say reporting is a key area for our readers? How about you? What is on your list of favorite things?
Oh, and I have just one more personal reporting favorite to add: Jim Brogden’s “Christmas Lights with Xcelsius.” Ok, not a true reporting article, but very festive with the fluffy fir tree and all the blinking lights!