Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    3
    Views
    1,100

    Ok, that I get, but if you are just displaying...

    Ok, that I get, but if you are just displaying results from a query you would expect to use the Data Format check box or something to get the format specified in the cube definition.

    That means...
  2. Replies
    3
    Views
    1,100

    PRD MDX vs PSD MDX

    I am seeing that Report Designer formats data differently than the other Pentaho MDX query tools. In a cube definition a Percentage column has a format defined as '%##.##'. The Schema Designer, and...
  3. I think Michael's presentation is excellent, but...

    I think Michael's presentation is excellent, but I do not think this will answer the question. The issue is really about a dynamic connection. You would have to make the connection prior to executing...
  4. Replies
    5
    Views
    2,431

    Here is my solution using the SampleData...

    Here is my solution using the SampleData database.

    Attached is a very simple report definition file that uses and MDX query as the basis for the data displayed. The problem was to provide a...
  5. Replies
    5
    Views
    2,431

    Thank you. I finally figured out the CSVArray()...

    Thank you. I finally figured out the CSVArray() expression and got that working. I will post an example using SampleData so that others heading down this path have some additional input. We have lots...
  6. Replies
    5
    Views
    2,431

    Is this possible to do in PRD 3.6 without all the...

    Is this possible to do in PRD 3.6 without all the extra Design Studio XAction manipulation? I have been racking my brain with a more straight forward approach to dynamic columns for MDX reports. I...
  7. Replies
    1
    Views
    962

    Multi Grained Results

    I have looked through various MDX sites and through the forums for how to deal with multi-grained result sets. One answer is to build a summary cube for the higher grained aggregation, but that seems...
  8. Replies
    0
    Views
    1,299

    Cast Errors with Key Expressions

    There was a post to the Mailiing list: [Mondrian] NamedExpressions Class Cast Exceptions
    that identified casting errors in 3.6. I am also getting errors using Key Expressions:
    ...
  9. Replies
    4
    Views
    2,916

    Actually, I can connect from other tools with the...

    Actually, I can connect from other tools with the same connection information. TAF is not the SID it is the service name. I use service names in other Spoon connections without any problems. The TNS...
  10. Replies
    4
    Views
    2,916

    Connection in Oracle

    I am getting an error message that Spoon cannot connect to an Oracle Service. This is really strange since I connect to Oracle DBs all the time via SID and Service with native JDBC connection. This...
  11. Replies
    0
    Views
    811

    XML as String Returned?

    I know that the WS Lookup does not handle complex types. Is there a way around by using some type of string output that can be parsed in a later step? The complex data type issue may be solved if...
  12. Replies
    6
    Views
    2,256

    Yep. I can log in from the command line and...

    Yep. I can log in from the command line and access Quartz, Hibernate and run queries.

    Bill
  13. Replies
    6
    Views
    2,256

    Here is my hibernate.cfg.xml. I left the server...

    Here is my hibernate.cfg.xml. I left the server to localhost as documented in http://www.pentaho-wiki.com/wiki/HOWTO_Manual-Tomcat-Deployment#Step_3:_Installing_and_configuring_Pentaho




    ...
  14. Replies
    6
    Views
    2,256

    HibernateUtil Problem

    I have installed 1.7 on OpenSolaris on Tomcat and Java 1.6.

    I have followed the Wiki for the Tomcat install and can access the main Pentaho splash page; however, when I try to select one of the...
  15. Replies
    2
    Views
    1,070

    Maybe a Plug-in?

    Well... another options is a plug-in, I guess. For my particular needs, advice on extending the current WS Lookup or perhaps going a different route? I am synchronizing two tool repositories. One of...
  16. Replies
    2
    Views
    1,070

    Maintain Session with WS Lookup?

    I have a login WS that is expecting to maintain a session [ setMaintainSession (Axis) ]. Can the WS Lookup step do this? I have got the login working, but subsequent calls need the session for...
  17. Replies
    1
    Views
    1,913

    I have been unable to get the Web Service...

    I have been unable to get the Web Service transform to return anything. I am gettin the following log output:

    2008/08/08 13:52:28 - Dummy (do nothing).0 - Starting to run...
    2008/08/08 13:52:28 -...
  18. We also investigated using the model for one of...

    We also investigated using the model for one of our large insurance customers. They had several insurance platforms and several claims platforms. The task to integrate and make changes to the model...
  19. Replies
    1
    Views
    1,913

    Login Web Service

    I have a very simple Web Service case in which I pass a username and password. This service should establish a session. The session is maintained by storing the HTTP cookie returned from the login...
  20. Replies
    8
    Views
    2,013

    I am using 3.1 M2. I am on MacOS X 10.5.3 (Matt,...

    I am using 3.1 M2. I am on MacOS X 10.5.3 (Matt, don't scream) with
    java version "1.5.0_13"
    Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_13-b05-237)
    Java HotSpot(TM) Client VM...
  21. Replies
    8
    Views
    2,013

    Ingo: thank you. that is basically what I had...

    Ingo:

    thank you. that is basically what I had done in testing, but I guess the drop down for field is not working? did you manually type in the field name? I created a Jira record since I was not...
  22. Replies
    8
    Views
    2,013

    XML Store and Forward

    Don't shoot the downstream developer, but we have a file which has an XML message per line similar to the following:

    <?xml version="1.0" encoding="ISO-8859-1" standalone="yes"...
  23. Replies
    7
    Views
    10,263

    I have finally found that a Database Join step...

    I have finally found that a Database Join step will work appropriately. I have never gotten the Table Input to accept parameters correctly nor have I gotten an Execute SQL Script step to work...
  24. Replies
    7
    Views
    10,263

    Sven, I have tried this several different ways...

    Sven,

    I have tried this several different ways and am not getting a Table Input step to work. I am using 3.0.2.

    I have a simple two-step transformation.

    First Step: Add Constants
    Name -...
  25. Replies
    10
    Views
    5,410

    BTW, I still get comments about PDI versus...

    BTW, I still get comments about PDI versus Informatica and people are totally amazed at the capabilities. Now, if we can only get them to purchase a subscription or two or three...

    Bill
  26. Replies
    10
    Views
    5,410

    Matt and co.: Thank you for the update. I am...

    Matt and co.:

    Thank you for the update. I am on OSX 10.5.2 and still have trouble mousing in dialog boxes. PDI crashes when you click different fields in different records.

    I am now getting...
  27. Replies
    7
    Views
    1,644

    Need any new data?

    Matt,

    Do you need any additional information? I have not changed anything (new PDI build) except Apple's OS patches.

    Funny thing, BTW, I am using the copy table wizard at an Informatica...
  28. Replies
    7
    Views
    1,644

    DI 3.0 Crashes on OS X

    This is a cross post from:

    http://forums.pentaho.org/showthread.php?p=178339#post178339

    I am reposting here since this is where it really belongs.

    Essentially DI 3.0 is almost unuseable on...
  29. Thread: DI 3.0 Crashes

    by billw
    Replies
    1
    Views
    2,382

    DI 3.0 Crashes

    Platform

    Mac OS X 10.5
    Pentaho DI 3.0.1

    When using the XLS file input:

    If you select a field to rename and then double click a different field to rename - DI crashes.

    This same crash...
  30. Replies
    0
    Views
    1,054

    Consume XAction in PDI WSL Step

    Is there a way to set up an XAction so that it can be consumed by a PDI WSL step? I would like to use ServiceAction to return SOAP that can then be consumed by PDI as a web service. I do not know of...
  31. Replies
    0
    Views
    1,055

    SOAP POST Request

    Is there a way to send a POST request via SOAP in the Pentaho platform? I have the following SOAP package:



    POST /saxtwebservice/saxtwebservice.asmx HTTP/1.1
    HPOST...
  32. Replies
    1
    Views
    1,143

    Views vs Tables in XActions

    I am using SQL Server DB (2005) as a data source and Pentaho 1.2 RC3. When a simple "select * from my_table" is executed it works fine. When a "select * from my_view" is executed, I get an error that...
  33. Replies
    2
    Views
    2,271

    I am using 1.2 GA and have not been able control...

    I am using 1.2 GA and have not been able control charts either. I see height and width in the Chart object but other controls are not really exposed.

    Bill
  34. Replies
    11
    Views
    3,563

    Re:Cube Designer - Step 6

    Agreed. If I have a fact table and create dimensions based on Fact Columns and measures based on the fact columns then it seems to save. Otherwise, If I join even one dimension table and try to save,...
  35. Replies
    3
    Views
    2,746

    Re:Using LDAP as a datasource ?

    Mike,

    I know the Pro version has some authentication extensions to the platform, but... If I create an additional source of type LDAP (specifically I need Active Directory) then I could query it...
  36. Replies
    4
    Views
    3,187

    Re:Impact of Incomplete Deployment?

    I have solved the problem, but I have found that I can cause the problem by shutting down and restarting too quickly causes the corruption. I think it is a Hypersonic problem. I am going to...
  37. Replies
    3
    Views
    2,589

    Re:XAction Returns Wrong Model

    Marc,

    I am still unable to get the result set back. I have a very simple one dimension, one measure model. Most other MDX models work fine. I have found this part of the suite the most...
  38. Replies
    4
    Views
    3,187

    Impact of Incomplete Deployment?

    I am running RC2 and get the following on PCI startup (lots of other errors during startup as well):

    22:04:46,804 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

    --- Incompletely...
  39. Replies
    3
    Views
    2,589

    XAction Returns Wrong Model

    I am using RC2 on Windows XP against an MSSQL 2005 db. I have created an MDX model and an MDX query xaction. However, when I execute it I get a JPivot view of a different model. I restart Pentaho and...
  40. Replies
    6
    Views
    4,070

    Re:XQuery Problems in Design Studio

    Mike,

    Works great! I have only used some simple expressions, and I will post if I find any additional issues.

    Bill
  41. Replies
    6
    Views
    4,070

    Re:XQuery Problems in Design Studio

    Mike,

    I will try it out. I have a complex set of XML documents served over HTTP so I have been really waiting for this feature. Looking forward to trying it out.

    Bill

    Post edited by: billw,...
  42. Replies
    6
    Views
    4,070

    Re:XQuery Problems in Design Studio

    I am guessing that XQuery FLOWR did not make RC2. I am running Server Version 1.2.0 build 398 RC2. I tried a simple XQuery statement:
    ...
  43. Replies
    2
    Views
    1,754

    Re:InvalidParameterException at runtime

    Hello Reader:

    Just a follow up. I have not figured out exactly what has been going on, but I do finally have a Jpivot/Mondrian .xaction working on my own dataset in Oracle. It seems that Pentaho...
  44. Replies
    2
    Views
    1,754

    InvalidParameterException at runtime

    Hello:

    Follwing the thread from Pablo and Nic very closely, I have gotten much further with the MDX component in the design studio. But I still have not gotten any JPivot to display.

    The...
  45. Replies
    21
    Views
    12,350

    Re:Getting started with analysis

    I am getting the same "page cannot be accessed directly" message.

    Here is my .xaction



    <action-sequence>

    <name>query1.xaction</name>
    <version>1</version>
  46. Thread: PivotView Error

    by billw
    Replies
    6
    Views
    2,207

    PivotView Error

    Hello:

    I have gotten Mondrian to work stand alone within TomCat, but have not been able to get my own data sources to work within Pentaho. My latest attempt was to use the PivotView. I am getting...
  47. Replies
    0
    Views
    1,066

    Help with Mondrian Error: MSDASQL?

    Hello:

    I have been working through creation of a Mondrian example outside the provided data set. I have read through many of the threads (including the very long mhan and nic exchange) and I am...
  48. Replies
    0
    Views
    1,322

    Advice: Kettle or Virtual Integration

    I am looking to run a report on two different data sources. Both sources are XML files. Basically, I need to take join the data and provide one report, and then drill into one of the sources based on...
  49. Replies
    4
    Views
    4,348

    Re:FreeTDS Version Issue

    James,

    I have it working with MSDE and the JTDS driver. I have not been able to get it working with SQL Server 2005 (see previous FreeTDS issue). I will also test with SQL Server 2000.

    Drivers...
  50. Replies
    4
    Views
    4,348

    Re:FreeTDS Version Issue

    This last issue is not related to the MS SQL issue with FreeTDS. I did get the JTDS driver working following the instructions in this thread:

    http://forums.pentaho.org/showthread.php?t=26644
    ...
Results 1 to 50 of 59
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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