About Pierre Lorentz

Business Consultant at Jedox partner 2K Business Intelligence Solutions.
18 08, 2014

Multiple data subsets

By |2016-12-09T11:43:10+00:00August 18th, 2014|Categories: Data Modeling|Tags: , , |

You may have encountered this issue:  you have a dimension that is shared throughout 2 or more cubes. You want to subset this dimension using data filters but each on a different cube. Impossible using the standard subset functions, but EZPZ using a simple macro engine hack. Let's check this out! Let's use the Demo database for this example and create

16 07, 2014

Send email using PHP

By |2016-12-09T11:43:11+00:00July 16th, 2014|Categories: How To|Tags: , |

After the post of Ana Stroe dealing with email sending using Groovy (thanks for that!), let's see how to do the same using PHP! The advantage of PHP in this case is that we can use the same function in a Jedox Web macro as well as in a Supervision-Server script. We'll just have to include the correct files in