Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    1
    Views
    624

    Ok, Found it in...

    Ok,

    Found it in /docs/performance_tunning_guide.pdf
  2. Replies
    1
    Views
    624

    Reporting 5.0.1 - Remove Cache

    Hello,

    Is there a way to disable cache for all reports? I have many reports and cant change one by one...

    Maybe some config in BI Server that removes that?

    Thanks
  3. Replies
    3
    Views
    1,256

    Thanks. Issue link:...

    Thanks.

    Issue link:
    http://jira.pentaho.com/browse/CDE-161
  4. Replies
    9
    Views
    2,420

    mcampbel, Thanks again. Look at the role...

    mcampbel,

    Thanks again. Look at the role picture:

    I need to filter both Year Range and Month Range. Year range i can filter with no problem, but i cant make both together.. When i use...
  5. Replies
    9
    Views
    2,420

    I am using this in a CDE Dashboard, so i will...

    I am using this in a CDE Dashboard, so i will place it as a parameter. There will be two selects, startmonth and endmonth, which will pass the NAME of the month..
    So what i need is to be able to...
  6. Thread: Filtros MDX

    by lucassig
    Replies
    0
    Views
    10,630

    Filtros MDX

    Olá,

    Preciso fazer um filtro em MDX selecionando os ultimos 3 anos (dinamicamente) e entre um range de meses, Janeiro à Junho por exemplo. Os meses serão inseridos como parâmetros na query através...
  7. Replies
    9
    Views
    2,420

    This is realy important, noone ever used it? ...

    This is realy important, noone ever used it?

    Please, help.
  8. Replies
    3
    Views
    1,352

    Maybe what solve it was OrdinalColumns, you...

    Maybe what solve it was OrdinalColumns, you should be able to map YWD or any date hierarchy...
  9. Replies
    9
    Views
    2,420

    mcampbell, Using this filter i get the last 3...

    mcampbell,

    Using this filter i get the last 3 months. Ok that is fine, but i need to use it has a parameter. My point is to dynamic fill Start Month and End Month for the last 3 years...

    I know...
  10. Replies
    9
    Views
    2,420

    Ok, i have found a good tutorial...

    Ok, i have found a good tutorial http://www.devx.com/codemag/Article/37460

    I have also found an article, Microsoft and some other stuff. I still cant find how can i filter something like:

    Month...
  11. Replies
    3
    Views
    1,352

    Hi, Are this a shared dimension? Place here...

    Hi,

    Are this a shared dimension? Place here the schema Definition for the cube where you use this dimension and the query.
  12. Replies
    3
    Views
    1,381

    More Info would be better... Place the query here

    More Info would be better... Place the query here
  13. Replies
    9
    Views
    2,420

    MDX Documentation

    Hi,

    I am searching for help in MDX language and syntax, but i dont know what am i missing.

    In Mondrian docs (http://mondrian.pentaho.com/documentation/mdx.php) they say the syntax is almost...
  14. Replies
    3
    Views
    1,256

    Hi. Does anyone have this working? If you can...

    Hi.

    Does anyone have this working? If you can run it, then may i can change some settings...

    Thanks
  15. Replies
    28
    Views
    2,886

    Another point that i still cant find an answer......

    Another point that i still cant find an answer...

    How do i consider only distinct members in a Cube? Take Quarters as an sample, how can i filter only 3º Quarter of ANY year?

    AFAIK i need to...
  16. Replies
    28
    Views
    2,886

    mcampbell Thanks, now it works fine. :)

    mcampbell

    Thanks, now it works fine. :)
  17. Replies
    28
    Views
    2,886

    The query now is every query that returns the...

    The query now is every query that returns the "All" Level:

    SELECT
    NON EMPTY {Hierarchize({[Data].[Todos os Periodos]})} ON COLUMNS,
    NON EMPTY {Hierarchize({[Measures].[Valor Despesa]})} ON ROWS...
  18. Replies
    3
    Views
    1,256

    Error CDE And Saiku

    Hi,

    I cant get CDE Dashboard working with SAIKU. Trying to add a new SAIKU by wizard, when add a new or load a query, i got the default error page (inside that box):

    Sorry. We really...
  19. Do you need this automatic? Why you dont just...

    Do you need this automatic?

    Why you dont just add a new Datasource?
  20. Replies
    2
    Views
    1,450

    Maybe i'll need this in future to. Look if...

    Maybe i'll need this in future to.

    Look if this help you: http://ask.analytical-labs.com/questions/1074/schedule-saiku-reports-on-pentaho
    I tried to download, but no file came (just a usefull...
  21. Replies
    28
    Views
    2,886

    I am having this error: (REsult Mondrian...

    I am having this error:

    (REsult Mondrian Error:No function matches signature '{<Level>}')

    If i add ".Members" at the end, it works fine. Isn't it a wrong attribute in def? Is it considering...
  22. Replies
    28
    Views
    2,886

    Ok, I Got TIME working fine on cubes and...

    Ok,

    I Got TIME working fine on cubes and Virtual Cube, even this change making no sense... :)

    Now, Escritorio still wierd. I can only see values when filtered by Nome. Cant see [All Values] for...
  23. Replies
    28
    Views
    2,886

    Looks like i have wrong definition, because if i...

    Looks like i have wrong definition, because if i change the Query i can get the results i want to.

    But i cannot follow this path, i need this automatic tools like Saiku to work .... :(
  24. Replies
    28
    Views
    2,886

    Also, MDX Created by Saiku SELECT NON EMPTY...

    Also, MDX Created by Saiku


    SELECT
    NON EMPTY {Hierarchize({[Data].[Ano].Members})} ON COLUMNS,
    NON EMPTY {Hierarchize({[Escritorio].[Todos Escritorios]})} ON ROWS
    FROM [Desempenho]

    (REsult...
  25. Replies
    28
    Views
    2,886

    I was checking this right now.. Wierd, i can...

    I was checking this right now..

    Wierd, i can see if i make my own MDX, but if i try to explore it in SAIKU it do not work as expected...

    I get no data sometimes, with simple combinations like...
  26. Replies
    28
    Views
    2,886

    I can show By "Nome Escritorio" (Office name) and...

    I can show By "Nome Escritorio" (Office name) and by "Todos os Periodos" (All times).

    But when i go down to Year on Time, or All Offices, it returns "No data".
  27. Replies
    28
    Views
    2,886

    Hello, Yes. Here is the new schema: ...

    Hello,

    Yes. Here is the new schema:



    <Schema name="Schema Desempenho" measuresCaption="Medidas">
    <Dimension type="TimeDimension" visible="true" highCardinality="false" name="Data"...
  28. Replies
    28
    Views
    2,886

    Ok i got it. Working... I can see the values...

    Ok i got it. Working...

    I can see the values from some Dimensions, but not for Data (Time). Levels do not work in this case.

    :(
  29. Replies
    28
    Views
    2,886

    I started now doing this relationship between two...

    I started now doing this relationship between two cubes, and i got to say, i cant find much docs about that... The docs i found are related to another version (older) and i cant reproduce its...
  30. Replies
    28
    Views
    2,886

    I took some time to reply, but your guys were...

    I took some time to reply, but your guys were faster then me. Thats why i get lost here... :D

    mcampbell Ok, that is nice to know that virtual cubes are the best choice. I will check Heisenberg...
  31. Replies
    28
    Views
    2,886

    Nice :) So in pentaho we use Mondrian 4? ...

    Nice :)

    So in pentaho we use Mondrian 4?

    I'll search on this, update here when have news

    Ty
  32. Replies
    28
    Views
    2,886

    Hello Heisenberg. Thanks, so you would not...

    Hello Heisenberg.

    Thanks, so you would not recommend this method? I need to start in some way, which is the best (in performance, easier to create and maintain, etc)?
  33. Replies
    28
    Views
    2,886

    I mean they occour at diferent points in time...

    I mean they occour at diferent points in time (not sync.). I can have 20 cost records and just one Sale at one day.

    They share the same TIME dimension.
  34. Replies
    28
    Views
    2,886

    How to join two Stars

    Ok, so i have a datawarehouse which two fact tables, and some dimensions. Some of this dimensions are shared.

    My point is to analyse two distinct measures to the company: Sales and Costs.

    As...
  35. Does this work on 5.0.1 Community Edition? :)

    Does this work on 5.0.1 Community Edition? :)
  36. Replies
    3
    Views
    4,952

    Hello Gutlez, thanks for reply. The two links...

    Hello Gutlez, thanks for reply.

    The two links goes to the same page (contact). Our company have filled about 4-5 forms in different times, and we got no answer.

    I cant have this pricing list...
  37. Replies
    3
    Views
    4,952

    Buy Pentaho - Pricing

    Hello,

    I have try every menu and option in pentaho's website but i cant find anything that lead me to pricing, or a person who knows it.

    How can i talk to a seller? Do anyone have a directly...
  38. Replies
    2
    Views
    1,602

    Reporting Designer and Mondrian Cubes

    Hello,

    What is possible to do in Reporting designer about Mondrian cubes? Is possible to use it in graphics, charts, and make then interactive?

    I am looking at every free solution for dashboard...
  39. Replies
    0
    Views
    918

    MDX Query Help - Or cube concept?

    In a Mondrian Schema, I have a fact table for Sales, a dimension table Time and a dimension table Client.

    I need to create a Saiku report where i can show How many clients Joined in per year. I...
  40. Replies
    1
    Views
    1,301

    Hi RAB, Does your firewall have a log or...

    Hi RAB,

    Does your firewall have a log or something? You could check there.

    I have seen Pentaho.log file but it do not show any links.
  41. Replies
    7
    Views
    3,289

    By the way, set view too ...

    By the way, set view too

    <data-access-view-roles>Administrator</data-access-view-roles>
  42. Replies
    7
    Views
    3,289

    Fixed. When you find config files asking for a...

    Fixed.

    When you find config files asking for a "Role" for certain access, you should place the "Administrator" role instead of your LDAP role. I was placing "Admin", as in my ldap, but dont work...
  43. Replies
    7
    Views
    3,289

    Anyone? Or do you know how to manually create a...

    Anyone?
    Or do you know how to manually create a DataSource, it would help.
  44. Hello Rafasegovia, For logs i usually check...

    Hello Rafasegovia,

    For logs i usually check for /biserver-ce/tomcat/logs, files Catalina-{date}.log or pentaho.log. If it dont help try to track the other files inside this folder.

    When i get...
  45. Replies
    7
    Views
    3,289

    Thanks mpiatek It fixed "Marketplace" and...

    Thanks mpiatek

    It fixed "Marketplace" and Administrator Options, but i still cant see Datasource menu. Did you fixed it too?
  46. Thread: Using Cubes

    by lucassig
    Replies
    1
    Views
    612

    Ok i Found Marketplace, installed, but i cant use...

    Ok i Found Marketplace, installed, but i cant use it.

    How do i start Saiku? And why i dont see "New" and "Manage Datasource" menus?

    What should i change?
  47. Replies
    7
    Views
    3,289

    There is a doc...

    Hello.

    We have LDAP configured following pentaho docs, it works fine. The only problem i get now is i (Admin) cant see Datasource Manage and Plugins menu.

    The login works just fine...

    ...
  48. Thread: Using Cubes

    by lucassig
    Replies
    1
    Views
    612

    Using Cubes

    Hello,

    I create a cube sample, and now i want to try it in Pentaho interface.

    The problem is that i use LDAP, how can i install some "Cube Viewer", dashboard or etc. from outside of the user...
  49. Replies
    0
    Views
    438

    Adding Datasource - LDAP Settings

    Hello,

    I am using LDAP login in my BI Server 5.0.1, after setting LDAP i notice that "Add Datasource" button is missing.

    We have set the admin Group in LDAP, we can login normaly and we see...
  50. Replies
    4
    Views
    788

    Thanks Lukolap. I'll read those links. I get...

    Thanks Lukolap.

    I'll read those links. I get kind lost in TechNet docs, it looks like a "Javadoc", and it get hard to follow just by looking at methods def... :(
Results 1 to 50 of 75
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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