Skip to Content
Former Member
Apr 17, 2007 at 06:26 AM

Key figure Comparison for Two time periods


Hi SAP Gurus,

Iam a novice in BI 7.0. I currently need some advice and directions on the following situation.

The datawarehousing holds data based on calendar dates. The BI system extracts the data from an MS SQL Server.

The report needs to compare key figures for two time periods. The time period may either be Monthly/Quarterly/Yearly or for that case can be a date range also. The key figures has to be displayed in two columns and only two columns (one each for the time periods).

Kindly do advice me on how to model and design the report based on the time-period and restricting it to only two columns.

I would much appreciate all kinds of suggestions.