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

Search Forums:

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

Search Forums: Search took 0.08 seconds.

  1. Real Time BI - Possible with Mondrian?

    Hi folks,

    we have the following requirement:

    Changes done in a productive system should be mirrored to the analytic system asap. For example: A user creates a report for last month and figures...
  2. Replies
    1
    Views
    89

    On a linux system you might use cron, on windows...

    On a linux system you might use cron, on windows the task scheduler. Take a look at Kitchen and Pan!
  3. Replies
    7
    Views
    1,243

    Hi! Let me guess, you only get the the ALL...

    Hi!

    Let me guess, you only get the the ALL Level for a fact if you use a dimension which is not linked to the fact table, right?
    To get rid of the problem google for the "ValidMeasure()" function...
  4. Hello! Had the same problem but found a...

    Hello!

    Had the same problem but found a workaround.
    Use the Properties() function to get the Captions! The Captions() function is also able to get the System Properties (like CAPTION, KEY, NAME,...
  5. Sounds comprehensible to me! Only thing I feared...

    Sounds comprehensible to me! Only thing I feared was the initialization of the cube. I read something like Mondrian would do a distinct count on the Dimension Members, what would be overkill for 4...
  6. Problem solved

    mcampbell, thanks for the additional explanation. In fact, ValidMeasure() was exactly what I needed! Now it works as expected, even though I don't understand it completely :p
  7. The All-Level works fine, even without...

    The All-Level works fine, even without ValidMeasure or IgnoreUnrelatedDimensions...
    But this does not help me at all ^^

    My Measure 1 is an Operational Parameter, saying the time a machine run....
  8. Calculated Member by partly shared Dimension

    Hello folks.

    Assume I have a calculated Member in a virtual Cube which consists of two virtual Measures. The two virtual Measures come from two different cubes. These cubes have a time dimension...
  9. Hi! This makes no sense due to several...

    Hi!

    This makes no sense due to several reasons:



    Actually I have ~ 35 Indicators what would lead to 50031545098999707 possible combinations ;) Therefor I modeled the indicators as facts so...
  10. Thanks for your answer mcampbell, now I know it's...

    Thanks for your answer mcampbell, now I know it's not my limited knowledge which is the problem. ;)

    Maybe you can help me with another question. I have a fact table which represents events and...
  11. Replies
    7
    Views
    365

    Hello, the book "Mondrian in Action" mostly...

    Hello,

    the book "Mondrian in Action" mostly describes methods for Mondrian 4.0, which has not been released now. The Attribute-Elements are introduced in Mondrian 4.0 and are afaik not available...
  12. Replies
    7
    Views
    1,111

    Hello, if your queries run fast enough without...

    Hello,

    if your queries run fast enough without the cache, disableing it is the easiest solution.
    Else, follow JulieNL's way. Built something that uses the Cache-Control Api and trigger it from...
  13. Dimension with non hierarchic Levels/Members

    Hi folks,

    suppose you have a dimension like Car. Some properties of a car can be arranged hieratchical, eg:

    DIM_CAR:

    Hierarchy (default)

    Brand
    Series
  14. Replies
    1
    Views
    270

    Hi sqlman. I started last year with BI, so...

    Hi sqlman.

    I started last year with BI, so maybe I can help you :)



    Be clear, what are your requirements. What do you want to do? Reporting, Dashboards, Self-Service-Bi?
    Get a deep...
  15. Replies
    0
    Views
    274

    How to benefit from Mondrian Cache

    Hi folks,

    it's quite hard to gather consitent information about how Mondrian, or especially the BI Server 4.8 makes use of the Mondrian Cache.
    My assumption was, that for every MDX Query I do, no...
  16. Hi, of course it is a shared Dimension. I...

    Hi,

    of course it is a shared Dimension.
    I changed the following things which made the cube work:

    - I changed from DayOfMonth to DayOfWeek in the Year, Week, Day Dimension
    - I deleted the...
  17. Problems with Schema for Time-Dimension

    Hi folks,

    I used to work with a time-dimension which looks like this:



    <Dimension type="TimeDimension" visible="true" highCardinality="false" name="DateTime">
    <Hierarchy name="YMD"...
  18. Replies
    28
    Views
    1,389

    No! Sorry for the confusion. Pentaho (4.8)...

    No! Sorry for the confusion. Pentaho (4.8) includes Mondrian 3.5.0 by default. See mcampell's post...
  19. Replies
    28
    Views
    1,389

    Actually I solved this problem once, far in the...

    Actually I solved this problem once, far in the past by using a Virtual Cube I think.
    But I just found this in the Book "Mondrian in Action":


    So maybe "Measure Groups" is your and mine new...
  20. Replies
    28
    Views
    1,389

    Until yesterday I was sure that this is quite...

    Until yesterday I was sure that this is quite simple by creating a Virtual-Cube (which contains all dimension and measures). But I have my problems with this requirement too (see my Thread...
  21. Replies
    2
    Views
    475

    I can view FACT_A and FACT_B while using the...

    I can view FACT_A and FACT_B while using the shared Dimensions (Time and Dimension1), but when I add a level from DIMENSION_B (or A), FACT_A (or B) returns no Data.
  22. Replies
    2
    Views
    475

    Problems with Cross-Join

    Hi folks,

    I have defined a Schema which looks like this:



    Time Dimension (Shared)
    Dimension1 (Shared)
    Cube A
  23. Replies
    2
    Views
    509

    So, big thanks go to pstoellberger from ##pentaho...

    So, big thanks go to pstoellberger from ##pentaho IRC! I copied the "mondrian-TRUNK-SNAPSHOT.jar" from pentaho-solutions\system\saiku\lib to tomcat\webapps\pentaho\WEB-INF\lib and deleted the...
  24. Replies
    2
    Views
    509

    I just replaced mondrian-3.5.0.jar by...

    I just replaced mondrian-3.5.0.jar by mondrian-3.5.4.jar, sadly with no effect.
    This error really starts to annoy me since it makes no sense at all that I get this error while using CDA but at the...
  25. Replies
    2
    Views
    509

    ClassCastException while using CDA

    Dear folks,

    I'm facing a strange issue whilst using CDA with pentaho-bi-ce 4.8.0 and cda 13.09.10.

    My CDA-File looks like this:


    <?xml version="1.0" encoding="utf-8"?>
    <CDADescriptor>
  26. Replies
    3
    Views
    4,507

    First I want to thank dudinatrix for that post, I...

    First I want to thank dudinatrix for that post, I managed using Multivalue Parameterlists in my report now.
    I think my question is similar to the one of nirmal:
    I want to reference the saleTypes in...
  27. Hi folks! I'm still not sure about the...

    Hi folks!

    I'm still not sure about the licensing thing but I found the following paragraph at wikipedia:

    Source:...
  28. You should read about web-sessions...

    You should read about web-sessions and cookies to understand the principles of how logging into a website works technically on the client's side.
    What you try to acchive, if I understand you...
  29. Not sure what you want to do? Your .NET...

    Not sure what you want to do?
    Your .NET environment has nothing to do with your browser. So even if your .NET Program successfully authenticated itself to the BI-Server, that has nothing todo with...
  30. Using Pentaho BI-Server In Closed-Source Project

    Hi folks!

    I'm confused by all the different information I found in the internet about the usage of GPL'ed software in Closed-Source software.

    The scenario:
    We want to use the BI-Server for...
  31. Just saw that CDA 12.09.05...

    Just saw that CDA 12.09.05 should support usage of Excel Templates. I think this would be the way to go but I can't find any documentation :(

    EDIT: So pedrovale from pentaho IRC chat could help me...
  32. Configurable Excel Output - Best Practice?

    Hello Community!

    I want to be able to export the result of a MDX query as a Excel sheet. I know how to do with CDA and also with a Pentaho Report Viewer.
    But I want to be able to configure the...
  33. Replies
    7
    Views
    1,243

    pstoellberger helped me out in the pentaho IRC...

    pstoellberger helped me out in the pentaho IRC chat.
    The problem was, that the "name" attributes of the dimension usages were not the same as the actual dimension names and the virtual dimension...
  34. Replies
    7
    Views
    1,243

    Hello mcampbell, thanks for your reply. I...

    Hello mcampbell,

    thanks for your reply. I looked at the example and it could help me a bit.
    But now I have the problem that only some combinations of facts and dimensions return values :confused:...
  35. Replies
    7
    Views
    1,243

    How to combine / join Cube Facts

    Hello Community.

    I have three cubes. Two of them share three dimensions (one of them a Date Dimension), the third one only shares two (one of them a Date Dimension) with the other ones.
    The cubes...
  36. Thank you very much for the hint, didn't find it...

    Thank you very much for the hint, didn't find it before on google... Will try it right now

    EDIT: Nice, .NET Exception while updating... Oh god why :mad:
    EDIT2: Installed Fresh Server, runs like...
  37. No, since it's a local installation and my hdd's...

    No, since it's a local installation and my hdd's are far from being full I can exclude that as a reason.

    EDIT: I'm quite sure it has something todo with deadlocks. It only appears if I use Table...
  38. Hello! The error persists. I also get it...

    Hello!

    The error persists.
    I also get it doing less complex table outputs.
    I checked the MySQL logs but nothing to do there.

    I worked around the problem in writing the Output, which is my...
  39. ETL Transformation fails with ERROR -1 from storage engine

    Hello!

    I'm trying to transform a denormalized table with about 600.000 records into a star schema with several lookup/update steps and a table output step for the fact table.
    When I check "Use...
  40. Thanks guys, I made it with the sort/group by...

    Thanks guys, I made it with the sort/group by steps :)
  41. How to aggregate and transform textual fields

    Hello!

    I have a table like this:



    ID

    Identifier
  42. Transform multiple, independant tables into a star schema

    Hello all!

    I have a problem which I will describe via an example. Lets assume we have four source data tables like this:
    10653

    We want to use BI on this data to answer the following questions:...
Results 1 to 42 of 42