Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Fact Constellation in Cubes..

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    May 2008
    Posts
    232

    Default Fact Constellation in Cubes..

    Hi...

    Can we build a Cube with a Fact Constellation Schema??
    Cause i see only one fact can be selected in the Cube Designer.. I need to select measures from 4 facts? How can i actually do this? Should i go for workbench?

    Thanks,
    Meena

  2. #2

    Thumbs down soll. for Fact Constellation Schema

    Hi

    If you want to create measures from 4 facts from Fact Constellation Schema then you can 4 cubes as per your 4 facts.Then you can use "VIRTUAL CUBE" that means you can use your four cubes & you can create four measures.

    I think it will easy for you if you will use workbench.
    Mr. Manasa Ranjan Panda
    Hyderabad,INDIA
    E.Mail-:manasaranjan.panda@gmail.com
    M.No-+91 9392923252

  3. #3
    Join Date
    May 2008
    Posts
    232

    Smile Virtual Cube in Workbench

    Oh, thanks Manasa...

    I'll make a try.. :-)

  4. #4
    Join Date
    May 2008
    Posts
    232

    Angry Fact Constellation Schema--Problem Exists

    Hello Manasa,
    I tried creating those, but it's not working out..
    I created 4 facts using CubeDesigner, and if i try to create a virtual cube for those it it's able to create a new dimension only with one cube which i had pulled in Workbench. How'll i create virtual cubes for the rest ?

    Please help me.. Am struck...

    Thanks,
    Meena

  5. #5

    Thumbs down regarding vairtual cube

    Hii

    please find the codes how we can take more then one cubes & how we will create virtual cube,measures


    <VirtualCube name="Warehouse and Sales">
    <
    CubeUsages>
    <
    CubeUsage cubeName="Sales" ignoreUnrelatedDimensions="true"/>
    <
    CubeUsage cubeName="Warehouse"/>
    <
    CubeUsages/>
    <
    VirtualCubeDimension cubeName="Sales" name="Customers"/>
    <
    VirtualCubeDimension cubeName="Sales" name="Education Level"/>
    <
    VirtualCubeDimension cubeName="Sales" name="Gender"/>
    <
    VirtualCubeDimension cubeName="Sales" name="Marital Status"/>
    <
    VirtualCubeDimension name="Product"/>
    <
    VirtualCubeDimension cubeName="Sales" name="Promotion Media"/>
    <
    VirtualCubeDimension cubeName="Sales" name="Promotions"/>
    <
    VirtualCubeDimension name="Store"/>
    <
    VirtualCubeDimension name="Time"/>
    <
    VirtualCubeDimension cubeName="Sales" name="Yearly Income"/>
    <
    VirtualCubeDimension cubeName="Warehouse" name="Warehouse"/>
    <
    VirtualCubeMeasure cubeName="Sales" name="[Measures].[Sales Count]"/>
    <
    VirtualCubeMeasure cubeName="Sales" name="[Measures].[Store Cost]"/>
    <
    VirtualCubeMeasure cubeName="Sales" name="[Measures].[Store Sales]"/>
    <
    VirtualCubeMeasure cubeName="Sales" name="[Measures].[Unit Sales]"/>
    <
    VirtualCubeMeasure cubeName="Sales" name="[Measures].[Profit Growth]"/>
    <
    VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Store Invoice]"/>
    <
    VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Supply Time]"/>
    <
    VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Units Ordered]"/>
    <
    VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Units Shipped]"/>
    <
    VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Warehouse Cost]"/>
    <
    VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Warehouse Profit]"/>
    <
    VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Warehouse Sales]"/>
    <
    VirtualCubeMeasure cubeName="Warehouse" name="[Measures].[Average Warehouse Sale]"/>
    <CalculatedMember name="Profit Per Unit Shipped" dimension="Measures">
    <
    Formula>[Measures].[Profit] / [Measures].[Units Shipped]</Formula>
    </CalculatedMember>
    </
    VirtualCube>
    Mr. Manasa Ranjan Panda
    Hyderabad,INDIA
    E.Mail-:manasaranjan.panda@gmail.com
    M.No-+91 9392923252

  6. #6
    Join Date
    May 2008
    Posts
    232

    Default Virtual Cube in Workbench

    Hii,

    I do not get how to implement this in workbench. I need to go for virtual cube because, it'll help me to create measures from one or more fact, isn't it?
    So, i'll create a schema with multiple cubes. How will i pull this in reports?
    Will i able to pull induvidual measures in the report?

    Please help..
    This is a critical problem am facing...

    Meena

  7. #7
    Join Date
    May 2008
    Posts
    232

    Default Posted in Mondrian forums..

    Hello Sir,

    I've posted this in Mondrian Analysis forum. Lets continue our discussion there..



    Thanks,
    Meena

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.