Hi I have 4 modules, with hierarchy regions set up. All 4 modules with dimensions are described in ss. I want to apply a filter on last module for only the countries selected for particular user but I am unable to do it.
hi Ankit,
you can try steps below:
it should show different users different countries selected for them in Moudule 3.
Can you explain it in more details? I don't understand the terms map it to module 3, if you can explain that more it would provide me some clarity.
Also thanks for you response
"Filter Country for user" = Module3.“select country L3” (assuming select country L3 is a boolean).
I am just want to tell you that to apply a filter on the last module based on user-selected countries, you can follow these steps:
If you have set up hierarchy regions, you can also filter by the parent region or by using the "descendants" operator to include all sub-regions under the selected country.
It's important to ensure that the dimension and hierarchy settings are correctly configured in all modules to ensure the filter works as intended. If you are still having trouble applying the filter, you may want to consult with a system administrator or support team for assistance.
Great, thanks I will try this out and let you know in case of any issues
Can we find somewhere documentation about UX drill down feature? UX is sometime showing underlying data upto 5 levels in hierarchy but doesn't work 6 or 7. Appreciate any pointers on limitations on this feature. Business wants to know up to what levels in reports they can analyze underlying data.
I' am migrating data from Classic to Polaris. I have a metric at the intersection of Market, Item, and Division that is calculated as Current Amount / Annual Amount. I obtain the annual amount using YEARVALUE(Current Amount). In Polaris, I cannot use this formula as a summary, so when data rolls up to higher hierarchy…
Hi Community, It appears that values shown here for Q1 are assuming 29 days in Feb 25, when there are actually only 28. My values tie out for all Quarter values and all months shown from Apr 25 forward, and it's not possible for only a single quarter/finite range of months to differ with formula-driven values: Please…