Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: How to query multiple copies of same hierarchy in a cube?

  1. #1
    Join Date
    Dec 2006
    Posts
    27

    Post How to query multiple copies of same hierarchy in a cube?

    hi,



    i am looking to see if pentaho support our analysis requirements, so i am not at the moment using with this data but i will if it supports the following:

    the source data has, for business reasons, eleven columns in their database that contain the same domain of values; essentially they collect the same type of information eleven times.
    for illustration purposes their table can be exemplified as below:

    record_key
    customer_key
    age_key
    gender_key
    income_key
    product_1_key
    product_2_key
    product_3_key
    product_4_key
    product_5_key
    product_6_key
    product_7_key
    product_8_key
    product_9_key
    product_10_key
    product_11_key
    one of their major requirements is to be able to analyse data where:
    a single value is present in the first N positions
    OR
    a group of values is present in the first N positions


    so i am considering whether it would be an option to create a bridge cube to do all this filtering OR some other option.

    I am completly at a loss with this request. thus suggestions are very welcome.

    Thanks,

    Nicolas

  2. #2
    Join Date
    Mar 2007
    Posts
    216

    Smile

    Hi,

    On the theorical point of view, you need :
    -an axis Product to do analysis by "single value"
    -an axis Product Category to do analysis by "group of values"
    -a position attribute to do your filter "is in the first N positions"
    Maybe you should not have 12 products columns in 1 line : repeat the line 12 times instead with each time 1 position colum and 1 product category column.
    The constraint is that you will need to build each group of values as a Product Category but it may be a good thing businessly speaking.

    a+, =)
    -=Clément=-

    PS : I apologize for mistakes I am a french guy.

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.