US and Worldwide: +1 (866) 660-7555

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.07 seconds.

  1. [Tutorial] Mondrian Schema for OLAP Cube Definition ft. Google Analytics and Saiku

    Hi folks,

    it happend again - in case you need a working example on how to craft a Mondrian schema to access and visualize a cube then check this out:
    ...
  2. MDX expression for aggregation by SUM of one level above lowest?

    Hi!

    I have two dimensions A,B and a measure M which is aggregated by summing.

    If I would apply both dimensions I could get a table that might look as follows:

    13456

    Now the problem I am...
  3. > I solve it by create a dir without chinese ...

    > I solve it by create a dir without chinese

    Well ... in Germany an IT-guy is going to get weird looks for not using English in the first place - not to mention our Umlaute (äöü) which are quite...
  4. The question is "what fact would you like to...

    The question is "what fact would you like to measure?"!

    So in case the fact table describes the number of minutes slept by P_n during meeting M_n then this would a possible design. You could then...
  5. Hey David, it is not clear to me what you web...

    Hey David,

    it is not clear to me what you web app does. Usually a web app is already directly connected to a server providing the app or site and all the communication is going through that...
  6. Tutorial on how to use the Dimension Lookup/Update step

    Hi fellow Pentahoes,

    I recently wondered how to make use of the Dimension Lookup/Update step to get some stuff done - digged into it - distilled all the pure knowledge and information from this...
  7. Star Modeler plug in available for PDI 5 CE?

    Hi!

    Diethard Steiner describes a Star Modeler plug-in for PDI 4.3 on his blog:

    http://diethardsteiner.blogspot.de/2011/11/star-schema-modeling-with-pentaho-data.html#comment-form

    Is this...
  8. Hi Darrell, thanks for confirming the assumption.

    Hi Darrell, thanks for confirming the assumption.
  9. http://stackoverflow.com/questions/23971595/how-to...

    http://stackoverflow.com/questions/23971595/how-to-look-up-technical-key-of-dimension-using-its-natural-key/23977536

    It seems that this step needs dummy columns for the dates and the version when...
  10. How to look up technical key of dimension using its natural key?

    Hi!

    According to the Wiki:


    "The Dimension Lookup/Update step allows you to implement Ralph Kimball's slowly changing dimension for both types: Type I (update) and Type II (insert) ..." ...
  11. A StackOverflow for Business Intelligence – or what BI Can Learn from PHP!

    I would like to make a point for a more community-driven BI and why I think StackExchange is a good place for that!

    http://www.joyofdata.de/blog/a-stackoverflow-but-for-business-intelligence/
    ...
  12. please remove thread

    please remove thread.
  13. You upload the schema using the "Data Source...

    You upload the schema using the "Data Source Manager" ... check this out:

    http://www.joyofdata.de/blog/getting-started-with-pentaho-bi-server-5-mondrian-and-saiku/
  14. [Tutorial] Getting Started With Pentaho BI Server 5, Mondrian and Saiku

    Hi folks,

    wrote a tutorial on how to get rollin' with BI Server - accessing a MySQL table as an OLAP cube via Mondrian and Saiku.
    ...
  15. Pentaho BI Server 5 only works with Mondrian 3...

    Pentaho BI Server 5 only works with Mondrian 3 and is shipped with Mondrian 3.6.1. The schema I gave is of version 4 and not downward compatible to 3.x.
  16. Schema fails to load in Pentaho BI Server 5: "Publish to Server General Error ..."

    Hi!

    I am new to OLAP with Mondrian and BI Server and facing a potetially very simple issue. I am using BI Server 5 and its set up is pretty much out of the box (just extracted it and installed...
  17. How to add an "Attribute" using Schema Workbench?

    Hi!

    For educational reasons I would like to reproduce the following example schema from "Mondrian in Action":

    13268

    But I cannot find a button for "Add Attribute"!?

    13269
  18. Thanks for the Info! I guess that's a good thing...

    Thanks for the Info! I guess that's a good thing because it's easier.
  19. [resolved] Setting up Mondrian for BI Server and MySQL

    Hi,

    I could use some guidance, a starting point, as to how to set up Mondrian with the BI Server and a MySQL DB.

    I have some documentation on how to write a schema for MySQL and Mondrian. But...
  20. Where may I find MDX_Datasource.xaction on my disk?

    Hi!

    I extacted the BI Server onto my disk and everything works like a charm. Now I found this folder full of sample files. I would assume that I can find those files also on my disk but can't...
  21. [Tutorial] The Making of a Pretty Web Stats Report with Pentaho Report Designer

    Hi fellow users of Pentaho products,

    just wanted to share that I composed an article on how to turn web stats data stored in MySQL into a very pretty report using Pentaho Report Designer 5.
    ...
  22. Pentaho Kettle 5 comes with improved database repository performance

    Pentaho Kettle 5 comes with improved database repository performance - See more at: http://www.joyofdata.de/blog/kettle-5-comes-improved-database-repository-performance/#more-1781
  23. I DO (mostly) "enjoy" working with Kettle and I...

    I DO (mostly) "enjoy" working with Kettle and I am looking forward to version 5 (BTW, why is the CE not ready yet while PDI 5 is available already?) but on those issues I would very much appreciate...
  24. Well, we're sitting in the same boat here, Bobse....

    Well, we're sitting in the same boat here, Bobse. When I use the repo on a locally running MySQL server it is fine but when using the remote MySQL-server through OpenVPN - good lord almighty - the...
  25. How to distinguish in job/transformation where current job is run?

    Hi!

    The main job is stored in a DB repository and run scheduled on a server and sometimes I execute it locally on my PC via Spoon.

    Paths f.x. would be different in these cases. So I would like...
  26. How do I request a fresh API key from Google?

    Hi!

    [@Mods: thread is obsolete, please delete - thanks!]

    Raffael
  27. Replies
    2
    Views
    469

    I think GA nowadays requires obligatorily usage...

    I think GA nowadays requires obligatorily usage of a generated and sent along API Key (which is apparently missing). At least I know that it is going to work then.

    Which brings me to the next...
  28. Hi marabu, thanks already! But I am wondering...

    Hi marabu,

    thanks already! But I am wondering about what those metrics are referring to - what is the difference between I - R and O - W f.x.?
  29. Meaning of logging information (I,O,R,W,U,E)

    Hi!

    Where can I find information on the meaning of I,O,R,W,U and E in the loggings seen when executing a Job?



    2013/09/30 10:46:27 - visits.0 - Finished processing (I=0, O=0, R=0, W=276,...
  30. Replies
    3
    Views
    428

    The calculator can't handle the date operations I...

    The calculator can't handle the date operations I want to do. The example is just a simplification.
  31. Replies
    3
    Views
    428

    Can't get formula step to work

    The set up is for now is as simple as possible. A Data Grid step provides singe row with a single field i and the value 0.
    And the formula step just adds another field j with value 1 or changes i to...
  32. @marabu: that also fixed my problem! good stuff

    @marabu: that also fixed my problem! good stuff
  33. well ... :D ... I thought I tried this ... :cool:...

    well ... :D ... I thought I tried this ... :cool:

    EDIT: hmm ... but actually in my current transformation "your" syntax shows no effect :/
  34. Modified JavaScript Value without compatibility switched on

    Hi!

    (Here's a boiled-down and simplified scenario).

    I have two input fields A and B keeping an integer.

    Using MJSV I want to add 1 to A and output it into field B.

    This works with...
  35. Hey marabu, I don't think so but I will...

    Hey marabu,
    I don't think so but I will investigate it - you might be correct.
    Thanks
    Raffael
  36. Hi! I updated my Java to most recent version 7...

    Hi!

    I updated my Java to most recent version 7 Update 25 64-bit. I still get the same error.

    Also tried with switched off Firewall. To no avail.

    Any ideas? The problem just occurs on my work...
  37. What did you learn about Kettle that made your job suddenly easier?

    Hi!

    Here is my little gold nugget:

    I was always wondering why I had to specify a DB connection for every transformation in a job. I just realized you can "share" a DB connection which is...
  38. Hi Tom, thanks for your input. Is there a...

    Hi Tom,

    thanks for your input.

    Is there a difference between using a "file system repository" and just simply saving jobs and trafos on your disk?
    And if yes - what is the difference and why...
  39. nice stuff, marabu! Learned two new tricks. ...

    nice stuff, marabu!

    Learned two new tricks.

    Poor Roger, though ... :/
  40. It works when I enable "dotall mode" for the reg...

    It works when I enable "dotall mode" for the reg exp step. Can somebody explain to me why?

    Regards

    Raffael
  41. The transformation of the above example:

    The transformation of the above example:
  42. Cannot use reg ex step on field conatining the concatenation of two fields !?

    Hi!

    What I originally intend to do is this:

    Unzip an archive, which always contains two files named 'x.a' and 'y.b'. The file extensions 'a' and 'b' are always the same but 'x' and 'y' are...
  43. Versioning Kettle projects with Git (on GitHub) - advice?

    Hi!

    I am currently working on a project revolving around importing the Eurostat database (provided as SDMX files) into a local database (Postgres) using Kettle. When I am done with this step I...
  44. That does the trick for now. Thanks!

    That does the trick for now. Thanks!
  45. Sorry, corrected the link. True. But it...

    Sorry, corrected the link.



    True.
    But it is also true that a lot of open source software has extensive and very well-written documentation.
    And true as well it is that the usage and the...
  46. That means the question marks serve no purpose?...

    That means the question marks serve no purpose? (Similar to ${...} f.x.?)



    I understand what you mean. But this is not what I meant. Not that important anyway as both of your solutions do the...
  47. Documentation on Kettle-specific JavaScript functions

    http://type-exit.org/adventures-with-open-source-bi/2010/06/generating-rows-using-javascript-in-pentaho-kettle/

    This blog post states the existence of for example a function called...
  48. Do "parameter" and "variable" mean the same?

    The usage of the terms "parameter" and "variable" confuses me. Are they synonyms or is there a difference in Kettle?

    Regards

    Raffael
  49. your solution provided HTTP.zip is fine, thanks. ...

    your solution provided HTTP.zip is fine, thanks.

    But where does DL come from?


    var url = service + "?file=" + param;
    var target_file = getVariable("DL", "") + "/" + param;


    In Settings...
  50. "I was unable to save the HTTP result to file because of a I/O error: Connection ..."

    Hi!

    I have a very simple job:

    11057

    The Logging panel reveals the following error:


    2013/06/12 17:05:46 - Spoon - Starting job...
Results 1 to 50 of 62
Page 1 of 2 1 2