Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: Phantal; Keyword(s):

Page 1 of 6 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. Replies
    11
    Views
    10,964

    re: andres' question

    My apologies, I haven't been frequenting these boards the last few years, my new job is not dwh-centric.

    Andres, I had a lot of issues related to closure tables when I needed to do some fairly...
  2. Sticky: asdf

    Error:

    Exception:

    [FONT=Courier New]Cause: This particular case (see this thread) was because hierarchies within a single dimension had unique table aliases. They should not. Only different...
  3. Sticky: asdf

    Error:

    Exception:

    Cause: If two dimensions share the same dimension table, the table needs to be aliased.
    Suggested error: (some variant of the existing error). If using multiple dimensions...
  4. Sticky: asdf

    Error:

    Exception:

    Cause of error for this instance: Nested joins were not setup properly. See http://forums.pentaho.org/showthread.php?t=63751.
  5. Sticky: Error: Suggested error: 's are not...

    Error:

    Suggested error: <Join>'s are not supported for fact tables at this time
    [/FONT]
  6. Replies
    9
    Views
    9,964

    You'd also have a Product Group dimension. A...

    You'd also have a Product Group dimension. A typical dynamic OLAP situation would start out with each dimension's All member on rows, and your measures on columns. You'd then drill down to the...
  7. Replies
    2
    Views
    1,234

    asdf

    Thank you. I figured that out about 10 minutes ago and fixed it. I just wish there was a relatively straightforward way to reference rows by column name in a copied row.

    I didn't find a method...
  8. Replies
    3
    Views
    1,384

    tail

    There's a function called 'Tail' that'll do, I think, what you need:

    <Set> Tail(<Set>, <Numeric Expression>)

    Take a look at this URL, there's an example given for its use:
    ...
  9. Sticky: The Great Cryptic Errors and Exceptions In Mondrian Thread

    Rules:



    Keep it short and simple
    One problem per message, please
    No explanations of the problem. Just post a one liner of what you think should be said in the error message. Link to...
  10. Replies
    2
    Views
    1,230

    asdf

    Mondrian does not support anything but tables and database views as the underlying relation for a fact table. This means <View>, <InlineTable>, and <Join> are not allowed.

    -Brian
  11. Replies
    6
    Views
    2,666

    Mondrian does not support anything but tables and...

    Mondrian does not support anything but tables and database views as the underlying relation for a fact table. This means <View>, <InlineTable>, and <Join> are not allowed.

    -Brian
  12. Replies
    9
    Views
    9,964

    asdf

    Please forgive me if I'm missing something very obvious, but ... why not add a contract dimension? It may not have pretty member names like "Stream", and "VOD", but it would allow you to use a...
  13. Replies
    2
    Views
    1,234

    Corrupt rows after javascript step

    I am using the following code in a javascript step to fill gaps in some data:



    currow = createRowCopy(getOutputRowMeta().size());

    if (prevrow == null)
    {
    prevrow = currow;
    ...
  14. Replies
    2
    Views
    1,128

    asdf

    Matt,

    Unfortunately, where the analytic query only allows you to lag a static number of rows, it won't do what I need. I might have a 20 minute gap here, a 1 minute gap somewhere else, and no...
  15. Replies
    2
    Views
    1,128

    [solved] javascript -- trouble with data types

    Original question is listed below, followed by the solution.

    -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

    I am having a bit of trouble with the javascript step. I'm attempting to read values from...
  16. Replies
    5
    Views
    3,209

    asdf

    I guess this is what I get for posting at 3am =)

    Um, a couple of things



    This belongs in the PDI forum. I am very surprised it ended up in reporting in the first place, my apologies.
    I...
  17. Replies
    5
    Views
    3,209

    analytic query, lag for first non-null value

    I'm trying to aggregate Forex tick data, but feel like I'm going to have to pull out the voodoo dolls to do it in a performant manner.

    The source information is rather simple, and comes in the...
  18. asdf

    When I was trying to improve performance on my transformations I tended to use 'IO wait' and other such system stats to gauge what worked. In my case, I was able to max CPU time on a quad xeon long...
  19. Replies
    29
    Views
    9,209

    asdf

    As I recall, there were some issues with Kettle using Mondrian, for some reason it didn't use the proper credentials to login to my sql server. I am fairly sure I wrote a bug on it, but I just...
  20. Replies
    6
    Views
    1,534

    asdf

    Ya, but that isn't a very good solution. Using a view is, with many RDBMS' anyway, about on par with creating a table with no indexes and querying against that table. When you constrain results...
  21. Replies
    17
    Views
    8,663

    asdf

    Only thing I can think of there is the dual use of that dimension is causing problems somehow. If you were having a similar problem in the same cube (which obviously means different dimensions, but...
  22. Replies
    17
    Views
    8,663

    asdf

    Julian,

    Thank you for the well wishes, I appreciate it. I just finished interviewing with one of them, and they said they'd have a decision for me tomorrow or monday, so it's probably a little...
  23. Replies
    12
    Views
    6,855

    asdf

    Oh dear, I thought I had posted the solution to this. I'm sorry.

    I don't remember the specifics, but I generally know it had to do with a level being given one or more wrong columns, and I...
  24. Replies
    2
    Views
    1,077

    asdf

    If you are using Oracle (or something similar), I'd suggest using materialized views for your aggregate tables.

    There are likely to be situations where new records fit into existing rows in the...
  25. Replies
    2
    Views
    2,166

    asdf

    When you run ant, make sure you build Mondrian first. If that isn't the problem, please post back (check to see if the errors change, if so then post a new log).

    -Brian
  26. Replies
    2
    Views
    2,506

    asdf

    In case you haven't already read material on this I'll give you the typical way to handle date & time of day dimensions. My apologies if you've heard it all before. In case you don't have a copy,...
  27. Replies
    9
    Views
    4,955

    asdf

    You should've just tried it. It works, although it doesn't work very well -- though that seems to depend on the dbms or the jdk driver you use.

    Kettle comes with the mysql jdbc 3.1.4 driver, or...
  28. Replies
    1
    Views
    1,290

    asdf

    You can build cmdrunner under any platform, it's just a java program. With 3.0.3 & 3.0.4, building cmdrunner is probably painless (haven't tried since 3.0.2 or so), since the build process is vastly...
  29. Replies
    17
    Views
    8,663

    asdf

    Julian,

    A better error message would probably help a lot, but it appears this happens
    under multiple circumstances, some of which may not be as easy to nail down
    under an umbrella error...
  30. Replies
    17
    Views
    8,663

    asdf

    The only times I recall encountering this error are in cubes that use <Join>
    and <Closure> constructs together, and I'm blanking on all the details. Here's
    an example of my shared dimension that...
  31. Replies
    7
    Views
    2,934

    asdf

    Well, there was an exception being caught & thrown, but, ultimately
    mysql was throwing the exception because a function call on a latinencoded
    string was causing it to bomb out.

    My instinct...
  32. asdf

    I'll give you my opinion on this, but don't take it as 'the best solution' -- it just works for me, maybe for you.

    I found Kettle's existing repository very useful for some things (eg,...
  33. asdf

    Daniel,

    Where is there documentation on some of the features you're using? I'd like to read up on it.

    Also, you said .equals() requires you pass it an array to indicate which fields to...
  34. asdf

    Back when I was working on this, I ended up re-doing it with existing steps in Kettle and was able to get much better performance than the javascript step using the hash table(s), so at least as far...
  35. Replies
    7
    Views
    2,934

    asdf

    Daniel & I worked out the problem last night. It had to do with the character set
    used, they weren't always UTF8.

    -Brian
  36. Replies
    7
    Views
    2,934

    asdf

    Well, I'm sure there's a number of ways to go about fixing this, but I would probably
    choose the 'simplest is best' approach for now, get everything working, then if you
    don't like the simple...
  37. Replies
    3
    Views
    1,796

    asdf

    What happens if you attempt to formulate the measures in generic SQL, if that's feasible to do so?

    Also, I did come up with a good workaround (not solution) to your problem. Create a generic...
  38. Replies
    5
    Views
    3,261

    asdf

    I know this is a really old thread, but I figured I'd throw another bone in the pile.

    You'll also see this with Oracle if you enable lazy conversion, under some circumstances. I have 3 table...
  39. Replies
    3
    Views
    1,710

    asdf

    Virtual Cubes are the equivalent of a table join. If you create a shared dimension (I prefer 'global', because shared is a little ambiguous), and two or more cubes use that dimension, all you have...
  40. asdf

    Howdy. I have a few comments and/or suggestions:

    What you want to do would not only be difficult to work with and/or maintain, but is not possible in Mondrian. When you speak to salespeople...
  41. Please comment on this issue

    I've submitted an 'artifact' to the OLAP4j project, please weigh in if you have an opinion, or further features you'd like added to the DrillThrough() API.
    ...
  42. asdf

    Ya, my wife & I started watching around season 2, went back & watched season 1, and have been hooked since. Season 1 is still the best, but it's all good, and that's what matters.

    As for what...
  43. Replies
    13
    Views
    5,067

    For the first question, under what circumstances...

    For the first question, under what circumstances is the row a repetition? I'm guessing when some piece of categorical information changes. If you have a copy of Ralph Kimball's Data Warehouse...
  44. asdf

    Yes, you see to the heart of it perfectly.

    OLAP4j has an API on the cell interface called drillThrough():


    ... where the ResultSet is an SQL resultset, so it sounds like adding a custom...
  45. asdf

    A little more reading on this for you, Daniel, when your copy of the data warehouse toolkit arrives. Page 75. I'll quote a little:



    -Brian
  46. asdf

    I'd have a use for completely dynamic queries, but my use case is not a common one.

    re: hacking, the only difference between a hack and a feature is whether someone decides it's an appropriate...
  47. Replies
    1
    Views
    2,479

    asdf

    Daniel,

    Howdy. I hadn't seen your thread yet so I posted my own to respond, http://forums.pentaho.org/showthread.php?t=64635.

    The short-term answer is, just duplicate the transaction rows...
  48. asdf

    Following up on this, I looked through The Data Warehouse Toolkit page 49, and all or parts of chapter 12. It talks about fact-less fact tables for handling situations where you want to express...
  49. Periodic snapshot -vs- transaction fact tables

    Daniel Murray asked me a question about periodic snapshot -vs- transaction fact tables, one I've wrestled with mentally for awhile.

    Suppose the source data you start with is transactional in...
  50. asdf

    I'm not sure I understand. Supposing I have a system in place for viewing individual cases in extreme detail -- far more detail than you'd need in an OLAP cube, such as pictures, video, detailed...
Results 1 to 50 of 257
Page 1 of 6 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.