How to get dimension settings in spreadsheet ?

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • How to get dimension settings in spreadsheet ?

    I want to know if it's possible to get Dimension's settings as : "Total element" "NA element" "Default read element" "Default write element" or "Default parent element".

    I want to know if there is a PHP function or just a spreadsheet function that can retrieve those information. Because the php function palo_dimension_info [/b]retrieve many information but not that one.


    Thanks
    Hello everyone if you are stuck and you can't post anything on this forum just contact info@jedox.com and request for account activation ! You're welcome !

    The post was edited 1 time, last by Zarcoff ().

  • in PHP : retrieve only default read element and default write element
    $resid = palo_init("localhost", $_JEDOX['OLAP_PORT'], $_JEDOX['OLAP_SESSION_ID']);
    //$resid = palo_init($_JEDOX['OLAP_HOST'], $_JEDOX['OLAP_PORT'], $_JEDOX['OLAP_SESSION_ID']);
    $res = palo_dimension_default_elements($resid,"db_name","dim_name");

    (for the $resid if you are in local use "localhost" if it's cloud instance use olap_host)

    in JS : retrieve all information you want
    new Jedox.backend.JRPCAsyncRqst('com.jedox.palo.mdlr.cube.Cube', 'getDimensionSettings', ['server_name','db_name','dim_name',{}])
    Hello everyone if you are stuck and you can't post anything on this forum just contact info@jedox.com and request for account activation ! You're welcome !