Can anyone explain this?]]>

Using the PALO.DATA() function I am able to use strings (pulled from an other element or as an atrribute) for the database and element names. Making the cube reference dynamic.

To take advantage of the automatic mapping of dimensions, I would like to do the same with the syntax '<cube>'['<Dim1>':'<Element1>',...].

But I am not able to let the rule parser take a string for <cube> or <Dim>. For <Element> it works.

Is there any way to make the rule parser take a string as '<cube>' and '<Dim>' definition?]]>

a simple problem, which I can not solve.. I have yearly numbers from year 2021 to 2090 - and i need to split them into months (1/12) for each year.

The only solution i have now is to hardcode rules with constant - so the rule looks like this:

['Measure':'Amount Month', , 'Time':{'2021-01', '2021-02', '2021-03', '2021-04','2021-05', '2021-06', '2021-07', '2021-08','2021-09', '2021-10', '2021-11', '2021-12'}] =

B:([ 'Measure':'Amount Year', 'Time':'2021', ] / 12)

But then I have to create 70 rules - one for each year..

There must be a simpler way to do this :-). The optimal solution would be if i could manipulate the "left side" of the rule, but since i can not change this - i can not find a smart approach.

All ideas are appreciated

regards

jorgen]]>

a simple problem, which i can not solve with the right syntax...

I need to copy from one dimension ID to another dimension ID. My TARGET dimension ID is same as SOURCE dimension ID - but with "_XXX" at the end.

['Product':'Laptop_XXX'] = ['Product':'Laptop']

My target is same dimension ID as my target -

['Product':concatenate("'", !'Product', "_XXX'"] = ['Product':'Laptop'].

But i can not find the correct syntax or any examples from Jedox.

Thank you,

Joergen]]>

i am struggling with finding the right syntax for using rule formulaes with IF AND / IF OR.

So for example

What is syntax for;

1) IF AND : IF !'Product' == "Car"

2) IF OR : IF !'Product' == "Bicycle"

Thank you,

Joergen Dalby]]>

I need to do a business rule on a model for calculating a measure (amount) from present value (including inflation) to present value (excluding inflation). It has to be a rule on the model.

I can't really find any support for this.

The formula is fairly simple : PV = FV/(1+R)

PV = present value

FV = future value

R = Inflation

n = number of years (so if a value is 5 years from now - n is 5)

this is a general question and a cry for help at the same time .

In the scenario, I have a calendar dimension (basically the standard jedox-Calendar with months and weeks in parallel with dummy elements for every month) and a movement dimension (BoP, NetMove, EoP).

Currently the EoP and BoP are not set up a consolidated elements in the dimension, so that they would be calculated by aggregation.

The data-load only happens for the NetMove (i.e. add & reduction). At the beginning of each year a BOP-value is written as well.

So first my general question: Would you calculate the EoP via a hierarchy or via Rule? And what would does the Rule then look like for the BoP of the next period (i.e. day)?

My second question: If I go for a rule solution only, how to I calculate the BoPs only for all days from the 2nd Jan onwards for each year in the calendar and how would I set up the EoP-rule?

Thanks for any hints and pieces of advice.

Br

Bjoern]]>

eg:

['#_Periode_':'TimeAggregation'] = if(1 == 1, "Special2", "")

in my case this rule is not working -- what is wrong? ]]>

is it posible to use variables from web report (Combobox) in rules?

Something like this:

['Bezeichnung'] = B:PALO.DATA("database", "cube", "0", ${cmb_1}, ${cmb_2}, !'Darlehensart', "Bezeichnung")

${cmb_1} - variable1 from web Report

${cmb_2} . variable2 from web Report

Thanks in advance]]>

I am looking for a way to calculate an avarage of the children of consolidated elements.

There are Measures that hold values as percentages. When it comes to consolidation, those values are summed up. This is obviously wrong because then you may get values like 355% for the consolidated elements.

To get it more specific: There are for example percentages for

How do I get an average for those parent-elements?

Thanks in advance for any advices!

-------

I am using Jedox 6. Maybe there is already a native feature or functionality in newer jedox-versions? If that is the case I would think of postponing this topic until we updated our version.

]]>

I want to set up allocation rules for cost centers and am struggling quite a bit.

Here a scenario: Cost center A has amount x in material costs // products 1 to 40 receive those costs by percentage of sales to the account allocation material costs.

At the same time the cost center should get the inverse value in the account material costs.

There is a cost center cube & a product cube each have the same accounts in the P&L

I'll split it up in sections to make it more accessbile.

Starting with the latter: inverse value for the cost center

Since there are numerous products and cost centers, I do not feel the urge to set up one rule per item.

In the dimension cost center, the hierarchy already reflects which cost center affects which allocation account. i.e. Cost center A to E belong to Product management and thus go to the allocation account "productmangement". Cost Center F-M belong to Adminstration and thus go to the allocation account "administration".

My intention was, to somehow state in the rule that the the target is: material costs for all cost centers that belong to product Management and the source is the account material costs for each cost center there

This is solved by another hierarchy in which the accounts were grouped to match the allocation type. So that I could just make a rule with PALO.DATA *-1

Basically the same problem as in 1. just not the inverse value and here I have the problem that I need to get the value from the cost center cube into the product cube where all dimensions are the same, except for the dimension cost center and respectively product. I thought about Palo.Data but did not get there.

Somehow I have to calculate the percentage of sales for each product and multiply it with (here the consolidation will suffice) the e.g. material costs of consolidated element product Management for cost centers and the target would be the account allocation material costs for each product.

Plus I need to do this with several cost types (aggregations) and several costcenter consolidations.

Is there a way to loop through the target i.e. give parent element and let it run through all base elements? I really do not want to give one rule per product and cost center. Since there is no "base indicator" for the target, I am already afraid that it is not possible.

Thanks in advance for any kind of help.

]]>

my problem is the following:

I cannot find a way to define a Business Rule that replaces a certain element with another one.

When I query the value for US

You may think "why not providing US-X direclty?". It is a Combo Box in a web report that provides the values (via a variable @country). In most of the cases the country that you choose by that combo box is ok. But there is one certain case in which the chosen value should be another one (but for just one certain value/measure).

Therefore I would like to stick to the @country-variable for all palo.data()-functions, but would like to replace this one special selection with another one.

I know I could do this on the Palo Web-sheet,

I tried to make a rule that assignes the value/measure to the other element:

`['Measure', 'Factory':'US'] = ['Measure', 'Factory':'US-X']`

But this obviously does not work because it is a circular reference.I have tried to do quite the same but in a different way by including an IF statement

`['Measure'] = IF((!'Factory') == "US", PALO.DATA(..., "US-X", ... ,"Measure"), PALO.DATA(..., !'Factory', ... ,"Measure" ))`

, but this gives the same error.Does someone have any idea?]]>

-Seems to be pretty complicated to go from the node, and calculate the difference between average and value from base elements...

- It also seems to be not possible to go from the Base Element, as you don't know which Nodes are used for consolidation...

Any Idea how to do it, if its possible ?]]>

I'm trying to upgrade a proyect to v7. Our proyect have some cubes with bussines rules.

Several rules are composed by "IF" logical conditions, like this example:

Have anyone experience to migrate a v6 proyect to v7 with this type of rules?

Thanks for all]]>

I am attempting to use rules to apply Exchange Rates to all Financial data points in my cube ("Benchmarks" cube), based on rates that are stored in another cube ("Exchange_Rates" cube)

Rule 1 (Constant) derives the value in USD by dividing any value in the cube where Currency is VEF(Venezuelan Bolivars) by the matching Currency in the Exchange_Rates cube where the Sub Category is "Max" (latest quarter)

Rule 2 (Variable) derives the value in USD by dividing any value in the cube where Currency is VEF(Venezuelan Bolivars) by the matching Year/Quarter/Currency in the Exchange_Rates cube regardless of Sub Category

These two rules appear to work in isolation. However, when I introduce more rules where the only difference is the specified currency e.g. GBP, then only the first rule of type (Constant) or (variable) works, depending the order in which they appear in the Rule editor

For example, if I have "Variable VEF Rule" first and "Constant GBP Rule" second, they both work, if i have "Constant VEF Rule" first and "Constant GBP Rule" second and "Variable GBP Rule" third - only "Constant VEF Rule" and ""Variable GBP Rule" work?

Are the "constant" versus "constant" and "Variable" versus "Variable" rules conflicting? surely not or is it just the order I've got them in?

The structure of the cubes is as follows

[Service] | [Scenario] | [Region_Country] | [Year] | [Quarter] | [Device Type] | [Operator] | [Type] | [Category] | [Sub Category] | [Currency] | [Frequency] | [Model_Input] | [Calc_Y_N] | [Measure] |

WOS | L | Venezuela | 2014 | Q1 | N/A | Movistar Venezuela | N/A | Prepaid | Variable Exchange Rate | USD | Monthly | Component 1 | Y | Revenue |

P | UK | 2015 | Q2 | Smartphone | EE | Voice | Postpaid | Constant Exchange Rate | VEF | Quarterly | Component 2 | N | ARPU | |

W | 2016 | Q3 | Non-Voice | Total | N/A | GBP | Annually | Component 3 | Subscriptions | |||||

2017 | Q4 | Data | EUR | N/A | N/A | Churn | ||||||||

2018 | Messaging | KRW | ||||||||||||

2019 | SEK | |||||||||||||

2020 | N/A |

[Year] | [Quarter] | [Type] | [Sub Category] | [Currency] |

2014 | Q1 | Bid | N/A | USD |

2015 | Q2 | Ask | Max | VEF |

2016 | Q3 | Midpoint | GBP | |

2017 | Q4 | EUR | ||

2018 | KRW |

- ['Sub Category':'Constant Exchange Rate','Currency':'USD'] = ['Sub Category':'N/A','Currency':'VEF'] / PALO.DATA("SAS_Dashboards","Exchange_Rates","All Years","All Quarters","Midpoint","Max","VEF");VEF CONSTANT;;1464186101
- ['Sub Category':'Variable Exchange Rate','Currency':'USD'] = ['Sub Category':'N/A','Currency':'VEF'] / PALO.DATA("SAS_Dashboards","Exchange_Rates",!'Year',!'Quarter',"Midpoint","WOS","VEF");VEF Variable;;1464186924
- ['Sub Category':'Constant Exchange Rate','Currency':'USD'] = ['Sub Category':'N/A','Currency':'GBP'] / PALO.DATA("SAS_Dashboards","Exchange_Rates","All Years","All Quarters","Midpoint","Max","GBP");GBP CONSTANT;;1464194173
- ['Sub Category':'Variable Exchange Rate','Currency':'USD'] = ['Sub Category':'N/A','Currency':'GBP'] / PALO.DATA("SAS_Dashboards","Exchange_Rates",!'Year',!'Quarter',"Midpoint","WOS","GBP");GBP Variable;;1464194223

Any help much appreciated. Even if to tell me I'm barking up the wrong tree and cannot be done

Thanks

J]]>

I'm trying to use this function but something worng is happening.

I tried some examples founded here: knowledgebase.jedox.com/knowledgebase/usage-markers/]]>

I'm trying to set the target of my business rules just for affect the base elements of the year '2016', i. e., just for the days. The source data are coming from other cube year based.

['Dim_Measure':'Value_for_day', 'Service_A', 'Dim_Period_Default':'2016'] = B:PALO.DATA("","Cube_Values_by_Year","2016","Service_A","Value")

With this... the base elements are not being affect.]]>

I need to implement a rule that should to accumulating a value from 1st. day of month till the last day.

My period/date dimension has the days as the base level and my measures dimenson has just one measure that may to show accumulated values.

There is a way to implement this "YTD" with business rules?]]>

I wonder if one could formulate a rule that is dependend on the user who creates the current view.

In documents I can bring in the BENUTZER.AKTUELL() formula which brings back the active user immediately. (User.Active)

I would like to have a rule that follows this logic:

['Your ticket'] = PALO.DATA("Database", "Cube", [BENUTZER.AKTUELL()], "Ticket number")

Unfortunately, a formula such as this is not listed in the manuals.

Any ideas or workarounds?

Thank you in advance!]]>

I have the following problem where I couldn't find a good solution for.

My cube contains in general dimensions for projects, locations, years and savings (to keep it simple).

One project can have savings in one or more years and I want to count a 1 for every year the project has savings > 0.

The final result report should list the locations and the amount of active projects for each year.

(the location is also written as an attribut on every single project)

My first thought was using a rule to determine wether a project is active (savings > 0) for each year or not.

['active projects'] = IF(['savings','All'] > 0,1,0)

But I couldn't make it to sum that up in my final web report by location.

Thanks in advance for your help!,

Stephan Wetzelsberger]]>