Attribute Member aggregation in YTD view
Summary:
Hi all,
We're looking to Set up Attribute dimension members in our Account dimension to support reporting on exception / non-exception items.
I.e. Create a P&L with accounts in the rows and then a split in the columns on exception / non-exception. Accounts will be tagged either as exception or non-exceptional.
This is working well in testing, but the balances only aggregate when the view is periodic, rather than YTD. I.e. We can only get our PBT on an exceptional / non-exceptional basis in periodic view and not YTD (using the members in the database).
My understanding is that attribute members don't aggregate into stored members, but would for a dynamically calculated one - which YTD is.