Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Is it possible to creat data source with 2 fact table ?

  1. #1
    Join Date
    Apr 2017
    Posts
    6

    Default Is it possible to creat data source with 2 fact table ?

    Hello,

    I have 2 fact tables and several dimension tables and i want to creat a data source with these tables. But i when i select tables, i can only select one fact table. how can i select two fact tables ?



    thanks.

  2. #2

    Default

    Hello Everyone,

    I'm also looking for the answer of the above Question?

    is it possible to select multiple fact table in Data source creation?

    Thanks in Advance,
    - Siva

  3. #3
    Join Date
    Nov 2012
    Posts
    24

    Default

    Quote Originally Posted by wyy View Post
    Hello,

    I have 2 fact tables and several dimension tables and i want to creat a data source with these tables. But i when i select tables, i can only select one fact table. how can i select two fact tables ?

    thanks.

    Wyy:

    If I understood your question and if you are referring to Mondrian, you might achieve this using Virtual Cube.
    check: http://mondrian.pentaho.com/document...#Virtual_cubes
    Id it's related with Mondrian better ask here: http://forums.pentaho.com/forumdispl...ysis-Services\

    If referring to CDE Datasources, you can use compound or kettle datasources to achieve it.

  4. #4
    Join Date
    Nov 2012
    Posts
    24

    Default

    Quote Originally Posted by sivaprasad3152 View Post
    Hello Everyone,

    I'm also looking for the answer of the above Question?

    is it possible to select multiple fact table in Data source creation?

    Thanks in Advance,
    - Siva

    Siva I believe the answer I gave Akabhay001 and wyy might also answer you

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.