Share

OpenI: BI Web App for SaaS Deployments

Code

Programming Languages: Java, JSP

License: GNU General Public License (GPL)

Repositories

browse code, statistics, last commit on 2009-11-09 svn co https://openi.svn.sourceforge.net/svnroot/openi openi

browse code, statistics cvs -d:pserver:anonymous@openi.cvs.sourceforge.net:/cvsroot/openi login

cvs -z3 -d:pserver:anonymous@openi.cvs.sourceforge.net:/cvsroot/openi co -P modulename

Show:

What's happening?

  • explore data page is unable to load all the charts

    Sometimes only few out of chart widgets which are supposed to be loaded on clicking 'explore' button on Explore Data Page get loaded and rest fail to load. There is no way to provide the informations to the users about the reason behind this. So It is better to show loading indicator on each chart widget until the corresponding chart gets loaded and show the exception message or appropriate...

    2009-11-19 16:45:44 UTC by mkhasu

  • Followup: RE: Multiple levels in schema

    OK, i got it : the problem lies in the utilisation of the "ordinalColumn" option in the mondrian schema xml file. When using the primarykey of the dimension table as the key for ordinal ordering, things are messed up on the "filter" part of OpenI, though OK on the column or row part. Suppressing that option suppressed the displaying weirdness I had. I don't know if this has to do with...

    2009-11-19 13:04:38 UTC by noblomov

  • Followup: RE: Hide Properties

    See if saving an analysis in a view-only mode works for you.

    2009-11-18 21:57:59 UTC by sandeep_giri

  • Followup: RE: Private information display

    Interesting idea, but no straightforward way to do that in OpenI today (aside for writing customization code) We did add a feature to create view-only analyses where the user gets a "canned view" of OLAP cube data that they can't further modify (drill up/down, add filter, etc.) -- maybe that could be a workaround for you The better solution is to add the user context to the MDX query that...

    2009-11-18 21:57:22 UTC by sandeep_giri

  • Hide Properties

    Anyone knows how do you hide analysis properties tabs? I don't want to allow users to see/modify MDX/SQL as they can directly inject SQL that may lead to cube restriction bypass and potentially to damage of the DB information. But I would like to still keep the Chart properties tab available. Regards, Juan Carlos.

    2009-11-18 20:48:25 UTC by johnccr

  • Private information display

    Hello I don't know if this is possible to do, so that is why I ma asking, I have a Cube or RDBM table with private information (a user can only see her/his own information) is there a way to enforce this in Mondrian/Openi? maybe including a user id as part of the query automatically? Regards, Juan Carlos.

    2009-11-18 20:41:35 UTC by johnccr

  • Percentile calculations

    Hi all, Been thinking if I can directly calculate the 95th percentile using mondrian's percentile function? I tried certain tests, but do not get the most accurate of results. Has anybody tried this? Nadia.

    2009-11-18 15:20:35 UTC by naaziz

  • Followup: RE: export multiple analysis in same Excel File

    Thanks Sandeep. As of now, havent got an idea for this, but if i do, will put it up here. Nadia.

    2009-11-18 15:18:13 UTC by naaziz

  • Followup: RE: Multiple levels in schema

    I'm using mondrian. As I've seen that you use it in the demo, I just wanted to see the schema xml file to try to understand how to set it right. Meanwhile, I'm looking at mondrian resources to learn how to do it, but without success up to know. Thanks for your help... N.

    2009-11-18 09:44:32 UTC by noblomov

  • Followup: RE: Multiple levels in schema

    Unless I'm missing something .. these hierarchies are defined in the OLAP cube. So depending upon whether you are using Mondrian or Microsoft Analysis Services, you will need to consult the resources on those specific tools to build similar hierarchies.

    2009-11-17 20:30:11 UTC by sandeep_giri