Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 6 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. Replies
    4
    Views
    1,838

    Resolved

    Went back to revisit my wrapper.conf file and sure enough, I had the wrong number of parms. So as an FYI, if you're going to use a config file for Carte be sure you're only passing in the config file...
  2. Replies
    4
    Views
    1,838

    Hi marabu - Yes, the working directory is set and...

    Hi marabu - Yes, the working directory is set and from what I can tell Carte is running without a hitch. Thanks for throwing in a suggestion though..:D
  3. Replies
    4
    Views
    1,838

    Calling a job against Carte via URL

    Does anyone know where the carte config file should reside when using YAJSW? I see five config files (eg.carte-config-{port}.xml and carte-config-master-{port}.xml) listed under the PWD directory but...
  4. Replies
    3
    Views
    1,242

    Hi Masond. It's not clear if you are able to...

    Hi Masond. It's not clear if you are able to successfully run the batch manually and are just having issues with the scheduled task not working. If the problem is just the scheduled task, make sure...
  5. I apologize if I don't understand what you're...

    I apologize if I don't understand what you're trying to do but if you expect it to be filtered on the set of periods why not just use a set?

    with set [MySet] as '(([Date].[Toutes les...
  6. The only way I have ever been able to get...

    The only way I have ever been able to get mondrian to behave correctly with roles is to use explicit grants for each member you want the role to be able to access. Yes, maintenance is a nightmare....
  7. Replies
    5
    Views
    1,275

    It also appears that existing EE customers can't...

    It also appears that existing EE customers can't use it either as it requires yet another license key.
  8. Replies
    1
    Views
    1,308

    Please vote for this...

    Please vote for this.
  9. Check out this post.

    This post describes how to make calls from JPivot but it may help get you started.
  10. Replies
    11
    Views
    5,065

    Maybe try this

    Hi -
    Forgive me if I'm not understanding your question, but it sounds like you are asking how to handle formulas that have to deal with multiple hierarchies where the hierarchy is unknown until...
  11. Replies
    1
    Views
    8,816

    Pentaho offers two products for rapidly designing...

    Pentaho offers two products for rapidly designing your Mondrian OLAP schema files/cubes. The first is the schema workbench and the second is their pentaho data integration designer (PDI). For non...
  12. Assuming mondrian supports the case statement...

    Assuming mondrian supports the case statement (which I don't believe it does) it would be something like:
    WITH
    MEMBER [Measures].[M1] AS
    CASE [ProcessType].CurrentMember
    WHEN...
  13. Replies
    1
    Views
    1,227

    Have you confirmed that the URL is being encoded...

    Have you confirmed that the URL is being encoded correctly from cold fusion?
  14. Replies
    4
    Views
    104,174

    Hi When working with multi valued dimensions,...

    Hi
    When working with multi valued dimensions, you typically have a fact for each value. So if you have a 2-1 relationship then you would have two facts with a weighting factor of .5 for each fact...
  15. Yes, this can be altered in the datasources.xml...

    Yes, this can be altered in the datasources.xml file .
    pentaho-solutions\system\olap\datasources.xml
  16. Replies
    3
    Views
    2,287

    Check log4j

    I don't believe mondrian logs are enabled by default. You can can enable them in biserver\tomcat\webapps\pentaho\WEB-INF\classes\log4j.xml. Usually they are toward the bottom and commented out. You...
  17. Replies
    4
    Views
    104,174

    When you say you configured Mondrian, are you...

    When you say you configured Mondrian, are you defining your schema as snowflaked? I have not tried plotting a mondrian schema against a bridge but it should work providing you have your joins set...
  18. Assuming you mean sector_of_coil is the most...

    Assuming you mean sector_of_coil is the most general:

    <Dimension name="Coil">
    <Hierarchy hasAll="true" allMemberName="All Coils">
    <Level name="Sector of Coil"...
  19. Replies
    3
    Views
    3,543

    Pentaho uses annotations for their Analyzer...

    Pentaho uses annotations for their Analyzer product. AFAIK, Out of the box Jpivot does not recognize annotations. The following is a hypothetical example...

    <Measure name="Charges" ... >
    ...
  20. The part of the log that you need to look at is...

    The part of the log that you need to look at is Table 'mis_jetstonenl.fact_salescount' doesn't exist. If you have a schema called mis_jetstonenl then you need to make sure you set that as a seperate...
  21. Replies
    7
    Views
    3,458

    Are you talking about two distinct dimensions of...

    Are you talking about two distinct dimensions of time? For example one that models dates and one that models time? If so, then yes you need two dimensions and they can be displayed independently of...
  22. Are you sure you have your foreign keys set...

    Are you sure you have your foreign keys set correctly? For example DWH0050"."PRDESTID" = "EST012"."PRDESTID is probably right but I question DWH0050"."CLIID" = "DWH0018"."CLIDWID" In any case,...
  23. Thread: Roles

    by microdisney
    Replies
    8
    Views
    1,695

    Unless I'm missing something EE version doesn't...

    Unless I'm missing something EE version doesn't support dynamic access rules either. But yes, you can force a slice on a yes/no column and hide it.
  24. Replies
    3
    Views
    2,287

    Usually hinders on memory and OS limitations

    Based on my experience, you can get some great results with Mondrian provided you have ample amount of memory. In my book, the first MUST HAVE for mondrian is a 64 bit platform so you don't get hit...
  25. Replies
    3
    Views
    1,158

    A good place to test this out is the...

    A good place to test this out is the bar-sparkline in the sub-report for the sample "Buyer Report". Modify the MDX to something like then for your message templates use your column references eg....
  26. Upgrade Reporting engine 3.7.1 to 3.8.0 on 3.7 platform

    Has anyone tried just upgrading the 3.8 libs for reporting and running them under 3.7 platform? As refreshing as it is to embrace Spring (the season not the framework) I do not find it refreshing to...
  27. Replies
    5
    Views
    3,475

    Same Here

    Unfortunately, the associated JIRA for this issue was closed due to non reproducible. It's just a warning but it has been driving me crazy for MONTHS!!. I just want to know what the heck it is trying...
  28. Replies
    6
    Views
    3,155

    Verify your roles.

    You need to make sure your role is getting passed into your xaction. My guess is that it is not based on what you describe. If all is working properly you will not see the gender available in the...
  29. Got it working!!

    Maria -
    Thank you so much. I forgot to add the named parameter in the job itself. Works like a charm. I'll be sure to grab a copy of your cookbook.

    Cheers!!!
    Darrin
  30. How to generate dynamic output file names based on result set from previous job.

    I'm having a difficult time with this one. Shouldn't I be able to pass a result set from say Job1 where in Job1 I have a trans that generates one column output of say 2010-01-01, 2010-02-01 etc and...
  31. If you have windoze, you can use this as an...

    If you have windoze, you can use this as an example for your task manger properties.
    D:\Kettle\Kitchen.bat /rep:"SS Kettle Repo" /job:"Master Daily Jobs" /dir:"/Data Warehouse" /user:kitchen...
  32. Replies
    1
    Views
    1,151

    Some of those elements are used solely for web...

    Some of those elements are used solely for web pages outside of the Pentaho User Console (aka GWT). You can probably find more information on the index.xml file in the docs prior to 2.x
  33. Replies
    11
    Views
    3,271

    Do yourself a favor and use 7zip...

    Do yourself a favor and use 7zip.
  34. Replies
    5
    Views
    4,717

    Hi - Once you are sure you have role values...

    Hi -
    Once you are sure you have role values being passed properly:
    Q1. Though it isn't clear in the security related docs, there is a provision for securing a dimension which simplifies access...
  35. Also, not all client tools support ragged...

    Also, not all client tools support ragged hierarchies which would be required to support an ontology. I have been working on a project trying to implement SNOMED through mondrian and JPIVOT just to...
  36. ditto that..

    ditto that..
  37. If I remember correctly, I believe I had to...

    If I remember correctly, I believe I had to change it in both places eg within the pentaho context as well as the mantle.jar file....
  38. Replies
    3
    Views
    1,043

    Please be more specific regarding your platform...

    Please be more specific regarding your platform specs ie number of processors, bus speed etc. Are you running on a 64 bit platform? Have you made sure you have indexed all of your foreign dim keys?...
  39. We used to use the manual deployment due to...

    We used to use the manual deployment due to customizations for the LnF, CAS and other non standard items but find it easier to just use the installer and then run a diff on the files that we...
  40. /* -1 = unknown */ Select coalesce(t1.col1,-1)...

    /* -1 = unknown */
    Select
    coalesce(t1.col1,-1) as source key,
    t1.col2 as desc
    from
    SrcTable t1
  41. Replies
    22
    Views
    14,297

    Correct me if I'm wrong but I don't believe he is...

    Correct me if I'm wrong but I don't believe he is building it into his schema. He is simply modifying the MDX statement via an xaction. I'm assuming he is passing in a parameter to his where...
  42. Replies
    6
    Views
    3,155

    Hi - Can you please be more specific as to what...

    Hi -
    Can you please be more specific as to what you're filtering and what you are seeing in the cube navigator? For example, do you have grant permissions for specific members within a hierarchy...
  43. Replies
    7
    Views
    5,917

    Hi - We use SS 2005 in our shop and use the...

    Hi -
    We use SS 2005 in our shop and use the combo/update step for Type 1 dims (see Tony's comment above). The combo/update will only handle the source and surrogate keys. So if you have additional...
  44. Hi - As far as I know you cannot filter on...

    Hi -
    As far as I know you cannot filter on properties within Analyzer. However, when I encounter this situation I just define another dimension with a single hierarchy and level that uses the field...
  45. What the documentation is saying is that mondrian...

    What the documentation is saying is that mondrian will not create joins on "snowflaked schemas" if the "level" that is defined comes from the fact table. Also, aliased tables where you are re-using a...
  46. Replies
    9
    Views
    2,575

    Don't use keys

    Degenerates don't require primary and foreign keys.

    Assuming you have all fields in one table called "URLAUBSTAGE", try somthing like this:

    <?xml version="1.0"?>
    <Schema name="Urlaub">
    ...
  47. Check out PRD-2586...

    Check out PRD-2586
  48. Replies
    8
    Views
    7,700

    Another option

    This is an example of what I typically use for opening up .prpt files in a new tab. If anyone has an easier method please share.



    ="javascript:if (top.mantle_initialized)
    {...
  49. In PRD, select the element you want to become a...

    In PRD, select the element you want to become a hyperlink then from menu bar Format->Hyperlinks. The rest is self explanatory. If you want to link to an internal report you can use things like...
  50. Since this thread is referenced from the Mondrian...

    Since this thread is referenced from the Mondrian WIKI (Needs some serious updating). I thought I should note that this is now supported in Mondrian.

    Darrin
Results 1 to 50 of 282
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.