Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to make a dimension without a dimension table?

  1. #1

    Default How to make a dimension without a dimension table?

    A customer of mine have e cube that one of the dimensions must show the text itself meaning for me that is not necessary to create a dimension table to do the relation between fact and dimension (because my client wants to see the names that we collect in the raw data). the data comes from a url (for example csr=facebook or csr=(not set) or csr=rdstation) and my client wants to explore this data
    How do I model this in Scheme Workbench?

  2. #2
    Join Date
    Apr 2008


    What you are talking about is called a Degenerate Dimension

    I don't know if the schema page is clear enough on how to put it into Schema Workbench

    But you also want to look at the stack overflow question on Degenerate Dimensions and performance... That may prompt you to make it a distinct dimension table.
    Last edited by gutlez; 05-30-2017 at 06:28 PM.

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.