Oracle Analytics Publisher

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

Categories

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

How to edit the sales order Report data model

Received Response
219
Views
9
Comments
Syed_Ibrahim
Syed_Ibrahim Rank 1 - Community Starter
in Oracle Analytics Publisher

I want to add new columns in the sales order print dala model. But I found out that the data model is not in sql but in XML format. When I downloaded the file it is in .xmdz file extension, which not opening in readable or editiable mode. Please help me in finding a way to add new columns in the data model of sales order report data model.

Path to find the data model - Shared folder → Supply Chain management → Order Managment → sales Order → Data Model.

Regards,

Syed

Answers

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    You can simply login to the catalog and edit the DM directly.

    Downloaded files of type .xdmz can be unizipped and the contents can be viewed.

    Rgds,

    Kevin

  • Dinesh Kumar R
    Dinesh Kumar R Rank 1 - Community Starter
    edited Aug 23, 2024 1:13PM

    Hi Kevin,

    How to edit XML data set? Please tell hoe to download file?

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    Login to /xmlpserver.

    Go to the catalog, select the data model, More→Download.

    Kevin

  • saurabh.dixit
    saurabh.dixit Rank 1 - Community Starter

    We have a similar need to customize SO report. We downloaded xdmz file and unzipped it. It contains xml, xdm, xlf & meta files.

    How do we use them to create a SQL data model?

  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    Easiest method is to select customize for the data model and then edit the SQL data set.

    Rgds,

    Kevin

  • Weitao
    Weitao Rank 1 - Community Starter

    Hi @Kevin M-Oracle

    There is no parameter in the SO data model.

    I think we need to know the parameter passed to data model when user click print in UI. So we can print specific order.

    May I know how can I get the parameter if I added new SQL data set?

    Thanks!

    image.png
  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    You have the data model in edit mode.

    Add the new data set there.

    There are no parameters in this data model.

    Rgds,

    Kevin

  • Weitao
    Weitao Rank 1 - Community Starter

    Hi @Kevin M-Oracle ,

    Thank you for your kindly reply.

    I created a test data set to get the created by of the order.

    image.png

    I saved the sample xml and created a test report with only 2 fields, but the field not showed.

    image.png image.png

    May I know why?

    Do I need to update the Data Files?

    Thank you!

    Weitao

  • Francis Hurtado
    Francis Hurtado Rank 1 - Community Starter

    Any solution to add fields to the report?