Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Mondrian write back support with iQuery ajax

  1. #1
    Join Date
    Jan 2016
    Posts
    6

    Unhappy Mondrian write back support with iQuery ajax

    Hi All

    I'm trying to implement writeback support with mondrian. With the below post i can able to understand that write back support has been provided with the help of java api. But we are currently using jQuery ajax xmla soap request to retrieve values from mondrian. Can any suggest me how to achieve mondrian write-back support with jQuery ajax. Please find the sample

    jQuery Sample:
    $.ajax({
    "type": "POST",
    "url": "http://bi.syncfusion.com:8085/mondrian/xmla",
    "contentType": "text/xml",
    "async": true,
    "dataType": "xml",
    "data": "<SOAP-ENV:Envelope xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"><SOAP-ENV:Body><Execute xmlns=\"urn:schemas-microsoft-com:xml-analysis\"><Command><Statement><=!=[=C=D=A=T=A=[\nSelect \nSUBSET({((({[Product].children})*{[Measures].[Customer Count]}))},0,2)\ndimension properties MEMBER_TYPE,CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS \n,SUBSET({((({[Customers].children})))},0,2)\ndimension properties MEMBER_TYPE,CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS\n FROM [Sales]\n CELL PROPERTIES VALUE, FORMAT_STRING, FORMATTED_VALUE \n ]=]=></Statement></Command><Properties><PropertyList><DataSourceInfo>Provider=mondrian;DataSource=MySQLTest;</DataSourceInfo><Catalog>FoodMart</Catalog><AxisFormat>TupleFormat</AxisFormat><Content>Data</Content><Format>Multidimensional</Format></PropertyList></Properties></Execute></SOAP-ENV:Body></SOAP-ENV:Envelope>",
    success: function (args) {
    if ($(args).find("Axes, CellData").length > 0)
    alert("Data retrived successfully");
    }
    });

    Write back support:
    http://forums.pentaho.com/showthread...ck-in-Mondrian

    Regards,
    Tamil

  2. #2
    Join Date
    Jan 2016
    Posts
    6

    Unhappy Mondrian write back support with jQuery ajax

    Hi All

    I'm trying to implement writeback support with mondrian. With the below post i can able to understand that write back support has been provided with the help of java api. But we are currently using jQuery ajax xmla soap request to retrieve values from mondrian. Can any suggest me how to achieve mondrian write-back support with jQuery ajax. Please find the sample

    jQuery Sample:
    $.ajax({
    "type": "POST",
    "url": "http://bi.syncfusion.com:8085/mondrian/xmla",
    "contentType": "text/xml",
    "async": true,
    "dataType": "xml",
    "data": "<SOAP-ENV:Envelope xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"><SOAP-ENV:Body><Execute xmlns=\"urn:schemas-microsoft-com:xml-analysis\"><Command><Statement><=!=[=C=D=A=T=A=[\nSelect \nSUBSET({((({[Product].children})*{[Measures].[Customer Count]}))},0,2)\ndimension properties MEMBER_TYPE,CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS \n,SUBSET({((({[Customers].children})))},0,2)\ndimension properties MEMBER_TYPE,CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS\n FROM [Sales]\n CELL PROPERTIES VALUE, FORMAT_STRING, FORMATTED_VALUE \n ]=]=></Statement></Command><Properties><PropertyList><DataSourceInfo>Provider=mondrian;DataSource=MySQLTest;</DataSourceInfo><Catalog>FoodMart</Catalog><AxisFormat>TupleFormat</AxisFormat><Content>Data</Content><Format>Multidimensional</Format></PropertyList></Properties></Execute></SOAP-ENV:Body></SOAP-ENV:Envelope>",
    success: function (args) {
    if ($(args).find("Axes, CellData").length > 0)
    alert("Data retrived successfully");
    }
    });

    Write back support:
    http://forums.pentaho.com/showthread...ck-in-Mondrian

    Regards,
    Tamil

  3. #3
    Join Date
    Jan 2016
    Posts
    6

    Default Mondrian writeback support with jQuery ajax

    Hi All

    I'm trying to implement writeback support with mondrian. With the below post i can able to understand that write back support has been provided with the help of java api. But we are currently using jQuery ajax xmla soap request to retrieve values from mondrian. Can any suggest me how to achieve mondrian write-back support with jQuery ajax. Please find the sample

    jQuery Sample:

    $.ajax({
    "type": "POST",
    "url": "http://127.0.0.3:8085/mondrian/xmla",
    "contentType": "text/xml",
    "async": true,
    "dataType": "xml",
    "data": "<SOAP-ENV:Envelope xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"><SOAP-ENV:Body><Execute xmlns=\"urn:schemas-microsoft-com:xml-analysis\"><Command><Statement><=!=[=C=D=A=T=A=[\nSelect \nSUBSET({((({[Product].children})*{[Measures].[Customer Count]}))},0,2)\ndimension properties MEMBER_TYPE,CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS \n,SUBSET({((({[Customers].children})))},0,2)\ndimension properties MEMBER_TYPE,CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS\n FROM [Sales]\n CELL PROPERTIES VALUE, FORMAT_STRING, FORMATTED_VALUE \n ]=]=></Statement></Command><Properties><PropertyList><DataSourceInfo>Provider=mondrian;DataSource=MySQLTest;</DataSourceInfo><Catalog>FoodMart</Catalog><AxisFormat>TupleFormat</AxisFormat><Content>Data</Content><Format>Multidimensional</Format></PropertyList></Properties></Execute></SOAP-ENV:Body></SOAP-ENV:Envelope>",
    success: function (args) {
    if ($(args).find("Axes, CellData").length > 0)
    alert("Data retrived successfully");
    }
    });


    Writeback support:
    http://forums.pentaho.com/showthread.php?70482-Cell-writeback-in-Mondrian

    Regards,
    Tamil

  4. #4
    Join Date
    Jan 2016
    Posts
    6

    Default Mondrian writeback support with jQuery ajax

    Hi All

    I'm trying to implement writeback support with mondrian. With the below post i can able to understand that write back support has been provided with the help of java api. But we are currently using jQuery ajax xmla soap request to retrieve values from mondrian. Can any suggest me how to achieve mondrian write-backsupport with jQuery ajax. Please find the sample



    jQuery Sample:

    $.ajax({
    "type": "POST",
    "url": "http://127.0.0.3:8085/mondrian/xmla",
    "contentType": "text/xml",
    "async": true,
    "dataType": "xml",
    "data": "<SOAP-ENV:Envelope xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" SOAP-ENV:encodingStyle=\"http://schemas.xmlsoap.org/soap/encoding/\"><SOAP-ENV:Body><Execute xmlns=\"urn:schemas-microsoft-com:xml-analysis\"><Command><Statement><=!=[=C=D=A=T=A=[\nSelect \nSUBSET({((({[Product].children})*{[Measures].[Customer Count]}))},0,2)\ndimension properties MEMBER_TYPE,CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON COLUMNS \n,SUBSET({((({[Customers].children})))},0,2)\ndimension properties MEMBER_TYPE,CHILDREN_CARDINALITY, PARENT_UNIQUE_NAME ON ROWS\n FROM [Sales]\n CELL PROPERTIES VALUE, FORMAT_STRING, FORMATTED_VALUE \n ]=]=></Statement></Command><Properties><PropertyList><DataSourceInfo>Provider=mondrian;DataSource=MySQLTest;</DataSourceInfo><Catalog>FoodMart</Catalog><AxisFormat>TupleFormat</AxisFormat><Content>Data</Content><Format>Multidimensional</Format></PropertyList></Properties></Execute></SOAP-ENV:Body></SOAP-ENV:Envelope>",
    success: function (args) {
    if ($(args).find("Axes, CellData").length > 0)
    alert("Data retrived successfully");
    }
    });


    Writeback support:
    http://forums.pentaho.com/showthread.php?70482-Cell-writeback-in-Mondrian

    Regards,
    Tamil
    Last edited by Tamil; 09-20-2017 at 07:18 AM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.