Добрый день!
Коллеги, можно ли средствами датаборинга выгрузить данные из куба?
То есть не писать опять запрос к витрине как на создание куба да еще со всеми вычисляемыми метриками, а обратиться к кубу напрямую - как к существующей уже вьюхе?
Добрый день, можно таким образом.
[{"id":"17fccbb60d018308","type":"luxmsbi-transfer-data","z":"cbcb13f7578eed1f","name":"","retryCount":1,"retryDelay":5000,"sourceType":"sql","sourceSqlConnIdent":"luxmsbi","sourceSqlQuery":"","sourceXlsFilePath":"","sourceXlsHeaderRow":"","sourceXlsFirstDataRow":"","sourceXlsSheetNumbers":"","sourceXlsStreamProcessing":false,"sourceXlsDropFileOnComplete":false,"sourceCsvFileEncoding":"utf-8","sourceCsvFilePath":"","sourceCsvWithNames":true,"sourceCsvDelimiter":"comma","sourceCsvZipped":false,"sourceCsvDropFileOnComplete":false,"sourceDbfFileEncoding":"utf-8","sourceDbfFilePath":"","sourceDbfDropFileOnComplete":false,"sourceQvdFilePath":"","sourceQvdDropFileOnComplete":false,"sourceAvroFilePath":"","sourceAvroDropFileOnComplete":false,"sourceParquetFilePath":"","sourceParquetDropFileOnComplete":false,"destinationType":"csv","destinationSqlConnIdent":"","destinationSqlSchemaName":"","destinationSqlTableName":"","destinationSqlMode":"truncate","destinationSqlTryToCast":true,"destinationSqlChunkSize":1000,"destinationCsvWithNames":true,"destinationCsvDelimiter":"comma","destinationCsvZipped":false,"allowed":"sql_sql,sql_csv,xls_sql,csv_sql,dbf_sql,qvd_sql,avro_sql,parquet_sql","x":590,"y":1220,"wires":[["45f690fd7afae9d0"]]},{"id":"b83d97ac31215432","type":"inject","z":"cbcb13f7578eed1f","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":160,"y":1220,"wires":[["14daa9ce26789db5"]]},{"id":"45f690fd7afae9d0","type":"debug","z":"cbcb13f7578eed1f","name":"debug 1003","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":770,"y":1220,"wires":[]},{"id":"14daa9ce26789db5","type":"luxmsbi-datagate","z":"cbcb13f7578eed1f","name":"","source":"luxmsbi","chunkSize":"","sqlQuery":"SELECT sql_query\nFROM ds_13.\"_cubes\"\nWHERE id='luxmsbi.custom_2_pro_org'","x":330,"y":1220,"wires":[["6efaf0dfea2c933b"]]},{"id":"6efaf0dfea2c933b","type":"function","z":"cbcb13f7578eed1f","name":"function 47","func":"msg.sourceSqlQuery = msg.payload.sql_query;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":455,"y":1220,"wires":[["17fccbb60d018308"]],"l":false},{"id":"8e1d372a7d3d7b42","type":"comment","z":"cbcb13f7578eed1f","name":"ds_13.\"_cubes\"","info":"","x":340,"y":1160,"wires":[]}]
Добрый день!
А каким образом это можно сгенерить?
Может быть, я недостаточно понятно сформулировала задачу.
Есть витрина в БД mi.
Я могу работать с ней в DBeaver’е, в DataBoring’е .
И где-то(!?) существует описание структуры куба, построенного на этой витрине. По сути - это вьюха.
И я хочу с этим кубом как с вьюхой работать в DataBoring’е .
Возможно ли это - в принципе? прямо сейчас?