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

Search Forums:

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

Search Forums: Search took 0.06 seconds.

  1. Password encryption in a Mondrian XMLA connection

    Hello all,

    I am developing a Pentaho plugin in Java that connects to Mondrian via Olap4J like this:


    Class.forName("org.olap4j.driver.xmla.XmlaOlap4jDriver");
    Connection cnx =...
  2. Replies
    5
    Views
    751

    june, you have to understand PDI as a row...

    june, you have to understand PDI as a row processor. I can understand what you are trying to do in the javascript step but this step is not going to create more rows than the ones that come in. If...
  3. Replies
    2
    Views
    776

    I haven't tried it myself but in Pentaho Report...

    I haven't tried it myself but in Pentaho Report Designer you can choose File -> Configuration and then edit the parameters for "output-csv". I think it may be what you are looking for.
  4. Replies
    1
    Views
    1,216

    You should use the function Filter() in the "ON...

    You should use the function Filter() in the "ON ROWS" statement.

    SELECT NON EMPTY {[Measures].[Actual]} ON COLUMNS,
    NON EMPTY Filter([Example Dimension].Members, [Measures].[Actual] <> 0) ON ROWS...
  5. To insert them in parent-child manner you need to...

    To insert them in parent-child manner you need to have a root member. Do you have it?
  6. If you are doing it in a "Table Input" it depends...

    If you are doing it in a "Table Input" it depends on your DBMS. Also, you can do it in a JavaScript step with JavaScript syntax like:

    var newVar = "%" + variable + "%";
  7. Thread: Dynamic Schema

    by xgumara
    Replies
    8
    Views
    1,832

    What configuration do you have in...

    What configuration do you have in pentaho-solutions/system/olap/datasources.xml?
  8. Replies
    4
    Views
    930

    ¿Y qué error te sale en el log?

    ¿Y qué error te sale en el log?
  9. Thread: Weka

    by xgumara
    Replies
    2
    Views
    2,773

    En la página oficial de Weka tienes un manual que...

    En la página oficial de Weka tienes un manual que explica el formato de los ficheros ARFF: http://www.cs.waikato.ac.nz/ml/weka/arff.html y en Kettle existe el paso de ARFF Output como plugin...
  10. Replies
    3
    Views
    872

    Another option would be to use the...

    Another option would be to use the <NameExpression> tag with an inside <SQL> query.
  11. Hope this links can help you: ...

    Hope this links can help you:

    http://www.walkingtree.in/forums/showthread.php?411-Restrict-the-users-on-accessing-mondrian-schema-dimensions...
  12. The administration console (it comes with the BI...

    The administration console (it comes with the BI server) is the used tool in CE to manage roles and users.
  13. Replies
    4
    Views
    930

    Qué tutoriales estás siguiendo? Has hecho alguna...

    Qué tutoriales estás siguiendo? Has hecho alguna modificación posterior?
  14. Replies
    3
    Views
    872

    I would create a "No Category" row in the...

    I would create a "No Category" row in the category dimension table with category_id = 0. Then in the fact table you have to update nulls in the category_id column with 0's.

    This way you don't have...
  15. Replies
    2
    Views
    977

    Does your report have parameters? I would suggest...

    Does your report have parameters? I would suggest to first try it without parameters and with the Advanced Options IFrame and Paginate set to false.
  16. Replies
    2
    Views
    1,565

    Well, they have a pretty documented page at...

    Well, they have a pretty documented page at http://docs.analytical-labs.com/
  17. What is your final goal? Wouldn't be Dynamic...

    What is your final goal? Wouldn't be Dynamic Schema Processor more suitable for this purpouse?
  18. There is not a big difference. The output files...

    There is not a big difference. The output files generated and modified are the same. PUC creation of datasources is easier and faster, but with PSW you can customize it better.

    For me, PUC...
  19. Replies
    1
    Views
    893

    By definition, you have to have at least one...

    By definition, you have to have at least one Hierarchy in each Dimension element. In your case I would implement a Product dimension with one hierarchy and one level: ProductName. You can specify a...
  20. Thread: Dynamic Schema

    by xgumara
    Replies
    8
    Views
    1,832

    You have to implement and compile (.jar) a Java...

    You have to implement and compile (.jar) a Java class like this:



    public class CustomDynamicSchema extends FilterDynamicSchemaProcessor implements DynamicSchemaProcessor {
    public...
  21. Replies
    1
    Views
    545

    If I understood the problem well, I would create...

    If I understood the problem well, I would create two sub-reports: one for schema 1 and one for schema 2. Then you can play with parameters and the 'visible' attribute of the sub-reports.
  22. Custom MDX connection to dynamically change roles

    Hello. I am having problems to dynamically change the role of an user in Pentaho.

    I am trying it with the Steel Wheels schema and I hope to get some help here.

    First I added this to the...
  23. Remove shadows in charts in Pentaho Reporting 3.9

    Hi,

    I tried to do a simple bar chart with Pentaho Reporting 3.9 and it always adds a shadow to the bars, which I find it misleading for the end-user.

    I couldn't find any option to turn the...
  24. Replies
    3
    Views
    2,018

    I don't know about older versions, but you will...

    I don't know about older versions, but you will find an example under the samples folder of PDI 4.2.1.

    The transformation is called "JsonInput - read incoming stream.htr" and you just have to...
  25. Replies
    6
    Views
    2,319

    I am facing the same error. I am running Pentaho...

    I am facing the same error. I am running Pentaho BI Server CE 3.8 and you can reproduce it by creating a cube with 24 or more dimensions (my case), one of them being a parent-child. When you create a...
  26. I have checked and if you save the report and...

    I have checked and if you save the report and open the xml file there is a rectangle tag with background-color #c0d0e0 (the hardcoded blue) defined in the group footer. If you change it, it works but...
Results 1 to 26 of 26