Oracle Communities

Oracle Analytics and AI

Child Item

Issue with Spanish Tags in JSON File Generated by Management Tool for Semantic Model Deployment

Good morning,

I am having an issue with the new "Semantic Model" functionality. After importing the generated repository from the management tool, I encounter errors when deploying it. Upon reviewing the JSON, I notice that the repository generated from the management tool contains some tags in Spanish that the semantic model does not recognize. If I change them directly in the SMML editor, it allows me to deploy it. Has anyone else experienced this? Is there a way to fix it configuratively without manually modifying the entire repository?

Here is an excerpt from the file generated by the management tool and how it should look in the semantic model:

Find more posts tagged with

Accepted answers

Federico Venturin - Oracle

Hi @User_HGRRZ ,

I'd raise a SR since it looks like a bug.

In the meantime, you could try setting your browser locale to English rather than Spanish (and eventually do the same in your Profile section).

Gianni Ceresa

Thanks for confirming.

I thought that maybe there was some other tool involved generating models, but you are just doing everything right and therefore you face a bug in the tool.

You probably already raised a SR as said above as that's the only way to get a fix.

All comments

Federico Venturin - Oracle

Hi @User_HGRRZ ,

I'd raise a SR since it looks like a bug.

In the meantime, you could try setting your browser locale to English rather than Spanish (and eventually do the same in your Profile section).

[Deleted User]

Hello @User_HGRRZ

Welcomed to the community, please update your profile, so we know with whom we are communicating with.

Please raise the SR as mentioned by Federico. I've informed Product Management already about this. If you post the SR number in here once you've created it I can send that to them as well to get more visibility on it.

Thanks

Gianni Ceresa

Hi @User_HGRRZ ,

After importing the generated repository from the management tool

What do you mean with repository generated by the management tool? What kind of tool does generate a repository for you?

Do you mean the Model Administration Tool (the good old fat client) where you build a RPD? Or it this some other kind of tool generating a repository?

Laura Bachiller

Yes, I am referring to the Model Administration tool (client)

Gianni Ceresa

Thanks for confirming.

I thought that maybe there was some other tool involved generating models, but you are just doing everything right and therefore you face a bug in the tool.

You probably already raised a SR as said above as that's the only way to get a fix.

[Deleted User]

Just to check something while you're raising an SR:

Can you go to your Admin Tool (Model Administration Tool), go to the Business Model layer, go to the dimension "Activos", press Ctrl+C, and then Ctrl+V your whole clipboard int Notepad?

I'd like to see the exact UDML from the real admin tool.

Laura Bachiller

This is the UDML:

DECLARE DIMENSION "OCUIA"."ActivosDim" AS "ActivosDim" ON
(
"OCUIA"."ActivosDim"."Activos Total" ) DEFAULT ROOT "OCUIA"."ActivosDim"."Activos Total"
PRIVILEGES ( READ);
DECLARE LEVEL "OCUIA"."ActivosDim"."Activos Detail" AS "Activos Detail"
HAVING (
"OCUIA"."Activos"."Activo",
"OCUIA"."Activos"."Id. Activo",
"OCUIA"."Activos"."Hostname",
"OCUIA"."Activos"."ID",
"OCUIA"."Activos"."Tiempo restauración (min)",
"OCUIA"."Activos"."Prioridad",
"OCUIA"."Activos"."Sede",
"OCUIA"."Activos"."Sede Elemento ID",
"OCUIA"."Activos"."Service",
"OCUIA"."Activos"."Tipo Activo" ) FULL DRILL UP COVERAGE
PARENTS (
"OCUIA"."ActivosDim"."Activos Total" DEFAULT )
CONSTANT {Activos Detail}
MEMBER COUNT 20
PRIVILEGES ( READ);
DECLARE LOGICAL KEY "OCUIA"."ActivosDim"."Activos Detail"."Activos Detail_Key1" AS "Activos Detail_Key1" HAVING
(
"OCUIA"."Activos"."Activo" ) PRIMARY KEY
PRIVILEGES ( READ);
DECLARE LEVEL "OCUIA"."ActivosDim"."Activos Total" AS "Activos Total" GRAND TOTAL ALIAS FULL DRILL UP COVERAGE
CONSTANT {Activos Total}
PRIVILEGES ( READ);

Laura Bachiller

And the logical table:

DECLARE LOGICAL TABLE "OCUIA"."Activos" AS "Activos"
KEYS (
"OCUIA"."Activos"."Activos_Key1" )
SOURCES (
"OCUIA"."Activos"."TLK_ACTIVOS" ) NO INTERSECTION ATTRIBUTES
(
"OCUIA"."Activos"."Activo",
"OCUIA"."Activos"."Id. Activo",
"OCUIA"."Activos"."Hostname",
"OCUIA"."Activos"."ID",
"OCUIA"."Activos"."Tiempo restauración (min)",
"OCUIA"."Activos"."Prioridad",
"OCUIA"."Activos"."Sede",
"OCUIA"."Activos"."Sede Elemento ID",
"OCUIA"."Activos"."Service",
"OCUIA"."Activos"."Tipo Activo" )
PRIVILEGES ( READ);
DECLARE ATTRIBUTE "OCUIA"."Activos"."Activo" AS "Activo" ATTRIBUTE MAP EXPRESSION {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."ACTIVO"}
PRIVILEGES ( READ);
DECLARE ATTRIBUTE "OCUIA"."Activos"."Id. Activo" AS "Id. Activo" ATTRIBUTE MAP EXPRESSION {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."ACTIVO_ID"}
PRIVILEGES ( READ);
DECLARE ATTRIBUTE "OCUIA"."Activos"."Hostname" AS "Hostname" ATTRIBUTE MAP EXPRESSION {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."HOSTNAME"}
PRIVILEGES ( READ);
DECLARE ATTRIBUTE "OCUIA"."Activos"."ID" AS "ID" ATTRIBUTE MAP EXPRESSION {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."ID"}
PRIVILEGES ( READ);
DECLARE ATTRIBUTE "OCUIA"."Activos"."Tiempo restauración (min)" AS "Tiempo restauración (min)" ATTRIBUTE MAP EXPRESSION {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."MIN_REST"}
PRIVILEGES ( READ);
DECLARE ATTRIBUTE "OCUIA"."Activos"."Prioridad" AS "Prioridad" ATTRIBUTE MAP EXPRESSION {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."PRIORIDAD"}
PRIVILEGES ( READ);
DECLARE ATTRIBUTE "OCUIA"."Activos"."Sede" AS "Sede" ATTRIBUTE MAP EXPRESSION {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."SEDE"}
PRIVILEGES ( READ);
DECLARE ATTRIBUTE "OCUIA"."Activos"."Sede Elemento ID" AS "Sede Elemento ID" ATTRIBUTE MAP EXPRESSION {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."SEDE_ELEMENTO_ID"}
PRIVILEGES ( READ);
DECLARE ATTRIBUTE "OCUIA"."Activos"."Service" AS "Service" ATTRIBUTE MAP EXPRESSION {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."SERVICE"}
PRIVILEGES ( READ);
DECLARE ATTRIBUTE "OCUIA"."Activos"."Tipo Activo" AS "Tipo Activo" ATTRIBUTE MAP EXPRESSION {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."TIPOACTIVO"}
PRIVILEGES ( READ);
DECLARE LOGICAL KEY "OCUIA"."Activos"."Activos_Key1" AS "Activos_Key1" HAVING
(
"OCUIA"."Activos"."Activo" ) PRIMARY KEY NOT USABLE FOR DRILLDOWN
PRIVILEGES ( READ);
DECLARE LOGICAL TABLE SOURCE "OCUIA"."Activos"."TLK_ACTIVOS" AS "TLK_ACTIVOS"
PROJECT (
{"OCUIA"."Activos"."Activo"} AS {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."ACTIVO"} ,
{"OCUIA"."Activos"."Id. Activo"} AS {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."ACTIVO_ID"} ,
{"OCUIA"."Activos"."Hostname"} AS {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."HOSTNAME"} ,
{"OCUIA"."Activos"."ID"} AS {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."ID"} ,
{"OCUIA"."Activos"."Tiempo restauración (min)"} AS {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."MIN_REST"} ,
{"OCUIA"."Activos"."Prioridad"} AS {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."PRIORIDAD"} ,
{"OCUIA"."Activos"."Sede"} AS {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."SEDE"} ,
{"OCUIA"."Activos"."Sede Elemento ID"} AS {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."SEDE_ELEMENTO_ID"} ,
{"OCUIA"."Activos"."Service"} AS {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."SERVICE"} ,
{"OCUIA"."Activos"."Tipo Activo"} AS {"DW_JIRA_LE".""."OCUIA"."TLK_ACTIVOS"."TIPOACTIVO"} )
FROM
(
( "DW_JIRA_LE".."OCUIA"."TLK_ACTIVOS")) CAN NOT COMBINE
AGGREGATE CONTENT { GROUPBYLEVEL("OCUIA"."ActivosDim"."Activos Detail")}
ALLOW NOT MAPPED TABLE
PRIVILEGES ( READ);
DECLARE LOGICAL SOURCE FOLDER "OCUIA"."Activos"."Sources" AS "Sources"
PRIVILEGES ( READ);