Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Basic Dimensional Modeling Question

  1. #1
    Join Date
    Feb 2009
    Posts
    1

    Default Basic Dimensional Modeling Question

    Hi all,

    I am new to dimensional modeling.

    I am learning how to do dimensional modeling.
    My question is where should the calculated aggregates kept? In Fact tables or as cubes?

    For example,

    I have the following Dimensions
    - Student Dimension
    StudentId(PK), StudentName

    - Subject
    SubjectId(ID), SubjectName

    - Fact Table
    Marks

    Should aggregates like CGPA, AverageCGPA, HighPerfomersCount, etc be in the Fact Table or should they be considered as cubes?

    Please help me...

  2. #2

    Default

    Hi there! Have you looked through http://mondrian.pentaho.org/document...ate_tables.php ? There is quite a lot of info on this topic as well as several tools that should be helpful with defining and populating such tables. If I am not mistaken, Mondrian can be made aware of these tables when executing MDX queries.

    - JB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.