1、查询出目前系统拥有的Datasources和Connections放入内存中

2、比对saiku-datasources中的ds是否有新增的，如果有，创建新的ds

1、查询OLAP数据连接(cubesConnectionList)列表

http://localhost:8080/saiku/rest/saiku/a1/discover

OlapDiscoverResource - getConnections()

2、根据单个 connection 解析出 catalog schema cube【SessionWorkspace.js】

var connection = this.connections[i];

var catalog = connection.catalogs[j];

var schema = catalog.schemas[k];

var cube = schema.cubes[l];

3、拼凑成交互ID - key 根据这个ID去 new Cube({ key: key })【SessionWorkspace.js】

var key = connection.name + "/" + catalog.name + "/" + ((schema.name === "" || schema.name === null) ? "null" : schema.name) + "/" + encodeURIComponent(cube.name);

至此就完成了获取connections的操作

http://localhost:8080/saiku/rest/saiku/api/repository?type=saiku,sdb

BasicRepositoryResource2 - getRepository()

返回的 repositoryList 如下：

ID                            NAME            TYPE        ACL

#/datasources                datasources        FOLDER        [READ, WRITE]

#/etc                        etc                FOLDER        [READ, WRITE]

#/etc/legacyreports          legacyreports      FOLDER        [READ, WRITE]

#/etc/theme                  theme              FOLDER        [READ, WRITE]

#/etc/theme/legacyreports    legacyreports      FOLDER        [READ, WRITE]

#/homes                      homes              FOLDER        [READ]

#/homes/home:a1              home:a1            FOLDER        [READ, WRITE, GRANT] 

http://localhost:8080/saiku/rest/saiku/api/license

查询思路剖析：

通过第二步可知已经得到了connection的信息和拼凑了key[交互ID]

执行 new Cube({key:key}) 调用接口获取Cube内容

前端请求url ：

Saiku.session.username + "/discover/" + args.key + "/metadata";

后端处理的方法：

OlapDiscoverResource - getMetadata()

后端rest接口所需参数 ：

@Path("/saiku/{username}/discover") + @Path("/{connection}/{catalog}/{schema}/{cube}/metadata") + key参数

调用成功后返回的Model：

SaikuCubeMetadata

    |-dimensions

    |-measures

    |-properties

附后台处理代码：

@GET

@Produces({"application/json" })

@Path("/{connection}/{catalog}/{schema}/{cube}/metadata")

 public SaikuCubeMetadata getMetadata(

         @PathParam("connection") String connectionName,

         @PathParam("catalog") String catalogName,

         @PathParam("schema") String schemaName,

         @PathParam("cube") String cubeName)

{

    if ("null".equals(schemaName)) {

        schemaName = "";

    }

    //获取Cube

    SaikuCube cube = new SaikuCube(connectionName, cubeName,cubeName,cubeName, catalogName, schemaName);

    try {

        //根据Cube获取 dimensions/measures/properties

        List<SaikuDimension> dimensions = olapDiscoverService.getAllDimensions(cube);

        List<SaikuMember> measures = olapDiscoverService.getMeasures(cube);

        Map<String, Object> properties = olapDiscoverService.getProperties(cube);

        return new SaikuCubeMetadata(dimensions, measures, properties);

    } catch (Exception e) {

        log.error(this.getClass().getName(),e);

    }

    return new SaikuCubeMetadata(null, null, null);

}

获取到的DEMO中的所有CUBE如下

参数分别是：

{connectionName}

{catalogName}

{schemaName}

{cubeName}

(1)Earthquakes

/earthquakes

/Global%20Earthquakes

/Global%20Earthquakes

/Earthquakes

http://localhost:8080/saiku/rest/saiku/a1/discover/earthquakes/Global%20Earthquakes/Global%20Earthquakes/Earthquakes/metadata?key=earthquakes%2FGlobal+Earthquakes%2FGlobal+Earthquakes%2FEarthquakes

(2)HR

/foodmart

/FoodMart

/FoodMart

/HR

http://localhost:8080/saiku/rest/saiku/a1/discover/foodmart/FoodMart/FoodMart/HR/metadata?key=foodmart%2FFoodMart%2FFoodMart%2FHR

(3)Sales

/foodmart

/FoodMart

/FoodMart

/Sales

http://localhost:8080/saiku/rest/saiku/a1/discover/foodmart/FoodMart/FoodMart/Sales/metadata?key=foodmart%2FFoodMart%2FFoodMart%2FSales

(4)Sales%202

/foodmart

/FoodMart

/FoodMart

/Sales%202

http://localhost:8080/saiku/rest/saiku/a1/discover/foodmart/FoodMart/FoodMart/Sales%202/metadata?key=foodmart%2FFoodMart%2FFoodMart%2FSales%25202

(5)Sales%202

/foodmart

/FoodMart

/FoodMart

/Store

http://localhost:8080/saiku/rest/saiku/a1/discover/foodmart/FoodMart/FoodMart/Store/metadata?key=foodmart%2FFoodMart%2FFoodMart%2FStore

(6)Warehouse

/foodmart

/FoodMart

/FoodMart

/Warehouse

http://localhost:8080/saiku/rest/saiku/a1/discover/foodmart/FoodMart/FoodMart/Warehouse/metadata?key=foodmart%2FFoodMart%2FFoodMart%2FWarehouse

(7)Warehouse%20and%20Sales

/foodmart

/FoodMart

/FoodMart

/Warehouse%20and%20Sales

http://localhost:8080/saiku/rest/saiku/a1/discover/foodmart/FoodMart/FoodMart/Warehouse%20and%20Sales/metadata?key=foodmart%2FFoodMart%2FFoodMart%2FWarehouse%2520and%2520Sales