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: […]
Category Archives: BI Platform
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, […]
Set Analysis Part 3b: Creating Sets In BusinessObjects
w that we’ve spent some time with sets, it’s time to begin to see the technology in action. Business Objects has made sets easy to build and maintain. There is virtually no limit to the ways you can now choose to look at your customers and look at how those customers are contributing to revenue, […]