Data source types: Oracle Essbase
Using Oracle Smart View for Office, you can analyze flash metrics such as sales of cost of goods sold against time-based metrics. This enables you to look for trends, find averages for different time periods, and so forth. To do this, you use linked attributes which enable periodicity of members. Periodicity is a shared pattern among time dimension members that make them meaningful for time-based analysis (January and April share periodicity as first months of quarters, for example). Day by month, day by week, and week by year are examples of linked attributes. You can also set ranges for linked attributes and apply filters.
To analyze time-related data in Query Designer: