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

Hi, I have a value on Time = Blank  and i need to load it into a time range. So if time range is [202001, 202003]. The integrator job should load it into Time = 202001, Time = 202002 and Time = 202003. or if time range is [202001, 202002]. The integrator job should load it into Time = 202001 and Time = 202002 Time range is variable. Any suggestions ? regards Jorgen

Hi, i have only worked in the web until now. So all reports are designed in designer and then published to reports. Now i want to work from the excel add in  but comboboxes and dynaranges doesn't appear to work in the excel plugin ? So is it even possible to develop customized planning input workbooks to use with Excel Plugin ? If so i assume it requires VBA knowledge ? Thank You, Jorgen

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…