This discussion is archived
1 Reply Latest reply: Feb 22, 2013 1:54 AM by 937325 RSS

Samp App V207 - joins F10 to time dimensions

Andy Nierhaus Newbie
Currently Being Moderated
Hi everybody,

I just had a look at the BIEE Sample App V207 and noticed that the physical fact table 'F10 Billed Rev' is joined to 3 Time dimensions:
'D01 Time Day Grain'
'D02 Time Month Grain'
'D03 Time Quarter Grain'

What's the idea behind this - performance improvements when doing time series calculations?

Thanks for your input

Regards
Andy
  • 1. Re: Samp App V207 - joins F10 to time dimensions
    937325 Explorer
    Currently Being Moderated
    Hi Andy,

    Here it is maintaining three different levels so it can be helpful for aggregation tables and maintaining multiple LTS in BMM layer. The main purpose is for performance tuning, the server hits any of this tables based on the time level used in analysis.

    For ex: If the analysis is based on month level then the server will hit Month level table.


    Please mark if it is helpful/correct.

    Revert me for any queries.

    thanks,

    Tinku

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points