Could anyone explain why the Product Family and Account line items are not populating in my TAR01.1 module? I've got these formulas linking to a SYS module that I created. These two modules have the same dimensions.
Thanks so much, I'll give that a try!
Hi, In your source module SYS03.01 Account Product Details you have in addition G2 Country dimension that you don't have in TAR01.1. You don't have summaries on in SYS03.1 (This is probably good idea with non numeric line items most of the time). As your target model doesn't have country dimension it reads values from country dimensions top level item which is blank as you don't have summaries on.
@fnaf is it necessary to add the country dimension to all those empty items?
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…
