Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    3
    Views
    2,789

    :(not a single reply yet:confused:

    :(not a single reply yet:confused:
  2. Replies
    3
    Views
    2,789

    SQL Query for Measure Expression

    Hi All,


    In this link http://mondrian.pentaho.com/documentation/schema.php#Measures , I found that, instead of getting values from a column of the fact table, measures can use sql...
  3. Replies
    0
    Views
    863

    Facebook Data through PDI

    Hi All,

    How to retrieve facebook data(images, likes, comments) using PDI. I found a previous post on almost the same issue here
    ...
  4. Replies
    0
    Views
    1,466

    Named Set does not show up in Saiku

    HI All,

    I added a Named Set to the cube and published but it does not show up in Saiku. I found a previous post on the same issue...
  5. Replies
    6
    Views
    1,072

    Thank you for the information.

    Thank you for the information.
  6. Replies
    6
    Views
    1,072

    Thank you duarte.leao. It worked. One thing.....

    Thank you duarte.leao. It worked.

    One thing.. is there any site or document where I could find these functions?
  7. Thanks for the reply, Duarte.leao. Okay, I...

    Thanks for the reply, Duarte.leao.

    Okay, I created a custom parameter with the code: function(d){ return d.toFixed(0); } as the value. And in the extension point of the pie chart I selected this...
  8. Replies
    6
    Views
    1,072

    c-tools 1.0 and Google Chrome

    c-tools 1.0 and Google Chrome
  9. 9899 What I want to do is to increase the size...

    9899

    What I want to do is to increase the size of the digits displayed on the chart or to make it bold and to change the decimal format to integer. How?
  10. Replies
    6
    Views
    1,072

    Tool Tip Issue

    Hey,

    I got a weird issue. Issue is with the tool tip (that shows the values of a component when mouse hovers over that component).
    Issue is like..

    Suppose, in the case of a pie...
  11. How to change the font size and format of the Values displayed on the Charts?

    HI,

    By setting the show values to true we can display the values on the charts. I wonder ,if there a way to change the size of the values displayed or make it bold etc. I suppose, value...
  12. Got it, thank you

    Got it, thank you
  13. Replies
    3
    Views
    1,418

    Sorry for the delay. Duarte.leao This is...

    Sorry for the delay. Duarte.leao

    This is what I was looking for.Thank you so much.:)
  14. Line chart not displaying the correct flow of data.

    Hi All,

    I have a line chart that shows the sales value within a date range for a particular product. Here is the MDX query for that.

    select {[Measures].[Sales]} ON COLUMNS,
    ...
  15. Replies
    1
    Views
    978

    No issues, I found it.

    No issues, I found it.
  16. Replies
    1
    Views
    978

    Issue with JPivot?

    Hi All,

    I created an OLAP cube with 5 measures. However, I can see only one measure in JPivot. Why?

    That is, Only the top most measure is shown in JPivot. Is that an...
  17. Replies
    3
    Views
    1,418

    Okay.. I will rephrase the issue. How to set a...

    Okay.. I will rephrase the issue.

    How to set a dynamic tool tip value? That is, depending upon the value of a parameter, the tool tip value need to be changed. How to do it?
  18. Replies
    3
    Views
    1,418

    Tool tip format

    Hi...
    How do I pass a simple parameter as the tool tip value for a pie chart? I think , the tool tip format can be used for the purpose but how? Any help appreciated.:)
  19. You are right.. I used a delay row step and it...

    You are right.. I used a delay row step and it worked. Thanks.
  20. Run Transformation in two Stages.

    Hi,

    Is there any way to run a transformation in two stages? For example, I need to stop a server and thenstart it again. The first stage would be stopping and the next stage will be,...
  21. Replies
    8
    Views
    1,051

    Thank you. that was a minor one. I should have...

    Thank you. that was a minor one. I should have changed the limit.:)
  22. Replies
    8
    Views
    1,051

    Hey marabu.. I used the step Execute a Process to...

    Hey marabu.. I used the step Execute a Process to start the bi-server and its works fine. However, the transformation is not stopping. Why is that?
  23. Okay, I suppose I need to explain the scenario. ...

    Okay, I suppose I need to explain the scenario.

    I have a report designed, generated and published on Bi Server using Pentaho Report Designer.

    In PAC, I created a...
  24. Refresh Period of Pentaho Admin Console

    Hi All,

    I wonder, if there is any variable for the refresh period for PAC. If so, how could we change it?

    Thanks in Advance
  25. Replies
    8
    Views
    1,051

    That's not working. I wonder if this could be...

    That's not working. I wonder if this could be used for refreshing the repository cos I found the documentation like this, http://wiki.pentaho.com/display/EAI/HTTP
  26. Replies
    8
    Views
    1,051

    Thanks for the reply.:) ...

    Thanks for the reply.:)

    Yeah I take that. However, may I know which will be the suitable job entry for the purpose?
  27. Replies
    8
    Views
    1,051

    Trigger Repository Refreshing

    Hi All,

    How do I trigger the repository refresh from kettle transformation by calling the URL "http://localhost:8080/pentaho/ResetRepository".??

    Does the step HTTP...
  28. Replies
    6
    Views
    3,924

    oh.. I thought, it wud take Select statements...

    oh.. I thought, it wud take Select statements too.

    Thank you lukolap and robj. Thanks for the detailed info.
  29. Replies
    6
    Views
    3,924

    Thank you, lukolap. Yeah. I know that we...

    Thank you, lukolap.

    Yeah. I know that we could use Table Input to execute Sql query. That's why I was wondering what would be the usage of the 'execute sql Script'.
  30. Replies
    6
    Views
    3,924

    Execute SQl Script

    Hi,

    Somebody please help me with the step 'Execute SQL script'. How is it used? How do I get the resultset from the sql query?

    ...
  31. Replies
    2
    Views
    788

    Thanks for the quick reply..:)

    Thanks for the quick reply..:)
  32. Replies
    2
    Views
    788

    Step to generate URL

    Hi All,

    hmm..does anyone know if there is a step which generates a URL upon when a condition is met? ...this URL should be pointing to some excel or PDF file.

    ...
  33. Replies
    7
    Views
    1,321

    Thank you. pmalves. I got it. Issue was with the...

    Thank you. pmalves. I got it. Issue was with the result set type (Banded mode). It was classic mode (by default ).

    But may I know what is the difference between these two modes or how the dash...
  34. Replies
    7
    Views
    1,321

    Hi, As I said, the issue with...

    Hi,

    As I said, the issue with bar chart was solved. However, the line chart issue is still there.

    For the MDX Query,

    with member Measures.Cum as...
  35. Replies
    7
    Views
    1,321

    Thank you, duarte.leao. I solved it. I...

    Thank you, duarte.leao. I solved it.

    I unchecked the hasAll option in the cube definition and now I got the desired bar chart in dash board.

    But still, do you have any idea on resolving this...
  36. Replies
    7
    Views
    1,321

    Thanks for the reply , duarte.leao. When I set...

    Thanks for the reply , duarte.leao.
    When I set the cross tab mode as false , I am getting the bar chart like this,

    9576

    which is showing All Products' purchase details only.

    What should I...
  37. Replies
    7
    Views
    1,321

    Now encountering more similar kind of issues.. ...

    Now encountering more similar kind of issues..

    I have the MDX query

    SELECT
    NON EMPTY {Hierarchize({[Measures].[Sales]})} ON COLUMNS,
    NON EMPTY...
  38. Replies
    4
    Views
    1,010

    Thank you, TomS. Thank you so much. You are...

    Thank you, TomS. Thank you so much. You are right, those were different products with different attributes. :)
  39. Replies
    4
    Views
    1,010

    Hi TomS, Thank you for the quick...

    Hi TomS,

    Thank you for the quick reply.
    This is the Product Hierarchy.
    9548

    There is nothing wrong with the result cos the table was populated on a date basis and there were...
  40. Replies
    4
    Views
    1,010

    How to merge two rows??

    Hi All,

    I have the MDX query,


    SELECT NON EMPTY CrossJoin({[Measures].[Sales]}, [Time].[Week].Members) ON COLUMNS,
    ...
  41. Replies
    7
    Views
    1,321

    Incomplete bar chart in dash Board

    Hi all,

    I have the MDX query,

    SELECT NON EMPTY {Hierarchize({[Measures].[Purchase],...
  42. Never mind.. I found it Issue was with the cube...

    Never mind.. I found it Issue was with the cube definition. Thank you..:)
  43. I checked it in JPivot and got the error message...

    I checked it in JPivot and got the error message

    java.sql.Date cannot be cast to java.lang.String

    Why is it? Is it because the type of date level in time hierarchy under the time dimension in...
  44. MDX query results differ in saiku and Dashboard

    Hi,

    I have the MDX query,

    SELECT
    NON EMPTY {Hierarchize({[Measures].[Quantity]})} ON COLUMNS,
    NON EMPTY {Hierarchize({[Product].[Category].Members})} ON ROWS
    FROM [Cube_Stock]
    where...
  45. Replies
    9
    Views
    1,796

    Thank you.Lukolap..Thank you so much..Its working...

    Thank you.Lukolap..Thank you so much..Its working now. :)
    For any one who has got problem with Order(), please refer the following link for the syntax:...
  46. Replies
    9
    Views
    1,796

    Order() method in MDX

    Hi,
    I am not sure, if have posted this on the right forum. Anyways,

    I have a simple MDX query,

    ...
  47. Thanks Marabu.. Yeah I know that the mail step in...

    Thanks Marabu.. Yeah I know that the mail step in a transformation is designed to send an email for each input row but ain't it necessary to have email as one of the fields in the input...
  48. Sending Email from a Job based on the output of the transformation.

    Hi Everybody,

    I am new to kettle. I am trying to send an email from a job depending on the nature of the output of a transformation included in the job.

    That is,

    ...
  49. I had already did that. It gives the message:...

    I had already did that. It gives the message: Resource not found : [OLAPSample/undefined/SocialHubReport1.prpt

    9348
  50. Thank you for the reply. I am not using...

    Thank you for the reply.

    I am not using Enterprise Edition, its Community Edition. I will provide you the steps followed.

    1.Selected a Layout.

    2. Selected PRPT component.
    9345

    3....
Results 1 to 50 of 54
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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