Check For value in Cube

MosheA · Oct 3rd 2018, 3:38pm

Hi
i have a cube and all the combinations are Zero.
there is any way (php code) that check inside the cube (all cube) and return the combinations with non zero.

thanks!

dominik_l · Oct 8th 2018, 10:56am

You can try with the php function palo_getdata_export() (see the PHP API documentation in Knowledgebase for details).

It allows you to set the option "ignore_empty", meaning it would return you a (potentially long...) list of cell coordinates with values which are not empty.

MosheA · Oct 8th 2018, 2:00pm

hi thanks.

but how its work :
for example

Source Code

function test(){
$dimensions = array('9', '2018', 'Q4', 'Controller', 'FlagSave');
palo_getdata_export("conection","cube",TRUE, false, 1 ,3, NULL ,$dimensions);
}

i wrote this code.
and now when i go to cell q10 for exmple and worte =test()
its show me 0

why ?

there is the cube only one line (combition) that the value is 1

Gerwin Haas · Oct 8th 2018, 3:33pm

Hi,

your code does not define neither "conection" nor "cube". How shall the function know which cube it may access?
You may want to define those parameters.

HERE you will find a full working code piece.

Best
Gerwin

laloune · Oct 8th 2018, 5:22pm

if your goal is only to get the count of the non-zero cells you can also use palo_data_cnt

MosheA · Oct 9th 2018, 9:19am

hi Gerwin:

first of all thanks!

i define a connection and cube:

Source Code

function test(){
$dimensions = array('9', '2018', 'Q4', 'Controller', 'FlagSave');
palo_getdata_export("localhost/UTP","UTP" ,TRUE, false, 1 ,3, NULL ,$dimensions);
}

but its still does not work

hi laloune:

first of all thanks!

my goal is getting lines like in the picture

returning all the combination of dimension that the value is one.

Gerwin Haas · Oct 9th 2018, 5:28pm

Hi MosheA,

try to stick to the docu in my Link above. There is a full example how to define a connection.

<?php
// Defines constant variables.
define('HOST', 'localhost');
define('PORT', '7777');
define('USER', 'admin');
define('PASS', 'admin');

// Establishes a new connection to the OLAP server.
$connection = palo_init(HOST, PORT, USER, PASS);

// Creates array with dimension coordinates
$dimensions = array('Desktop L', 'France', 'Jan', '2012', 'Actual', 'Units');

// Exports data as specified in function
echo "<pre>";
print_r(palo_getdata_export($connection, 'Demo', 'Sales', TRUE, TRUE, 200, 15000, 'gte', 'lt', 'and', 10, NULL, $dimensions));
echo "</pre>";

// Same as above, but uses string instead of numeric values
echo "<pre>";
print_r(palo_getdata_export($connection, 'Demo', 'Sales', TRUE, TRUE, ">=200 AND <15000", 10, NULL, $dimensions));
echo "</pre>";

// Closes the established connection.
palo_disconnect($connection);
?>

Best
Gerwin

Source Code

Source Code

Share