Apply Relative-Time and Drill Functions to Excel Sources

Uploaded Excel data can support useful reporting when dates and dimensions are modeled consistently.

Practical approach

Create appropriate time attributes, define relative-period calculations and verify the drill hierarchy used by the report.

Validation and limitations

Prepare realistic example data including year changes and missing periods to confirm the calculated values.

Read the German original

AI-assisted translation and adaptation.