Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 7 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. Replies
    2
    Views
    1,501

    Found it : table = r_trans_data_service Field...

    Found it :
    table = r_trans_data_service
    Field 'CACHE_METHOD' is of type string. A length of 15 does the trick, but i do not know if this is the inteded length.
  2. Replies
    2
    Views
    1,501

    thin kettle jdbc driver

    I was playing with the thin kettle jdbc driver.
    Therefor i needed a new transformation, so i created one.
    When i save a transformation to the repository, that has information in the Data service...
  3. Looking at the code does not reveal the answer.

    I was looking at the code to see if i could find something there.

    I guess my problem is that i do not clearly understand the usage of object:externalId/lookupField

    Can someone elaborate on this...
  4. If module field = Account:Id/ParentId I get...

    If module field = Account:Id/ParentId
    I get the error :
    2013/02/18 21:53:52 - Salesforce Upsert.0 - ERROR (version 4.3.0, build 1 from 2013-02-18 17.27.49 by begunrom) : Unexpected error...
  5. salesforce upsert give error on Account parentId relation

    Hi,

    I want to update the parent field of an salesforce Account.
    In the module field i entered : Account:Parent__r/Account
    The Use external id field is set to yes.
    What do i do wrong?

    If i do...
  6. Is there a recording of the session somewhere?

    Is there a recording of the session somewhere?
  7. Replies
    6
    Views
    4,393

    Kyle, What does the Alfresco log say's? If...

    Kyle,

    What does the Alfresco log say's?

    If you are in Share, you should see at the right hand side "repository" This is the root level. Below you find among others also "Sites".
    So i guess...
  8. Replies
    6
    Views
    4,393

    Kyle, They can be connected to each other by a...

    Kyle,

    They can be connected to each other by a hop.

    Look at the cmis example in the samples folder.

    These are the standard settings for the documents tab. The only thing you need to change...
  9. Replies
    6
    Views
    4,393

    Kyle, The URL you should use is...

    Kyle,

    The URL you should use is http://alfresco.xxx.com/alfresco/service/cmis

    Cmis uses a specific url to listen for it's call's.

    Enter user name & passord and then press test. If the test...
  10. Replies
    6
    Views
    4,393

    Kettle PDI plugin for CMIS (Alfresco,..)

    Created case from http://wiki.pentaho.com/display/EAI/How+to+install+the+Output+Alfresco+Plugin?&#comments

    There exists another plugin that connects to any cmis compliant content management system...
  11. ParallelPeriod function does not support leap years.

    We have a MDX that computes the gross sales of february last year. This works fine for all months except for february 2012. This is caused by the fact that february 29th only occurs each 4 years....
  12. Replies
    0
    Views
    1,854

    Mondrian memory limit exceeded

    We have a Pentaho server running on 64bit suse linux.
    We have a 64 bit java virtual machine.
    Tomcat is started with -Xmx3072m, to have more memory available.

    At a certain point in time, we see...
  13. Replies
    5
    Views
    4,478

    i go this working in the latest 3.8 build. You...

    i go this working in the latest 3.8 build. You need to use this function in the post-processing formula field of a parameter
  14. Replies
    5
    Views
    4,478

    So i created a jdbc datasource names...

    So i created a jdbc datasource names "singlevaluequery" with the query "SELECT bp_name_city FROM `bpdim` where bp_bp_id = '100059001G'"in it. The preview works.
    Then i defined a open formula...
  15. Replies
    5
    Views
    4,478

    SINGLEVALUEQUERY function

    I used the following open formula funtion to retrieve the bp_name_city.
    The only thing i get is -1, when i try to display the value in a string field.

    =SINGLEVALUEQUERY("SELECT bp_name_city...
  16. Replies
    1
    Views
    1,027

    Apparently ${param0} works (param0 = string) If...

    Apparently ${param0} works (param0 = string)
    If i want to have the value of param0 placed between quotes, i use ${param0,string}. This results in an error
  17. Replies
    1
    Views
    1,027

    MDX-parametrization.

    I wanted to have parametrization in an MDX query as explained in :
    http://www.sherito.org/2009/12/back-to-start-mdx-parametrization.html
    So i created the following MDX in prd. param1 is a parameter...
  18. Replies
    0
    Views
    1,159

    pdi 3.2.5 has a slow UI on 64bit windows 7

    Since i got a new 64 bit windows 7 PC, pdi (the same version as on my old machine) runs awfully slow. It takes more than 10 seconds before the screen of a step opens.
    Besides being slow it...
  19. Replies
    0
    Views
    1,059

    html-anchors not created.

    I have created a html report where i want to include anchors in the html, so i can reference them in the future.
    I created a report with 3 groups.
    On level 1 i grouped on CHAPTERNAMEL1.
    On level...
  20. thanks thomas

    thanks thomas
  21. bookmarks folded out by default when opening pdf

    Often i receive pdf reports from our foreign collegues. When you open these, the bookmarks are folded out and the the data of the first bookmark is displayed at the right.
    When i open documents...
  22. Replies
    0
    Views
    1,078

    nested bookmarks.

    I can define bookmarks in a pdf report created with the report designer.
    As i have a need for nested bookmarks, what do i have to change?
    How do i specify that they are nested.
  23. Replies
    11
    Views
    6,853

    the next step

    If i put fields group-value-0 and item-index on the form, i can get lines in the form
    "my toc item1 1"
    "my toc item2 5"
    "my toc item3 ...
  24. Replies
    11
    Views
    6,853

    example

    Bart,

    Thanks for the reply.
    Do you mind sharing with me an example?
  25. Replies
    11
    Views
    6,853

    same problem

    I am having the same problem. Did you manage to find a solution?
  26. Replies
    1
    Views
    1,261

    roles are fed into mondrian

    How can i check what roles are fed into mondrian?
    Can i make the connect string visible?
  27. Replies
    1
    Views
    1,261

    use of UserRoleMapper

    I was testing if mondrian roles were still functional after the upgrade of 1.7 to 3.5
    Apparently with the current setup (no UserRoleMapper) roles are ignored.
    So i tried using the...
  28. 2 solutions

    if you use a regular jbbc datasource use
    SELECT * FROM my_table WHERE A = ${Env::username}
    or
    use a custom JDBC query and enter in the formula field for the query name
    SELECT * FROM my_table...
  29. you need 3.6.0-M2 to get it work.

    you need 3.6.0-M2 to get it work.
  30. Thread: confused

    by begunrom
    Replies
    5
    Views
    1,542

    ban option works

    I now inplemented the "ban" option. After setting a default value for the additional parameter i could get the post processing formula =TEXT([param1];"yyyy-MM-dd HH:mm:ss") to work with kettle.

    ...
  31. Thanks for looking into it.

    Thanks for looking into it.
  32. roleListService == null

    I added some logging aand found out that roleListService == null.
    My java knowledge is not sufficient to understand what this means:
    PentahoSystem.get(IUserDetailsRoleListService.class)
  33. test xaction

    To test i created an xaction that reads the security inputs (principalRoles,principalName,systemRoleNames,systemUserNames).
    They all return the expected values.
    I think the principalRoles...
  34. OK

    You have overlooked something. I have done it and at least the hidden parameters do not show up. There are problems with date parameters.
  35. roles & users visible

    I was happy with my security setup up to now. I am using LDAP and in the mantle UI, i can see roles, i can see users, so as far as i can see there is no problem with the security settings for normal...
  36. ThinkingPhoneNetworks, Did you also try the...

    ThinkingPhoneNetworks,

    Did you also try the roles thing in the platform or only in the designer?
  37. Thread: confused

    by begunrom
    Replies
    5
    Views
    1,542

    upgrade does not work

    I took the latest build from prd & the reporting-platform-plugin. Copied the files to the platform.
    Behaviour is the same. Looks like the post processing formula =TEXT([param1];"yyyy-MM-dd...
  38. "IUserDetailsRoleListService" has not been configured

    I upgraded according to the instructions in : http://forums.pentaho.org/showthread.php?t=73796

    Every time i run a report i get the following error multiple times in the log.
    What did i forget to...
  39. Thread: confused

    by begunrom
    Replies
    5
    Views
    1,542

    which jars do i need to update

    Taqua, thanks for the info.
    Is it sufficient to update the reporting-platform-plugin or do i need other jars as well
  40. Thread: confused

    by begunrom
    Replies
    5
    Views
    1,542

    confused

    I have an imput parameter type = date picker.
    I have a post processing formula =TEXT([param1];"yyyy-M-d'T'H:m:s")
    What should the value type be String or Date?
    The result type of the formula or of...
  41. Replies
    4
    Views
    1,264

    functionsNeverReturnBlobs=true is not sufficient

    In my case the "functionsNeverReturnBlobs=true" did not work. Only reverting to an older version works.
  42. Replies
    4
    Views
    1,264

    thank you

    thank you for the quick reply.
  43. Replies
    4
    Views
    1,264

    query

    I forgot the query :

    SELECT
    tcibd001.t_item,
    tcibd001.t_dsca,
    tcibd001.t_citg,
    (ifnull((SELECT t_stoc FROM twhwmd215100 where ((t_item = tcibd001.t_item) and (t_cwar = 'B'))),'Not sold...
  44. Replies
    4
    Views
    1,264

    SQL resultset is different in ci builds

    I have the following query


    The type of the field "stock" returned in 3.5.0.GA is String.
    As i need to use a more recent version than 3.5.0.GA, because of bug fixes, i tried the lates ci...
  45. UI code

    Taqua, i got it that it is a bad idea to use the data picker with a datatype other than date.

    I still have another question. Is it so that the code for the parameter UI as used in PRD is different...
  46. prd & platform show date with different formatting

    I have a date input parameter defined in the new designer. In the UI it shows up as "2009-10-31T00:00:00.000+0100".
    As this parameter is needed for a Kettle transformation, i have selected as type...
  47. main report

    Define all your database connections in the main report and the connection is reused. All defined connections are inherited by the slave report.
  48. security

    As the username is known we do a lookup for security information as the platform role is not the same as the "security role".
    Currently, because we do not have an other option, the platform fetches...
  49. Replies
    1
    Views
    1,089

    pdf document properties

    In the 3.5 report designer, you can use the export to pdf function to create a pdf report.
    On of the option tabs you can fill out is Meta-data. When you enter for example the title, it's get's...
  50. Replies
    28
    Views
    4,849

    My feedback

    Over the last day's i have noted the problems i have encountered. Most of them are related to the lack of documentation/ease of use. If the program would be easy to use, you would not need any...
Results 1 to 50 of 314
Page 1 of 7 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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