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

Thread: snowflake - error

  1. #1
    Join Date
    Sep 2010
    Posts
    23

    Default snowflake - error

    <Schema name="New Schema1">
    <Cube name="Cube1" cache="true" enabled="true">
    <Table name="TableA" schema="facts" alias="">
    </Table>
    <Dimension type="StandardDimension" foreignKey="group_id" name="DimGroup">
    <Hierarchy name="" hasAll="true" allMemberName="All Groups" primaryKey="group_id" primaryKeyTable="groups">
    <join leftKey="type_id" rightkey="type_id">
    <Table name="groups" schema="dimensions">
    </Table>
    <Table name="group_types" schema="dimensions">
    </Table>
    </join>
    <Level name="GroupLevel" table="groups" column="group_id" nameColumn="name" ordinalColumn="" parentColumn="" nullParentValue="" type="String" uniqueMembers="false" levelType="Regular" captionColumn="">
    </Level>
    </Hierarchy>
    </Dimension>
    <Measure name="MeasureValue" column="value" datatype="Numeric" formatString="" aggregator="min" formatter="" visible="true">
    </Measure>
    </Cube>
    </Schema>

    ----------------
    When I open schema in workbench, error - join attribute - right key is unset and has no default value

  2. #2
    Join Date
    Jun 2010
    Posts
    172

    Default

    Hi,

    the keywords used are case-sensitive...
    change;
    <join leftKey="type_id" rightkey="type_id">
    to;
    <join leftKey="type_id" rightKey="type_id">

    hope that helps...
    Thanks & Regards


  3. #3
    Join Date
    Oct 2012
    Posts
    3

    Default

    Quote Originally Posted by PriyankaP View Post
    Hi,

    the keywords used are case-sensitive...
    change;
    <join leftKey="type_id" rightkey="type_id">
    to;
    <join leftKey="type_id" rightKey="type_id">

    hope that helps...


    Thanks its worked for me too .. but for different error which was dude to case sensitivity.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •