Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: views with postgresql is not working

  1. #1
    Join Date
    Feb 2013

    Default views with postgresql is not working

    Hi Forum,
    I have designed a CUBE... db : postgresql

    I have added few dimensions to the CUBE..
    I can NOT add one of the dimensions from the table (As foreign key and primary key realtionship is importent) .. To add this dimension I am writing an SQL view in the view provided option... giving alias and matching the columns....

    Thought it is not working..

    How can I over come this ? Can some one suggest me on this ?

  2. #2
    Join Date
    Jan 2013


    Here's a tiny example with a dimension built on a <View>, maybe it will help you. You should be able to save this snippet to a file and open in in PSW.

    <?xml version="1.0"?>
    <Schema name="ViewTest">
    <Cube name="GenderCube">
    <Table name="sales_fact_1997" alias="sales_fact_1997_gender" />
    <Dimension name="Gender2" foreignKey="customer_id">
    <Hierarchy hasAll="true" allMemberName="All Gender" primaryKey="customer_id">
    <View alias="gender2">
    <SQL dialect="generic">
    <![CDATA[SELECT * FROM customer]]>
    <Level name="Gender" column="gender" uniqueMembers="true" />
    <Measure name="Unit Sales" column="unit_sales" aggregator="sum" formatString="Standard" />

Tags for this Thread

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 - 2017 Pentaho Corporation. All Rights Reserved.