-
1. Re: Help with calc based on parameter and dimension hierarchy
Madhusudhan Khambham Nov 17, 2017 4:44 PM (in response to Steve Gesuale)please see the attached workbook and let me know if this is what you are expecting?
Thanks & Regards
Madhu K
-
calc based on parameter.twbx 20.6 KB
-
-
2. Re: Help with calc based on parameter and dimension hierarchy
Steve Gesuale Nov 17, 2017 5:05 PM (in response to Madhusudhan Khambham)Hi Madhu,
Thanks for the helpful reply.
It's almost there. I added an ELSE "Other" piece to your calc, but I was hoping it would return the relevant Region value for the other countries in the same region, e.g., when Germany is chosen, the calc would return "Europe" for Germany but also Italy and Poland.
Any ideas on revising to make that work?
Appreciate the help!
Steve
-
calc based on parameter.twbx 40.1 KB
-
-
3. Re: Help with calc based on parameter and dimension hierarchy
Madhusudhan Khambham Nov 17, 2017 5:29 PM (in response to Steve Gesuale)I doubt we can achieve what you needed. if you interchange country with region as your parameter then you can show all the countries within the region.
reasons:
1. We have country parameter and mapping it in the calculation to bring its corresponding region.
2. your parameter and filter is already filtering the country data.
3. We can use LOD's to exclude this filter. But, we cant bring all the countries within the region even with LOD's.
Hope this helps to understand why we can't.
Thanks & Regards
Madhu K
-
4. Re: Help with calc based on parameter and dimension hierarchy
Mohamed Thahir Gaffar Hussain Nov 17, 2017 11:42 PM (in response to Steve Gesuale)Hi Steve, I have shown two ways of doing this. Window calc and LOD. Hope this helps...
Thanks,
Mohamed
-
calc based on parameter MD.twbx 39.8 KB
-
-
5. Re: Help with calc based on parameter and dimension hierarchy
Madhusudhan Khambham Nov 18, 2017 3:46 AM (in response to Mohamed Thahir Gaffar Hussain)Hi Mohamed Thahir Gaffar Hussain
can you please post the workbook here..i would like to see how it can be done.
Thanks & Regards
Madhu K
-
6. Re: Help with calc based on parameter and dimension hierarchy
Madhusudhan Khambham Nov 18, 2017 3:57 AM (in response to Madhusudhan Khambham)I can see the workbook now. Thanks for the solution, i thought with Max we will get only one record in LOD. but, that is wrong.
Appreciated for your answer it helped me.
Thanks
Madhu K
-
7. Re: Help with calc based on parameter and dimension hierarchy
Steve Gesuale Nov 18, 2017 4:16 PM (in response to Mohamed Thahir Gaffar Hussain)Thanks, Mohamed, for solving this. I really appreciate the help from you and Madhu. The LOD calc is what I was trying but failing to get.
Steve