Examples of org.pentaho.platform.plugin.action.olap.IOlapService

Package org.pentaho.platform.plugin.action.olap

Examples of org.pentaho.platform.plugin.action.olap.IOlapService

org.pentaho.platform.plugin.action.olap.IOlapService
This service manages the hosted OLAP connections, implemented with Mondrian, as well as other generic olap4j connections.
There are two types of connections that you can create. Either
- Hosted locally by the local Mondrian server instance
- Hosted by some other OLAP server and configured as a generic olap4j connection.
Whether hosted or generic, the OLAP connections must not share the same name.
To create a hosted connection, you must use the method {@link #addHostedCatalog(String,String,InputStream,boolean,IPentahoSession)}. The InputStream parameter must be pointing to a Mondrian schema file.
When a hosted connection is added, the service will also attempt to use the IConnectionUserRoleMapper, if one is configured.
To create a generic connection, use the method {@link #addOlap4jCatalog(String,String,String,String,String,Properties,boolean,IPentahoSession)}. The parameters are the standard ones used by JDBC and will be passed to the java.sql.DriverManager as-is.
To obtain a list of the configured catalogs, there are a few options. Calling {@link #getCatalogNames(IPentahoSession)} is the cheap and fast method.It will return a list of the catalog names available. For more metadata, one can use {@link #getCatalogs(IPentahoSession)}, {@link #getSchemas(String,IPentahoSession)}or {@link #getCubes(String,String,IPentahoSession)}. These alternative methods come at a higher price, since we will need to activate each of the configured connections to populate the metadata.
Throughout the API, it is possible to pass a user's session. In that case, only the catalogs which are accessible to the specified user will be available. Passing 'null' as the sesison has the effect of granting root access and will allow access to all catalogs.

        // Flush the catalog helper (legacy)
        IMondrianCatalogService mondrianCatalogService =
            PentahoSystem.get( IMondrianCatalogService.class, "IMondrianCatalogService", pentahoSession ); //$NON-NLS-1$
        mondrianCatalogService.reInit( pentahoSession );
        // Flush the IOlapService
        IOlapService olapService =
          PentahoSystem.get( IOlapService.class, "IOlapService", pentahoSession ); //$NON-NLS-1$
        olapService.flushAll( pentahoSession );
      }
      return Response.ok().type( MediaType.TEXT_PLAIN ).build();
    } else {
      return Response.status( UNAUTHORIZED ).build();
    }

View Full Code Here

          PentahoSystem.get( IMondrianCatalogService.class, "IMondrianCatalogService", PentahoSessionHolder
              .getSession() );
      mondrianCatalogService.reInit( PentahoSessionHolder.getSession() );


      // Flush the IOlapService
      IOlapService olapService =
          PentahoSystem.get( IOlapService.class, "IOlapService", PentahoSessionHolder.getSession() ); //$NON-NLS-1$
      olapService.flushAll( PentahoSessionHolder.getSession() );


    } catch ( PentahoAccessControlException e ) {
      return Response.serverError().entity( e.toString() ).build();
    } catch ( Exception e ) {
      return Response.serverError().entity( e.toString() ).build();

View Full Code Here

        }
      }
    }


    // Check with the IOlapService and try to get a list of roles there.
    IOlapService olapService = PentahoSystem.get( IOlapService.class );
    if ( olapService != null ) {
      MondrianCatalogRepositoryHelper helper =
          new MondrianCatalogRepositoryHelper( PentahoSystem.get( IUnifiedRepository.class ) );
      String serverName = null;
      for ( String name : helper.getOlap4jServers() ) {
        PropertyList props = Util.parseConnectString( helper.getOlap4jServerInfo( name ).URL );
        if ( props.get( RolapConnectionProperties.Catalog.name(), "" ).equals( context ) ) {
          serverName = name;
        }
      }
      if ( serverName != null ) {
        OlapConnection conn = null;
        try {
          // Use a null session for root access.
          conn = olapService.getConnection( serverName, null );
          List<String> roleList = conn.getAvailableRoleNames();
          String[] roleArray = roleList.toArray( new String[roleList.size()] );
          Arrays.sort( roleArray );
          return roleArray;
        } catch ( OlapException e ) {

View Full Code Here

TOP

Related Classes of org.pentaho.platform.plugin.action.olap.IOlapService

org.pentaho.platform.plugin.action.mondrian.mapper.MondrianAbstractPlatformUserRoleMapper

org.pentaho.platform.web.http.api.resources.RepositoryImportResource

org.pentaho.platform.web.http.api.resources.SystemRefreshResource

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.