Archive for the ‘Universe Design’ Category
Monday, November 16th, 2009
Summary
This article looks at a reporting requirement where we need to restrict data to the latest data, for example, to only show the latest account balance or the latest action item for work streams in a project.
Our solution is to implement a series of predefined conditions one for each dimension ...
Posted in How To, SAP Business Objects, Universe Design, Web Intelligence | No Comments »
Wednesday, November 11th, 2009
A large amount of data analysis will use dates to filter or group results. This article looks at what objects and predefined conditions we should include in your universe that provide rich functionality to report authors that are querying with dates.
Posted in SAP Business Objects, Universe Design | 1 Comment »
Tuesday, January 27th, 2009
Often in a reporting or data analysis scenario the analyst or business user wants to view data that is current, for example, sales for the current week or employee turnover for the current month etc. The analyst could create the report and then just enter whatever the current date is ...
Posted in Information Delivery, SAP Business Objects, Universe Design, Web Intelligence | No Comments »
Monday, January 26th, 2009
In the previous article we looked at why using System Date functions in a BI solution can lead to difficulties in development and testing. In this article we are going to look at several alternatives to using system date functions.
Posted in Information Delivery, SAP Business Objects, Universe Design, Web Intelligence | No Comments »
Sunday, January 25th, 2009
In the last article we looked at alternatives to returning the system date in the report queries. This article looks at the report and alternatives to using system date functions in report calculations
Posted in Information Delivery, SAP Business Objects, Universe Design, Web Intelligence | No Comments »