Reporting by Time, Scenario and View
The Time details are controlled by the Scenario for Input Frequency and Workflow Tracking Frequency. The Scenario is defined through the Workflow point of view. The BI Blend process will always assign the Time as a stored column whether time is defined as a record or by Workflow. This is done to maximize the BI Blend table generation and reporting performance
The View dimension is not available or managed in BI Blend. Accumulating results, for YTD reporting, must be done in the reporting tools as a calculation or performed using business rules. The output results of BI Blend include an identifying column records identifying the Account Type to identify Flow and Balance Type accounts.