Issues with Dynamic Calc Member formula
Summary:
I have several accounts with member formulas in the statistical hierarchy of the Account dimension. After validating the formulas, everything appears to be correct. However, I'm encountering a strange issue when retrieving the data. When I pull the data in Periodic view for these accounts, the retrieval is quick and the data is accurate. But when I add YTD, the data becomes completely incorrect for both YTD and Periodic views. To troubleshoot, I segregated these accounts into two sets. Set 1 works fine in both Periodic and YTD views, and the same goes for Set 2. However, when I combine
Tagged:
0