Search Results
Search results 17 of 7.
This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

Hi, In Jedox 2020.04. i have a workbook with multiple views (in separate tabs). Is it possible to have a "main page"  where the user defines which version and year they want to see, and then this variable is passed to all the views in the workbook ? This way, users doesn't have to change version and year in the views onebyone If it is possible  how do I do it ? regards jorgen

Hi, as a starting Point i create an attribute on the year "MonthFormula"  which contains the "list" value. So 2020 has "202001', '202002', '202003', '202004', '202005', '202006', '202007', '202008', '202009', '202010', '202011', '202012" as month formula. Then i can create a Query formula, which returns attribute (202001', '202002', '202003', '202004', '202005', '202006', '202007', '202008', '202009', '202010', '202011', '202012) on left side and uses element (2020) on r…

Hi, 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':{'202101', '202102', '202103', '202104','202105', '202106', '202107', '202108','202109', '202110', '202111', '202112'}] = B:([ 'Measure':'Amount Year', 'Time':'2021', ] / 12) But then I have to create 70 r…

Hi, 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. For example with logic ['Product':'Laptop_XXX'] = ['Product':'Laptop'] My target is same dimension ID as my target  but with "_XXX" concenated at the end. So i am looking for a syntax like: ['Product':concatenate("'", !'Product', "_XXX'"] = ['Product':'Laptop']. But i can not find th…

Hi, 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" AND !'Color' == "Green" THEN xxxx ELSE yyyy 2) IF OR : IF !'Product' == "Bicycle" OR !'Color' = "Blue" THEN xxxx ELSE yyyy Thank you, Joergen Dalby

Hi, it worked with the power formula. Thank you. Then my next challenge is how to deduct to 2 dimension value from each other So i have "Base Year", which is the year the budget is done. So if the budget is done for 2020  base year is 2020. Then the budget is multiple years  which is "Time". So time is 2020, 2021, 2022, 2023 etc. The "Power" is the difference between "Time""Base Year". Power = "Time""Base Year". So the power is 0 in 2020 (20202020) and power is one in 2021 (20212020). Rega…

Hi, 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)n PV = present value FV = future value R = Inflation n = number of years (so if a value is 5 years from now  n is 5) The problem is the "raised to the power". Here the is a formula EXP(number)  which is support in rule…