Answered Questions

  • Dimensional Modelling

    Explain the design of dimensional model for Internet selling

    Ramanagoud

    • Mar 17th, 2013

    Dimensional model will be having original tables and will be joined directly to other tables using primary key. As in ER modelling we will not do any normalization here. We don't bother about any memo...

    BIchick

    • Feb 5th, 2010

    This is simple layout without stocking/restocking data, also without GL, specials handling, etc...You would have to have these dimensions:Date (including, excluding time - based on how grainual you ne...

  • what is flat aggregation

    kishore

    • Nov 26th, 2013

    If we create an aggregate on a dimension which has less than or equal to 16 characteristics, then it is act as a line item dimension, This type of aggregates are called flat aggregates. my personal re...

    JAGADISH RAJU

    • Sep 14th, 2011

    If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.