Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Accepted answer
61
Views
8
Comments
Laura Bachiller
Laura Bachiller Rank 2 - Community Beginner
edited Jul 17, 2024 6:34AM in Oracle Analytics Cloud and Server

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:

image.png image.png

Best Answers

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod
    Answer ✓

    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
    Gianni Ceresa Mod
    Answer ✓

    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.

Answers

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    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
    Gianni Ceresa Mod

    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
    Laura Bachiller Rank 2 - Community Beginner

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

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    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
    Laura Bachiller Rank 2 - Community Beginner

    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
    Laura Bachiller Rank 2 - Community Beginner

    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);