Using time is one of the most important ways to analyze information. Each day, week, month and year is unique and can best be understood within it’s specific context. In my last post, we showed how you can use the Semantic Layer to create time-based filters. Today we are going to discuss Time Specific Measures. […]
Tag Archives: Semantic Layer
Supercharge Your Universe with Time-Series Analysis – Part 1
To some degree or another, as we close out the year, we will all reflect on 2009 and what has been accomplished. There are always things we might have done better, but looking at things over the time helps to put them in perspective– both in life and in business. This is the first in […]
Sets Integrated into the Semantic Layer
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 […]
Universe Measures – Divide and Conquer
I was recently working with a universe and attempting to calculate a ratio between two numbers and coming up with some strange results. I wanted to share this with you so you didn’t waste as much time as I did trying to solve the problem. Always Returning Zero In my example, I had two measures […]
Multipass SQL 2.0 (Updated 2/23/2009)
So what is Multipass SQL? Multipass SQL. To calculate comparisons or to correctly calculate non-additive measures in report break rows, the query tool must break the report down into a number of simple queries that are processed separately by the DBMS. The query tool then automatically combines the results of the separate queries in an […]