two cubes (calculations views) on one application on Business Application Studio?

[kennedydb]

Hi!

Is it possible to create two or more cubes (calculations views) on one application on Business Application Studio?

[jan_zwickel]

Hi David,

the error is independent of whether you deploy two Calculation Views or not. Rather something is wrong with your Calculation View definition. The error message above suggests:

"semanticQuery doesn't support the lob datatype of attribute ItemNumber"

In a sense this is indeed a consequence of using type "Cube" instead of "Dimension" but it is because lobs are not supported in Calculation Views of type "Cube".

Best,

Jan

[jan_zwickel]

Hi David,

not sure about the background of your question but you can create multiple calculation views of category "Cube" in one folder.

Best,
Jan

[kennedydb]

Every time that I try to deploy two calculations view type cube on the same database project I got an error.

For instance, I got a calculation view called FACI and another one called BOMS that are constructed using synonyms from different tables located on the same Schema on SAP Hana. I use one HDI container and a single user-provided service. And I got the following error when I deploy the project.

Error: com.sap.hana.di.calculationview: Database error 2048: column store error: fail to create scenario: [34011] Inconsistent calculation model;calculationNode (finalNode) -> operation (SemanticQueryOp): semanticQuery doesn't support the lob datatype of attribute ItemNumber,Structured Details: <?xml version="1.0" encoding="utf-8"?><createCalculationScenario version="1"><status><message>Inconsistent calculation model</message><errorCode>34011</errorCode></status><details><errors><detail><calculationNode name="finalNode"><operation name="SemanticQueryOp"><message>semanticQuery doesn't support the lob datatype of attribute ItemNumber</message></operation></calculationNode></detail><detail><calculationNode name="finalNode"><operation name="SemanticQueryOp"><message>semanticQuery doesn't support the lob datatype of attribute FacilityName</message></operation></calculationNode></detail><detail><calculationNode name="finalNode"><operation name="SemanticQueryOp"><message>semanticQuery doesn't support the lob datatype of attribute DieCode</message></operation></calculationNode></detail></errors><warnings><detail><scenario><message details="cubeSchema">Default language not set. Use 'en'</message></scenario></detail></warnings></details></createCalculationScenario> [8201003] at "src/FACI.hdbcalculationview" (0:0) Warning: Worker 0 running the "com.sap.hana.di.calculationview" plugin has encountered an error while deploying 1 objects [8212030] Error: Worker 0 has encountered an error; all remaining jobs will be canceled [8214600] Error: Processing work list... failed [8212102] Make failed (4 errors, 1 warnings): tried to deploy 1 files, undeploy 0 files, redeploy 0 dependent files Error: Making... failed [8211605] Error: Starting make in the container "BOM_1" with 1 files to deploy, 0 files to undeploy... failed [8214168] Deployment to container BOM_1 failed - error: HDI make failed [Deployment ID: none]. Error: HDI make failed (1s 860ms) npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! deploy@ start: `node node_modules/@sap/hdi-deploy/deploy.js "--exit"` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the deploy@ start script. npm ERR! This is probably not a problem with npm. There is likely additional logging output above. Terminal will be reused by tasks. npm ERR! A complete log of this run can be found in: npm ERR! /home/user/.npm/_logs/2021-02-02T20_56_11_565Z-debug.log