US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: views with postgresql is not working

  1. #1
    Join Date
    Feb 2013
    Posts
    385

    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
    Posts
    512

    Default

    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]]>
    </SQL>
    </View>
    <Level name="Gender" column="gender" uniqueMembers="true" />
    </Hierarchy>
    </Dimension>"
    <Measure name="Unit Sales" column="unit_sales" aggregator="sum" formatString="Standard" />
    </Cube>
    </Schema>

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
  •