Hitachi Vantara Pentaho Community Forums
Page 1 of 5 123 ... LastLast
Results 1 to 10 of 41

Thread: Need Help with Creating query and so on

  1. #1

    Default Need Help with Creating query and so on

    Hey Guys,

    I have big Problems with creating a query and a Schema...

    I "installed" modrian with the example DB and so on. This works great.

    But now I want to make my own query with my own Tables and so on. But I´m a totaly noob. So I need ur help!

    I have n Tables which look like this

    Tablename=tab1

    ID Value1 Value2 ......
    1 5 8
    2 6 9
    3 7 10


    Table2 looks like table one but has other values.

    Now I want to make a query which will compare Value 1 of all Tables and show this in the Graph. X-Achse is the id and y-ache the Value of the Table.

    But how to do this??? I think for you this is really easy but i´m totally a noob. Thats why I need an example like this to understand how this works.

    What I need is now the Schema and the query for that Issue. Is someone here so polite and will schow me how the query and schema has to look like. With a smal explanation pls??

    Problem is, that I need this till tomorow. Time atm 5 p.m.

    So pls help me and show me how to solve this easy problem.

  2. #2

    Default

    My advice would be next time be more prepared. If you have to do it in Mondrian, check out the demos in the PCI, especially the Steel Wheels Jpivot stuff and also try reading http://www.databasejournal.com/featu...le.php/1495511 and related articles.

    Being honest though I recon you've got no chance.

    But good luck

    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3

    Default

    Ok, thx 4 the Link.

    I know it will be hard 4 me. But I also hope to solve this problem.

    Can u make a query and a schema for my Problem I posted here? I think for someone who knows how to do that it should not be a problem. PLs. This is an example for me with with I can learn and so on.

    Can u make a qury and a shema for that pls?

    pls

    I really need it. So pls help me. Ps. I have a oracle DB

    I think the query I can do alone, hope so, but with the shema I can´t understand anything... so it would be great if u would make this example for me. Because all othe examples I found are so big and I donßt understand a word. So a small example like this will help me. So pls
    Last edited by JJDTE; 04-01-2008 at 11:28 AM.

  4. #4

    Default

    *bump*

    Still the problem. I read the doc but still no plan how to do that.

    So pls help me. I need it really....

  5. #5

    Default

    Firstly I can't believe you bumped it, secondly if you want peoples help they'll be far more inclined to give that help if it looks like you've at least tried to make an effort and we aren't doing all the work for you.

    If you boss is giving you deadlines like this on systems you don't know perhaps he should out source it, on the other hand if you've left it until the last minute then well perhaps you shouldn't have.
    Tom
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  6. #6
    Join Date
    Oct 2007
    Posts
    255

    Default asdf

    "Hi, I have no idea what I'm doing and I've committed to a project I need done in 2 hours, will someone do it for me so I can get paid?"

    -Brian

  7. #7

    Default

    Hmm, I do this noch for my work...

    And I will not paid for that. I´m a Student who have to do a presantation. Tomorrow I have to prasentate what mondrian can to my studends. If the presentation is good we will make a big project about this.

    My problem is now, that i thouht this is much easier. But it isn´t.

    So I need now ur help to check the thema. Thats why I only need a little programm. Compare some things from tables....


    It´s not so that I did nothing..but I understnd not what to do. I installed the test DB and looked the schema and querys read the doc and so on...but still no plan.

    Thats why I asked hier for help. I think 4 you this little thing should not be a problem. And with this little programm I have a examle wich I maybe can understand....

    Now I understand why u won´t help me. But I will not be paid for this . I´m only a student.

  8. #8
    Join Date
    Mar 2006
    Posts
    683

    Default

    JJDTE:

    you'll probably have to use some "suplemental" tables to catupure the information you want to probably using kettle, "pentaho data intergration" to do some transformation so that you can systimatically get the differences and have data to chart and fit it into your monderian schema.

    Those are my first throughts on it. So for a noob getting started with kettle wouldn't hurt it's one of the pieces that's great to get firmiliar with.

    -- Nic
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

  9. #9

    Default

    hmm, ok thx.

    So if i have only 1 table and I only want to show 1 value in the graph.

    x-achse the ids and y-achse Value.

    How my schema have to look like and my query? Can u give here a explanation?

    Sry Guys, I know I´m stupid but I really did not understand the subject schema..

  10. #10
    Join Date
    Mar 2006
    Posts
    683

    Default

    Then maybe it's time to take a step back and get other concepts under your hat.
    When i started working with pentaho a few years ago took me 4 to 9 months to get of the learning curves. So I felt stupid for a long time so don't get down on yourself.
    But I also came from NOT a DB/developer role as well.

    you got tab1 that has values and stuff then keep use kettle to turn tab1 with id and value 1 and value 2 then transformat that have the id+value to reflect with the changes so that you have simplified your efforts.

    USE THE KISS MENTHODOLOGY
    K.eep
    I.t
    S.imple
    S.tupid
    so when you start complicating things and are stumped step back think of how you want to brake out your steps to simple steps instead of a big complicated step.

    Hope that helps point you in a direction.
    More details might be needed and it might not hurt to see what you have already came up with.
    Try not to have too much fun.
    - - - -
    Nic Guzaldo
    That guy who shows up here
    and there

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.