Author Archives: Ron Keler

Webi enhancements in 4.0: dynamic chart titles and formula wildcard name searching

Web Intelligence has a lot of new features and capabilities that make life a lot easier for report developers. A couple that i ran across and thought were very useful are the ability to use a formula as a chart … Continue reading

Posted in Web Intelligence | Tagged , , , , | 5 Comments

Using EIC and z-index to coordinate and layer multiple SAP Dashboards (Xcelsius) swf files

Every Xcelsius developer who has any significant real life experience with the tool, knows that one of the greatest challenges of this technology is its scalability. As users get excited about the speed in which new developments can be incorporated … Continue reading

Posted in Xcelsius | Tagged , , , | 3 Comments

SAP Dashboards Thanksgiving trivia game

Inspired by thanksgiving and a family trip to Plimouth Plantation, i created this simple trivia game in Sap Dashboards. It’s just another demonstration of the versatility of the tool, and also kind of fun.. Enjoy the XLF here. (*Trivia questions … Continue reading

Posted in Xcelsius | Tagged , | Comments Off on SAP Dashboards Thanksgiving trivia game

Xcelsius data randomizer

One of SAP Dashboards strongest capabilities is in producing quick prototypes. Leveraging Excel rand() function it’s easy to produce random data for your prototype or proof of concept dashboard. Using variations of rand() you can produce random fake data, and … Continue reading

Posted in Xcelsius | Tagged | Comments Off on Xcelsius data randomizer

Using webi ForEach function to solve complex aggregation problems

When you create variables in web intelligence, they must be assigned a qualification. This qualification assigns a “strong” type of either a measure, or a dimension (or a detail) kind of object to your variable. This strong tying has a … Continue reading

Posted in Web Intelligence | Tagged | 52 Comments

Dynamic visibility in webi

One of the features that webi was lacking for years was the ability to conditionally suppress columns. Especially when compared to Crystal that supported this kind of functionality from the get go, or Xcelsius with its dynamic visibility, webi report … Continue reading

Posted in Web Intelligence | Tagged , , | 16 Comments

Making sense of Crystal Reports SDK and APIs

If you are looking to integrate Crystal Reports into your application, you have many ways to go about it. You can find oodles of information about the different options, pros, cons, differences and user guides, tips and tricks galore in … Continue reading

Posted in Crystal Reports | Tagged , , | 1 Comment

Extend SAP Dashboard visualizations and capabilities with google charts integration

Back in January, i wrote about Google Charts, and how they stand to shake the BI and data visualization world. Well, over the past months, not only the charts collection has grown substantially and now includes many nontraditional charting options, … Continue reading

Posted in Uncategorized, Xcelsius | Tagged , , , , , | Comments Off on Extend SAP Dashboard visualizations and capabilities with google charts integration

Would you pick strong planning or strong execution for your BI project?

If you had to choose, would you pick strong planning or strong execution for your BI project? Any project can be thought of along the lines of planning and execution. BI projects are of course no exception. Some projects emphasize … Continue reading

Posted in BI At Large | 1 Comment

Centigon GMaps Plugin example – MA counties, towns and traffic stats

Maps are a very powerful way to visualize data and bring information to users in an attractive and usable manner. Maps help make data intuitive and fun and encourage usage of information. Xcelsius comes equipped with a variety of out-of-the-box … Continue reading

Posted in Xcelsius | Tagged , | Comments Off on Centigon GMaps Plugin example – MA counties, towns and traffic stats