On August 5, 2009, the SAP BusinessObjects Innovation Center announced a prototype for moving Sets Technology directly into the Semantic Layer. Potential Future of Sets Since the EOL announcement of BusinessObjects Performance Manager and two of the three analytic engines, Process Analysis and Predictive Analysis, there has been an ongoing question on the future of […]
Category Archives: Set Analysis
Set Analysis Part 5b: Custom Groups in WebIntelligence
So how we do do this exactly? How can I use BusinessObjects to create custom groups on-the-fly? How can I get beyond my requirements for multi-pass SQL and speed up my reports? The answer is Sets. Set Data All the information regarding sets is located is the tables called sets_*. The most important tables are: […]
Set Analysis Part 5a: Custom Groups in WebIntelligence
I recently had a customer who was in the process of migrating from a legacy version of Microstrategy to BusinessObjects. They had been able to migrate over most of their core reports, but there were several reports that required a number of custom groups. Microstrategy’s approach was to allow the customer to define any number […]
Set Analysis Part 4b: Creating FreeHand SQL or Importing
A less common way to create sets is to create sets is through free-hand SQL. Normally you will want to leverage to power of the set engine to design the SQL for you to return the correct results, but in rare cases you might find it helpful to create your own SQL Statements. Free Hand […]
Set Analysis Part 4a: Creating Visual Sets
I’ve decided it’s probably a good idea to break down these tutorials a bit. Although I love to share all this information, it’s probably getting a little long for a single post. Visual Sets When creating sets in Set Analysis, Visual Sets are extemely helpful. Visual Sets allow you to quick look at the union, […]