# Recent Activities

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

• ### laloune - Oct 16th 2018, 6:01pm

Replied to the thread Planning: Sales and/or Quantity with price staying the same?.

Post
Hello, supervisionserver is designed for this purpose. You can watch a slice of the cube and react to the change of a cell within this slice. Say, you change price, then you can fire a script that will write the price in the cube, and calculate the…
• ### Gerwin Haas - Oct 16th 2018, 2:31pm

Replied to the thread Planning: Sales and/or Quantity with price staying the same?.

Post
Hi Sara, this seems a bit daisy chained! I would tend to use worksheet (using palo setdata) or integrator calculations for a logic like this, I think this cannot be done through rules. You could always "flag" one variable as static, depending on what…
• ### SaraLM - Oct 16th 2018, 10:46am

Replied to the thread Planning: Sales and/or Quantity with price staying the same?.

Post
Hi Gerwin, thanks for your answer. I already built a Business Rule saying Price = Sales / Quantity. If I want to increase Sales now the price will increase as well - but I´d like to stay the price the same and increase the quanity... Otherwise I´d…
• ### Gerwin Haas - Oct 15th 2018, 4:56pm

Replied to the thread Planning: Sales and/or Quantity with price staying the same?.

Post
Hi Sara, what you are looking for is defined in Jedox as "Business Rule". You may want to read this LINK for some useful information. Best Gerwin
• ### SaraLM - Oct 12th 2018, 11:08am

Posted the thread Planning: Sales and/or Quantity with price staying the same?.

Dear Jedox Community, this might be a relatively simple question for some of you but I just don´t get it at the moment. Our users shall plan sales figures and/or quanities - either way the other KPI should be calculated with the price staying the…
• ### Gerwin Haas - Oct 9th 2018, 5:28pm

Replied to the thread Check For value in Cube.

Post
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');
• ### marieblur - Oct 9th 2018, 4:49pm

Wrote a comment on marieblur’s wall.

Wall Comment
With altoconvertpdftoexcel.com you can transform any PDF file to Excel easily
• ### MosheA - Oct 9th 2018, 9:19am

Replied to the thread Check For value in Cube.

Post
hi Gerwin: first of all thanks! i define a connection and cube: Source Code (4 lines)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…
• ### Gerwin Haas - Oct 8th 2018, 5:46pm

Liked laloune’s post in the thread Check For value in Cube.

Like (Post)
if your goal is only to get the count of the non-zero cells you can also use palo_data_cnt
• ### laloune - Oct 8th 2018, 5:22pm

Replied to the thread Check For value in Cube.

Post
if your goal is only to get the count of the non-zero cells you can also use palo_data_cnt
• ### Gerwin Haas - Oct 8th 2018, 3:33pm

Replied to the thread Check For value in Cube.

Post
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
• ### MosheA - Oct 8th 2018, 2:00pm

Replied to the thread Check For value in Cube.

Post
hi thanks. but how its work : for example Source Code (5 lines)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, 11:24am

Liked MosheA’s post in the thread Insert Element to dimension by report.

Like (Post)
thanks Gerwin Its done !!!
• ### Gerwin Haas - Oct 8th 2018, 11:24am

Replied to the thread User permissions - allow / disallow the usage of specified reports.

Post
Hi, we have the same issue! Here's my workaround: you can use the "current_groups()"-function LINK and define within the worksheet in a table if the user is not member of a certain group to hide specific rows. Not the best way, but it…
• ### dominik_l - Oct 8th 2018, 10:56am

Replied to the thread Check For value in Cube.

Post
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…
• ### SvenAndersen - Oct 5th 2018, 1:28pm

Posted the thread export cell range into excel in a web report.

Dear all, is there a way from a inside a web report to export a defined cell range into excel using a macro or similar? The best would be to have a button in the report, where a macro is assigned to, and when clicked on Excel is opened locally on the…
• ### MosheA - Oct 3rd 2018, 3:38pm

Posted the thread Check For value in Cube.

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!
• ### MosheA - Oct 3rd 2018, 3:31pm

Replied to the thread Insert Element to dimension by report.

Post
thanks Gerwin Its done !!!
• ### fnsl - Oct 2nd 2018, 2:00pm

Posted the thread User permissions - allow / disallow the usage of specified reports.